Commit Graph

259 Commits

Author SHA1 Message Date
Matthew Bucci
a6765201ce rewrite utc timestamp requests 2024-10-17 02:54:44 -07:00
Matthew Bucci
d0eab624eb replace regexp with its postgres version 2024-10-17 02:45:32 -07:00
Matthew Bucci
90d1c47695 cast numbers explictly as ints rather than adding 0 to them 2024-10-17 02:36:24 -07:00
Matthew Bucci
07b49dbb65 remove key names which are not supported during key creation in postgres 2024-10-17 01:31:06 -07:00
Matthew Bucci
b463ead79f convert mediumints to ints 2024-10-17 01:25:16 -07:00
Matthew Bucci
d46dba6148 numeric rewriting should be case insensitive 2024-10-17 01:18:11 -07:00
Matthew Bucci
d8b83c88e2 Add newest WP version to tested list 2024-06-03 02:34:53 -07:00
Matthew Bucci
c7e3fbd50b Merge pull request #101 from PostgreSQL-For-Wordpress/returning-replaces-seq
Replace calls to seq by adding a RETURNING * to all insert and replace statements
v3.4
2024-02-29 00:07:55 -08:00
Matthew Bucci
916950315f Merge remote-tracking branch 'origin/v3' into returning-replaces-seq 2024-02-29 00:07:13 -08:00
Matthew Bucci
6df70e35f2 Merge pull request #93 from PostgreSQL-For-Wordpress/rewrite-fixes
Improve string replacements
2024-02-29 00:04:36 -08:00
Matthew Bucci
28fb016969 update expected results for create table tests with protected names 2024-02-27 00:58:58 -08:00
Matthew Bucci
b7be1aa89a add rewriting for protected column names 2024-02-27 00:53:05 -08:00
Matthew Bucci
1b6ecce7d9 Merge remote-tracking branch 'origin/v3' into rewrite-fixes 2024-02-26 23:55:09 -08:00
Matthew Bucci
a2e25163ff remove custom last_insert_ID logic 2024-02-26 23:47:53 -08:00
Matthew Bucci
2d5f178426 improve primary key detection to use first column found if no primary key found 2024-02-26 23:44:17 -08:00
Matthew Bucci
b92d8dde92 append RETURNING * to REPLACE Commands 2024-02-26 23:31:22 -08:00
Matthew Bucci
226ed1fc89 Merge pull request #107 from PostgreSQL-For-Wordpress/fix-site-editor
remove unnecessary insert regex which modified (0 to ("0",
v3.3.1
2024-02-26 23:16:43 -08:00
Matthew Bucci
6149c2f234 remove uncessary insert regex which modified (0 to ("0", 2024-02-26 23:15:24 -08:00
Matthew Bucci
10d8047776 Merge branch 'returning-replaces-seq' into rc-3.4 2024-02-26 16:30:07 -08:00
Matthew Bucci
ed7cbf106c correct the REGEX for returning statements to account for backticks around table name 2024-02-26 16:29:49 -08:00
Matthew Bucci
cf88b4d075 formatting 2024-02-26 16:15:07 -08:00
Matthew Bucci
f602b49a5b Merge remote-tracking branch 'origin/returning-replaces-seq' into v3.4 2024-02-26 16:14:43 -08:00
Matthew Bucci
2adacb53aa Merge remote-tracking branch 'origin/rewrite-fixes' into v3.4 2024-02-26 16:08:00 -08:00
Matthew Bucci
d66df1d283 add pull request template 2024-02-26 13:24:33 -08:00
Matthew Bucci
052f6cc978 Update issue templates 2024-02-26 13:22:15 -08:00
Matthew Bucci
e9c35a4294 Update issue templates 2024-02-26 13:21:25 -08:00
Matthew Bucci
8de18593da Updated tested versions 2024-02-26 12:47:54 -08:00
Matthew Bucci
ab2809d28a Merge pull request #100 from PostgreSQL-For-Wordpress/site-health
add rewrite logic for SHOW TABLE STATUS and a catch for calls to information_schema
v3.3
2024-02-26 12:31:34 -08:00
Matthew Bucci
66cd2fb034 Merge branch 'v3' into site-health 2024-02-26 12:30:31 -08:00
Matthew Bucci
a5480c70cb quote any variable usages in SQL 2024-02-26 12:27:23 -08:00
Matthew Bucci
cdd38f6dfe Merge pull request #102 from PostgreSQL-For-Wordpress/wordpress-search
Fix Wordpress Search
2024-02-26 12:25:19 -08:00
Matthew Bucci
9373b914c2 Merge pull request #103 from PostgreSQL-For-Wordpress/replace-support
add support for REPLACE INTO rewriting
2024-02-26 12:24:54 -08:00
Matthew Bucci
15bdebed5e Merge pull request #104 from PostgreSQL-For-Wordpress/robust-numeric
make numeric rewriters generic
2024-02-26 12:21:25 -08:00
Matthew Bucci
b44dd00ec2 make numeric rewriters generic 2024-02-22 19:33:03 -08:00
Matthew Bucci
b33aa78976 add support for REPLACE INTO rewriting 2024-02-22 19:11:41 -08:00
Matthew Bucci
315823a203 adjust Select rewriter to handle order by case statements 2024-02-22 00:52:19 -08:00
Matthew Bucci
8d420dca52 replace calls to seq by adding a RETURNING * to all insert statements 2024-02-21 20:22:43 -08:00
Matthew Bucci
61cfa6896d extract public to schema variable so we can use a constant later 2024-02-21 01:22:57 -08:00
Matthew Bucci
ebbe2915c6 add rewrite logic for SHOW TABLE STATUS and a catch for calls to information_schema 2024-02-21 01:15:51 -08:00
Matthew Bucci
b76a569a15 add test for single quotes 2024-02-21 01:12:35 -08:00
Matthew Bucci
0dd4213cfc handle Alter Table Add Index behavior 2024-01-16 22:45:28 -08:00
Matthew Bucci
0b09d08fb1 remove unncessary string replacement for != to <> 2024-01-16 22:17:07 -08:00
Matthew Bucci
23da9c0dd2 Merge pull request #76 from PostgreSQL-For-Wordpress/mb-fix-auto-increment
Improve table creation
v3.2
2024-01-16 22:01:32 -08:00
Matthew Bucci
98bcd4aad0 improve performance of sequence lookup 2024-01-16 21:49:06 -08:00
Matthew Bucci
d45c7d58d9 Merge pull request #91 from PostgreSQL-For-Wordpress/fix-show-variables
correctly emulate Show Variables command in postgres
2024-01-16 21:41:30 -08:00
Matthew Bucci
487657a642 correctly emulate Show Variables command in postgres by using the pg_settings table 2024-01-16 21:38:24 -08:00
Matthew Bucci
66d8a3df0e update sequence handling to support bigserial and serial types 2024-01-16 21:35:32 -08:00
Matthew Bucci
ade3d6ad87 handle case with keys across multiple columns with defined lengths 2024-01-11 01:28:43 -08:00
Matthew Bucci
8f1f65db47 handle tables with fixed key lengths 2024-01-11 01:10:57 -08:00
mattbucci
a90ab01a9b handle table charsets 2024-01-08 05:08:57 +00:00