Database.list

Execute a SQL statement from a file that takes many Variant parameters 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)
class Database
T[]
list
(
T
string path
)
(
Variant[] parameters
)
T[] list(string sql, T model)
T[] list(T model)

Parameters

T: type to map columns to
path: path to SQL file
parameters Variant[]: many ordered Variant parameters

Return Value

Type: T[]

new array of T with the fields for each T mapped to columns

Examples

auto models = database.list!(Model, "queries/statement.sql")(variantArray("value one", "value two"));

Meta

Source

See Implementation

quill database Database constructors

this

functions