DBConnection
Database connection instance.
DBConnection Properties
CatalogSeparator : String
The catalog separator.
QuoteStart : String
The prefix to use when specifying database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens.
QuoteEnd : String
The suffix to use when specifying database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens.
DBConnection Methods
Schema(query?) : Schema
Returns the database or query result schema.
Schema Parameters
query? : String
Query(query, params?) : Dict[]
Loads data from the database using SQL SELECT query.
Query Parameters
query : String
params? : Dict
Execute(query, params?, outParams?) : Integer
Executes SQL statement in the database (e.g. INSERT, UPDATE, DELETE).
Execute Parameters
query : String
params? : Dict
outParams? : Dict
Procedure(name, params?)
Executes stored procedure in the database.
Procedure Parameters
name : String
params? : Dict