I'm using csvsql to insert into to a Postregress database, and I'd like it to ignore any errors generated from unique constraints (basically skip importing the same data twice).
In Postgres and that would be handled like this:
INSERT INTO table (num1, num2) VALUES (1,1) ON CONFLICT DO UPDATE
However, it doesn't look like any of the current csvsql options allow me to modify the insert statement like this, since --prefix would add it direcly after INSERT and --after-insert executes a seperate statement. Postgres doesn't support the 'OR IGNORE' format that MySQL does.
Seems like a --suffix option to append something to the end of the query would be useful here, or is this a fundamental issue, since agate-sql doesn't support this?
Are there any alternatives for ignoring unique constraint insert attempt errors? Even just a flag to ignore any error from an individual insert statement and keep trying would help here.
I'm using csvsql to insert into to a Postregress database, and I'd like it to ignore any errors generated from unique constraints (basically skip importing the same data twice).
In Postgres and that would be handled like this:
However, it doesn't look like any of the current csvsql options allow me to modify the insert statement like this, since
--prefixwould add it direcly after INSERT and--after-insertexecutes a seperate statement. Postgres doesn't support the 'OR IGNORE' format that MySQL does.Seems like a
--suffixoption to append something to the end of the query would be useful here, or is this a fundamental issue, since agate-sql doesn't support this?Are there any alternatives for ignoring unique constraint insert attempt errors? Even just a flag to ignore any error from an individual insert statement and keep trying would help here.