Reference¶
Connection¶
- mysqlx.get_client
- mysqlx.get_session
- mysqlx.Client
- mysqlx.Session
SessionSession.close()Session.close_connections()Session.commit()Session.create_schema()Session.drop_schema()Session.get_connection()Session.get_default_schema()Session.get_schema()Session.get_schemas()Session.is_open()Session.release_savepoint()Session.rollback()Session.rollback_to()Session.set_savepoint()Session.sql()Session.start_transaction()Session.use_pure
CRUD¶
- mysqlx.Schema
SchemaSchema.am_i_real()Schema.create_collection()Schema.drop_collection()Schema.exists_in_database()Schema.get_collection()Schema.get_collection_as_table()Schema.get_collections()Schema.get_connection()Schema.get_name()Schema.get_schema()Schema.get_session()Schema.get_table()Schema.get_tables()Schema.get_view()Schema.modify_collection()Schema.nameSchema.schemaSchema.sessionSchema.who_am_i()
- mysqlx.Collection
CollectionCollection.add()Collection.add_or_replace_one()Collection.am_i_real()Collection.count()Collection.create_index()Collection.drop_index()Collection.exists_in_database()Collection.find()Collection.get_connection()Collection.get_name()Collection.get_one()Collection.get_schema()Collection.get_session()Collection.modify()Collection.nameCollection.remove()Collection.remove_one()Collection.replace_one()Collection.schemaCollection.sessionCollection.who_am_i()
- mysqlx.Table
- mysqlx.View
- mysqlx.expr
Result¶
- mysqlx.Column
ColumnColumn.character_set_nameColumn.collation_nameColumn.column_labelColumn.column_nameColumn.fractional_digitsColumn.get_character_set_name()Column.get_collation_name()Column.get_column_label()Column.get_column_name()Column.get_fractional_digits()Column.get_length()Column.get_proto_type()Column.get_schema_name()Column.get_table_label()Column.get_table_name()Column.get_type()Column.is_bytes()Column.is_number_signed()Column.is_padded()Column.lengthColumn.schema_nameColumn.table_labelColumn.table_nameColumn.type
- mysqlx.Row
- mysqlx.Result
ResultResult.append_warning()Result.get_affected_items_count()Result.get_autoincrement_value()Result.get_document_id()Result.get_generated_ids()Result.get_generated_insert_id()Result.get_warnings()Result.get_warnings_count()Result.set_closed()Result.set_generated_ids()Result.set_generated_insert_id()Result.set_rows_affected()
- mysqlx.BufferingResult
BufferingResultBufferingResult.append_warning()BufferingResult.countBufferingResult.fetch_all()BufferingResult.fetch_one()BufferingResult.get_affected_items_count()BufferingResult.get_warnings()BufferingResult.get_warnings_count()BufferingResult.index_of()BufferingResult.set_closed()BufferingResult.set_generated_ids()BufferingResult.set_generated_insert_id()BufferingResult.set_has_data()BufferingResult.set_has_more_results()BufferingResult.set_rows_affected()
- mysqlx.RowResult
RowResultRowResult.append_warning()RowResult.columnsRowResult.countRowResult.fetch_all()RowResult.fetch_one()RowResult.get_affected_items_count()RowResult.get_columns()RowResult.get_warnings()RowResult.get_warnings_count()RowResult.index_of()RowResult.set_closed()RowResult.set_generated_ids()RowResult.set_generated_insert_id()RowResult.set_has_data()RowResult.set_has_more_results()RowResult.set_rows_affected()
- mysqlx.SqlResult
SqlResultSqlResult.append_warning()SqlResult.columnsSqlResult.countSqlResult.fetch_all()SqlResult.fetch_one()SqlResult.get_affected_items_count()SqlResult.get_autoincrement_value()SqlResult.get_columns()SqlResult.get_warnings()SqlResult.get_warnings_count()SqlResult.has_data()SqlResult.index_of()SqlResult.next_result()SqlResult.set_closed()SqlResult.set_generated_ids()SqlResult.set_generated_insert_id()SqlResult.set_has_data()SqlResult.set_has_more_results()SqlResult.set_rows_affected()
Statement¶
- mysqlx.DbDoc
- mysqlx.Statement
- mysqlx.FilterableStatement
FilterableStatementFilterableStatement.bind()FilterableStatement.changedFilterableStatement.deallocate_prepare_executeFilterableStatement.exec_counterFilterableStatement.execute()FilterableStatement.get_binding_map()FilterableStatement.get_bindings()FilterableStatement.get_grouping()FilterableStatement.get_having()FilterableStatement.get_limit_offset()FilterableStatement.get_limit_row_count()FilterableStatement.get_projection_expr()FilterableStatement.get_sort_expr()FilterableStatement.get_where_expr()FilterableStatement.increment_exec_counter()FilterableStatement.is_doc_based()FilterableStatement.limit()FilterableStatement.offset()FilterableStatement.preparedFilterableStatement.repeatedFilterableStatement.reset_exec_counter()FilterableStatement.schemaFilterableStatement.sort()FilterableStatement.stmt_idFilterableStatement.targetFilterableStatement.where()
- mysqlx.SqlStatement
SqlStatementSqlStatement.bind()SqlStatement.changedSqlStatement.deallocate_prepare_executeSqlStatement.exec_counterSqlStatement.execute()SqlStatement.get_binding_map()SqlStatement.get_bindings()SqlStatement.increment_exec_counter()SqlStatement.is_doc_based()SqlStatement.preparedSqlStatement.repeatedSqlStatement.reset_exec_counter()SqlStatement.schemaSqlStatement.sqlSqlStatement.stmt_idSqlStatement.target
- mysqlx.FindStatement
FindStatementFindStatement.bind()FindStatement.changedFindStatement.deallocate_prepare_executeFindStatement.exec_counterFindStatement.execute()FindStatement.fields()FindStatement.get_binding_map()FindStatement.get_bindings()FindStatement.get_grouping()FindStatement.get_having()FindStatement.get_limit_offset()FindStatement.get_limit_row_count()FindStatement.get_projection_expr()FindStatement.get_sort_expr()FindStatement.get_where_expr()FindStatement.group_by()FindStatement.having()FindStatement.increment_exec_counter()FindStatement.is_doc_based()FindStatement.is_lock_exclusive()FindStatement.is_lock_shared()FindStatement.limit()FindStatement.lock_contentionFindStatement.lock_exclusive()FindStatement.lock_shared()FindStatement.offset()FindStatement.preparedFindStatement.repeatedFindStatement.reset_exec_counter()FindStatement.schemaFindStatement.sort()FindStatement.stmt_idFindStatement.targetFindStatement.where()
- mysqlx.AddStatement
AddStatementAddStatement.add()AddStatement.changedAddStatement.deallocate_prepare_executeAddStatement.exec_counterAddStatement.execute()AddStatement.get_values()AddStatement.increment_exec_counter()AddStatement.is_doc_based()AddStatement.is_upsert()AddStatement.preparedAddStatement.repeatedAddStatement.reset_exec_counter()AddStatement.schemaAddStatement.stmt_idAddStatement.targetAddStatement.upsert()
- mysqlx.RemoveStatement
RemoveStatementRemoveStatement.bind()RemoveStatement.changedRemoveStatement.deallocate_prepare_executeRemoveStatement.exec_counterRemoveStatement.execute()RemoveStatement.get_binding_map()RemoveStatement.get_bindings()RemoveStatement.get_grouping()RemoveStatement.get_having()RemoveStatement.get_limit_offset()RemoveStatement.get_limit_row_count()RemoveStatement.get_projection_expr()RemoveStatement.get_sort_expr()RemoveStatement.get_where_expr()RemoveStatement.increment_exec_counter()RemoveStatement.is_doc_based()RemoveStatement.limit()RemoveStatement.offset()RemoveStatement.preparedRemoveStatement.repeatedRemoveStatement.reset_exec_counter()RemoveStatement.schemaRemoveStatement.sort()RemoveStatement.stmt_idRemoveStatement.targetRemoveStatement.where()
- mysqlx.ModifyStatement
ModifyStatementModifyStatement.array_append()ModifyStatement.array_insert()ModifyStatement.bind()ModifyStatement.change()ModifyStatement.changedModifyStatement.deallocate_prepare_executeModifyStatement.exec_counterModifyStatement.execute()ModifyStatement.get_binding_map()ModifyStatement.get_bindings()ModifyStatement.get_grouping()ModifyStatement.get_having()ModifyStatement.get_limit_offset()ModifyStatement.get_limit_row_count()ModifyStatement.get_projection_expr()ModifyStatement.get_sort_expr()ModifyStatement.get_update_ops()ModifyStatement.get_where_expr()ModifyStatement.increment_exec_counter()ModifyStatement.is_doc_based()ModifyStatement.limit()ModifyStatement.offset()ModifyStatement.patch()ModifyStatement.preparedModifyStatement.repeatedModifyStatement.reset_exec_counter()ModifyStatement.schemaModifyStatement.set()ModifyStatement.sort()ModifyStatement.stmt_idModifyStatement.targetModifyStatement.unset()ModifyStatement.where()
- mysqlx.SelectStatement
SelectStatementSelectStatement.bind()SelectStatement.changedSelectStatement.deallocate_prepare_executeSelectStatement.exec_counterSelectStatement.execute()SelectStatement.get_binding_map()SelectStatement.get_bindings()SelectStatement.get_grouping()SelectStatement.get_having()SelectStatement.get_limit_offset()SelectStatement.get_limit_row_count()SelectStatement.get_projection_expr()SelectStatement.get_sort_expr()SelectStatement.get_sql()SelectStatement.get_where_expr()SelectStatement.group_by()SelectStatement.having()SelectStatement.increment_exec_counter()SelectStatement.is_doc_based()SelectStatement.is_lock_exclusive()SelectStatement.is_lock_shared()SelectStatement.limit()SelectStatement.lock_contentionSelectStatement.lock_exclusive()SelectStatement.lock_shared()SelectStatement.offset()SelectStatement.order_by()SelectStatement.preparedSelectStatement.repeatedSelectStatement.reset_exec_counter()SelectStatement.schemaSelectStatement.sort()SelectStatement.stmt_idSelectStatement.targetSelectStatement.where()
- mysqlx.InsertStatement
InsertStatementInsertStatement.changedInsertStatement.deallocate_prepare_executeInsertStatement.exec_counterInsertStatement.execute()InsertStatement.get_values()InsertStatement.increment_exec_counter()InsertStatement.is_doc_based()InsertStatement.preparedInsertStatement.repeatedInsertStatement.reset_exec_counter()InsertStatement.schemaInsertStatement.stmt_idInsertStatement.targetInsertStatement.values()
- mysqlx.DeleteStatement
DeleteStatementDeleteStatement.bind()DeleteStatement.changedDeleteStatement.deallocate_prepare_executeDeleteStatement.exec_counterDeleteStatement.execute()DeleteStatement.get_binding_map()DeleteStatement.get_bindings()DeleteStatement.get_grouping()DeleteStatement.get_having()DeleteStatement.get_limit_offset()DeleteStatement.get_limit_row_count()DeleteStatement.get_projection_expr()DeleteStatement.get_sort_expr()DeleteStatement.get_where_expr()DeleteStatement.increment_exec_counter()DeleteStatement.is_doc_based()DeleteStatement.limit()DeleteStatement.offset()DeleteStatement.order_by()DeleteStatement.preparedDeleteStatement.repeatedDeleteStatement.reset_exec_counter()DeleteStatement.schemaDeleteStatement.sort()DeleteStatement.stmt_idDeleteStatement.targetDeleteStatement.where()
- mysqlx.UpdateStatement
UpdateStatementUpdateStatement.bind()UpdateStatement.changedUpdateStatement.deallocate_prepare_executeUpdateStatement.exec_counterUpdateStatement.execute()UpdateStatement.get_binding_map()UpdateStatement.get_bindings()UpdateStatement.get_grouping()UpdateStatement.get_having()UpdateStatement.get_limit_offset()UpdateStatement.get_limit_row_count()UpdateStatement.get_projection_expr()UpdateStatement.get_sort_expr()UpdateStatement.get_update_ops()UpdateStatement.get_where_expr()UpdateStatement.increment_exec_counter()UpdateStatement.is_doc_based()UpdateStatement.limit()UpdateStatement.offset()UpdateStatement.order_by()UpdateStatement.preparedUpdateStatement.repeatedUpdateStatement.reset_exec_counter()UpdateStatement.schemaUpdateStatement.set()UpdateStatement.sort()UpdateStatement.stmt_idUpdateStatement.targetUpdateStatement.where()
- mysqlx.CreateCollectionIndexStatement
CreateCollectionIndexStatementCreateCollectionIndexStatement.changedCreateCollectionIndexStatement.deallocate_prepare_executeCreateCollectionIndexStatement.exec_counterCreateCollectionIndexStatement.execute()CreateCollectionIndexStatement.increment_exec_counter()CreateCollectionIndexStatement.is_doc_based()CreateCollectionIndexStatement.preparedCreateCollectionIndexStatement.repeatedCreateCollectionIndexStatement.reset_exec_counter()CreateCollectionIndexStatement.schemaCreateCollectionIndexStatement.stmt_idCreateCollectionIndexStatement.target
- mysqlx.ReadStatement
ReadStatementReadStatement.bind()ReadStatement.changedReadStatement.deallocate_prepare_executeReadStatement.exec_counterReadStatement.execute()ReadStatement.get_binding_map()ReadStatement.get_bindings()ReadStatement.get_grouping()ReadStatement.get_having()ReadStatement.get_limit_offset()ReadStatement.get_limit_row_count()ReadStatement.get_projection_expr()ReadStatement.get_sort_expr()ReadStatement.get_where_expr()ReadStatement.group_by()ReadStatement.having()ReadStatement.increment_exec_counter()ReadStatement.is_doc_based()ReadStatement.is_lock_exclusive()ReadStatement.is_lock_shared()ReadStatement.limit()ReadStatement.lock_contentionReadStatement.lock_exclusive()ReadStatement.lock_shared()ReadStatement.offset()ReadStatement.preparedReadStatement.repeatedReadStatement.reset_exec_counter()ReadStatement.schemaReadStatement.sort()ReadStatement.stmt_idReadStatement.targetReadStatement.where()
- mysqlx.WriteStatement
WriteStatementWriteStatement.changedWriteStatement.deallocate_prepare_executeWriteStatement.exec_counterWriteStatement.execute()WriteStatement.get_values()WriteStatement.increment_exec_counter()WriteStatement.is_doc_based()WriteStatement.preparedWriteStatement.repeatedWriteStatement.reset_exec_counter()WriteStatement.schemaWriteStatement.stmt_idWriteStatement.target