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

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