adodb/drivers/adodb-sqlite3.inc.php, branch master

Coding guidelines

2025-08-18T16:52:58Z

sqlite: Fix SQLDate() method

2025-08-18T16:52:58Z

ADOdb date/time library was removed in #970. Follow-up PR #1002 replaced legacy adodb_date()/adodb_date2() calls through custom functions, by native strftime(). That introduced a regression in SQLDate() behavior, as the date formats changed from PHP-style to strftime (e.g. `Ymd` -> `%Y%m%d`). This commit partially reverts 4700171afa6c5f939e8d04b079331e207dea22ca and reintroduces the createFunction() call with a closure providing behavior compatible with the legacy adodb_date2() function. It also removes the now-useless test script that was added as part of PR #1002.

PSR cleanup

2025-08-18T16:28:39Z

Changes the returned keys to lowercase if necessary

2025-08-18T16:27:03Z

Fixes #1090 Signed-off-by: Damien Regad The original commit was modified to remove the change of indentation from tab to space.

Added sqlite3 specific ifnull to driver

2025-08-12T01:42:15Z

Merge tag 'v5.22.10'

2025-08-03T16:26:39Z

# Conflicts: # adodb.inc.php # docs/changelog.md

Refactor metaForeignKeys() method

2025-08-03T16:05:05Z

Use a single, more advanced regex to parse the table SQL, allowing identification of foreign key definitions with a single pass, instead of several preg_split/preg_match calls. The new regex recognizes both column and table constraints, and allows composite keys too. Case conversion (when $upper parameter is true) is performed within the foreach loop that builds the return array, instead of calling array_change_key_case() at the end. Fixes #1078, #1079, #1080

Ignore case when matching FOREIGN keyword

2025-08-03T16:05:05Z

Fixes metaForeignKeys() method returning nothing when FOREIGN keyword was not given in upper case. Fixes #1078

Code cleanup

2025-08-03T16:05:05Z

- Fix static analysis warnings - Remove useless code - Coding guidelines

Execute PRAGMA to retrieve PK after getting table info

2025-08-03T16:05:05Z