mysqlx.UpdateStatement

class mysqlx.UpdateStatement(table)

Bases: mysqlx.statement.FilterableStatement

A statement for record update operations on a Table.

Parameters:table (mysqlx.Table) – The Table object.

Changed in version 8.0.12: The fields parameters were removed.

bind(*args)

Binds value(s) to a specific placeholder(s).

Parameters:*args – The name of the placeholder and the value to bind. A mysqlx.DbDoc object or a JSON string representation can be used.
Returns:FilterableStatement object.
Return type:mysqlx.FilterableStatement
Raises:ProgrammingError – If the number of arguments is invalid.
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
Raises:ProgrammingError – If condition was not set.
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
get_grouping()

Returns the grouping expression list.

Returns:The grouping expression list.
Return type:list
get_having()

Returns the having expression.

Returns:The having expression.
Return type:object
get_limit_offset()

Returns the limit offset.

Returns:The limit offset.
Return type:int
get_limit_row_count()

Returns the limit row count.

Returns:The limit row count.
Return type:int
get_projection_expr()

Returns the projection expression.

Returns:The projection expression.
Return type:object
get_sort_expr()

Returns the sort expression.

Returns:The sort expression.
Return type:object
get_update_ops()

Returns the list of update operations.

Returns:The list of update operations.
Return type:list
get_where_expr()

Returns the where expression.

Returns:The where expression.
Return type:object
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
limit(row_count, offset=None)

Sets the maximum number of items to be returned.

Parameters:row_count (int) – The maximum number of items.
Returns:FilterableStatement object.
Return type:mysqlx.FilterableStatement
Raises:ValueError – If row_count is not a positive integer.

Changed in version 8.0.12: The usage of offset was deprecated.

offset(offset)

Sets the number of items to skip.

Parameters:offset (int) – The number of items to skip.
Returns:FilterableStatement object.
Return type:mysqlx.FilterableStatement
Raises:ValueError – If offset is not a positive integer.

New in version 8.0.12.

order_by(*clauses)

Sets the order by criteria.

Parameters:*clauses – The expression strings defining the order by criteria.
Returns:UpdateStatement object.
Return type:mysqlx.UpdateStatement
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
set(field, value)

Updates the column value on records in a table.

Parameters:
  • field (string) – The column name to be updated.
  • value (object) – The value to be set on the specified column.
Returns:

UpdateStatement object.

Return type:

mysqlx.UpdateStatement

sort(*clauses)

Sets the sorting criteria.

Parameters:*clauses – The expression strings defining the sort criteria.
Returns:FilterableStatement object.
Return type:mysqlx.FilterableStatement

Deprecated since version 8.0.12.

stmt_id

Returns this statement ID.

Returns:The statement ID.
Return type:int
target

The database object target.

Type:object
where(condition)

Sets the search condition to filter.

Parameters:condition (str) – Sets the search condition to filter records.
Returns:UpdateStatement object.
Return type:mysqlx.UpdateStatement