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
- 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
- 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
- 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