Repository navigation

SQLite support via a MySQL parser - #9

Merged

aristath merged 109 commits into

mainfrom

lexer-translation

Feb 23, 2023

Merged

SQLite support via a MySQL parser#9
aristath merged 109 commits into
mainfrom
lexer-translation

Commits on Feb 8, 2023
- Draft lexer-based SQL translation layer
  adamziel
  committed
  2de6628
- Add a note about lexer
  adamziel
  committed
  46b0621
- Remove dev artifacts
  adamziel
  committed
  41ca55d
- Add support for more query types
  adamziel
  committed
  1d9c695
Commits on Feb 9, 2023
- phpcbf
  aristath
  committed
  39d0c89
- fix a fatal error
  aristath
  committed
  1fd0d14
- Add the standalone Lexer object
  aristath
  committed
  4b47e76
- Use constants & static vars from WP_SQLite_Lexer
  aristath
  committed
  53ee424
- WordPress Coding Standards
  aristath
  committed
  e8a1bc4
- no need for else after return
  aristath
  committed
  8fa6227
- Merged all the query translation logic into the Translator class
  adamziel
  committed
  b0e642a
- Bring over field_types_translation and mysql_php_date_formats to the translator class
  adamziel
  committed
  cbfe844
- minor tweaks
  aristath
  committed
  eb8e4de
- Consolidate the translation logic and sketch some unit tests
  adamziel
  committed
  dcf0243
- Converge all translators in the SQLiteTranslationResult class
  adamziel
  committed
  6317df8
- MVP WordPress integration – Installation, frontend, wp-admin seem to work on the surface!
  adamziel
  committed
  a6ec488
- Adjust a few details to get the unit suite to boot
  adamziel
  committed
  03390ad
Commits on Feb 10, 2023
- coding standards
  aristath
  committed
  c543d27
- bugfix
  aristath
  committed
  5e0afe8
- cleanup + restructure
  aristath
  committed
  30819c6
- add $options to consume_all
  aristath
  committed
  54ce5ef
- add some docs
  aristath
  committed
  86482b1
- Remove the WP_SQLite_Query object
  aristath
  committed
  38464ea
- Record num rows for insert queries
  adamziel
  committed
  8a795f6
- Support for TRANCATE queries
  adamziel
  committed
  6c6239e
- Use WP_SQLite_Translator::get_query_object instead of SQLiteQuery
  adamziel
  committed
  4ff78af
- Remove the WP_SQLite_Translation_Result class
  aristath
  committed
  5f7fb23
- Merge branch 'main' into lexer-translation
  aristath
  committed
  c998a3a
- Support more query types – WooCommerce is now installing and reporting all tables in tact
  adamziel
  committed
  b4ee88a
- Fix a typo
  adamziel
  committed
  6389246
- Implement REGEX via a PHP callback
  adamziel
  committed
  79a16a3
Commits on Feb 13, 2023
- Refactor the lexer
  aristath
  committed
  2d5a64b
Commits on Feb 14, 2023
- Documentation + Coding-standards + readability tweaks
  aristath
  committed
  d5961f7
- Remove parser dependency in CREATE TABLE queries
  adamziel
  committed
  fad76d7
Commits on Feb 15, 2023
- CS fixes & other small tweaks
  aristath
  committed
  1e1629d
- Add VARIABLES
  aristath
  committed
  345e643
Commits on Feb 16, 2023
Commits on Feb 17, 2023
- Support counting rows per table
  adamziel
  committed
  26faba7
- Crosscheck mode: Restore SQLite's Autoincreement values after rollback
  adamziel
  committed
  1651ea6
- Remove unused code
  adamziel
  committed
  7987cce
- Fix unit tests
  adamziel
  committed
  fe718f4
- Major API cleanup
  adamziel
  committed
  c9eeb76
- Plug in SQLite's regexp function, not regexpp
  adamziel
  committed
  250a21c
- API Cleanup
  adamziel
  committed
  4d864d3
- Resolve lexer bug where it doesn't correctly calculate the length of UTF8 string
  adamziel
  committed
  0749584
- Support compound ALTER queries
  adamziel
  committed
  444c5a8
- Remove the sql queries log
  adamziel
  committed
  58425bf
- Retry on SQLite BUSY error, stringify COUNT(*) results
  adamziel
  committed
  4bc8995
Commits on Feb 18, 2023
- Reverse the argument order in REGEXP handler and add unit tests
  adamziel
  committed
  e8b1a17
- Stringify fetch data
  adamziel
  committed
  5b6a0c3
- Fix a bug in the field() function implementation
  adamziel
  committed
  3bb4b9b
- Improve handling of YEAR(), MONTH(), etc
  adamziel
  committed
  582837e
- Translate DATE_ADD to DATETIME instead of DATE
  adamziel
  committed
  190d2bb
- Store the number of affected rows as an integer, not as a string
  adamziel
  committed
  ee5a9bb
- Migrate date handling to user defined functions
  adamziel
  committed
  60f76ac
- Support case-insensitive text field lookups
  adamziel
  committed
  124df49
