1 | #include "event.h" |
---|
2 | |
---|
3 | QSqlRecord const Event::sColumns = Event::toRecord(QList<QSqlField>() |
---|
4 | << QSqlField("id", QVariant::Int) |
---|
5 | << QSqlField("xid_conference", QVariant::Int) |
---|
6 | << QSqlField("start", QVariant::DateTime) |
---|
7 | << QSqlField("duration", QVariant::Int) |
---|
8 | << QSqlField("xid_activity", QVariant::Int) |
---|
9 | << QSqlField("type", QVariant::String) |
---|
10 | << QSqlField("language", QVariant::String) |
---|
11 | << QSqlField("favourite", QVariant::Bool)); |
---|
12 | |
---|
13 | QString const Event::sTableName = QString("event"); |
---|
14 | |
---|
15 | Event Event::getById(int id, int conferenceId) |
---|
16 | { |
---|
17 | QSqlQuery query; |
---|
18 | query.prepare(selectQuery() + "WHERE id = :id AND xid_conference = :conf"); |
---|
19 | query.bindValue(":id", id); |
---|
20 | query.bindValue(":conf", conferenceId); |
---|
21 | return loadOne(query); |
---|
22 | } |
---|
23 | |
---|
24 | QList<Event> Event::getByDate(const QDate& date, int conferenceId) |
---|
25 | { |
---|
26 | QSqlQuery query; |
---|
27 | query.prepare(selectQuery() + "WHERE xid_conference = :conf AND start >= :start AND start < :end ORDER BY start"); |
---|
28 | query.bindValue(":conf", conferenceId); |
---|
29 | query.bindValue(":start", convertToDb(date, QVariant::DateTime)); |
---|
30 | query.bindValue(":end", convertToDb(date.addDays(1), QVariant::DateTime)); |
---|
31 | |
---|
32 | return load(query); |
---|
33 | } |
---|
34 | |
---|