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
changed

True if this statement has changes.

Type:bool
deallocate_prepare_execute

True to deallocate + prepare + execute statement.

Type:bool
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
prepared

True if this statement has been prepared.

Type:bool
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.

schema

The Schema object.

Type:mysqlx.Schema
sql

The SQL text statement.

Type:string
stmt_id

Returns this statement ID.

Returns:The statement ID.
Return type:int
target

The database object target.

Type:object