Slots

closeSource

native Void close()

Close the statement.

connSource

internal readonly Connection conn

The connection that this statement uses.

executeSource

native Int execute([Str:Obj]? params := null)

Execute a SQL statement and if applicable return the number of rows modified.

makeSource

new make(Connection conn, Str sql)

Make a new statement with the specified SQL text.

prepareSource

native This prepare()

Prepare this statement by compiling for efficient execution. Return this.

querySource

native Row[] query([Str:Obj]? params := null)

Execute the statement and return the resulting List of Rows. The Cols are available from List.of.fields or on type.fields of each row instance.

queryEachSource

native Void queryEach([Str:Obj]? params, |Row| eachFunc)

Execute the statement. For each row in the result, invoke the specified function each. The Obj passed to the each function will be of type Row.

sqlSource

readonly Str sql

The SQL text used to create this statement.