/home/subzero/sqliteman/trunk/Sqliteman/sqliteman/database.h

Go to the documentation of this file.

/*
For general Sqliteman copyright and licensing information please refer
to the COPYING file provided with the program. Following this notice may exist
a copyright and/or license notice that predates the release of Sqliteman
for which a new license (GPL+exception) is in place.
*/

#ifndef DATABASE_H
#define DATABASE_H

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QStringList>


#define SESSION_NAME "sqliteman-db"

typedef struct
{
    int cid;
    QString name;
    QString type;
    bool notnull;
    QString defval;
    bool pk;
    QString comment;
}
DatabaseTableField;

typedef QMap<QString,QString> DbAttach;

typedef QList<DatabaseTableField> FieldList;

typedef QMap<QString,QString> DbObjects;


class Database
{
        Q_DECLARE_TR_FUNCTIONS(Database)
                
    public:
        static DbAttach getDatabases();
        static DbObjects getObjects(const QString type = 0, const QString schema = "main");

        static DbObjects getSysObjects(const QString & schema = "main");

        static QStringList getSysIndexes(const QString & table, const QString & schema);

        static bool execSql(QString statement);

        static QString sessionName(const QString & schema);

        static bool dropTable(const QString & table, const QString & schema);

        static bool dropTrigger(const QString & name, const QString & schema);

        static FieldList tableFields(const QString & table, const QString & schema);
        
        static QStringList indexFields(const QString & index, const QString &schema);
        
        static bool dropView(const QString & view, const QString & schema);

        static bool dropIndex(const QString & name, const QString & schema);

        static bool exportSql(const QString & fileName);

        static QString describeObject(const QString & name, const QString & schema = "main");

        static QString hex(const QByteArray & val);

        static QString pragma(const QString & name);

    private:
        static void exception(const QString & message);
};

#endif

---