Creating table with inserting default rows

[afbora]

For example; I want to create a options table and at the same time insert some static settings such as color, limit, etc. Is this possible?

{
  name: "options",
  columns: {
    id: {primaryKey: true, autoIncrement: true},
    key: {dataType: "string", notNull: true},
    value: {dataType: "string", notNull: true}
  },
  values: [
    {
      key: "color",
      value: "red"
    },
    {
      key: "limit",
      value: 10
    }
  ]
}

I also want to be able to do this when upgrading the db version, not only when creating a table.

[ujjwalguptaofficial]

Creating a table and inserting data into table are two different process. So you need to write two query for it.

1. Add table basically updating database schema
2. Insert data into the new table

JsStore returns true when you create or update the db schema.

// initiate jsstore connection
var connection = new JsStore.Connection();

// step1 - create database schema
var tblProduct = {
    name: 'Product',
    columns: {
        // Here "Id" is name of column 
        Id:{ primaryKey: true, autoIncrement: true },
        ItemName:  { notNull: true, dataType: "string" },
        Price:  { notNull: true, dataType: "number" },
        Quantity : { notNull: true, dataType: "number" }
    }
};

var tblOrder = {
    name: 'Order',
    columns: {
        // Here "OrderId" is name of column 
        OrderId:{ primaryKey: true, autoIncrement: true }
    }
};

var db = {
      name: dbName,
      tables: [tblProduct, tblOrder]
}

// step 2
var isDbCreated = await connection.initDb(db);
// isDbCreated will be true when database will be initiated for first time

if(isDbCreated){
    alert('Db Created & connection is opened');
    // insert data here
}
else{
    alert('Connection is opened');
}

You can also check for db version to insert or update data based on particular version.

[afbora]

Thank you for the answer.

You can also check for db version to insert or update data based on particular version.

I didn't know it. Checking db version is good idea for me 👍