+ 8
- 0
@@ -44,6 +44,10 @@ class CSVSQL(CSVKitUtility):
@@ -135,6 +139,8 @@ class CSVSQL(CSVKitUtility):
@@ -146,6 +152,8 @@ class CSVSQL(CSVKitUtility):
Created by: jest
My use case: inserting into IDENTITY
columns in SQL Server is not possible, unless you execute SET IDENTITY_INSERT <tablename> ON
in the same transaction before. So, to allow for --insert
in csvsql
I have to execute this SQL before the inserts themself.
This PR adds --execute-before-insert
and --execute-after-insert
command line options.
Preferences