• R/O
  • SSH

execsql-upsert: List of commits

Default repository for the execsql-upsert scripts

修訂. 時間 作者
d035be3dd62c tip 2021-04-28 09:53:38 rdnielsen

Added a semicolon to the end of all logged SQL statements.

8c636a69de57 2020-05-10 01:33:04 Dreas Nielsen

Modified progress bar display for better performance.

98d0a593abe0 2020-04-29 09:38:28 Dreas Nielsen

Modified to explicitly roll back changes if do_commit is 'No' rather than just restoring the previous autocommit state.

2da9348ffd67 2020-01-06 10:22:52 Dreas Nielsen

Modified documentation per change from Bitbucket/RTD to OSDN.

9a6099ac5dad 2019-08-02 00:16:10 Dreas Nielsen

Minor edits to documentation.

2c93c8d3caef 2019-06-26 11:09:10 Dreas Nielsen

Updated version number in the change log.

1baa96727b3a 2019-06-24 09:26:27 Dreas Nielsen

Updated documentation to describe UPDTPK_ONE.

ef2f84bc2569 2019-06-24 05:13:40 Dreas Nielsen

PK UPSERT script completed for MariaDB/MySQL. All versions updated to 2.0.0.

5d867f6a5a68 2019-06-04 11:33:08 Elizabeth Shea

Added UPDTPKQA_ONE to pg_upsert and correction to logging in ss_upsert.

462eeeeb09f0 2019-05-30 10:55:08 Elizabeth Shea

Added script UPDTPK_ONE to pg_upsert

8714d454fe71 2019-05-29 10:37:19 Elizabeth Shea

Corrected ups_cols selection in UPSERT_ONE script within pg_upsert to include only columns from staging table that are also in the base table

a941efc27ff1 2019-05-23 12:23:17 Elizabeth Shea

Added script UPDTPKQA_ONE to ss_upsert

834e2c9017ae 2019-05-11 07:23:47 Elizabeth Shea

Added script UPDTPK_ONE to ss_upsert

bf24e17fcc21 2019-05-02 12:46:31 Dreas Nielsen

Merged heads.

9216ab414a72 2019-05-02 12:46:01 Dreas Nielsen

Corrected use of 'trim()' in ss_upsert.sql.

5ca5cc0df7e6 2019-04-17 05:14:55 Dreas Nielsen


c283dcdab74a 2019-04-17 05:09:16 Dreas Nielsen

Added casts of string literals to text in pg_upsert.sql.

9a39f57f928d 2019-03-25 03:07:46 Dreas Nielsen

Added documentation.

d4c55ee3cafb 2019-03-25 01:41:51 Dreas Nielsen

Modified the PKQA_ONE script for MariaDB to get only data for the current database from the information schema.

097f5f6e5662 2019-03-24 23:00:10 Dreas Nielsen

Modified tests for MariaDB.

28eb1a981efc 2019-03-16 14:34:21 Dreas Nielsen

Added table validation to md_upsert.sql. Added casts to validation in pg_upsert.sql.

3666ed342a4a 2019-03-16 08:15:01 Elizabeth Shea

Added table validation to pg_upsert.

ad6821f02019 2019-03-16 07:47:56 Elizabeth Shea

Added table validation to ss_upsert.

f6172d20a57c 2019-03-15 04:15:25 Dreas Nielsen

Updated documentation.

bcae7f412896 2019-03-15 04:08:30 Dreas Nielsen

Correction to staged_to_load() for Postgres.

e637e5f30bf9 2019-03-10 09:34:54 Dreas Nielsen

Updated documentation to describe the PK checks.

1a7b7e672085 2019-03-10 07:56:48 Elizabeth Shea

Merged with changes from DN.

17c5fb561b88 2019-03-10 07:56:01 Elizabeth Shea

Added 'ups_' prefix to 'nk' selection in ss_upsert and pg_upsert.

2512f265ccd7 2019-03-10 06:36:27 Dreas Nielsen

Updated md_upserts.sql with changes to pg_upsert.sql by ES.

306687fc640b 2019-03-10 05:12:21 Dreas Nielsen

Merged heads from ES changes to pg_upsert with local changes to md_upsert and documenation.

Show on old repository browser