summaryrefslogtreecommitdiff
path: root/drivers/adodb-sqlite3.inc.php
AgeCommit message (Collapse)AuthorFilesLines
2025-08-03Refactor metaForeignKeys() methodDamien Regad1-19/+17
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
2025-08-03Ignore case when matching FOREIGN keywordDamien Regad1-1/+1
Fixes metaForeignKeys() method returning nothing when FOREIGN keyword was not given in upper case. Fixes #1078
2025-08-03Code cleanupDamien Regad1-74/+54
- Fix static analysis warnings - Remove useless code - Coding guidelines
2025-08-03Execute PRAGMA to retrieve PK after getting table infoDamien Regad1-25/+7
2025-08-03Remove unnecessary where clauseDamien Regad1-2/+1
According to SQLite schema documentation, the only valid values for *type* are 'table', 'index', 'view', or 'trigger' [1] so testing for `type != 'meta'` is useless. [1]: https://sqlite.org/schematab.html#interpretation_of_the_schema_table
2025-08-03Remove unnecessary subquery in metaForeignKeys()Damien Regad1-4/+1
2025-08-03Prevent SQL injection in sqlite3 driverDamien Regad1-22/+15
Use query parameters instead of injecting the table name in the SQL, in the following methods: - metaColumns() - metaForeignKeys() - metaIndexes() Thanks to Marco Nappi (@mrcnpp) for reporting this vulnerability. Fixes #1083, CVE-2025-54119, GHSA-vf2r-cxg9-p7rf
2025-03-22Fix SQLite error reportingraspopov1-7/+13
Without debug flag, the library returns '0' instead of error messages and correct SQLite error codes. Fixes #1061, PR #1062
2023-04-30Define ADOConnection::_query() methodDamien Regad1-1/+0
- Update child classes to be consistent with this declaration. - Remove unnecessary, non-PHPDoc comments - Consistent parameter names Fixes #966
2021-11-07Uniformize metaForeignKeys() function signatureDamien Regad1-1/+1
- public visibility - camelCase - change $owner default from false to '' - add $associative param where missing - PHPDoc updates
2021-11-07WhitespaceDamien Regad1-1/+1
2021-08-17Redo Merge branch 'hotfix/5.21' Standardized file headersDamien Regad1-17/+21
Try to do it right this time... # Conflicts: # adodb-memcache.lib.inc.php Fixes #751
2021-08-17Reset version to avoid merge conflictsDamien Regad1-1/+1
Fixes #751
2021-08-17Revert changes since Standardized file headers mergeDamien Regad1-45/+151
The conflicts resolution applied when merging the Standardized file headers (commit e9dcce3df24912ad869d0193f0b419f2309101fc) was seriously messed up, actually overwriting a number of changes in the master branch. Rather than trying to go and fix things one by one which has a high risk of messing things further, it's easier to redo the merge from a clean slate, so this commit reverts the following: - "Merge branch 'hotfix/5.21' Standardized file headers", e9dcce3df24912ad869d0193f0b419f2309101fc - "Merge tag 'v5.21.1'", 5f437df3104159d5d659f60e31bef8d33c34995f - "Reset version to 5.22.0-dev" af9234a525c3255af051a330164486d73be4c63a - "Fix incorrect resolution of merge conflicts" a6733f61b0165b366c8d2c70d9af82edc3881951. - "Fix syntax error in toexport.inc.php" 20b01e83cb61b6b2460f64c7d1277c5f4cc28574. Fixes #751
2021-08-14Standard file header: /driversDamien Regad1-17/+21
2021-04-11WhitespaceDamien Regad1-19/+19
2021-04-11Add stub for ADOConnection::_insertID()Damien Regad1-1/+1
Update child classes so method signature matches the parent's.
2021-03-08Bump version to 5.21.1-devDamien Regad1-1/+1
2021-02-27Bump version to 5.21.0v5.21.0Damien Regad1-1/+1
2021-02-02Bump version to 5.21.0-rc.1v5.21.0-rc.1Damien Regad1-1/+1
2021-01-24metaIndexes does not return primary key correctly, see #656 (#660)Mark Newnham1-8/+72
The primary key parameter was reversed . In addition, the method tried to obtain primary key information from the sqlite_master table, instead of the pragma (cherry picked from commit 45a1d6a567727a846fe2fa218c3f77dbc77464fc)
2020-12-20Bump version to 5.21.0-beta.1v5.21.0-beta.1Damien Regad1-1/+1
2020-12-19adodb.org is now served over SSLDamien Regad1-1/+1
Change web site references from http://adodb.org to https.
2019-12-30Provides Control of BLOB data dictionary featureMark Newnham1-0/+1
ADOdb automatically disallows setting of NOT NULL or DEFAULT values on blob type fields. This was due to historic limitations on data types that no longer exists. This commit takes the work done in PR #118 by @obmsch and adds the driver for SQLite. Fixes #292
2019-11-29Columns in SQLite metaindexes not reported correctly see #567Mark Newnham1-6/+3
The columns list in the metaindexes funtion in the SQLite driver was returned as a CSV list, not an array
2018-08-06Merge branch 'hotfix/5.20' (v5.20.13)Damien Regad1-1/+1
# Conflicts: # adodb-time.inc.php # docs/changelog.md # drivers/adodb-mssql.inc.php # drivers/adodb-mssqlnative.inc.php # drivers/adodb-oci8po.inc.php
2018-08-06Reset version to avoid merge conflictsDamien Regad1-1/+1
2018-08-06Bump version to 5.20.13v5.20.13Damien Regad1-1/+1
2018-08-06Replace adodb.sourceforge.net URLs by adodb.orgDamien Regad1-1/+1
2018-03-30Bump version to 5.20.12v5.20.12Damien Regad1-1/+1
2018-03-30Merge branch 'hotfix/5.20'Damien Regad1-0/+2
I messed up the merge at c350c007ed585a4da4dc8c62ae7954cfe13b621f. Not sure what I did or how, but the changes from the hotfix branch got lost. Redoing the merge to fix the problem.
2018-03-30Bump version to 5.20.11v5.20.11Damien Regad1-1/+1
2018-03-30Fix potential SQL injection in SelectLimit()Dave Paul1-0/+2
The `SelectLimit` function has a potential SQL injection vulnerability through the use of the `nrows` and `offset` parameters which are not forced to integers. This is a follow-up on #311, and fixes all remaining drivers that do not use ADOConnection::SelectLimit(). Fixes #401 Signed-off-by: Damien Regad <dregad@mantisbt.org> Original commits squashed, message reworded. Fixed whitespace.
2018-03-08Bump version to 5.20.10v5.20.10Damien Regad1-1/+1
2016-12-21Bump version to 5.20.9v5.20.9Damien Regad1-1/+1
2016-12-17Bump version to 5.20.8v5.20.8Damien Regad1-1/+1
2016-09-20Bump version to 5.20.7v5.20.7Damien Regad1-1/+1
2016-09-20Update changelogDamien Regad1-1/+1
2016-08-31Bump version to 5.20.6v5.20.6Damien Regad1-1/+1
2016-08-10Bump version to 5.20.5v5.20.5Damien Regad1-1/+1
2016-04-27WhitespaceDamien Regad1-19/+19
2016-04-27New helper methods: day(), month(), year()Mark Newnham1-1/+56
These new methods provide a simple shortcut to a timestamp field formatted with the following values: - Day as zero padded 2 digit number - Month as zero padded 2 digit number - Year as 4 digit number The methods are documented in the ADOdb reference manual. The sqlite version of these methods avoids the DST issue with sqlDate() by directly calling the native date functions instead of adodb_date(). Fixes #225
2016-03-30Bump version to 5.20.4Damien Regad1-1/+1
2016-02-04Sqlite Metatypes mapped incorrectly #177Mark Newnham1-0/+67
Sqlite datahases have very limited datatypes. The metaType function defaults to the standard version which is based on the mysql standards. The new driver specific version provides a metatype mapping based on the sqlite datatype affinities
2016-01-07Use PHPdoc blocks instead of block commentsDamien Regad1-3/+2
2016-01-07sqlite: Adds charmax() and textmax() methodsMark Newnham1-0/+23
Methods are added to both sqlite & sqlite3 driver. Fixes #183
2016-01-05sqlite: driver did not support metaForeignKeysMark Newnham1-0/+54
The metaForeignKeys() method was not available in the driver, so when request was made, it always returned false. Fixes #179
2016-01-02Update version 5.21.0-dev release year to 2016Damien Regad1-1/+1
2016-01-01Bump version to 5.20.3v5.20.3Damien Regad1-1/+1
2016-01-01metaIndexes does not work correctly with upper case table names. see ↵Mark Newnham1-1/+1
https://github.com/ADOdb/ADOdb/issues/176
generated by cgit v1.3 (git 2.53.0) at 2026-07-14 18:19:54 +0000