Database.single

Execute a SQL statement from a file that takes a model parameter and returns a single row

T single(string sql)
T single()
T single(string sql, Variant parameter)
T single(Variant parameter)
T single(string sql, Variant[] parameters)
T single(Variant[] parameters)
T single(string sql, T model)
T single(T model)
class Database
T
single
(
T
string path
)
(
T model
)

Parameters

T: type to map parameters and columns to
path: path to SQL file
model T: model to map parameters and columns to

Return Value

Type: T

new instance of T with fields mapped to columns

Examples

class Model
{
    int id;
    @(bind("name")) string name;
}
auto model = new Model();
model.id = 4;
auto model = database.single!(Model, "queries/statement.sql", model);

Meta

Source

See Implementation

quill database Database constructors

this

functions