Star

Created With

linkLimit

linkLimit by using a literal string

A literal string will be used as is.

1linkconst queryBuilder = new QueryBuilder()

2link    .limit('toInteger(3 * rand()) + 1'); /* --> literal string to use */

3link

4linkconsole.log(queryBuilder.getStatement()); // LIMIT toInteger(3 * rand()) + 1

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

linkLimit by using a number

That way, a Bind Parameter is used

1linkconst queryBuilder = new QueryBuilder().limit(5);

2link

3linkconsole.log(queryBuilder.getStatement()); // LIMIT $limit

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

linkSkip

linkSkip by using a literal string

A literal string will be used as is.

1linkconst queryBuilder = new QueryBuilder()

2link    .skip('toInteger(3 * rand()) + 1'); /* --> literal string to use */

3link

4linkconsole.log(queryBuilder.getStatement()); // SKIP toInteger(3 * rand()) + 1

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

linkSkip by using a number

That way, a Bind Parameter is used

1linkconst queryBuilder = new QueryBuilder().skip(5);

2link

3linkconsole.log(queryBuilder.getStatement()); // SKIP $skip

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

LimitLimit by using a literal stringLimit by using a numberSkipSkip by using a literal stringSkip by using a number

Introduction Getting Started

Modelschevron_right

Overview Defining a Model Instances Creating Nodes and Relationships Merging Nodes and Relationships Updating Nodes and Relationships Deleting Nodes Deleting Relationships Finding Nodes and Relationships Hooks Temporary Databases

Sessions and Transactions

Query Builderchevron_right

Overview Clauses Match Clause Create Clause Set Clause Delete Clause Where Clause Remove Clause Order By Clause Return Clause Limit/Skip Clause With Clause Unwind Clause Helpers

Query Runnerchevron_right

Overview Running Arbitrary Queries Creating Nodes Updating Nodes Deleting Nodes Creating Relationships Helpers

Bind Parameters

Where Parameters

GitHub