/home/bes3soft/bes3soft/Boss/7.0.2/dist/7.0.2/Calibration/rdbModel/rdbModel-00-01-01/rdbModel/Db/Connection.h

Go to the documentation of this file.

// $Header: /bes/bes/BossCvs/Calibration/rdbModel/rdbModel/Db/Connection.h,v 1.1.1.1 2005/10/17 06:10:53 maqm Exp $
#ifndef RDBMODEL_CONNECTION_H
#define RDBMODEL_CONNECTION_H
#include <vector>
#include <string>


namespace rdbModel{

  enum MATCH  {
    MATCHequivalent,
    MATCHcompatible,
    MATCHfail,
    MATCHnoConnection
  };

  class ResultHandle;
  class Assertion;
  class Rdb;
  typedef std::vector<std::string>  StringVector;

  class Connection {
  public:
    Connection() {};
    virtual ~Connection() {};
    virtual bool open(const std::string& host, const std::string& userid,
                      const std::string& password,
                      const std::string& dbName) = 0;
                      //,                      unsigned int       port) = 0;
    virtual bool close() = 0;

    virtual bool open(const std::string& parms) = 0;

    virtual bool isConnected() = 0;

    virtual std::ostream* getOut() const = 0;
    virtual std::ostream* getErrOut() const = 0;

    virtual MATCH matchSchema(Rdb *rdb, bool matchDbName=true) = 0;

    virtual bool insertRow(const std::string& tableName, 
                           const StringVector& colNames, 
                           const StringVector& values,
                           int* auto_value=0,
                           const StringVector* nullCols = 0) = 0;

    /*
       So far anticipated uses of UPDATE would just modify a single row
       identified by ser_no (or, more generally, primary key), so
       make a method for this case.  Can call the more general
       version below.

       @return true if no errors were encountered; else false.  If the 
       update requested was error-free but entailed no actual change, 
       returns ??
     */
    /*
      At this level, don't have access to column name for primary 
      key, if any.  This has to be done by caller
    virtual bool updateUnique(const std::string& tableName, 
                              const StringVector& colNames, 
                              const StringVector& values,
                              const std::string& keyValue) = 0;
    */

    virtual unsigned int update(const std::string& tableName, 
                                const StringVector& colNames, 
                                const StringVector& values,
                                const Assertion* where=0,
                                const StringVector* nullCols = 0) = 0;

    virtual ResultHandle* select(const std::string& tableName,
                                 const StringVector& getCols,
                                 const StringVector& orderCols,
                                 const Assertion* where=0,
                                 int   rowLimit=0,
                                 int   rowOffset=0)=0;

    virtual void disableModify(bool disable)=0;

    virtual ResultHandle* dbRequest(const std::string& request)=0;

    virtual bool compileAssertion(const Assertion* a, std::string& sqlString)
      const = 0;

  };

}  // end namespace rdbModel
#endif

---