us_db2.h

Go to the documentation of this file.

#ifndef US_DB2_H
#define US_DB2_H

#include <QtCore>

// The supercomputer does not use the DB
#ifndef NO_DB
#include "mysql.h"
#endif

#include "us_extern.h"

class US_UTIL_EXTERN US_DB2
{
  public:

    US_DB2();

    US_DB2( const QString& );

    ~US_DB2();

#undef ERROR
    enum dbStatus
    {
      OK             = 0,       
      ERROR          = -1,      

      NOT_CONNECTED  = 1,       
     
      DUP_EMAIL      = 101,     
      NO_ACCT        = 102,     
      INACTIVE       = 103,     
      BADPASS        = 104,     
      EMPTY          = 105,     
      BAD_CHECKSUM   = 106,     
     
      NOTPERMITTED   = 201,     
      BADOPERATOR    = 202,     
      BADLABLOCATION = 203,     
      BADGUID        = 204,     
     
      NOROWS         = 301,     
     
      INSERTNULL     = 401,     
      INSERTDUP      = 402,     
      DUPFIELD       = 403,     
      CONSTRAINT_FAILED = 404,  

      NO_BUFFER      = 501,     
      NO_COMPONENT   = 502,     
      NO_ROTOR       = 503,     
      NO_ANALYTE     = 504,     
      NO_LAB         = 505,     
      NO_PERSON      = 506,     
      NO_MODEL       = 507,     
      NO_EXPERIMENT  = 508,     
      NO_RAWDATA     = 509,     
      NO_EDITDATA    = 510,     
      NO_SOLUTION    = 511,     
      CALIB_IN_USE   = 512,     
      ROTOR_IN_USE   = 513,     
      NO_NOISE       = 514,     
      NO_PROJECT     = 515,     
      BUFFR_IN_USE   = 516,     
      ANALY_IN_USE   = 517,     
      SOLUT_IN_USE   = 518,     
      NO_CALIB       = 519,     
      NO_REPORT      = 520,     
      NO_REPORT_DETAIL = 521,   
      NO_REPORT_DOCUMENT = 522, 
      UNKNOWN_ERR    = 999      
    };

    enum dbUserlevels
    {
      USER           = 0,       
      PRIV           = 1,       
      ANALYST        = 2,       
      SUPER          = 3,       
      ADMIN          = 4        
    };

    // Methods

    bool test_db_connection( const QString&, const QString&, 
                             const QString&, const QString&, 
                             QString& );

    bool test_secure_connection( const QString&, const QString&, 
                                 const QString&, const QString&, 
                                 const QString&, const QString&, 
                                 QString& );

    bool          connect     ( const QString&, QString& );

    bool          connect     ( const QString&, const QString&, 
                                const QString&, const QString&, 
                                QString& );

    void          rawQuery    ( const QString& );

    int           statusQuery ( const QString& );

    int           statusQuery ( const QStringList& );

    int           functionQuery( const QStringList& );

    void          query       ( const QString& );

    void          query       ( const QStringList& );
    
    bool          next        ( void );

    QVariant      value       ( unsigned );
                  
    bool          isConnected ( void );

    int           numRows     ( void );

    int           writeBlobToDB ( const QString& , const QString& , const int );

    int           readBlobFromDB( const QString&, const QString&, const int );


    int           readAucFromDB( const QString&, int );


    int           writeAucToDB( const QString&, int );

    QString       lastError   ( void ) { return error;  };

    int           lastErrno   ( void ) { return db_errno;  };

    int           lastInsertID( void );
    
    QString       lastDebug( void );

    unsigned long mysqlEscapeString( QByteArray& , QByteArray& , unsigned long );

  private:
    bool       connected;
#ifndef NO_DB
    MYSQL*     db;
    MYSQL_RES* result;
    MYSQL_ROW  row;
#endif      
    QString    email;
    QString    userPW;
    QString    guid;

    QString    certFile;
    QString    keyFile;
    QString    caFile;
    QString    error;
    int        db_errno;

    QString    buildQuery      ( const QStringList& );
    QString    buildQuerySelect( const QStringList& );
};
#endif