sqlCommandFactory.h

Go to the documentation of this file.

/******************************************************************************
** Copyright (c) 1992-2025 MAK Technologies, Inc
** All rights reserved.
******************************************************************************/


#ifndef sqlCommandFactory_H_
#define sqlCommandFactory_H_

#include "databaseCommandFactory.h"
#include "databaseColumn.h"

class DtString;
class DT_DLL_VLDB DtSqlCommandFactory : public DtDatabaseCommandFactory
{
public:
   DtSqlCommandFactory();
   virtual ~DtSqlCommandFactory();

   // Request the creation of a database (currently, you must be connected to
   // a master database to perform this operation)
   virtual DtString createDatabase( const DtString& databaseName );

   // Request the creation of a database, if it exists (currently, you must be 
   // connected to a master database to perform this operation)
   virtual DtString deleteDatabase( const DtString& dbName );

   virtual DtString createTable( const DtDatabaseTable& table);

   virtual DtString deleteTable( const DtDatabaseTable& table);

   virtual void insertTable( std::vector<DtString>& commands,const DtDatabaseTable& table);

   virtual DtString updateTable( const DtDatabaseTable& table,
      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 );

protected:
   virtual DtString createArgList(const DtDatabaseTable& table);
   virtual DtString createColumnList(const DtDatabaseTable& table);
   virtual DtString createColumnRep(const DtDatabaseColumn& column);
   virtual DtString dataTypeToSqlString( DtDatabaseColumn::DataType storageType);

};

#endif