Changeset 20a6010 in confclerk_git for src/test

Timestamp:

12/30/09 14:50:23 (13 years ago)

Author:

komarma <komarma@…>

Branches:

master, qt5

Children:

489f262

Parents:

5a73d27

Message:

Adding database loading and data conversion to orm module

Location:

src/test/model

Files:

• eventtest.cpp (modified) (2 diffs)
• eventtest.h (modified) (1 diff)

src/test/model/eventtest.cpp

@@ -12 +12 @@
     // Connect to the test database. Ask Mr. Pavelka to generate one for you :)
     QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
-    db.setDatabaseName("fostem-test.sqlite");
+    db.setDatabaseName("fosdem-test.sqlite");
     QVERIFY(db.open());
 }
@@ -28 +28 @@
 }
 
-void EventTest::colNames()
-{
-    QCOMPARE(Event::colName(Event::Id), QString("id"));
-    QCOMPARE(Event::colName(Event::Conference), QString("xid_conference"));
-    QCOMPARE(Event::colName(Event::Start), QString("start"));
-    QCOMPARE(Event::colName(Event::Duration), QString("duration"));
-    QCOMPARE(Event::colName(Event::Activity), QString("xid_activity"));
-    QCOMPARE(Event::colName(Event::Type), QString("type"));
-    QCOMPARE(Event::colName(Event::Language), QString("language"));
-}
-
 void EventTest::storingValues()
 {
     Event event;
-    QCOMPARE(event.id(), 0);
 
     event.setId(10);
+    event.setConferenceId(20);
+    event.setStart(QDateTime::fromString("Sat Feb 7 11:30:00 2009"));
+    event.setDuration(30);
+    event.setActivityId(40);
+    event.setTypeId(50);
+    event.setLanguageId(60);
+
     QCOMPARE(event.id(), 10);
-
-    event.setConferenceId(20);
     QCOMPARE(event.conferenceId(), 20);
-
-    event.setStart(QDateTime::fromString("Sat Feb 7 11:30:00 2009"));
     QCOMPARE(event.start(), QDateTime::fromString("Sat Feb 7 11:30:00 2009"));
-
-    event.setDuration(30);
     QCOMPARE(event.duration(), 30);
-
-    event.setActivityId(40);
     QCOMPARE(event.activityId(), 40);
-
-    event.setTypeId(50);
     QCOMPARE(event.typeId(), 50);
-
-    event.setLanguageId(60);
     QCOMPARE(event.languageId(), 60);
 }
+
+
+void EventTest::hydrate()
+{
+    QSqlRecord record;
+    record.append(QSqlField("duration", QVariant::Int));
+    record.append(QSqlField("id", QVariant::Int));
+    record.setValue(0, 10);
+    record.setValue(1, 20);
+
+    Event event = Event::hydrate(record);
+    QCOMPARE(event.id(), 20);
+    QCOMPARE(event.duration(), 10);
+}
+
+void EventTest::columnsForSelect()
+{
+    QCOMPARE(Event::columnsForSelect(), QString("id,xid_conference,start,duration,xid_activity,type,language"));
+    QCOMPARE(Event::columnsForSelect("t0"),
+             QString("t0.id,t0.xid_conference,t0.start,t0.duration,t0.xid_activity,t0.type,t0.language"));
+}
+
+void EventTest::selectQuery()
+{
+    QCOMPARE(Event::selectQuery(), QString("SELECT id,xid_conference,start,duration,xid_activity,type,language FROM event "));
+}

src/test/model/eventtest.h

@@ -12 +12 @@
 
     void getById();
-    void colNames();
     void storingValues();
+    void hydrate();
+    void columnsForSelect();
+    void selectQuery();
 };