reittiopas_qtquick/dbmanager.h at public · aop/reittiopas_qtquick · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
#ifndef DBMANAGER_H
#define DBMANAGER_H

#include <QObject>
#include <QSqlDatabase>
#include <QSqlError>
#include <QFile>
#include <QSqlQuery>

#include "addressparser.h"

class DBManager : public QObject
{
    Q_OBJECT
public:
    explicit DBManager(QObject *parent = 0);
    ~DBManager();
    bool openDB();
    void closeDB();
    QSqlError lastError();
    QList<AddressContainer *> getAddresses(QString startswith=QString());
    int insertAddress(AddressContainer *addr);
    bool deleteDB();
    QList<AddressContainer*> addressQuery(QSqlQuery query);
    AddressContainer * getExactAddress(QString name);
    bool removeAddress(QString name);

private:
    QSqlDatabase db;
    bool createTables();

signals:

public slots:

};

#endif // DBMANAGER_H