Scripts for the execsql.py script processor that perform automated upsert operations (insert or update) on multiple tables simultaneously. The scripts dynamically create and execute SQL based on the database's information schema, and therefore do not require any customization, and work with any tables in any database in any of the supported DBMSs (PostgreSQL, MariaDB/MySQL, and SQL Server). The upsert scripts will automatically check for null values in non-null columns, conflicting primary key values, and invalid foreign key values before merging the data. The progress and results of the upsert operation can be logged and reviewed through interactive displays of pending data changes.
Fork
rdnielsen
