src/flbase/FLSqlDatabase.h

Ir a la documentación de este archivo.

/***************************************************************************
                             FLSqlDatabase.h
                          -------------------
 begin                : Thu Nov 22 2005
 copyright            : (C) 2002-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.
 ***************************************************************************/

#ifndef FLSQLDATABASE_H
#define FLSQLDATABASE_H

#include <qsqldatabase.h>
#include <qsqlresult.h>

class FLTableMetaData;
class FLSqlCursor;
class FLManager;
class FLManagerModules;

class FL_EXPORT FLSqlDatabase
{

public:

  enum ConnOptions {
    USER = 0,
    PASSWORD = 1,
    PORT = 2,
    HOST = 3
  };

  FLSqlDatabase();

  ~FLSqlDatabase();

  static QStringList driverAliases();

  static QString defaultAlias();

  static QString driverAliasToDriverName(const QString &alias);

  static QString driverNameToDriverAlias(const QString &name);

  static bool needConnOption(const QString &alias, const int connOption);

  static QString defaultPort(const QString &alias);

  bool loadDriver(const QString &driverName, const QString &connName = "default");

  bool connectDB(const QString &database, const QString &user = QString::null,
                 const QString &password = QString::null,
                 const QString &host = QString::null,
                 int port = -1, const QString &connName = "default");

  bool connectDB();

  void closeDB();

  bool createTable(FLTableMetaData *tmd);

  bool canRegenTables();

  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);

  QSqlDatabase *db() const {
    return db_;
  }

  QSqlDatabase *dbAux() const {
    return dbAux_;
  }

  QString database() const {
    return database_;
  }

  QString user() const {
    return user_;
  }

  QString password() const {
    return password_;
  }

  QString host() const {
    return host_;
  }

  int port() const {
    return port_;
  }

  QString driverName() const {
    return driverName_;
  }

  bool alterTable(const QString &mtd1, const QString &mtd2, const QString &key = QString::null);

  FLManager *manager();

  FLManagerModules *managerModules();

  QString connectionName() const {
    return connectionName_;
  }

  bool canSavePoint();

  bool savePoint(const QString &n);

  bool releaseSavePoint(const QString &n);

  bool rollbackSavePoint(const QString &n);

  bool canTransaction() const;

  void Mr_Proper();

  bool canDetectLocks() const;

  QStringList locksStatus();

  QStringList detectLocks();

  QStringList detectRisksLocks(const QString &table = QString::null, const QString &primaryKeyValue = QString::null);

  bool regenTable(const QString &n, FLTableMetaData *tmd);

  // Some Wrappers to QSqlDatabase
  bool isOpen() const;
  bool isOpenError() const;
  QStringList tables() const;
  QStringList tables(QSql::TableType type) const;
  QSqlError lastError() const;
  QString connectOptions() const;

private:

  QSqlDatabase *db_;

  QSqlDatabase *dbAux_;

  QString database_;

  QString user_;

  QString password_;

  QString host_;

  int port_;

  QString driverName_;

  FLManager *manager_;

  FLManagerModules *managerModules_;

  QString connectionName_;

  bool lockDetection_;
};

#endif