Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/transaction-handling.html
The example assumes that the test schema exists and that the collection my_collection does not exist. Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-collections-basic-crud.html
The example assumes that the test schema exists and that the collection my_collection does not exist. Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-document-ids.html
It is assumed that the test schema exists and is assigned to the variable db, that the collection my_collection exists and that custom_id is unique. This section describes what a document ID is and how to work with it. Every document has a unique ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-locking.html
Consistent reads ignore any locks set on the records that exist in the read view. Locks are held for as long as the transaction which they were acquired in exists. X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-savepoints.html
For example, consider the following statements with no explicit BEGIN, session.startTransaction() or similar call: session.setSavepoint('testsavepoint'); session.releaseSavepoint('testsavepoint'); If autocommit mode is enabled on the server, these ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. var res = mySession.sql('SELECT name, age FROM ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-single-document-operations.html
Collection.replaceOne(string id, Document doc) updates or replaces the document identified by id, if it exists, with the provided document. Collection.addOrReplaceOne(string id, Document doc) adds the given document; however, if the id or any other ... The CRUD commands described at Section 4.3, “Collection CRUD Function Overview” all act on a group of documents in a collection that match a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/database-connection-example.html
The example assumes that a schema called test exists, and the my_collection collection exists. The code that is needed to connect to a MySQL document store looks a lot like the traditional MySQL connection code, but now applications can establish ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/error-handling.html
The example assumes that the test schema exists and that the collection my_collection exists. When writing scripts for MySQL Shell you can often simply rely on the exception handling done by MySQL Shell. For all other languages either proper ...