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 explains how to use method chaining instead of working with SQL strings of JSON structures.

The following example shows how method chaining is used instead of an SQL string when working with Session objects. The example assumes that thetestschema exists and anemployeetable exists.

MySQL Shell JavaScript Code

/ /用于执行新的方法链接uting an SQL SELECT statement // Recommended way for executing queries var employees = db.getTable('employee'); var res = employees.select(['name', 'age']). where('name like :param'). orderBy(['name']). bind('param', 'm%').execute(); // Traditional SQL execution by passing an SQL string // It should only be used when absolutely necessary var result = session.sql('SELECT name, age ' + 'FROM employee ' + 'WHERE name like ? ' + 'ORDER BY name').bind('m%').execute();

MySQL Shell Python Code

# New method chaining used for executing an SQL SELECT statement # Recommended way for executing queries employees = db.get_table('employee') res = employees.select(['name', 'age']) \ .where('name like :param') \ .order_by(['name']) \ .bind('param', 'm%').execute() # Traditional SQL execution by passing an SQL string # It should only be used when absolutely necessary result = session.sql('SELECT name, age ' + 'FROM employee ' + 'WHERE name like ? ' + 'ORDER BY name').bind('m%').execute()

Node.js JavaScript Code

/ /用于执行新的方法链接uting an SQL SELECT statement // Recommended way for executing queries var employees = db.getTable('employee'); var promise = employees.select('name', 'age') .where('name like :name') .orderBy('name') .bind('m%') .execute(); // Traditional SQL execution by passing an SQL string var sqlString = 'SELECT name, age ' + 'FROM employee ' + 'WHERE name like ? ' + 'ORDER BY name'; var promise = db.executeSql(sqlString, 'm%').execute();

C# Code

/ /用于执行新的方法链接uting an SQL SELECT statement // Recommended way for executing queries var employees = db.GetTable("employee"); var res = employees.Select("name", "age") .Where("name like :param") .OrderBy("name") .Bind("param", "m%").Execute(); // Traditional SQL execution by passing an SQL string // It should only be used when absolutely necessary var result = session.SQL("SELECT name, age " + "FROM employee " + "WHERE name like ? " + "ORDER BY name").Bind("m%").Execute();

Python Code

# Connector/Python # New method chaining used for executing an SQL SELECT statement # Recommended way for executing queries employees = db.get_table('employee') res = employees.select(['name', 'age']) \ .where('name like :param') \ .order_by(['name']) \ .bind('param', 'm%').execute() # Traditional SQL execution by passing an SQL string # It should only be used when absolutely necessary result = session.sql('SELECT name, age ' + 'FROM employee ' + 'WHERE name like ? ' + 'ORDER BY name').bind('m%').execute()

Java Code

/ /用于执行新的方法链接uting an SQL SELECT statement // Recommended way for executing queries Table employees = db.getTable("employee"); RowResult res = employees.select("name, age") .where("name like :param") .orderBy("name") .bind("param", "m%").execute(); // Traditional SQL execution by passing an SQL string // It should only be used when absolutely necessary SqlResult result = session.sql("SELECT name, age " + "FROM employee " + "WHERE name like ? " + "ORDER BY name").bind("m%").execute();

C++ Code

/ /用于执行新的方法链接uting an SQL SELECT statement // Recommended way for executing queries Table employees = db.getTable("employee"); RowResult res = employees.select("name", "age") .where("name like :param") .orderBy("name") .bind("param", "m%").execute(); // Traditional SQL execution by passing an SQL string // It should only be used when absolutely necessary RowResult result = session.sql("SELECT name, age " "FROM employee " "WHERE name like ? " "ORDER BY name").bind("m%").execute();