Implement the following building blocks function to construct more complex use cases:

Main

• stmt:parse()

creates new statement object.

• stmt:parse()

registers db connection in s.conn.

• stmt:parse()

registers unparsed statement in s.str.

• stmt:parse()

parses sql statement in s.pstmt.

• stmt:parse()

requires s:finalize() in order to close connection.

Helpers

• stmt:step()

a function must be called to evaluate the (next iteration) of the prepared statement.
returns flags.busy (unable to acquire the locks needed), flags.done (finished
executing successfully), flags.row (a new row is ready for processing) and
error,misuse.

• stmt:reset():

resets SQL statement so that it is ready to be re-executed. Any
statement variables that had values bound to them using the stmt:bind
functions retain their values.

• stmt:finalize():

Frees the prepared statement, if the statement is successful, or
not execute at all then return flags.ok

BIND

• stmt:bind(n, value):

binds/maps type value to statement parameter n: string->text,
number->int, boolean->0/1, binary_string->blob and if nil the value is removed. On success returns flags.ok or else error code.

• stmt:bind_names(nametable):

binds the values in nametable to statement parameters.
If the statement parameters are named, it should look for appropriately named fields in nametable;
If the statement parameters are anonymous, i.e. "?", it should look for numerical fields 1 to the
number of statement parameters.
On success returns flags.ok or else error
code.

• stmt:param_size():

Returns the number of parameters in the parsed statement e.g. stmt:param_size() --> number

• stmt:param_name(n):

Returns the name of the n-th parameter in the parsed statement
e.g. stmt:param_name(0) --> string

• stmt:clear_bindings():

clears bindings

• stmt:bind_values():

Binds the given values to statement parameters.
Returns sqlite3.OK on success or else a numerical error code (see
Numerical error and result codes).

GET

• stmt:nkeys()

returns the number of columns/keys in results.

• stmt:nrows()

returns the number of rows in the results.

• stmt:types()

returns the type of each columns/keys in results.

• stmt:type()

returns the type of columns/keys by idx.

• stmt:keys()

returns key/column names

• stmt:key()

returns key/column name by idx

• stmt:kt()

returns a dict of key name and their type.

• stmt:kv()

returns (with stmt:each) a key value pairs of all rows

• stmt:val()

returns (with stmt:each) a list of vals in all the rows at idx.

• stmt:vals()

returns (with stmt:each) a nested list all the vals in all the rows.

• stmt:kvrows()

returns a nested kv-pairs all the rows. if no callback.

• stmt:vrows()

returns a nested list all values in all the rows. if no callback.

Misc

• stmt:last_insert_rowid():

Returns the rowid of the most recent INSERT into the database corresponding to this statement.