SQLite3 driver
Driver that can read and write on an SQLite3 database table. The table should include at least two TEXT columns including the name and value of the variables. The value in TEXT format will be converted by the driver to the defined datatype.
Parameters
Aside from the common parameters described in the communication_driver docs, this driver includes:
- address: This is the path of the database. Default = "mydb.db"
- table: This is the name of the database table where the variables are located. Default = "variables"
- variable_column: This is the name of the column which includes the variable names. Default = "name"
- value_column: This is the name of the column which includes the variable values. Default = "value"
Setup data
The setup data will give values to the parameters required and will specify the I/O variables info.
{
"parameters": {
"address": "C:\\TEMP\\mydb.db",
"table": "variables",
"variable_column": "name",
"value_column": "value",
},
"variables": {
"inputs": {
"datatype": "byte",
"size": 1,
"operation": "write"
},
"outputs": {
"datatype": "byte",
"size": 1,
"operation": "read"
}
}
}
Note
The setup_params in the generic PLC components for sqlite3_conn will need the following format:
{"address": "C:\\TEMP\\mydb.db", "table": "variables", "variable_column": "name", "value_column": "value"}