*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    
Outputs
ID Name Type Remarks
1   scalar  

*DATABASE_DELETE_RECORDS

Description: Deletes records from a database

Syntax: database_delete_records(database_id,filters)

Inputs
ID Name Type Default Remarks
1 Database remote_lookup    
2 Choose Filters filters   Choose Filters to find the records
Outputs
ID Name Type Remarks
1   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    
2 Choose Simulation remote_lookup    
3 Choose Parent Simulation remote_lookup    
4 Simulation Input Id scalar    
5 Parent Simulation Input Id scalar    
6 Create Or Replace select    
Outputs
ID Name Type Remarks
1   scalar  
2   scalar  

*DATABASE_CONNECTOR

Description: Database Connector

Syntax: database_connector(database_type,database_host,options)

Inputs
ID Name Type Default Remarks
1 Database Type scalar    
2 Database Type select    
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  

*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    
3 Port text    
4 Username text    
5 Password password    
6 Database text    
7 Database Query textarea    
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    
2 Duration text    
Outputs
ID Name Type Remarks
1   integer  

*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,type_of_insertion)

Inputs
ID Name Type Default Remarks
1 Choose Database remote_lookup    
2 Choose Physicaltest remote_lookup    
3 Choose Parent Physicaltest remote_lookup    
4 Physicaltest Input Id scalar    
5 Parent Physicaltest Input Id In Database scalar   Parent Physicaltest Input id
6 Create Or Replace select    
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 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
8 Type Of Insertion select   Create or replace
Outputs
ID Name Type Remarks
1   scalar  
2   scalar  

*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    
2 Column Name text    
Outputs
ID Name Type Remarks
1   scalar  
2   vector  

*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    
2 Hostname text    
3 Port text    
4 Username text    
5 Password password    
6 Database text    
7 Query textarea    
Outputs
ID Name Type Remarks
1 Records dataset  
2 Log dataset  

*DATABASE_CREATE_NEW

Description: Create a new Database

Syntax: database_create_new(db_name,schema,records,delete_if_exists)

Inputs
ID Name Type Default Remarks
1 Name text    
2 Schema dataset    
3 Records(optional) dataset   Optional records matching the schema
4 Delete if Exists select   Delete database if it exists
Outputs
ID Name Type Remarks
1   integer  

*DATABASE_GET_RECORDS

Description: Get records from a Database

Syntax: database_get_records(database_id,filters)

Inputs
ID Name Type Default Remarks
1 Database remote_lookup    
2 Choose Filters filters   Choose Filters to find the records
Outputs
ID Name Type Remarks
1   dataset