src/flbase/FLSqlQuery.h

Ir a la documentación de este archivo.

/***************************************************************************
                              FLSqlQuery.h
                          -------------------
 begin                : sáb jun 22 2002
 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 FLSQLQUERY_H
#define FLSQLQUERY_H

#include "FLTableMetaData.h"

#include <qsqlquery.h>
#include <qvariant.h>
#include <qdict.h>
#include <qregexp.h>
#include <qstringlist.h>
#include <qinputdialog.h>
#include <qdict.h>

class FLParameterQuery;
class FLGroupByQuery;
class FLFieldMetaData;
class FLSqlDatabase;
class FLSqlQueryPrivate;

class FL_EXPORT FLSqlQuery: public QObject
{

  Q_OBJECT

public:

  FLSqlQuery(QObject *parent = 0, const QString &connectionName = "default");

  ~FLSqlQuery();

  bool exec();

  void addParameter(const FLParameterQuery *p);

  void addGroup(const FLGroupByQuery *g);

  typedef QDict<FLParameterQuery> FLParameterQueryDict;

  typedef QDict<FLGroupByQuery> FLGroupByQueryDict;

  void setName(const QString &n);

  QString name() const;

  QString select() const;

  QString from() const;

  QString where() const;

  QString orderBy() const;

  void setSelect(const QString &s, const QString &sep = QString::fromLatin1(","));

  void setFrom(const QString &f);

  void setWhere(const QString &w);

  void setOrderBy(const QString &w);

  QString sql();

  FLParameterQueryDict *parameterDict() const;

  FLGroupByQueryDict *groupDict() const;

  QStringList fieldList() const;

  void setGroupDict(FLGroupByQueryDict *gd);

  void setParameterDict(FLParameterQueryDict *pd);

  void showDebug();

  QVariant value(const QString &n, bool raw = false) const;
  
  
  bool isNull(const QString &n) const;

  QVariant value(int i, bool raw = false) const;
  
  QString posToFieldName(const int p) const;

  int fieldNameToPos(const QString &n) const;

  QStringList tablesList() const;

  void setTablesList(const QString &tl);

  void setValueParam(const QString &name, const QVariant &v);

  QVariant valueParam(const QString &name) const;

  int size() const;

  FLTableMetaData::FLFieldMetaDataList *fieldMetaDataList();

#ifdef FL_DEBUG
  static long countRefQuery;
#endif

  FLSqlDatabase *db() const;

private:

  FLSqlQueryPrivate *d;

public:

  //
  // QSqlQuery
  //

  bool                isValid() const {
    return qry_.isValid();
  }
  bool                isActive() const {
    return qry_.isActive();
  }
  bool                isNull(int field) const {
    return qry_.isNull(field);
  }
  int                 at() const {
    return qry_.at();
  }
  QString             lastQuery() const {
    return qry_.lastQuery();
  }
  int                 numRowsAffected() const {
    return qry_.numRowsAffected();
  }
  QSqlError           lastError() const {
    return qry_.lastError();
  }
  bool                isSelect() const {
    return qry_.isSelect();
  }
  int                 QSqlQuery_size() const {
    return qry_.size();
  }
  const QSqlDriver   *driver() const {
    return qry_.driver();
  }
  const QSqlResult   *result() const {
    return qry_.result();
  }
  bool                isForwardOnly() const {
    return qry_.isForwardOnly();
  }
  void                setForwardOnly(bool forward) {
    qry_.setForwardOnly(forward);
  }

  bool        exec(const QString &query) {
    return qry_.exec(query);
  }
  QVariant    QSqlQuery_value(int i) const {
    return qry_.value(i);
  }

  bool        seek(int i, bool relative = FALSE) {
    return qry_.seek(i, relative);
  }
  bool        next() {
    return qry_.next();
  }
  bool        prev() {
    return qry_.prev();
  }
  bool        first() {
    return qry_.first();
  }
  bool        last() {
    return qry_.last();
  }

  // prepared query support
  bool                prepare(const QString &query) {
    return qry_.prepare(query);
  }
  void                bindValue(const QString &placeholder, const QVariant &val) {
    qry_.bindValue(placeholder, val);
  }
  void                bindValue(int pos, const QVariant &val) {
    qry_.bindValue(pos, val);
  }
  void                addBindValue(const QVariant &val) {
    qry_.addBindValue(val);
  }
  // remove these overloads in 4.0
  void                bindValue(const QString &placeholder, const QVariant &val, QSql::ParameterType type) {
    qry_.bindValue(placeholder, val, type);
  }
  void                bindValue(int pos, const QVariant &val, QSql::ParameterType type) {
    qry_.bindValue(pos, val, type);
  }
  void                addBindValue(const QVariant &val, QSql::ParameterType type) {
    qry_.addBindValue(val, type);
  }
  QVariant            boundValue(const QString &placeholder) const {
    return qry_.boundValue(placeholder);
  }
  QVariant            boundValue(int pos) const {
    return qry_.boundValue(pos);
  }
  QMap<QString, QVariant> boundValues() const {
    return qry_.boundValues();
  }
  QString             executedQuery() const {
    return qry_.executedQuery();
  }

private:

  QSqlQuery qry_;
};

class FLSqlQueryPrivate
{
public:

  FLSqlQueryPrivate();
  ~FLSqlQueryPrivate();

  QString name_;

  QString select_;

  QString from_;

  QString where_;

  QString orderBy_;

  QStringList fieldList_;

  FLSqlQuery::FLParameterQueryDict *parameterDict_;

  FLSqlQuery::FLGroupByQueryDict *groupDict_;

  QStringList tablesList_;

  FLTableMetaData::FLFieldMetaDataList *fieldMetaDataList_;

  FLSqlDatabase *db_;
};

inline FLSqlDatabase *FLSqlQuery::db() const
{
  return d->db_;
}

inline void FLSqlQuery::setName(const QString &n)
{
  d->name_ = n;
}

inline QString FLSqlQuery::name() const
{
  return d->name_;
}

inline QString FLSqlQuery::select() const
{
  return d->select_;
}

inline QString FLSqlQuery::from() const
{
  return d->from_;
}

inline QString FLSqlQuery::where() const
{
  return d->where_;
}

inline QString FLSqlQuery::orderBy() const
{
  return d->orderBy_;
}

inline FLSqlQuery::FLParameterQueryDict *FLSqlQuery::parameterDict() const
{
  return d->parameterDict_;
}

inline FLSqlQuery::FLGroupByQueryDict *FLSqlQuery::groupDict() const
{
  return d->groupDict_;
}

inline QStringList FLSqlQuery::fieldList() const
{
  return d->fieldList_;
}

inline QStringList FLSqlQuery::tablesList() const
{
  return d->tablesList_;
}

#endif