/***************************************************************************
                         qsqlite.h  -  description
                            -------------------
   begin                : lun Nov 24 2003
   copyright            : (C) 2003-2004 by InfoSiAL S.L.
   email                : mail@infosial.com
***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 ***************************************************************************/

#ifndef QSQLITE_H
#define QSQLITE_H

#include <qsqlresult.h>
#include <qstringlist.h>
#include <qregexp.h>
#include <qdir.h>
#include <stdlib.h>
#include <qmessagebox.h>
#include <FLManager.h>
#include <FLTableMetaData.h>
#include <FLFieldMetaData.h>
#include <FLManagerModules.h>
#include <FLUtil.h>
#include <sqlitedataset.h>
#include <FLSqlDatabase.h>
#include <FLSqlDriver.h>
#include <FLSqlConnections.h>
#include <FLDiskCache.h>

#if (QT_VERSION-0 >= 0x030000)
typedef QVariant QSqlVariant;
#endif

using namespace dbiplus;

class SqliteDriver : public FLSqlDriver
{

public:

    SqliteDriver( QObject * parent = 0, const char *name = 0 );
    ~SqliteDriver();
    bool open( const QString & db, const QString & user = QString::null, const QString & password = QString::null, const QString & host = QString::null, int port = -1 );
    bool open( const QString & db, const QString & user, const QString & password, const QString & host, int port, const QString & connOpts );
    void close();
    bool hasFeature( QSqlDriver::DriverFeature f ) const;
    QSqlQuery createQuery() const;
    QStringList tables( const QString & user ) const;
    QSqlRecord record( const QString & tablename ) const;
    QSqlRecord record( const QSqlQuery & query ) const;
    QSqlRecordInfo recordInfo( const QString & tablename ) const;
    QSqlRecordInfo recordInfo( const QSqlQuery & query ) const;
    QSqlIndex primaryIndex( const QString & tablename ) const;
    bool beginTransaction();
    bool commitTransaction();
    bool rollbackTransaction();
    SqliteDatabase *dataBase();

    QString formatDatabaseName( const QString & name );
    bool tryConnect( const QString & db, const QString & user = QString::null, const QString & password = QString::null, const QString & host = QString::null, int port = -1 );
    QString sqlCreateTable( FLTableMetaData * tmd );
    QString formatValueLike( int t, const QVariant & v, const bool upper = false );
    QString formatValue( int t, const QVariant & v, const bool upper = false );
    QVariant nextSerialVal( const QString & table, const QString & field );
    bool alterTable( const QString & mtd1, const QString & mtd2, const QString & key = QString::null );
    void Mr_Proper();

private:

    QSqlIndex primaryIndex2( const QString& tablename ) const;
    QSqlRecord record2( const QString& tablename ) const;
    QSqlRecordInfo recordInfo2( const QString& tablename ) const;
    SqliteDatabase *dataBase_;
};

class SqliteResult : public QSqlResult
{

public:

    SqliteResult( const QSqlDriver * d );
    ~SqliteResult();

protected:

    QVariant data( int );
    bool reset( const QString & query );
    bool fetch( int );
    bool fetchFirst();
    bool fetchLast();
    bool isNull( int );
    int size();
    int numRowsAffected();

private:

    QString query;
    const SqliteDriver *driver;
    Dataset *dataSet;
};

#endif