databaseInterface.h

Go to the documentation of this file.

/*******************************************************************************
** Copyright (c) 1992-2010 VT MAK
** All rights reserved.
*******************************************************************************/


#ifndef databaseInterface_H_
#define databaseInterface_H_

#include "vlDatabase.h"
#include <vector>

class DtString;

class DtDatabaseColumn;
class DtDatabaseCommandFactory;
class DtDatabaseCommandProcessor;
class DtDatabaseConnection;
class DtDatabaseDriver;
class DtDatabaseEnvironment;
class DtDatabaseParameters;
class DtDatabaseTable;

class DT_DLL_VLDB DtDatabaseInterface
{
public:

   enum ConditionOperator
   {
      Equals,
      NotEquals
   };

   enum MergeOperator
   {
      And,
      Or
   };

   explicit DtDatabaseInterface(const DtDatabaseDriver* databaseDriver);

   virtual ~DtDatabaseInterface();

   DtDatabaseParameters* createDefaultParameters() const;

   virtual bool connect( DtDatabaseParameters* params, bool useMaster);

   virtual bool disconnect();

   virtual unsigned int maximumColumnWidth();

   virtual bool executeCommand( const DtString& sqlCommand );

   virtual bool createDatabase( const DtString& databaseName );

   virtual bool deleteDatabase( const DtString& databaseName );

   virtual bool createDataSourceName(DtDatabaseParameters* params, 
      bool useMaster);

   virtual bool createTable( const DtDatabaseTable& tableDef, bool deleteIfExists);

   virtual bool insertRow( const DtDatabaseTable& tableDef );

   virtual bool updateRow( const DtDatabaseTable& tableDef,
      const std::vector<DtString>& columnsToSet,
      const DtString& whereCondition);

   virtual DtString createConditionString(const DtDatabaseColumn& column, 
      const DtString& columnValue,ConditionOperator anOperator);

   virtual DtString combineConditionStrings(const DtString& conditionOne,
      const DtString& conditionTwo,MergeOperator anOperator);

   void setIsMasterDSN( bool yesNo );
   bool isMasterDSN() const;

   void setCreateDsnFailed( bool yesNo );
   bool createDsnFailed() const;

protected:
   const DtDatabaseDriver* myDriver;
   DtDatabaseEnvironment* myEnvironment;
   DtDatabaseConnection* myConnection;
   DtDatabaseCommandProcessor* myCommandProcessor;
   DtDatabaseCommandFactory* myCommandFactory;

   bool  myIsMaster;
   bool  myCreateDsnFailed;
};

#endif