Fantom

 

class

sql::Statement

sys::Obj
  sql::Statement

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.

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.

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.