Commit Graph

  • 1327b9d82f add end to list of reserved keywords hotfix/add-end-to-reserved-keywords Matthew Bucci 2024-10-18 23:31:21 -07:00
  • 3af0cc5f51 set default schema when connecting feature/schema_name Matthew Bucci 2024-10-18 23:13:25 -07:00
  • 36726124a4 swap hardcoded public values for DB_SCHEMA constant Matthew Bucci 2024-10-18 23:07:05 -07:00
  • 102f7f3ffb correction to incrementing duplicates test hotfix/wp-statistics-compatibility Matthew Bucci 2024-10-18 22:52:37 -07:00
  • d1832ca99b add test for incrementing duplicates Matthew Bucci 2024-10-18 22:46:46 -07:00
  • 5d8407d244 add date casting examples Matthew Bucci 2024-10-18 22:41:40 -07:00
  • 129aa7f171 Merge pull request #135 from PostgreSQL-For-Wordpress/hotfix/handle-utc Matthew Bucci 2024-10-17 05:55:50 -04:00
  • a6765201ce rewrite utc timestamp requests hotfix/handle-utc Matthew Bucci 2024-10-17 02:54:44 -07:00
  • 9f33ebc14d Merge pull request #134 from PostgreSQL-For-Wordpress/hotfix/handle-regexp Matthew Bucci 2024-10-17 05:46:44 -04:00
  • d0eab624eb replace regexp with its postgres version Matthew Bucci 2024-10-17 02:45:32 -07:00
  • f03cc84142 Merge pull request #133 from PostgreSQL-For-Wordpress/hotfix/handle-zero-int-addition-casting Matthew Bucci 2024-10-17 05:37:22 -04:00
  • 90d1c47695 cast numbers explictly as ints rather than adding 0 to them hotfix/handle-zero-int-addition-casting Matthew Bucci 2024-10-17 02:36:24 -07:00
  • 3de1eaae35 Merge pull request #132 from PostgreSQL-For-Wordpress/hotfix/primary_key_rewriting Matthew Bucci 2024-10-17 05:10:46 -04:00
  • 0873fdaf7c Merge pull request #131 from PostgreSQL-For-Wordpress/hotfix/numeric-rewriting v3.4.1 Matthew Bucci 2024-10-17 04:33:36 -04:00
  • 07b49dbb65 remove key names which are not supported during key creation in postgres hotfix/primary_key_rewriting Matthew Bucci 2024-10-17 01:31:06 -07:00
  • b463ead79f convert mediumints to ints Matthew Bucci 2024-10-17 01:25:16 -07:00
  • d46dba6148 numeric rewriting should be case insensitive Matthew Bucci 2024-10-17 01:18:11 -07:00
  • d8b83c88e2 Add newest WP version to tested list Matthew Bucci 2024-06-03 02:34:53 -07:00
  • 716db95999 Trying to fix BIGINT issues fix_capital_numeric_types 0xFEEDC0DE64 2024-04-10 20:20:06 +02:00
  • c7e3fbd50b Merge pull request #101 from PostgreSQL-For-Wordpress/returning-replaces-seq v3.4 v3 Matthew Bucci 2024-02-29 00:07:55 -08:00
  • 916950315f Merge remote-tracking branch 'origin/v3' into returning-replaces-seq Matthew Bucci 2024-02-29 00:07:13 -08:00
  • 6df70e35f2 Merge pull request #93 from PostgreSQL-For-Wordpress/rewrite-fixes Matthew Bucci 2024-02-29 00:04:36 -08:00
  • c47a610e24 Merge remote-tracking branch 'origin/rewrite-fixes' into rc-3.4 rc-3.4 Matthew Bucci 2024-02-28 17:53:11 -08:00
  • 28fb016969 update expected results for create table tests with protected names Matthew Bucci 2024-02-27 00:58:58 -08:00
  • b7be1aa89a add rewriting for protected column names Matthew Bucci 2024-02-27 00:53:05 -08:00
  • 1b6ecce7d9 Merge remote-tracking branch 'origin/v3' into rewrite-fixes Matthew Bucci 2024-02-26 23:55:09 -08:00
  • a2e25163ff remove custom last_insert_ID logic Matthew Bucci 2024-02-26 23:47:53 -08:00
  • 2d5f178426 improve primary key detection to use first column found if no primary key found Matthew Bucci 2024-02-26 23:44:17 -08:00
  • b92d8dde92 append RETURNING * to REPLACE Commands Matthew Bucci 2024-02-26 23:31:22 -08:00
  • 226ed1fc89 Merge pull request #107 from PostgreSQL-For-Wordpress/fix-site-editor v3.3.1 Matthew Bucci 2024-02-26 23:16:43 -08:00
  • 6149c2f234 remove uncessary insert regex which modified (0 to ("0", Matthew Bucci 2024-02-26 23:15:24 -08:00
  • 10d8047776 Merge branch 'returning-replaces-seq' into rc-3.4 Matthew Bucci 2024-02-26 16:30:07 -08:00
  • ed7cbf106c correct the REGEX for returning statements to account for backticks around table name Matthew Bucci 2024-02-26 16:29:49 -08:00
  • cf88b4d075 formatting Matthew Bucci 2024-02-26 16:15:07 -08:00
  • f602b49a5b Merge remote-tracking branch 'origin/returning-replaces-seq' into v3.4 Matthew Bucci 2024-02-26 16:14:43 -08:00
  • 2adacb53aa Merge remote-tracking branch 'origin/rewrite-fixes' into v3.4 Matthew Bucci 2024-02-26 16:08:00 -08:00
  • d66df1d283 add pull request template Matthew Bucci 2024-02-26 13:24:33 -08:00
  • 052f6cc978 Update issue templates Matthew Bucci 2024-02-26 13:22:15 -08:00
  • e9c35a4294 Update issue templates Matthew Bucci 2024-02-26 13:21:25 -08:00
  • 8de18593da Updated tested versions Matthew Bucci 2024-02-26 12:47:54 -08:00
  • ab2809d28a Merge pull request #100 from PostgreSQL-For-Wordpress/site-health v3.3 Matthew Bucci 2024-02-26 12:31:34 -08:00
  • 66cd2fb034 Merge branch 'v3' into site-health Matthew Bucci 2024-02-26 12:30:31 -08:00
  • a5480c70cb quote any variable usages in SQL Matthew Bucci 2024-02-26 12:27:23 -08:00
  • cdd38f6dfe Merge pull request #102 from PostgreSQL-For-Wordpress/wordpress-search rc-3.3 Matthew Bucci 2024-02-26 12:25:19 -08:00
  • 9373b914c2 Merge pull request #103 from PostgreSQL-For-Wordpress/replace-support Matthew Bucci 2024-02-26 12:24:54 -08:00
  • 15bdebed5e Merge pull request #104 from PostgreSQL-For-Wordpress/robust-numeric Matthew Bucci 2024-02-26 12:21:25 -08:00
  • b44dd00ec2 make numeric rewriters generic Matthew Bucci 2024-02-22 19:33:03 -08:00
  • b33aa78976 add support for REPLACE INTO rewriting Matthew Bucci 2024-02-22 19:11:41 -08:00
  • 315823a203 adjust Select rewriter to handle order by case statements Matthew Bucci 2024-02-22 00:49:48 -08:00
  • 8d420dca52 replace calls to seq by adding a RETURNING * to all insert statements Matthew Bucci 2024-02-21 20:08:57 -08:00
  • 61cfa6896d extract public to schema variable so we can use a constant later Matthew Bucci 2024-02-21 01:22:57 -08:00
  • ebbe2915c6 add rewrite logic for SHOW TABLE STATUS and a catch for calls to information_schema Matthew Bucci 2024-02-21 01:15:51 -08:00
  • b76a569a15 add test for single quotes Matthew Bucci 2024-02-21 01:12:35 -08:00
  • 0dd4213cfc handle Alter Table Add Index behavior Matthew Bucci 2024-01-16 22:45:28 -08:00
  • 0b09d08fb1 remove unncessary string replacement for != to <> Matthew Bucci 2024-01-16 22:17:07 -08:00
  • 23da9c0dd2 Merge pull request #76 from PostgreSQL-For-Wordpress/mb-fix-auto-increment v3.2 Matthew Bucci 2024-01-16 22:01:32 -08:00
  • 98bcd4aad0 improve performance of sequence lookup Matthew Bucci 2024-01-16 21:49:06 -08:00
  • d45c7d58d9 Merge pull request #91 from PostgreSQL-For-Wordpress/fix-show-variables Matthew Bucci 2024-01-16 21:41:30 -08:00
  • 487657a642 correctly emulate Show Variables command in postgres by using the pg_settings table Matthew Bucci 2024-01-16 21:38:24 -08:00
  • 66d8a3df0e update sequence handling to support bigserial and serial types Matthew Bucci 2024-01-16 21:35:32 -08:00
  • ade3d6ad87 handle case with keys across multiple columns with defined lengths Matthew Bucci 2024-01-11 01:28:43 -08:00
  • 8f1f65db47 handle tables with fixed key lengths Matthew Bucci 2024-01-11 01:10:57 -08:00
  • a90ab01a9b handle table charsets mattbucci 2024-01-08 05:08:57 +00:00
  • 53125aec2d Add support for keys with multiple values mattbucci 2024-01-08 05:00:42 +00:00
  • 5f27c893b3 Remove Default character set mattbucci 2024-01-08 04:22:59 +00:00
  • aca566b8bf pgrewrite should not remove IF NOT EXISTS mattbucci 2024-01-08 04:13:06 +00:00
  • 200dfaa0b2 Add space before replacements to avoid any issues with similar types mattbucci 2024-01-08 04:08:35 +00:00
  • 7471e353e9 Merge mattbucci 2024-01-08 01:15:25 +00:00
  • 30f5bee84b Merge remote-tracking branch 'origin/v3' into mb-fix-auto-increment mattbucci 2024-01-08 01:14:46 +00:00
  • 94259e408b style fixes mattbucci 2024-01-07 23:07:50 +00:00
  • 021aa6d106 Merge pull request #88 from LougaoCloud/v3 v3.1 Matthew Bucci 2023-12-31 00:34:27 -08:00
  • 1b08e302c0 bugfix: $dbname is not used in driver_pgsql.php laotoutou 2023-12-31 13:32:41 +08:00
  • c3c11a0640 correct mispellled word in readme Matthew Bucci 2023-12-17 01:25:29 -08:00
  • d7bf645504 handle regular key expressions Matthew Bucci 2023-11-26 15:24:45 -08:00
  • f3a71be3f0 handle unique keys Matthew Bucci 2023-11-26 15:17:26 -08:00
  • fd2467c00b switch to serial numeric types Matthew Bucci 2023-11-26 15:07:33 -08:00
  • cbd3d83918 postgres does support primary keys in the mysql format, we don't need to rewrite Matthew Bucci 2023-11-26 01:42:21 -08:00
  • 91f1612d10 add tests for table creation Matthew Bucci 2023-11-26 01:34:10 -08:00
  • a389cc7adc Update readme.md Matthew Bucci 2023-11-11 13:03:43 -08:00
  • bf2ef7f418 Merge pull request #55 from PostgreSQL-For-Wordpress/switch-to-mysqli v3.0 v4 Matthew Bucci 2023-11-10 11:25:48 -08:00
  • 3d164e15a6 remove the field function because it's already accounted for in the rewriter Matthew Bucci 2023-11-10 11:24:49 -08:00
  • 402d9cbb73 Update compatibility table Matthew Bucci 2023-11-10 11:23:15 -08:00
  • 2485f31cdc Change connections to pass by reference to better emulate the mysqli driver Matthew Bucci 2023-11-10 11:11:04 -08:00
  • 54b4ffb4df add connect error handling Matthew Bucci 2023-11-09 23:01:26 -08:00
  • 31ce063e06 ignore multi query as part of flush Matthew Bucci 2023-11-09 22:51:55 -08:00
  • 1f3692d4f9 implement pg_ping Matthew Bucci 2023-11-09 21:28:21 -08:00
  • 259a58b144 remove nonexistant PG_query mode Matthew Bucci 2023-11-09 21:24:38 -08:00
  • 20f0d7b9e9 driver fixes Matthew Bucci 2023-11-09 20:19:02 -08:00
  • eb3a4c1711 port over what exists from the old pgsql driver Matthew Bucci 2023-11-09 19:53:49 -08:00
  • 0761849977 add links Matthew Bucci 2023-11-09 18:05:52 -08:00
  • 5b73c978e7 give example use cases Matthew Bucci 2023-11-09 18:02:06 -08:00
  • b66d747b21 add a graphic explaining the design of pg4wp Matthew Bucci 2023-11-09 17:57:25 -08:00
  • 50db9c8fd8 rewrite mysql driver implementation to replace mysqli instead of mysql Matthew Bucci 2023-11-09 09:34:33 -08:00
  • e3f3682bc0 update wordpress dependency files for WP 6.4.1 Matthew Bucci 2023-11-08 22:48:27 -08:00
  • a810cfb7da cleanup AlterTableSQLRewriter v2 Matthew Bucci 2023-11-07 15:50:52 -08:00
  • 8a19f4c76d Merge pull request #53 from PostgreSQL-For-Wordpress/mb-fix-install v2.3 Matthew Bucci 2023-11-07 15:32:53 -08:00
  • ed00779cf5 add connection to pg_last_error call Matthew Bucci 2023-11-07 15:32:19 -08:00
  • dad1f0d264 formatting Matthew Bucci 2023-11-07 15:29:37 -08:00
  • c60d8f90b1 Migrate install rewriting to new rewriters Matthew Bucci 2023-11-07 15:26:03 -08:00
  • 3754ae32e4 Change plugin info Matthew Bucci 2023-10-30 22:15:04 -07:00