mysqlx.SqlStatement¶

class mysqlx.SqlStatement(connection, sql)¶

Bases: mysqlx.statement.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