Configuration Database component
Functions | Variables
fwConfigurationDB_DBAccess.ctl File Reference

Functions

void fwConfigurationDB_dbConnect (string dbConnectionName, string connectString, string dbType, string dbName, string dbUser, string dbSchema, string dbPassword, dbConnection &dbCon, dyn_string &exceptionInfo, bool errorIfOpenFails=TRUE)
 
void _fwConfigurationDB_getDBDriver (string dbType, string &driver, dyn_string &exceptionInfo)
 
string _fwConfigurationDB_extractOraErrCode (string errTxt, string &oraMsg)
 
void fwConfigurationDB_callPlSqlApi (string functionName, dyn_mixed functionParams, string inputColumns, string outputColumns, dyn_dyn_mixed inputData, dyn_dyn_mixed &outputData, dyn_string &exceptionInfo, dyn_int outputColumnTypes=0, bool cleanupInputTable=TRUE, string orderByColumn="")
 
Database Access functions

These functions are used in context of database access

void fwConfigurationDB_openDBConnection (string dbConnectionName, dbConnection &dbCon, dyn_string &exceptionInfo)
 
string _fwConfigurationDB_checkSchemaPrivileges (dbConnection dbCon, dyn_string &exceptionInfo)
 
void fwConfigurationDB_checkOpenDB (dyn_string &exceptionInfo)
 
void fwConfigurationDB_initializeQuery (string sql, dbConnection conn, dbCommand &dbCmd, dyn_string &exceptionInfo)
 
void fwConfigurationDB_initializeQueryWithParams (string sql, dbConnection conn, mixed bindParams, dbCommand &dbCmd, dyn_string &exceptionInfo)
 
int fwConfigurationDB_fetchQuery (dbCommand &dbCmd, dyn_dyn_mixed &aRecords, dyn_string &exceptionInfo, int maxRecords=0, bool columnWise=FALSE, bool closeOnNoMoreData=TRUE, dyn_int colTypes=0, int numCol=999)
 
void _fwConfigurationDB_executeDBQuery (string sql, dbConnection conn, dyn_dyn_mixed &aRecords, dyn_string &exceptionInfo, int numCol=999, bool columnWise=FALSE, dyn_int colTypes=0)
 
void _fwConfigurationDB_executeDBQueryWithParams (string sql, dbConnection conn, anytype bindParams, dyn_dyn_mixed &aRecords, dyn_string &exceptionInfo, int numCol=999, bool columnWise=FALSE, dyn_int colTypes=0)
 
void _fwConfigurationDB_executeDBBulkCmd (string sql, dbConnection conn, dyn_dyn_mixed data, dyn_string &exceptionInfo, bool columnWise=FALSE, dyn_int colTypes=0)
 
void _fwConfigurationDB_executeDBCmd (string sql, dbConnection conn, anytype params, dyn_string &exceptionInfo)
 
void fwConfigurationDB_executeSqlSimple (string sql, dbConnection connection, dyn_string &exceptionInfo)
 
bool _fwConfigurationDB_hasKeywords (string src, string keywords)
 
void _fwConfigurationDB_executeSqlFromFile (dbConnection dbCon, string fileName, string whatItIs, dyn_string &exceptionInfo, bool breakOnDbError=TRUE)
 

Variables

global string _fwConfigurationDB_fileVersion_fwConfigurationDB_DBAccess_ctl ="8.2.1"
 
Error Codes in DBAccess package

see also Error Codes overview module.

const int fwConfigurationDB_ERROR_DBNoConnection = -162
 

Detailed Description

This package contains database access functions of the Configuration Database tool

Author
Piotr Golonka (BE/ICS-FD)
Date
March 2018

(c) Copyright CERN, All Rights Reserved

Function Documentation

void fwConfigurationDB_dbConnect ( string  dbConnectionName,
string  connectString,
string  dbType,
string  dbName,
string  dbUser,
string  dbSchema,
string  dbPassword,
dbConnection &  dbCon,
dyn_string &  exceptionInfo,
bool  errorIfOpenFails = TRUE 
)
void _fwConfigurationDB_getDBDriver ( string  dbType,
string &  driver,
dyn_string &  exceptionInfo 
)
string _fwConfigurationDB_extractOraErrCode ( string  errTxt,
string &  oraMsg 
)
void fwConfigurationDB_callPlSqlApi ( string  functionName,
dyn_mixed  functionParams,
string  inputColumns,
string  outputColumns,
dyn_dyn_mixed  inputData,
dyn_dyn_mixed &  outputData,
dyn_string &  exceptionInfo,
dyn_int  outputColumnTypes = 0,
bool  cleanupInputTable = TRUE,
string  orderByColumn = "" 
)

Variable Documentation

global string _fwConfigurationDB_fileVersion_fwConfigurationDB_DBAccess_ctl ="8.2.1"
fwConfigurationDB_ERROR_DBNoConnection = -162

connection to database does not exist