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.

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:	Result object.
Return type:	mysqlx.Result

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

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`

stmt_id¶

Returns this statement ID.

Returns:	The statement ID.
Return type:	int

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:	mysqlx.InsertStatement