src/plugins/sqldrivers/psql/qsql_psql.h

Ir a la documentación de este archivo.

/***************************************************************************
                              qsql_psql.h
                          -------------------
 begin                : mie Sep 15 2004
 copyright            : (C) 2004-2005 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; version 2 of the License.               *
 ***************************************************************************/
/***************************************************************************
   Este  programa es software libre. Puede redistribuirlo y/o modificarlo
   bajo  los  términos  de  la  Licencia  Pública General de GNU   en  su
   versión 2, publicada  por  la  Free  Software Foundation.
 ***************************************************************************/
/****************************************************************************
**
** Definition of PostgreSQL driver classes
**
** Created : 001103
**
** Copyright (C) 1992-2000 Trolltech AS.  All rights reserved.
**
** This file is part of the sql module of the Qt GUI Toolkit.
**
** This file may be distributed under the terms of the Q Public License
** as defined by Trolltech AS of Norway and appearing in the file
** LICENSE.QPL included in the packaging of this file.
**
** This file may be distributed and/or modified under the terms of the
** GNU General Public License version 2 as published by the Free Software
** Foundation and appearing in the file LICENSE.GPL included in the
** packaging of this file.
**
** Licensees holding valid Qt Enterprise Edition licenses may use this
** file in accordance with the Qt Commercial License Agreement provided
** with the Software.
**
** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
**
** See http://www.trolltech.com/pricing.html or email sales@trolltech.com for
**   information about Qt Commercial License Agreements.
** See http://www.trolltech.com/qpl/ for QPL licensing information.
** See http://www.trolltech.com/gpl/ for GPL licensing information.
**
** Contact info@trolltech.com if any conditions of this licensing are
** not clear to you.
**
**********************************************************************/

#ifndef QSQL_PSQL_H
#define QSQL_PSQL_H

#include <qdict.h>
#include <qsqlresult.h>
#include <qsqldriver.h>
#include <qmessagebox.h>
#include <qptrvector.h>
#include <libpq-fe.h>
#include <FLManager.h>
#include <FLManagerModules.h>
#include <FLTableMetaData.h>
#include <FLFieldMetaData.h>
#include <FLRelationMetaData.h>
#include <FLUtil.h>
#include <FLSqlDatabase.h>
#include <FLSqlDriver.h>
#include <FLSqlCursor.h>
#include <FLDiskCache.h>

#ifdef QT_PLUGIN
#define Q_EXPORT_SQLDRIVER_PSQL
#else
#define Q_EXPORT_SQLDRIVER_PSQL Q_EXPORT
#endif

class QPSQLPrivate;
class QPSQLDriver;
class QSqlRecordInfo;

class QPSQLDriver : public FLSqlDriver
{

  Q_OBJECT

public:

  enum Protocol {
    Version6  = 6,
    Version7  = 7,
    Version71 = 8,
    Version73 = 9,
    Version74 = 10,
    Version8  = 11,
    Version81 = 12,
    Version82 = 13,
    Version83 = 14,
    Version84 = 15,
    Version9  = 16,
    Version91 = 17
  };

  QPSQLDriver(QObject *parent = 0, const char *name = 0);
  QPSQLDriver(PGconn *conn, QObject *parent = 0, const char *name = 0);
  ~QPSQLDriver();
  bool hasFeature(DriverFeature f) const;
  bool open(const QString &db, const QString &user = QString::null,
            const QString &password = QString::null, const QString &host = QString::null, int port = -1);
  void close();
  QSqlQuery createQuery() const;
  QStringList tables(const QString &user) const;
  QSqlIndex primaryIndex(const QString &tablename) 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;

  Protocol protocol() const {
    return pro;
  }
  PGconn *connection();
  QString formatValue(const QSqlField *field, bool trimStrings) const;

  // ### remove me for 4.0
  bool open(const QString &db, const QString &user, const QString &password,
            const QString &host, int port, const QString &connOpts);

  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);
  int atFrom(FLSqlCursor *cur);
  bool alterTable(const QString &mtd1, const QString &mtd2, const QString &key = QString::null);
  bool canSavePoint();
  bool savePoint(const QString &n);
  bool releaseSavePoint(const QString &n);
  bool rollbackSavePoint(const QString &n);
  QStringList rowsLockeds(const QString &table, const QString &primaryKeyValue = QString::null);
  QStringList locksStatus();
  QStringList detectLocks();
  QStringList detectRisksLocks(const QString &table = QString::null, const QString &primaryKeyValue = QString::null);
  bool regenTable(const QString &n, FLTableMetaData *tmd);
  int backendId() const;

private slots:

  void Mr_Proper();

protected:

  bool beginTransaction();
  bool commitTransaction();
  bool rollbackTransaction();

private:

  QSqlIndex primaryIndex2(const QString &tablename) const;
  QSqlRecord record2(const QString &tablename) const;
  QSqlRecord record(FLTableMetaData *mtd) const;
  bool constraintExists(const QString &name) const;
  bool alterTable(FLTableMetaData *newMTD);
  QSqlRecordInfo recordInfo2(const QString &tablename) const;
  bool alterTable2(const QString &mtd1, const QString &mtd2, const QString &key = QString::null, bool force = false);
  int insertMulti(const QString &tablename, QPtrList<QSqlRecord> * records);
#ifndef FL_QUICK_CLIENT
  void createIndex(const QString &fieldName, const QString &tableName, bool textOp, bool noUpper = false) const;
  static QDict < bool > * dictIndexes;
#endif
  void init();
  Protocol pro;
  QPSQLPrivate *d;
};

class QPSQLResult : public QSqlResult
{

  friend class QPSQLDriver;

public:

  QPSQLResult(const QPSQLDriver *db, const QPSQLPrivate *p);
  ~QPSQLResult();
  PGresult *result();

protected:

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

private:

  void calcSize();
  bool nextResult(int i);
  void closeCursor();
  bool openCursor();
  void cleanupCache();
  int currentSize;
  QPSQLPrivate *d;

  static int cursorCounter;
};

#endif