mysqlx.InsertStatement¶
-
class
mysqlx.
InsertStatement
(table, *fields)¶ Bases:
mysqlx.statement.WriteStatement
A statement for insert operations on Table.
- Parameters
table (mysqlx.Table) – The Table object.
*fields – The fields to be inserted.
-
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
Result object.
- Return type
-
get_values
()¶ Returns the list of values.
- Returns
The list of values.
- 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
stmt_id
¶ Returns this statement ID.
- Returns
The statement ID.
- Return type
int
-
property
target
¶ The database object target.
- Type
object
-
values
(*values)¶ Set the values to be inserted.
- Parameters
*values – The values of the columns to be inserted.
- Returns
InsertStatement object.
- Return type