mysqlx.InsertStatement¶
- class mysqlx.InsertStatement(table, *fields)¶
Bases:
mysqlx.statement.WriteStatementA 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