Interface Setup

Inserting Records in Batches

Batch Update Records

Count the number of records that meet the condition.

Example

import * as db from 'db';

let s = db.setup('setup_object');
let cond = {
    conjunction: db.Conjunction.AND,
    conditions: [
        {
            field: "name",
            "operator": db.Operator.eq,
            "value": 'setup_name'
        }
    ]
}
let num = s.count(cond);
Copy

Deletes records by ID.

A maximum of 5000 records can be deleted based on conditions.

Create a record

Querying Records by ID

The number of records to be returned can be limited. The skip value is used to specify the number of records to be returned. The limit value is used to specify the number of records to be returned.

If skip and limit are not specified, the default values are skip=0 and limit=5000, indicating that the first 5000 records in the result set are returned. The maximum limit can be set to 10000, indicating that the query interface can return only the first 10000 records in the query result set.

Updates records by ID.

Records are updated based on conditions. A maximum of 5000 records can be updated.