Changeset d0d0a66
- Timestamp:
- 01/02/10 22:14:10 (13 years ago)
- Branches:
- master, qt5
- Children:
- 9bbb44e
- Parents:
- 489f262
- Location:
- src
- Files:
-
- 2 added
- 9 edited
Legend:
- Unmodified
- Added
- Removed
-
src/app/app.pro
r489f262 rd0d0a66 2 2 TARGET = fosdem 3 3 DESTDIR = ../bin 4 QT += sql 4 5 5 6 # module dependencies -
src/gui/gui.pro
r489f262 rd0d0a66 3 3 DESTDIR = ../bin 4 4 CONFIG += static 5 QT += sql 5 6 6 7 # module dependencies 7 LIBS += -L$$DESTDIR -lmodel 8 INCLUDEPATH += ../ model9 DEPENDPATH += . ../ model10 TARGETDEPS += $$DESTDIR/lib model.a8 LIBS += -L$$DESTDIR -lmodel -orm 9 INCLUDEPATH += ../orm ../model 10 DEPENDPATH += . ../orm ../model 11 TARGETDEPS += $$DESTDIR/liborm.a $$DESTDIR/libmodel.a 11 12 12 13 -
src/gui/mainwindow.cpp
r489f262 rd0d0a66 1 1 #include "mainwindow.h" 2 3 #include <QTreeView> 4 5 #include <eventmodel.h> 2 6 3 7 MainWindow::MainWindow(QWidget *parent) 4 8 : QMainWindow(parent) 5 9 { 10 // open database connection 11 QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); 12 db.setDatabaseName("fosdem-test.sqlite"); 13 db.open(); 14 15 QTreeView * view = new QTreeView(parent); 16 this->setCentralWidget(view); 17 18 view->setModel(new EventModel()); 6 19 } -
src/model/event.cpp
r489f262 rd0d0a66 14 14 Event Event::getById(int id, int conferenceId) 15 15 { 16 QString query = selectQuery() + "WHERE id = :id AND xid_conference = :conf"; 16 QSqlQuery query; 17 query.prepare(selectQuery() + "WHERE id = :id AND xid_conference = :conf"); 18 query.bindValue(":id", id); 19 query.bindValue(":conf", conferenceId); 20 return loadOne(query); 21 } 17 22 18 QSqlQuery q; 19 q.prepare(query); 20 q.bindValue(":id", id); 21 q.bindValue(":conf", conferenceId); 22 return loadOne(q); 23 QList<Event> Event::getByDate(const QDate& date, int conferenceId) 24 { 25 QSqlQuery query; 26 query.prepare(selectQuery() + "WHERE xid_conference = :conf AND start >= :start AND start < :end ORDER BY start"); 27 query.bindValue(":conf", conferenceId); 28 query.bindValue(":start", convertToDb(date, QVariant::DateTime)); 29 query.bindValue(":end", convertToDb(date.addDays(1), QVariant::DateTime)); 30 31 return load(query); 23 32 } -
src/model/event.h
r489f262 rd0d0a66 24 24 public: 25 25 static Event getById(int id, int conferenceId); 26 static QList<Event> getByDate(const QDate& date, int conferenceId); 26 27 27 28 public: -
src/model/model.pro
r489f262 rd0d0a66 11 11 TARGETDEPS += $$DESTDIR/liborm.a 12 12 13 HEADERS += event.h 14 SOURCES += event.cpp 13 HEADERS += \ 14 event.h \ 15 eventmodel.h 16 SOURCES += \ 17 event.cpp \ 18 eventmodel.cpp 15 19 -
src/orm/ormrecord.h
r489f262 rd0d0a66 163 163 QVariant OrmRecord<T>::convertToDb(QVariant value, QVariant::Type colType) 164 164 { 165 if (colType == QVariant::DateTime && value. type() == QVariant::DateTime)165 if (colType == QVariant::DateTime && value.canConvert<QDateTime>()) 166 166 { 167 167 return value.toDateTime().toTime_t(); -
src/test/model/eventtest.cpp
r489f262 rd0d0a66 27 27 QCOMPARE(event.type(), QString("Podium")); 28 28 QCOMPARE(event.language(), QString("English")); 29 } 30 31 void EventTest::getByDate() 32 { 33 QCOMPARE(Event::getByDate(QDate(2009, 2, 7), 1).count(), 127); 34 QCOMPARE(Event::getByDate(QDate(2009, 2, 8), 1).count(), 154); 29 35 } 30 36 -
src/test/model/eventtest.h
r489f262 rd0d0a66 12 12 13 13 void getById(); 14 void getByDate(); 14 15 void storingValues(); 15 16 void hydrate();
Note: See TracChangeset
for help on using the changeset viewer.