*DATABASE_GET_VECTOR_COLUMN¶
Description: Gets a vector column from a database
Syntax:
database_get_vector_column(database_id,column_name)
ID | Name | Type | Default | Remarks |
---|---|---|---|---|
1 | Database | remote_lookup | Database | |
2 | Column Name | text | Column Name |
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)
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 |
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)
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 |
ID | Name | Type | Remarks |
---|---|---|---|
1 | scalar | ||
2 | scalar |
*DATABASE_DELETE_RECORD¶
Description: Deletes record from a database
Syntax:
database_delete_record(database_id)
ID | Name | Type | Default | Remarks |
---|---|---|---|---|
1 | Database | remote_lookup | Database |
ID | Name | Type | Remarks |
---|---|---|---|
1 | scalar |
*DATABASE_CREATE_RECORD¶
Description: Creates a record into a database
Syntax:
database_create_record(database_id)
ID | Name | Type | Default | Remarks |
---|---|---|---|---|
1 | Database | remote_lookup | Database |
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)
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 |
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)
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 |
ID | Name | Type | Remarks |
---|---|---|---|
1 | Records | dataset | |
2 | Log | dataset |
*DATABASE_TIMEZONE_CONVERTER¶
Description: Timezone converter
Syntax:
database_timezone_converter(source_tz,duration)
ID | Name | Type | Default | Remarks |
---|---|---|---|---|
1 | Source tz | text | Source tz | |
2 | Duration | text | Duration |
ID | Name | Type | Remarks |
---|---|---|---|
1 | integer |
*DATABASE_CONNECTOR¶
Description: Database Connector
Syntax:
database_connector(database_type,database_host,options)
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 |
ID | Name | Type | Remarks |
---|---|---|---|
1 | Modified Movie | movie | |
2 | Frames | dataset |