datatable-to-sqlite-file

Exports a datatable as a SQLite database file.

When using a SQLite database file, this adaptor can be used to update a table in that file using data from a datatable.

Arguments

Inputs:

sqlite: The name of an existing SQLite file to which the data will be exported.

table name: The name of an existing table in the SQLite DB file to which the data will be exported.

id column name: The name of the column containing unique row ids.

data: The datatable that will be converted into an SQLite file.

Output:

sqlite: The output file in SQLite format containing the data to be exported.

ids: A list of row ids that have been created or updated.

created ids: A list of row ids that have been created.

updated ids: A list of row ids that have been updated.

Possible use cases

• Update an sqlite table with data processed in Data-flo