Package com.inductiveautomation.ignition.gateway.util.sqlite

Class SqliteInstance

java.lang.Object

com.inductiveautomation.ignition.gateway.util.sqlite.SqliteInstance

public class SqliteInstance
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	SqliteInstance.PreparedQueryProvider
static interface	SqliteInstance.RowMapper<T>

Constructor Summary

Constructors

Constructor	Description
SqliteInstance(Path path)

Method Summary

Modifier and Type	Method	Description
protected org.sqlite.SQLiteConfig	createConfiguration()
Connection	getConnection()
@NotNull Path	getPath()
<T> @NotNull List<T>	query(SqliteInstance.PreparedQueryProvider query, SqliteInstance.RowMapper<T> rowMapper)	Executes a query that returns a result set, using rowMapper to translate each row of the result set into some domain type.
<T> T	queryOne(SqliteInstance.PreparedQueryProvider query, SqliteInstance.RowMapper<T> rowMapper)	Executes a query that returns a single result, using rowMapper to translate the result set into some domain type.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SqliteInstance

public SqliteInstance(Path path)

Method Details

createConfiguration

protected org.sqlite.SQLiteConfig createConfiguration()

getConnection

public Connection getConnection()
                         throws SQLException

Throws:

SQLException

query

@NotNull
public <T> @NotNull List<T> query(SqliteInstance.PreparedQueryProvider query,
 SqliteInstance.RowMapper<T> rowMapper)
                           throws SQLException

Executes a query that returns a result set, using rowMapper to translate each row of the result set into some domain type. Automatically closes the provided connection and result set.

Parameters:

query - A function that accepts a connection and return a fully configured PreparedStatement, e.g. with parameters, if any, specified.

rowMapper - A function that accepts a ResultSet and returns an instance of type T.

Returns:

An unmodifiable list of type T.

Throws:

SQLException - If an error occurs while executing the query, retrieving the connection, etc.

queryOne

@Nullable
public <T> T queryOne(SqliteInstance.PreparedQueryProvider query,
 SqliteInstance.RowMapper<T> rowMapper)
               throws SQLException

Executes a query that returns a single result, using rowMapper to translate the result set into some domain type. Automatically closes the provided connection and result set.

Parameters:

query - A function that accepts a connection and return a fully configured PreparedStatement, e.g. with parameters, if any, specified.

rowMapper - A function that accepts a ResultSet and returns an instance of type T.

Returns:

An instance of type T, or null if the result set is empty.

Throws:

SQLException - If an error occurs while executing the query, retrieving the connection, etc.

getPath

@NotNull
public @NotNull Path getPath()