6 #include <QSqlDatabase>
11 #include "coordinates/geocoordinate.h"
12 #include "notification.h"
14 class Database : public QObject
18 Database(QObject *parent = 0);
21 bool addTag(qulonglong userId, const QString &tag);
22 QList<Notification*> &getNotifications(qulonglong userId);
23 QStringList getTags(qulonglong userId);
24 QByteArray getInterestingPeople(qulonglong userId,
25 const GeoCoordinate &southWestCoordinates,
26 const GeoCoordinate &northEastCoordinates);
28 bool createNotificationTable();
29 bool createTagTable();
30 bool createUserTagTable();
31 bool createUserTable();
33 bool sendMessage(qulonglong senderId, qulonglong receiverId, const QString &message);
36 QSqlDatabase m_database;
37 QList<Notification*> m_notifications;