Log error records as a pipe delimited string

[dinakarmu]

I have a list of tuples that will be loaded using executemany. Good records should get loaded while I want to log the error or bad records into an error_table with three columns run_date, data_string, error. is this possible?

[anthony-tuininga]

Yes, it is definitely possible! Use the batcherrors option for executemany() which is documented here.

[dinakarmu]

Should I be loading the error records in a loop one by one from the "data" list in the example? I can't use executemany() to load the error records in one shot?

[anthony-tuininga]

You can use executemany() to load the error records as well. No reason not to!