mysqlx.SqlStatement¶

class mysqlx.SqlStatement(connection, sql)¶

Bases: Statement

A statement for SQL execution.

Parameters:

connection (mysqlx.connection.Connection) – Connection object.
sql (string) – The sql statement to be executed.

bind(*args)¶

Binds value(s) to a specific placeholder(s).

Parameters:: *args – The value(s) to bind.
Returns:: SqlStatement object.
Return type:: mysqlx.SqlStatement

property changed¶

True if this statement has changes.

Type:: bool

property deallocate_prepare_execute¶

True to deallocate + prepare + execute statement.

Type:: bool

property exec_counter¶

The number of times this statement was executed.

Type:: int

execute()¶

Execute the statement.

Returns:: SqlResult object.
Return type:: mysqlx.SqlResult

get_binding_map()¶

Returns the binding map dictionary.

Returns:: The binding map dictionary.
Return type:: dict

get_bindings()¶

Returns the bindings list.

Returns:: The bindings list.
Return type:: list

increment_exec_counter()¶: Increments the number of times this statement has been executed.

is_doc_based()¶

Check if it is document based.

Returns:: True if it is document based.
Return type:: bool

property prepared¶

True if this statement has been prepared.

Type:: bool

property repeated¶

True if this statement was executed more than once.

Type:: bool

reset_exec_counter()¶: Resets the number of times this statement has been executed.

property schema¶

The Schema object.

Type:: mysqlx.Schema

property sql¶

The SQL text statement.

Type:: string

property stmt_id¶

Returns this statement ID.

Returns:: The statement ID.
Return type:: int

property target¶

The database object target.

Type:: object