insert api is used to insert new records in a table.

Sql

INSERT INTO TABLE_NAME
(column1, column2, column3,...columnN)
VALUES
(value1, value2, value3,...valueN);

JsStore

var value = {
    column1: value1,
    column2: value2,
    column3: value3,
    ...
    columnN: valueN
};

var noOfRowsInserted = await connection.insert({
    into: "TABLE_NAME",
    values: [Value], //you can insert multiple values at a time
});
if (noOfRowsInserted > 0) {
    alert('Successfully Added');
}


Note :- You can also insert data for a column, which you have not defined in db schema. JsStore preserves the NoSql functionality of IndexedDb.

Example

insert api has following options -

into

into is used to specify name of table

insert({
    into:'Products'
})

values

values is used to specify data to insert. It takes array of data.

insert({
    into:'Products',
    values:[data1,data2]
})

return

return is a optional & type of boolean field. It is used to get the inserted data. This is useful in case - you want the autoincrement column value.

insert({
    into:'Products',
    values:[data1,data2],
    return: true
})

Default value of return is false.

upsert

Update data if exist otherwise insert . Default value is false.

Read upsert doc.

validation

Whether to validate data or not. By default value is true. This can be used to speed up insert query.

insert({
    into:'Products',
    values:[data1,data2],
    validation: false
})

skipDataCheck

Do not check or change anything in data. By default value is false.

If supplied true, this will directly insert data without checking any thing like datatype, auto increment etc. This is useful in case - where you want to insert huge record at a time.

insert({
    into:'Products',
    values:[data1,data2],
    skipDataCheck: true
})
Difference between validation & skipDataCheck is - validation generates autoIncrement field for autoIncrement column but skipDataCheck do not change anything in data.

ignore

ignore records when error occurs. This is helpful in case when you are recieving some random data from users or any source.

e.g - consider you have 5 rows and 3 of them are not valid. It can be anything like - null value, data type does not match, existing value of primary key etc.

then 2 rows will be inserted & three will be ignored. So in result you will get 2.

insert({
    into:'Products',
    values:[datas],
    ignore: true
})

By default ignore value is false. So when any error occurs you will get error & whole transaction is aborted.