#ifndef OPIE_PIM_ACCESS_SQL_H
#define OPIE_PIM_ACCESS_SQL_H

#include <qasciidict.h>

#include "otodoaccessbackend.h"

namespace Opie{
namespace DB {
class OSQLDriver;
class OSQLResult;
class OSQLResultItem;
}
}

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 settings, const QDateTime& d = QDateTime() );
    OTodo find(int uid)const;
    OTodo find(int uid, const QArray<int>&, uint cur, Frontend::CacheDirection )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 );

    QBitArray supports()const;
    QArray<int> matchRegexp(  const QRegExp &r ) const;
    void removeAllCompleted();
    

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

    QAsciiDict<int> m_dict;
    Opie::DB::OSQLDriver* m_driver;
    QArray<int> m_uids;
    bool m_dirty : 1;
};


#endif