Bulk insertion on SQLite with ionic 3

Question

I want to do a bulk insertion in ionic 3 I have this code it works but it's really slow

 insertQuotation(value){

    for(var i=0; i<=value.length; i++){
    let data=[value[i].quotation_id,value[i].customer_name,value[i].product_name,value[i].price,value[i].services,value[i].response_time,value[i].created_time];

    this.database.executeSql("insert into care_plan_quotation_history(care_plan_quotation_id,customer_name,product,price,services,response_time,created_time) values(?,?,?,?,?,?,?)",data)
    .then(data=>{
      return data;
    },err=>{
      alert("error");
    })
    }
  }

please help me with this

Nil Llisterri · Accepted Answer · 2018-04-27 07:25:10Z

6

You can do bulk operations with Ionic and SQLite like this:

let insertRows = [];
items.forEach(item => {
    insertRows.push([
        "INSERT INTO items (id, type, date, message) VALUES (?, ?, ?, ?)",
        [item.id, item.type, item.date, item.message]
    ]);
});
this.database.sqlBatch(insertRows).then((result) => {
    console.info("Inserted items");
}).catch(e => console.log(e));

answered Apr 27, 2018 at 7:25

Nil Llisterri

86710 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Bulk insertion on SQLite with ionic 3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related