mysqlx.InsertStatement

class mysqlx.InsertStatement(table, *fields)

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

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

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:

mysqlx.Schema

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:

mysqlx.InsertStatement