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.

Instalar

Download the release package and copy the script(s) that you are going to use to a place from which they will be INCLUDEd by execsql scripts. Show How to Install

Uso

See the documentation at http://execsql-upsert.osdn.io/. Mostrar Uso

Download

Resenha
Your rating
Review this project

Statistics

Recent Activities

2020-05-10
01:33
execsql-upsert
2020-04-29
09:38
execsql-upsert
[Hg] commits were pushed to 'execsql-upsert' (current: 98d0a593abe07d2b183c2f01e60f864eb10df8dd)
Modified to explicitly roll back changes if do_commit is 'No' rather than just restoring the prev...
2020-01-06
10:49
execsql-upsert
10:48
execsql-upsert
Show history