Skip error values and insert into tables

[SrujanMungara]

Do we have Insert Ignore option in SqfEntity?

Requirement:
I have 3 unique values in a statement, 4th value is a duplicate, followed by 2 unique values. When using batchCommit for insertion, rollback is happening. If tried to insert without batchStart and batchCommit, only first 3 values are inserted and remaining values are getting skipped. I need only 4th value to be skipped and all the unique 5 values to insert into the table.

Can u please suggest a solution for the above issue? @hhtokpinar

[hhtokpinar]

Hi,
I've added optional parameters into saveAll method and batchCommit. re-generate the models after upgrading to the latest version

  MyDbModel.batchCommit({bool? exclusive, bool? noResult, bool? continueOnError})
  .... 
  saveAll({bool? exclusive, bool? noResult, bool? continueOnError})

[SrujanMungara]

can u please update the same method for upsert also?

[hhtokpinar]

updated upsertAll method too

[SrujanMungara]

I need only few fields of the table to be updated and it has to be done for n number of values, looping, which i need to perform using single upsert function instead of upsertall/saveall

[hhtokpinar]

You could use the single functions like save() or upsert like below

MyDbModel().batchStart() 
// do single save/upsert
item1.save(ignoreBatch:false)
item2.upsert(...., ignoreBatch:false)
... 
MyDbModel().batchCommit(continueOnError:true)

[SrujanMungara]

@hhtokpinar

If i use ignoreBatch: false, when an error value is hit, all the values are getting rolledback and table has 0 values. But if i use Ignorebatch: true, the values are getting inserted till the error value is hit and is getting exited from loop with the next correct values not inserting.

Both the processes are happening when using batchCommit(continueOnError: true)

[SrujanMungara]

@hhtokpinar

Any update please

[SrujanMungara]

@hhtokpinar

Any update please