adatabase.h

/****************************************************************************
** $Id: adatabase.h,v 1.52 2008/05/19 06:45:31 app Exp $
**
** Header file of the ananas database of Ananas
** Designer and Engine applications
**
** Created : 20031201
**
** Copyright (C) 2003-2004 Leader InfoTech.  All rights reserved.
** Copyright (C) 2003-2005 Grigory Panov <gr1313 at mail dot ru >, Yoshkar-Ola
**
** This file is part of the Library of the Ananas
** automation accounting system.
**
** 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.
**
** 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.leaderit.ru/page=ananas or email sales@leaderit.ru
** See http://www.leaderit.ru/gpl/ for GPL licensing information.
**
** Contact org@leaderit.ru if any conditions of this licensing are
** not clear to you.
**
**********************************************************************/

#ifndef ADATABASE_H
#define ADATABASE_H
#include <qobject.h>
#include <qstringlist.h>
#include <qsqldatabase.h>
#include <qdict.h>
#include "acfg.h"
#include <qwidget.h>

#define db_document_header      "dh%1"
#define db_document_table       "dt%1_%2"
#define db_catalog_element      "ce%1"
#define db_catalog_group        "cg%1"
#define db_iregister            "ri%1"
#define db_aregister            "ra%1"
#define db_areg_remainder       "ra%1_rem"
#define db_user_roles           "usr_rl"
#define db_users                "usr"
#define db_roles                "rl"
#define db_right_roles          "r_rl"
#define db_indices              "idc"
#define db_areg_dim             "ra%1_d%2"

class aDatabase;
class aCfgRc;
class aDataTable;
//class QDataSchema;


class  ANANAS_EXPORT aDatabase: public QObject
{
        Q_OBJECT

public slots:
public:
        enum dbServer
        {
        unknown,
        mysql,
        postgresql,
        odbc,
        oracle,
        mssql,
        sybase };

        
        aCfg cfg;

        aDatabase();
        ~aDatabase();
        bool            init( aCfgRc *rc, const QString &dbname = QString::null );
        bool            init( const QString &rcname, const QString &dbname = QString::null );
        bool            prepareDatabaseConnect( aCfgRc *rc );
        void            done();
        QSqlDatabase*   db(const QString &dbname = QString::null );
        bool            checkStructure();
        bool            create();
        bool            drop( const QString &);
        bool            update();
        Q_ULLONG        uid( int otype );
        int             uidType ( Q_ULLONG uid );
        aDataTable*     table( const QString & name = QString::null );
        bool            tableExists( const QString & name );
        void            markDeleted(Q_ULLONG uid);
        void            deleteMarked();
        QString         driverName();

        static QStringList      supportedDriverList();
        static QStringList      getUniqueIndices(const QString & flddef);
        static QString          tableDbName( aCfg &md, aCfgItem context, long * tid);
        static QString          tableDbName( aCfg &md, aCfgItem context);

        bool exchangeDataSystables       ( QDomDocument &xml, bool import );
        bool exchangeDataCatalogues      ( QDomDocument &xml, bool import );
        bool exchangeDataDocuments       ( QDomDocument &xml, bool import );
        bool exchangeDataJournals        ( QDomDocument &xml, bool import );
        bool exchangeDataInfoRegisters   ( QDomDocument &xml, bool import );
        bool exchangeDataAccumulationRegisters   ( QDomDocument &xml, bool import );
        bool exchangeDataUniques         ( QDomDocument &xml, bool import );

        bool transaction();
        bool commit();
        bool rollback();
private:
        QSqlDatabase *dataBase;

        bool exportTableData(QDomDocument& xml, const QString &tableName);
        bool importTableData(QDomDocument& xml, const QString &tableName);
        void reportError(QSqlError er, const QString &query);

        QString fieldtype( const QString &tdef );
        void checkIndices(const QString &table, const QString &flddef, QStringList &ui_add, QStringList &ui_drop);
        bool isExists(const QString fname, QStringList *f_lst, QString &match);
        QString fieldsDef( aCfgItem context, const QString &idx=QString::null);
        QString sysFieldsDef ( aCfgItem context );
        QString convFieldsDef( const QString flddef, QString &idxdef, QString &pkey );
        bool createdb( bool update );
        bool createIndexes(const QString &table, const QString &indexl, const QStringList & uidc=QStringList());
        bool dropIndexes(const QString &table, const QStringList &indices=QStringList());
        bool verifyTable( const QString &table, const QString &flddef,
        QString &f_drop, QString &f_add, QString &f_upd,
        QString &i_drop, QString &i_add, QStringList & ui_drop, QStringList & ui_add);
        bool createTable(int update, const QString table, QString flddef );
        bool createSystables( bool update );
        bool createCatalogues( bool update );
        bool createDocuments( bool update );
        bool createJournals( bool update );
        bool createInformationRegisters( bool update );
        bool createAccumulationRegisters( bool update );
        bool createARegisters( bool update );
        bool dumpTable( QDomDocument& xml, const QString &tableName);
        void fillFeatures();
        QString feature(const QString& fetureName);

        QMap<QString, QString> featuresMySQL, featuresSQLite, featuresPostgreSQL;

};

#endif

---