Star

Created With

linkSet

QueryBuilderParameters['SetI']

linkSet by using a literal string

A literal string will be used as is.

1linkconst queryBuilder = new QueryBuilder()

2link .set('a.id = 5'); /* --> literal string to use */

3link

4linkconsole.log(queryBuilder.getStatement()); // SET a.id = 5

5linkconsole.log(queryBuilder.getBindParam().get()); // {}

linkSet by using an object

A SET statement can be generated using an object with an identifier and properties.

1linkconst queryBuilder = new QueryBuilder().set({

2link /* --> identifier whose properties will be set */

3link identifier: 'n',

4link /* --> properties to set */

5link properties: {

6link name: 'John',

7link age: 28,

8link },

9link});

10link

11linkconsole.log(queryBuilder.getStatement()); // SET n.name = $name AND n.age = $age

12linkconsole.log(queryBuilder.getBindParam().get()); // { name: 'John', age: 28 }

SetSet by using a literal stringSet by using an object

Introduction Getting Started

Modelschevron_right

Sessions and Transactions

Query Builderchevron_right
Query Runnerchevron_right

Bind Parameters

Where Parameters