Fix an issue where command and statements were parsed incorrectly for Rules. Fixes #5115
Fixed issue where removing command or statements altogether was not generating modified SQL.
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=a44f17a2fcdca20611fdaea0cb1e8b633e4e81bc
Author: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Modified Files
--------------
docs/en_US/release_notes_4_19.rst | 3 +-
.../schemas/tables/rules/static/js/rule.js | 8 ++--
.../tests/default/alter_delete_event_rule.sql | 4 +-
.../tests/default/alter_delete_event_rule_msql.sql | 4 +-
.../tests/default/alter_insert_event_rule.sql | 6 +--
.../default/alter_insert_event_rule_complex.sql | 17 +++++++
.../alter_insert_event_rule_complex_msql.sql | 8 ++++
.../tests/default/alter_insert_event_rule_msql.sql | 6 +--
.../tests/default/alter_update_event_rule.sql | 6 +--
.../tests/default/alter_update_event_rule_msql.sql | 6 +--
.../tests/default/create_delete_event_rule.sql | 3 +-
.../default/create_delete_event_rule_msql.sql | 3 +-
.../tests/default/create_insert_event_rule.sql | 6 +--
.../default/create_insert_event_rule_msql.sql | 6 +--
.../tests/default/create_update_event_rule.sql | 6 +--
.../default/create_update_event_rule_msql.sql | 6 +--
.../schemas/tables/rules/tests/default/test.json | 11 +++++
.../schemas/tables/templates/rules/sql/create.sql | 16 +++----
.../tables/templates/rules/sql/properties.sql | 4 +-
.../schemas/tables/templates/rules/sql/update.sql | 16 ++++---
.../servers/databases/schemas/utils.py | 53 +++++++++++++---------
21 files changed, 124 insertions(+), 74 deletions(-)