Configuration Database component
|
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) |
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 = "5.0.0" |
Error Codes in DBAccess package | |
see also Error Codes overview module. | |
const int | fwConfigurationDB_ERROR_DBNoConnection = -162 |
This package contains database access functions of the Configuration Database tool
(c) Copyright CERN, All Rights Reserved
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 |
||
) |
global string _fwConfigurationDB_fileVersion_fwConfigurationDB_DBAccess_ctl = "5.0.0" |
connection to database does not exist