• R/O
  • SSH

execsql-upsert: Commit

Default repository for the execsql-upsert scripts


Commit MetaInfo

Revision98d0a593abe07d2b183c2f01e60f864eb10df8dd (tree)
Time2020-04-29 09:38:28
AuthorDreas Nielsen <dreas.nielsen@gmai...>
CommiterDreas Nielsen

Log Message

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

Change Summary

Incremental Difference

diff -r 2da9348ffd67 -r 98d0a593abe0 doc/source/themes/sunwood/static/sunwood.css_t
--- a/doc/source/themes/sunwood/static/sunwood.css_t Sun Jan 05 17:22:52 2020 -0800
+++ b/doc/source/themes/sunwood/static/sunwood.css_t Tue Apr 28 17:38:28 2020 -0700
@@ -94,6 +94,11 @@
9494 margin-left: 1.5em;
9595 }
9696
97+pre {
98+ font-family: "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Lucida Console", "Courier New", Courier, fixed;
99+ font-size: 90%;
100+}
101+
97102 h1, h2, h3, h4 {
98103 font-family: {{ theme_headerfont }};
99104 font-weight: normal;
diff -r 2da9348ffd67 -r 98d0a593abe0 upsert/md_upsert.sql
--- a/upsert/md_upsert.sql Sun Jan 05 17:22:52 2020 -0800
+++ b/upsert/md_upsert.sql Tue Apr 28 17:38:28 2020 -0700
@@ -142,6 +142,7 @@
142142 -- through QA check 8. RDN.
143143 -- 2019-06-16 Nominally complete revisions of PK updating scripts. RDN.
144144 -- 2019-06-23 Completed debugging of PK updating scripts. RDN.
145+-- 2020-04-28 Explicitly rolled back the changes if 'do_commit' = "No". RDN.
145146 -- ==================================================================
146147
147148
@@ -527,6 +528,7 @@
527528 -- !x! write "!!$current_time!! -- CHANGES COMMITTED." to !!logfile!!
528529 -- !x! endif
529530 -- !x! else
531+ -- !x! autocommit on with rollback
530532 -- !x! write "CHANGES NOT COMMITTED ('do_commit' argument = !!#do_commit!!)"
531533 -- !x! if(sub_defined(log_changes))
532534 -- !x! andif(is_true(!!log_changes!!))
diff -r 2da9348ffd67 -r 98d0a593abe0 upsert/pg_upsert.sql
--- a/upsert/pg_upsert.sql Sun Jan 05 17:22:52 2020 -0800
+++ b/upsert/pg_upsert.sql Tue Apr 28 17:38:28 2020 -0700
@@ -154,6 +154,7 @@
154154 -- 2019-05-29 Added script UPDTPK_ONE. ES.
155155 -- 2019-05-30 Added UPDTPKQA_ONE through check #8. ES.
156156 -- 2019-06-03 Completed UPDTPKQA_ONE and added UPDTPKQA_ONE_INNERLOOP. ES.
157+-- 2020-04-28 Explicitly rolled back the changes if 'do_commit' = "No". RDN.
157158 -- ==================================================================
158159
159160
@@ -585,6 +586,7 @@
585586 -- !x! write "!!$current_time!! -- CHANGES COMMITTED." to !!logfile!!
586587 -- !x! endif
587588 -- !x! else
589+ -- !x! autocommit on with rollback
588590 -- !x! write "CHANGES NOT COMMITTED ('do_commit' argument = !!#do_commit!!)"
589591 -- !x! if(sub_defined(log_changes))
590592 -- !x! andif(is_true(!!log_changes!!))
diff -r 2da9348ffd67 -r 98d0a593abe0 upsert/ss_upsert.sql
--- a/upsert/ss_upsert.sql Sun Jan 05 17:22:52 2020 -0800
+++ b/upsert/ss_upsert.sql Tue Apr 28 17:38:28 2020 -0700
@@ -125,6 +125,7 @@
125125 -- in UPDTPKQA_ONE. ES.
126126 -- 2019-05-29 Corrections to comments. ES.
127127 -- 2019-06-03 Correction to logging in UPDTPKQA_ONE_INNERLOOP. ES.
128+-- 2020-04-28 Explicitly rolled back the changes if 'do_commit' = "No". RDN.
128129 -- ==================================================================
129130
130131 -- ################################################################
@@ -695,7 +696,8 @@
695696 -- !x! write "==================================================================" to !!logfile!!
696697 -- !x! write "!!$current_time!! -- CHANGES COMMITTED." to !!logfile!!
697698 -- !x! endif
698- -- !x! else
699+ -- !x! else
700+ -- !x! autocommit on with rollback
699701 -- !x! write "CHANGES NOT COMMITTED ('do_commit' argument = !!#do_commit!!)"
700702 -- !x! if(sub_defined(log_changes))
701703 -- !x! andif(is_true(!!log_changes!!))
Show on old repository browser