qlabdatabase.h

#ifndef QLABDATABASE_H
#define QLABDATABASE_H

#include <qobject.h>
#include <qvariant.h>

// forward declarations
class QStringList ;
class QSqlRecord ;
class QlabDatabase ;
class QlabDatabase_priv ;
class QlabDatabaseTableSchema_priv ;


// convenient typedef
typedef QMap< QString, QlabDatabase * > Associations ;

class Q_EXPORT QlabDatabase : public QObject
{
        Q_OBJECT ;

        Q_ENUMS( AssociationModes ) ;
        Q_ENUMS( OperationModes ) ;
        Q_ENUMS( ErrorCodes ) ;

public :
        enum AssociationModes { AssocNone = 0,
                                                    AssocMustProvide = 1,
                                                        AssocCanProvide = 2,
                                                        AssocUnique = 4,
                                                        AssocIsList = 8
                                                  } ;
        enum OperationModes { ReadData,
                                                  ModifyData,
                                                  CreateNewData,
                                                  DeleteData
                                                } ;
        enum ErrorCodes { DriverNotInstalled,
                                          DuplicateConnectionName,
                                          InvalidConnection,
                                          InvalidConnectionTableAccess
                                        } ;

        QlabDatabase( const QString & driver, const QString & connectionName = QString::null,
                                  bool autoconnect = TRUE, QObject *parent, char * name ) ;
        QlabDatabase( const QString & tableName, bool autoPopulate,
                                  const QString & connectionName = QString::null ) ;
        ~QlabDatabase() ;

        static QStringList availableDrivers() const ;
        static bool importSchema( const QString & schemaPath ) ;
        static bool importExtendedSchema( const QString & schemaPath ) ;
        static bool createConnections( const QString & schemaPath = QString::null,
                                                                   bool autoconnect = TRUE  ) ;
        static bool addConnection( const QString & driver, const QString & connectionName = QString::null,
                                                           bool autoconnect = TRUE ) ;
        static QStringList connections() const ;

        bool openConnection( const QString & connectionName ) ;
        void setConnectionParameters( const QString & connectionName,
                                                                  const QString & databaseName, const QString & user,
                                                                  const QString & passwd, const QString & host = "localhost",
                                                                  int port = -1 ) ;
        void setConnectionOptions( const QString & connectionName, const QString & options ) ;

public slots :
        // Global properties


        // Table Properties
        bool addAssociation( const QString & assocName, AssociationModes mode = AssocMustProvide ) ;
        QlabDatabase * getAssociate( const QString & assocName ) ;
        QSqlRecord * getEntry( uint uoid ) ;
        QSqlRecord * createEntry() ;
        QSqlRecord * cloneEntry( int uoid = 0 ) ;
        QSqlRecord * modifyEntry( int uoid = 0 ) ;
        bool deleteEntry( int uoid = 0 ) ;
        bool saveChangedData() ;
        bool operationAllowed( OperationModes md, const QString & fld = QString::null ) ;
        void setFilter( const QString & flt ) ;
        QString filter() const ;
        void setSortOrder( const QStringList & order ) ;
        QStringList sortOrder() const ;

signals :
        error( uint errno, const QString & errDescription ) ;

protected :

protected slots :
        bool makeDirectSqlQuery( const QString & query ) ;

private :
        const QString connection ;
        bool validConnection ;
        const QString table ;
        Associations associates ;

        QlabDatabase_priv * tableView ;
        QSqlRecord * activeRecord ;
        QlabDatabaseTableSchema_priv * tableSchema ;

} ;

#endif // QLABDATABASE_H