Class: Statement

Bind values to the parameters, after having reseted the statement

SQL statements can have parameters, named '?', '?NNN', ':VVV', '@VVV', '$VVV', where NNN is a number and VVV a string. This function binds these parameters to the given values.

Warning: ':', '@', and '$' are included in the parameters names

Binding values to named parameters

var stmt = db.prepare("UPDATE test SET a=@newval WHERE id BETWEEN $mini AND $maxi");
stmt.bind({$mini:10, $maxi:20, '@newval':5});

• Create a statement that contains parameters like '$VVV', ':VVV', '@VVV'
• Call Statement.bind with an object as parameter

Binding values to parameters

var stmt = db.prepare("UPDATE test SET a=? WHERE id BETWEEN ? AND ?");
stmt.bind([5, 10, 20]);

• Create a statement that contains parameters like '?', '?NNN'
• Call Statement.bind with an array as parameter

Value types

Execute the statement, fetching the the next line of result, that can be retrieved with Statement.get() .

Get one row of results of a statement. If the first parameter is not provided, step must have been called before get.

var stmt = db.prepare("SELECT * FROM test");
while (stmt.step()) console.log(stmt.get());

Get the list of column names of a row of result of a statement.

var stmt = db.prepare("SELECT 5 AS nbr, x'616200' AS data, NULL AS nothing;");
stmt.step(); // Execute the statement
console.log(stmt.getColumnNames()); // Will print ['nbr','data','nothing']

Get one row of result as a javascript object, associating column names with their value in the current row.

var stmt = db.prepare("SELECT 5 AS nbr, x'616200' AS data, NULL AS nothing;");
stmt.step(); // Execute the statement
console.log(stmt.getAsObject()); // Will print {nbr:5, data: Uint8Array([1,2,3]), nothing:null}

Shorthand for bind + step + reset Bind the values, execute the statement, ignoring the rows it returns, and resets it

Reset a statement, so that it's parameters can be bound to new values It also clears all previous bindings, freeing the memory used by bound parameters.

Free the memory allocated during parameter binding

Free the memory used by the statement