Changeset 680a4da in confclerk_git for src/orm

Timestamp:

01/16/10 16:31:15 (13 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

c790268

Parents:

8860ff4

Message:

work on favourite

• created 'favourite' column in EVENT table
• modified 'ormrecord' for setting record's elements
• favourities view not implemented

File:

• src/orm/ormrecord.h (modified) (5 diffs)

src/orm/ormrecord.h

@@ -34 +34 @@
     OrmRecord();
     static T hydrate(const QSqlRecord& record);
+    void update(QString col, QVariant value = QVariant()); // updates specified column 'col'
 
 protected:
@@ -45 +46 @@
     static QString columnsForSelect(const QString& prefix = QString());
     static QString selectQuery();
+    static QString updateQuery();
     static QSqlRecord toRecord(const QList<QSqlField> & columnList);
 
@@ -63 +65 @@
     object.QSqlRecord::operator=(record);
     return object;
+}
+
+// updates specified column 'col'
+// if the value is not specified  as an argument,
+// it's taken from the reford itself
+// see also: setValue() method for more details
+template <typename T>
+void OrmRecord<T>::update(QString col, QVariant value)
+{
+    QSqlQuery query;
+    query.prepare(QString(updateQuery() + "SET %1 = :col WHERE id = :id").arg(col));
+    if(value.isValid()) // take 'col' value from the method's arguments
+        query.bindValue(":col", value);
+    else // take 'col' value from the record; see setValue()
+        query.bindValue(":col", convertToDb(this->value(col), this->value(col).type()));
+    query.bindValue(":id", this->value("id"));
+    //query.bindValue(":id", convertToDb(value("id"), QVariant::Int));
+    query.exec();
 }
 
@@ -103 +123 @@
         if (!query.exec())
         {
-            //TODO Palo: exception handling !
-                QString start = "START\n";
-                QString end = "\nEND\n";
-                QString message = start + query.lastError().text() + end;
-                const char *data = message.toLatin1().data();
-                qDebug(data);
             throw new OrmSqlException(query.lastError().text());
         }
@@ -139 +153 @@
 {
     return QString("SELECT %1 FROM %2 ").arg(columnsForSelect(), T::sTableName);
+}
+
+template <typename T>
+QString OrmRecord<T>::updateQuery()
+{
+    return QString("UPDATE %1 ").arg(T::sTableName);
 }