Database.list

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

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

Parameters

T: type to map columns to
path: path to SQL file
parameter Variant: single Variant parameter

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")(Variant("value"));

Meta

Source

See Implementation

quill database Database constructors

this

functions