Download List

Project Description

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.

System Requirements

Operating System: POSIX (Linux,BSD,Solaris etc..), Windows, OS Independent
Python >=2.7
execsql.py (https://osdn.net/projects/execsql/)

Download Package list

execsql-upsert (1 items )

Released at 2020-01-06 10:27
v. 2.0.0 2019-05-23 (3 files Hide)