Database.list

Execute a SQL statement from a file that takes a model parameter and returns many rows

T[] list(string sql)
T[] list()
T[] list(string sql, Variant parameter)
T[] list(Variant parameter)
T[] list(string sql, Variant[] parameters)
T[] list(Variant[] parameters)
T[] list(string sql, T model)
T[] list(T model)
class Database
T[]
list
(
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 array of T with the fields for each T mapped to columns

Examples

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

Meta

Source

See Implementation

quill database Database constructors

this

functions