Search Results
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/boolean-expression-strings.html
Boolean expression strings can be used when filtering collections or tables using operations, such as find() and remove(). The following example of a boolean expression string uses find() to search for all documents with a “red” color attribute ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. There are two different kinds ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/creating-documents.html
Once a collection has been created, it can store JSON documents. You store documents by passing a JSON data structure to the Collection.add() function. Some languages have direct support for JSON data, others have an equivalent syntax to represent ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/devapi-users-crud-operations.html
This section explains how to use the X DevAPI for Create Read, Update, and Delete (CRUD) operations. X DevAPI extends this domain by adding support for CRUD operations that can be run against collections of documents.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/fetching-all-data-items-at-once.html
The following example assumes that the test schema exists and that the employee table exists in myTable. myResult = myTable.select(['name', 'age']) \ .where('name like :name').bind('name','L%') \ .execute() myRows = myResult.fetch_all() for row in ... In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume data items one by one, X DevAPI also provides a pattern using fetchAll(), which passes all data items of a data set as a list to the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/method-chaining.html
The example assumes that the test schema exists and an employee table exists. X DevAPI supports a number of modern practices to make working with CRUD operations easier and to fit naturally into modern development environments. This section ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-a-session-object.html
All previous examples used the getSchema() or getDefaultSchema() methods of the Session object, which return a Schema object. Most examples make use of the X DevAPI ability to chain all object constructions, enabling you to get to the Schema object ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-document-ids.html
Every document has a unique identifier called the document ID, which can be thought of as the equivalent of a table's primary key. This section describes what a document ID is and how to work with it. The document ID value is usually automatically ...