summaryrefslogtreecommitdiffstats
path: root/kexi/kexidb/drivers/pqxx/pqxxconnection.h
blob: 50ec655ed251fe00b8dcf0fe62e62b4a2eceb868 (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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
/* 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;

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

/**
@author Adam Pigg
*/
class pqxxSqlConnection : public Connection
{
	Q_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;
		//! temporary solution for executeSQL()...
		pqxxTransactionData *m_trans;

		

	friend class pqxxSqlDriver;
	friend class pqxxSqlCursor;
	friend class pqxxTransactionData;
};
}
#endif