summaryrefslogtreecommitdiff
path: root/libopie2/opiepim/backend/otodoaccesssql.h
blob: 6c5f50aa8caa0418a1ef153091054e4fa5afeefc (plain)
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
39
40
41
42
43
44
45
46
#ifndef OPIE_PIM_ACCESS_SQL_H
#define OPIE_PIM_ACCESS_SQL_H

#include <qasciidict.h>

#include "otodoaccessbackend.h"

class OSQLDriver;
class OSQLResult;
class OTodoAccessBackendSQL : public OTodoAccessBackend {
public:
    OTodoAccessBackendSQL( const QString& file );
    ~OTodoAccessBackendSQL();

    bool load();
    bool reload();
    bool save();
    QArray<int> allRecords()const;

    QArray<int> queryByExample( const OTodo& t, int sort );
    OTodo find(int uid)const;
    void clear();
    bool add( const OTodo& t );
    bool remove( int uid );
    bool replace( const OTodo& t );

    QArray<int> overDue();
    QArray<int> effectiveToDos( const QDate& start,
                                const QDate& end, bool includeNoDates );
    QArray<int> sorted(bool asc, int sortOrder, int sortFilter, int cat );

private:
    void update();
    void fillDict();
    inline bool date( QDate& date, const QString& )const;
    inline OTodo todo( const OSQLResult& )const;
    inline QArray<int> uids( const OSQLResult& )const;
    OTodo todo( int uid )const;

    QAsciiDict<int> m_dict;
    OSQLDriver* m_driver;
    QArray<int> m_uids;
};


#endif