- Add geom data type support
  adamziel
  committed
  d33fd36
- Support for MySQL data format with a timezone baked in
  adamziel
  committed
  4a1d62e
- Implement get_col_charset with a hardcoded utf8mb4 encoding
  adamziel
  committed
  4bf2135
- Support 24 hour format
  adamziel
  committed
  66fb606
- Support arbitrary ON DUPLICATE KEY queries
  adamziel
  committed
  a8d1cda
- Add support for REGEXP BINARY
  adamziel
  committed
  ab80f7b
- Support inserting "\f" and "\v" as a literal string, not as a form feed or vertical tab
  adamziel
  committed
  1ce224c
- Extend debug info in slqite pdo engine
  adamziel
  committed
  d5255de
- Support truncating invalid dates
  adamziel
  committed
  8ba62bb
- Support MySQL's WEEKDAY() function
  adamziel
  committed
  29d73e1
- Increase the quality of date support
  adamziel
  committed
  b7a8502
- Add support for date lookup based on comparing date_format() to floats
  adamziel
  committed
  e73c601
Commits on Feb 19, 2023
- Support for ON DUPLICATE KEY with a composite pk
  adamziel
  committed
  6954055
- Brush up compatibility with class wpdb
  adamziel
  committed
  dd9b222
- Improve readability of the console-logged errors during the test run
  adamziel
  committed
  2d20a2d
- Translate DESCRIBE queries
  adamziel
  committed
  6e012ce
Commits on Feb 20, 2023
- ALTER TABLE CHANGE COLUMN support
  adamziel
  committed
  db6e8b3
- Fix one last failing dbDelta test
  adamziel
  committed
  6ad37f1
- Migrate a number of SQLiteTranslator tests to SQLiteEngine tests
  adamziel
  committed
  bce3338
- Fix up dayofweek() return value
  adamziel
  committed
  c60a29f
- Add methods docs & fix coding-standards issues
  aristath
  committed
  1544eeb
- Support for SELECT FROM DUAL
  adamziel
  committed
  7bedd3f
Commits on Feb 21, 2023
- more docs & CS fixes
  aristath
  committed
  578a766
- Remove the PDO_Driver class
  aristath
  committed
  758a058
- moved files + CS/Docs fixes
  aristath
  committed
  77d8c85
- minor formatting tweaks
  aristath
  committed
  24eba06
- The sqlite_regexp method doesn't seem to be used anywhere
  aristath
  committed
  f1bcc08
- Add phpcs:ignore comments for builtin methods
  aristath
  committed
  adf1820
- Remove unused methods from the WP_SQLite_Tokens_List object
  aristath
  committed
  38b2804
- copy/paste error
  aristath
  committed
  ddc7b0c
- WP_SQLite_Tokens_List doesn't need to implement ArrayAccess
  aristath
  committed
  025b43a
- revert comments deletion
  aristath
  committed
  94f524a
- Docs fix - props @adamziel
  aristath
  committed
  d93383c
- Avoid using list() to assign vars
  aristath
  committed
  ee45851
- Inline the process_results() method of the SQLite engine class
  adamziel
  committed
  5297093
- Remove the private _results variable
  adamziel
  committed
  3efdc7c
- move require_once calls to db.php
  aristath
  committed
  6411003
- Merge remote-tracking branch 'WordPress/lexer-translation' into lexer-translation
  aristath
  committed
  fcd5a54
- CS
  aristath
  committed
  f93fb03
Commits on Feb 22, 2023
- add files to .gitattributes
  aristath
  committed
  dc18b26
- Merge PDO_Engine & Translator classes
  aristath
  committed
  203f0e8
- copy/paste error
  aristath
  committed
  a8dbf21
- Update wp-includes/sqlite/class-wp-sqlite-translator.php
  
  aristath
  and
  adamziel
  authored
  f5a6a5e
- Update wp-includes/sqlite/class-wp-sqlite-db.php
  
  aristath
  and
  adamziel
  authored
  c7fb01e
- fix comments formatting
  aristath
  committed
  11c3a9a
- Move files
  aristath
  committed
  12747f4
- Up the version & update the readme file
  aristath
  committed
  7e1af11
- Merge Tokens_List in Lexer
  aristath
  committed
  fd0cba9
Commits on Feb 23, 2023
- Simpler solution for WP_SQLite_Object_Array
  aristath
  committed
  7aa61de
- Add more keywords for MariaDB
  aristath
  committed
  3b9043d
- inline docs for crosscheck & cleanup
  aristath
  committed
  ecc760d

Commits

Commits on Feb 8, 2023

Commits on Feb 9, 2023

Commits on Feb 10, 2023

Commits on Feb 13, 2023

Commits on Feb 14, 2023

Commits on Feb 15, 2023

Commits on Feb 16, 2023

Commits on Feb 17, 2023

Commits on Feb 18, 2023

Commits on Feb 19, 2023

Commits on Feb 20, 2023

Commits on Feb 21, 2023

Commits on Feb 22, 2023

Commits on Feb 23, 2023