Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/setting-the-current-schema.html
If no default schema has been selected at connection, the Session class setCurrentSchema() function can be used to set a current schema. A default schema for a session can be specified using the schema attribute in the URI-like connection string or ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/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-js/en/working-with-metadata.html
For example, the following metadata is returned in response to the query SELECT 1+1 AS a, b FROM mydb.some_table_with_b AS b_table. Results contain metadata related to the origin and types of results from relational queries. This metadata can be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-find.html
The find(SearchConditionStr) function is for searching documents in a collection, similar to the SELECT statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that should be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-modify.html
Here are some examples, which do not exhaust the possibilities of using mysql.expr(Expression) for ExprOrLiteral: Another DocPath selecting a value from the document that is being modified (for example, set("favorNums[0]", ... The ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/crud-operations-overview.html
Operation Document Relational Create Section 4.3.1, “Collection.add()” Table.insert() Read Section 4.3.2, “Collection.find()” Table.select() Update Section 4.3.3, “Collection.modify()” Table.update() Delete Section 4.3.4, ... CRUD ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/fetching-all-data-items-at-once.html
myResult = myTable.select(['name', 'age']) \ .where('name like :name').bind('name','L%') \ .execute() myRows = myResult.fetch_all() for row in myRows: print("%s is %s years old." % (row.name, row.age)) When mixing fetchOne() and fetchAll() to read ... 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/result-set-classes.html
DocResult find().execute() The fetched data set RowResult select.execute() The fetched data set The following class diagram gives a basic overview of the result classes and their functions. The type of result returned depends on the operation that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/setting-the-current-schema.html
If no default schema has been selected at connection, the Session class setCurrentSchema() function can be used to set a current schema. A default schema for a session can be specified using the schema attribute in the URI-like connection string or ...
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.