*DATABASE_GET_VECTOR_COLUMN

Description: Gets a vector column from a database

Syntax: database_get_vector_column(database_id,column_name)

Inputs
ID Name Type Default Remarks
1 Database remote_lookup   Database
2 Column Name text   Column Name
Outputs
ID Name Type Remarks
1   scalar  
2   vector  

*DATABASE_PHYSICALTEST_RESPONSE_IMPORTER

Description: Creates or Replaces a record into the database based on physicaltest responses

Syntax: database_physicaltest_response_importer(database_id,physicaltest_id,parent_physicaltest_id,physicaltest_input_id,parent_physicaltest_input_id,create_replace,map_data)

Inputs
ID Name Type Default Remarks
1 Choose Database remote_lookup   Choose Database
2 Choose Physicaltest remote_lookup   Choose Physicaltest
3 Choose Parent Physicaltest remote_lookup   Choose Parent Physicaltest
4 Physicaltest input id scalar physicaltest_id Physicaltest input id
5 PPII scalar parent_physicaltest_id Parent Physicaltest Input id
6 Create or replace select   Create or replace
7 Response Names to Database Columns Map Information dataset   If Database column names are different from Test Response Names, this map data can be used to associate the correct mapping information. The map format is Database column Name => Testid.response_name
Outputs
ID Name Type Remarks
1   scalar  
2   scalar  

*DATABASE_SIMULATION_RESPONSE_IMPORTER

Description: Creates or Replaces a record into the database based on simulation responses

Syntax: database_simulation_response_importer(database_id,simulation_id,parent_simulation_id,simulation_input_id,parent_simulation_input_id,create_replace)

Inputs
ID Name Type Default Remarks
1 Choose Database remote_lookup   Choose Database
2 Choose Simulation remote_lookup   Choose Simulation
3 Choose Parent Simulation remote_lookup   Choose Parent Simulation
4 simulation_input_id scalar simulation_id simulation_input_id
5 parent_simulation_input_id scalar parent_simulation_id parent_simulation_input_id
6 Create or replace select   Create or replace
Outputs
ID Name Type Remarks
1   scalar  
2   scalar  

*DATABASE_DELETE_RECORD

Description: Deletes record from a database

Syntax: database_delete_record(database_id)

Inputs
ID Name Type Default Remarks
1 Database remote_lookup   Database
Outputs
ID Name Type Remarks
1   scalar  

*DATABASE_CREATE_RECORD

Description: Creates a record into a database

Syntax: database_create_record(database_id)

Inputs
ID Name Type Default Remarks
1 Database remote_lookup   Database
Outputs
ID Name Type Remarks
1   scalar  

*DATABASE_INSERT

Description: Connects to a database and inserts records based on the SQL-Query

Syntax: database_insert(db_type,db_host,db_port,db_user,db_password,db_database,db_query)

Inputs
ID Name Type Default Remarks
1 Database type select   Database type
2 Hostname text   Hostname
3 Port text   Port
4 Username text   Username
5 Password password   Password
6 Database text   Database
7 Query textarea   Query
Outputs
ID Name Type Remarks
1 Records dataset  
2 Log dataset  

*DATABASE_SELECT

Description: Connect to a Database to Select Records based on a Query

Syntax: database_select(db_type,db_host,db_port,db_user,db_password,db_database,db_query)

Inputs
ID Name Type Default Remarks
1 Database Type select   Database type
2 Hostname text   Hostname
3 Port text   Port
4 Username text   Username
5 Password password   Password
6 Database text   Database
7 Database Query textarea   Database Query
Outputs
ID Name Type Remarks
1 Records dataset  
2 Log dataset  

*DATABASE_TIMEZONE_CONVERTER

Description: Timezone converter

Syntax: database_timezone_converter(source_tz,duration)

Inputs
ID Name Type Default Remarks
1 Source tz text   Source tz
2 Duration text   Duration
Outputs
ID Name Type Remarks
1   integer  

*DATABASE_CONNECTOR

Description: Database Connector

Syntax: database_connector(database_type,database_host,options)

Inputs
ID Name Type Default Remarks
1 Database Type scalar   Database Type
2 Database Type select   Database Type
3 Options textarea   Options separated by a comman and equal sign. Example a=b, c=d
Outputs
ID Name Type Remarks
1 Modified Movie movie  
2 Frames dataset