Database

this this(DataSource datasource): Creates a new Database given an existing DataSource
this this(string path): Creates a new SQLite Database
this this(string host, ushort port, string name, string username, string password, bool ssl): Creates a new PostgreSQL Database.
this this(string host, ushort port, string name, string username, string password): Creates a new MySQL Database.

Members

Functions

execute void execute(string sql): Execute a SQL statment with no parameters and no return
execute void execute(): Execute a SQL statment from a file with no parameters and no return
execute void execute(string sql, Variant parameter): Execute a SQL statment that takes a single Variant parameter
execute void execute(Variant parameter): Execute a SQL statement from a file that takes a single Variant parameter
execute void execute(string sql, Variant[] parameters): Execute a SQL statement that takes many Variant parameters
execute void execute(Variant[] parameters): Execute a SQL statement from a file that takes many Variant parameters
execute void execute(string sql, T model): Execute a SQL statement that takes a model parameter
execute void execute(T model): Execute a SQL statement from a file that takes a model parameter
list T[] list(string sql): Execute a SQL statment that returns multiple rows
list T[] list(): Execute a SQL statement from a file that returns multiple rows
list T[] list(string sql, Variant parameter): Execute a SQL statement that takes a single Variant parameter and returns many rows
list T[] list(Variant parameter): Execute a SQL statement from a file that takes a single Variant parameter and returns many rows
list T[] list(string sql, Variant[] parameters): Execute a SQL statement that takes many Variant parameters and returns many rows
list T[] list(Variant[] parameters): Execute a SQL statement from a file that takes many Variant parameters and returns many rows
list T[] list(T model): Execute a SQL statement from a file that takes a model parameter and returns many rows
list T[] list(string sql, T model): Execute a SQL statement that takes a model parameter and returns many rows
single T single(string sql): Execute a SQL statement that returns a single row
single T single(): Execute a SQL statment from a file that returns a single row
single T single(string sql, Variant parameter): Execute a SQL statement that takes a Variant parameter and returns a single row
single T single(Variant parameter): Execute a SQL statement from a file that takes a Variant parameter and returns a single row
single T single(string sql, Variant[] parameters): Execute a SQL statement that takes many Variant parameters and returns a single row
single T single(Variant[] parameters): Execute a SQL statement from a file that takes many Variant parameters and returns a single row
single T single(string sql, T model): Execute a SQL statement that takes a model parameter and returns a single row
single T single(T model): Execute a SQL statement from a file that takes a model parameter and returns a single row
sql string sql(): Import a SQL string from a file

Database

Constructors

Members

Functions

Meta

Source