Statement is an executable statement for a specific database. A statement may be executed immediately or prepared and executed later with parameters.
Slots
- closeSource
-
native Void close()
Close the statement.
-
internal readonly Connection conn
The connection that this statement uses.
- executeSource
-
native Obj execute([Str:Obj]? params := null)
Execute a SQL statement and if applicable return a result. If the statement produced auto-generated keys, then return an Int[] list of the keys generated, otherwise return number of rows modified.
- limitSource
-
native Int? limit
Maximum number of rows returned when this statement is executed. If limit is exceeded rows are silently dropped. A value of null indicates no limit.
-
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
ofRows
. TheCols
are available fromList.of.fields
or ontype.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
. TheObj
passed to theeach
function will be of typeRow
. - sqlSource
-
readonly Str sql
The SQL text used to create this statement.