pqxxconnection.h

/* This file is part of the KDE project
   Copyright (C) 2003 Adam Pigg <adam@piggz.co.uk>
 
   This program is free software; you can redistribute it and/or
   modify it under the terms of the GNU Library General Public
   License as published by the Free Software Foundation; either
   version 2 of the License, or (at your option) any later version.
 
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
   Library General Public License for more details.
 
   You should have received a copy of the GNU Library General Public License
   along with this program; see the file COPYING.  If not, write to
   the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
 * Boston, MA 02110-1301, USA.
*/
 
#ifndef PQXXCONNECTION_H
#define PQXXCONNECTION_H
 
#include <tqstringlist.h>
 
#include <kexidb/connection.h>
#include "pqxxcursor.h"
 
 
 
 
namespace KexiDB
{
 
class pqxxSqlConnectionInternal;

class pqxxTransactionData : public TransactionData
{
    public:
        pqxxTransactionData(Connection *conn, bool nontransaction);
        ~pqxxTransactionData();
        pqxx::transaction_base *data;
};

class pqxxSqlConnection : public Connection
{
    TQ_OBJECT
  
 
    public:
        virtual ~pqxxSqlConnection();
 
        virtual Cursor* prepareQuery( const TQString& statement = TQString(), uint cursor_options = 0 );
        virtual Cursor* prepareQuery( QuerySchema& query, uint cursor_options = 0 );
        virtual PreparedStatement::Ptr prepareStatement(PreparedStatement::StatementType type, 
            FieldList& fields);
    protected:
 
        pqxxSqlConnection( Driver *driver, ConnectionData &conn_data );
 
        virtual bool drv_isDatabaseUsed() const;
        virtual bool drv_connect(KexiDB::ServerVersionInfo& version);
        virtual bool drv_disconnect();
        virtual bool drv_getDatabasesList( TQStringList &list );
        virtual bool drv_createDatabase( const TQString &dbName = TQString() );
        virtual bool drv_useDatabase( const TQString &dbName = TQString(), bool *cancelled = 0, 
          MessageHandler* msgHandler = 0 );
        virtual bool drv_closeDatabase();
        virtual bool drv_dropDatabase( const TQString &dbName = TQString() );
        virtual bool drv_executeSQL( const TQString& statement );
        virtual TQ_ULLONG drv_lastInsertRowID();
 
//TODO: move this somewhere to low level class (MIGRATION?)
        virtual bool drv_getTablesList( TQStringList &list );
//TODO: move this somewhere to low level class (MIGRATION?)
        virtual bool drv_containsTable( const TQString &tableName );
 
        virtual TransactionData* drv_beginTransaction();
        virtual bool drv_commitTransaction(TransactionData *);
        virtual bool drv_rollbackTransaction(TransactionData *);
 
        //Error reporting
        virtual int serverResult();
        virtual TQString serverResultName();
        virtual void drv_clearServerResult();
        virtual TQString serverErrorMsg();
        
        pqxxSqlConnectionInternal *d;
    private:
        TQString lastRowId;
        TQString escapeName(const TQString &tn) const;
        //      pqxx::transaction_base* m_trans;
        pqxxTransactionData *m_trans;
 
        
 
    friend class pqxxSqlDriver;
    friend class pqxxSqlCursor;
    friend class pqxxTransactionData;
};
}
#endif