SQLite Library/en
Inhaltsverzeichnis
Introduction[Bearbeiten]
The SQLite Library contains action blocks to access SQLite databases. The functionality and actions are similar to the ones found in the ODBC library.
Depending on your operating system, additional libraries (DLLs) need to be installed on your machine. This is operating system specific and out of the scope of the expecco documentation. Please consult your administrator on how to setup SQLite.
Connecting / Disconnecting[Bearbeiten]
[SQLite] Connect[Bearbeiten]
Establishes a connection to a database. You have to provide the filename of the database. Upon success, a session handle is written to the output pin. This is needed to further talk to the database, and should either be stored in a variable, or passed along a pin-connection to one of the query actions below.
[SQLite] Disconnect[Bearbeiten]
Closes a database connection. Takes a connection handle as generated by "[SQLite] Connect" as input.
SQL Queries[Bearbeiten]
[SQLIte] Execute-BlockOut[Bearbeiten]
Executes an SQL statement and provides the resulting rows as a single (possibly big) collection of individual rows. The statement is a string which must represent a valid SQL statement. The receiving action will be triggered once. For example, "select name,telno from myTable" will generate a collection consisting of 2-valued rows, each containing name and telno from the table.
[SQLite] Execute-StreamOut[Bearbeiten]
Similar to the above, but the resulting rows are sent individually to the output pin. Thus, for every result, one output tuple is generated, and the receiving action will be triggered once for each.
The library provides additional actions which execute a parametrized SQL statement. These have addition input pins to fill in placeholders in a statement template.
DB Queries[Bearbeiten]
[SQLite] Library Version[Bearbeiten]
Retrieves meta information about the SQLite version.
