When switching themes INSERT statement is not parsed correctly

PostgreSQL-For-Wordpress / postgresql-for-wordpress

A maintained fork of https://wordpress.org/plugins/postgresql-for-wordpress/

GNU General Public License v2.0

220 stars 71 forks source link

When switching themes INSERT statement is not parsed correctly #43

Closed mattbucci closed 10 months ago

mattbucci commented 10 months ago

SQL Statement

INSERT INTO "wp_options" ("option_name", "option_value", "autoload") VALUES ('theme_switch_menu_locations', 'a:0:{}', 'yes') ON CONFLICT ("option_name") DO UPDATE SET "option_name" = EXCLUDED."option_name", "option_value" = EXCLUDED."option_value", "autoload" = EXCLUDED."autoload

Existing regex:

/INSERT INTO (\w+)\s+\([ a-zA-Z_"]+/