Changeset 0bb39f5 for src/mvc/conference.cpp

Timestamp:

01/27/10 16:31:10 (12 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

a790a90

Parents:

07ae23a

Message:

removed appsettings

• created 'active' column in 'conference' table

File:

• src/mvc/conference.cpp (modified) (2 diffs)

src/mvc/conference.cpp

@@ -11 +11 @@
     << QSqlField("days", QVariant::Int)
     << QSqlField("day_change", QVariant::Int)
-    << QSqlField("timeslot_duration", QVariant::Int));
+    << QSqlField("timeslot_duration", QVariant::Int)
+    << QSqlField("active", QVariant::Bool));
 
 QString const Conference::sTableName = QString("conference");
@@ -30 +31 @@
 }
 
+int Conference::activeConference()
+{
+    QSqlQuery query("SELECT id FROM conference WHERE active = 1");
+    query.exec();
+
+    QList<int> activeConfs;
+    while(query.next())
+        activeConfs.append(query.record().value("id").toInt());
+
+    if(activeConfs.count()==0) // no active DB
+        return 1;
+    else // even if there are more active confs, the first from the list is confidered active
+        return activeConfs[0];
+}
+