Built-In Namespace _global_
Field Attributes | Field Name and Description |
---|---|
***************************************************************************************************************************
(c) ITSV GmbH - http://www.itsv.at/
Software Operations
Zentrale Daten und Services
Wolfgang Scherer
CCDB - Competence Center Controlling Database
MODULE: ccdb.js
SEE ALSO: http://zpvwiki.sozvers.at/wiki/ZPV_Controlling_Datenbank#App
HISTORY:
VERSION DATE CHANGES
0.1 08.08.2015 created with RANGE
0.2 15.08.2015 multi-database with selection page
/show_cpu graphically with D3-Library
generic /query and /sequence
0.3 09.09.2015 replace /show_cpu with query configuration
load_xls with XLSX library
0.4 06.10.2015 session management, LOGIN/password management, authorization rights check
0.5 28.10.2015 remove /sequence, replaced by querytype='sequence'
query result format 'hhlist'
0.6 04.11.2015 DBrequest new attribute 'reqid', identifies the request in order to be able to substitute
other SQL statements for other databases (current SQL assumes oracle RDBMS with oracledb nodejs driver)
relocate auxiliary functions to aux/auxiliary.js
relocate modular business functions to functions/functions.js
0.7 11.11.2015 re-factor load_csv and load_xls to a common load_file
0.71 16.11.2015 allow options in SEQUENCE steps, sparated from QUERY-Name of step by ':'
clean-up DSEQUENCE by processing all steps in the same state and by the same code
0.8.099 20.11.2015 make /dquery a POST action
start changing to query parameter processing 0.8:
each query has a 'paramtype', no more 'paramnames' or 'attributenames'
the paramtype can have multiple attributes, there go the query parameters !!
param form processing will benefit from this
****************************************************************************************************************************
|
Method Attributes | Method Name and Description |
---|---|
Document(initializer)
***************************************************************************************************************************
(c) ITSV GmbH - http://www.itsv.at/
Software Operations
Zentrale Daten und Services
Wolfgang Scherer
CCDB - Competence Center Controlling Database
MODULE: document.js
USES: mfile.js
db.js
SEE ALSO: http://zpvwiki.sozvers.at/wiki/ZPV_Controlling_Datenbank#App
DESCRIPTION: This module contains document handling
|
|
get(obj, prop)
|
|
getConfig()
|
|
setConfig(dbn)
***************************************************************************
FUNCTION: setConfig
INPUT: dbn - name of DB Configuration to be set
RESULT: text describing the outcome of the operation
GLOBALS: db.currentConfig - global current DB configuration
dbConfig - global configuration structure
DESCRIPTION: sets the current DB configuration to the one with name
|
Field Detail
script_version
***************************************************************************************************************************
(c) ITSV GmbH - http://www.itsv.at/
Software Operations
Zentrale Daten und Services
Wolfgang Scherer
CCDB - Competence Center Controlling Database
MODULE: ccdb.js
SEE ALSO: http://zpvwiki.sozvers.at/wiki/ZPV_Controlling_Datenbank#App
HISTORY:
VERSION DATE CHANGES
0.1 08.08.2015 created with RANGE
0.2 15.08.2015 multi-database with selection page
/show_cpu graphically with D3-Library
generic /query and /sequence
0.3 09.09.2015 replace /show_cpu with query configuration
load_xls with XLSX library
0.4 06.10.2015 session management, LOGIN/password management, authorization rights check
0.5 28.10.2015 remove /sequence, replaced by querytype='sequence'
query result format 'hhlist'
0.6 04.11.2015 DBrequest new attribute 'reqid', identifies the request in order to be able to substitute
other SQL statements for other databases (current SQL assumes oracle RDBMS with oracledb nodejs driver)
relocate auxiliary functions to aux/auxiliary.js
relocate modular business functions to functions/functions.js
0.7 11.11.2015 re-factor load_csv and load_xls to a common load_file
0.71 16.11.2015 allow options in SEQUENCE steps, sparated from QUERY-Name of step by ':'
clean-up DSEQUENCE by processing all steps in the same state and by the same code
0.8.099 20.11.2015 make /dquery a POST action
start changing to query parameter processing 0.8:
each query has a 'paramtype', no more 'paramnames' or 'attributenames'
the paramtype can have multiple attributes, there go the query parameters !!
param form processing will benefit from this
****************************************************************************************************************************
Defined in: ccdb.js.
Defined in: ccdb.js.
Method Detail
Document(initializer)
***************************************************************************************************************************
(c) ITSV GmbH - http://www.itsv.at/
Software Operations
Zentrale Daten und Services
Wolfgang Scherer
CCDB - Competence Center Controlling Database
MODULE: document.js
USES: mfile.js
db.js
SEE ALSO: http://zpvwiki.sozvers.at/wiki/ZPV_Controlling_Datenbank#App
DESCRIPTION: This module contains document handling
Defined in: document.js.
Defined in: document.js.
- Parameters:
- initializer
get(obj, prop)
Defined in: auxiliary.js.
- Parameters:
- obj
- prop
getConfig()
Defined in: db.js.
setConfig(dbn)
***************************************************************************
FUNCTION: setConfig
INPUT: dbn - name of DB Configuration to be set
RESULT: text describing the outcome of the operation
GLOBALS: db.currentConfig - global current DB configuration
dbConfig - global configuration structure
DESCRIPTION: sets the current DB configuration to the one with name
configuration parameters are taken from global dbConfig
if is not given, the default configuration is used
the name of the default configuration is taken from dbConfig.default
Defined in: db.js.
Defined in: db.js.
- Parameters:
- dbn