/****************************************************************************
**
** Definition of PostgreSQL driver classes
**
** Created : 001103
**
** Copyright (C) 2010 Timothy Pearson and (C) 1992-2008 Trolltech ASA.
**
** This file is part of the sql module of the TQt GUI Toolkit.
**
** This file may be used under the terms of the GNU General
** Public License versions 2.0 or 3.0 as published by the Free
** Software Foundation and appearing in the files LICENSE.GPL2
** and LICENSE.GPL3 included in the packaging of this file.
** Alternatively you may (at your option) use any later version
** of the GNU General Public License if such license has been
** publicly approved by Trolltech ASA (or its successors, if any)
** and the KDE Free TQt Foundation.
**
** Please review the following information to ensure GNU General
** Public Licensing requirements will be met:
** http://trolltech.com/products/qt/licenses/licensing/opensource/.
** If you are unsure which license is appropriate for your use, please
** review the following information:
** http://trolltech.com/products/qt/licenses/licensing/licensingoverview
** or contact the sales department at sales@trolltech.com.
**
** This file may be used under the terms of the Q Public License as
** defined by Trolltech ASA and appearing in the file LICENSE.TQPL
** included in the packaging of this file.  Licensees holding valid TQt
** Commercial licenses may use this file in accordance with the TQt
** Commercial License Agreement provided with the Software.
**
** This file is provided "AS IS" with NO WARRANTY OF ANY KIND,
** INCLUDING THE WARRANTIES OF DESIGN, MERCHANTABILITY AND FITNESS FOR
** A PARTICULAR PURPOSE. Trolltech reserves all rights not granted
** herein.
**
**********************************************************************/

#ifndef TQSQL_PSTQL_H
#define TQSQL_PSTQL_H

#include <tqsqlresult.h>
#include <tqsqlfield.h>
#include <tqsqldriver.h>
#include <libpq-fe.h>

#ifdef TQT_PLUGIN
#define TQ_EXPORT_STQLDRIVER_PSQL
#else
#define TQ_EXPORT_STQLDRIVER_PSQL TQ_EXPORT
#endif

class TQPSTQLPrivate;
class TQPSTQLDriver;
class TQSqlRecordInfo;

class TQPSTQLResult : public TQSqlResult
{
    friend class TQPSTQLDriver;
public:
    TQPSTQLResult( const TQPSTQLDriver* db, const TQPSTQLPrivate* p );
    ~TQPSTQLResult();
    PGresult* result();
protected:
    void		cleanup();
    bool		fetch( int i );
    bool		fetchFirst();
    bool		fetchLast();
    TQVariant		data( int i );
    bool		isNull( int field );
    bool		reset ( const TQString& query );
    int			size();
    int			numRowsAffected();
private:
    int			currentSize;
    TQPSTQLPrivate*	d;
};

class TQ_EXPORT_STQLDRIVER_PSQL TQPSTQLDriver : public TQSqlDriver
{
public:
    enum Protocol {
	Version6 = 6,
	Version7 = 7,
	Version71 = 8,
	Version73 = 9
    };

    TQPSTQLDriver( TQObject * parent=0, const char * name=0 );
    TQPSTQLDriver( PGconn * conn, TQObject * parent=0, const char * name=0 );
    ~TQPSTQLDriver();
    bool		hasFeature( DriverFeature f ) const;
    bool		open( const TQString & db,
				const TQString & user = TQString::null,
				const TQString & password = TQString::null,
				const TQString & host = TQString::null,
				int port = -1 );
    void		close();
    TQSqlQuery		createQuery() const;
    TQStringList		tables( const TQString& user ) const;
    TQSqlIndex		primaryIndex( const TQString& tablename ) const;
    TQSqlRecord		record( const TQString& tablename ) const;
    TQSqlRecord		record( const TQSqlQuery& query ) const;
    TQSqlRecordInfo	recordInfo( const TQString& tablename ) const;
    TQSqlRecordInfo	recordInfo( const TQSqlQuery& query ) const;

    Protocol            protocol() const { return pro; }
    PGconn*             connection();
    TQString		formatValue( const TQSqlField* field,
				     bool trimStrings ) const;
    
    // ### remove me for 4.0
    bool open( const TQString& db,
	       const TQString& user,
	       const TQString& password,
	       const TQString& host,
	       int port,
	       const TQString& connOpts );
protected:
    bool		beginTransaction();
    bool		commitTransaction();
    bool		rollbackTransaction();
private:
    void		init();
    Protocol            pro;
    TQPSTQLPrivate*	d;
};

#endif