summaryrefslogtreecommitdiff
path: root/drivers/adodb-sqlite3.inc.php
AgeCommit message (Collapse)AuthorFilesLines
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
2015-12-27Update version to avoid merge conflictsDamien Regad1-1/+1
2015-12-27Bump version to 5.20.2v5.20.2Damien Regad1-1/+1
2015-12-16Remove useless constructorsDamien Regad1-4/+0
Fixes #171
2015-12-06Bump version to 5.20.1v5.20.1Damien Regad1-1/+1
2015-11-28Bump version to 5.21devDamien Regad1-1/+1
2015-11-28Bump version to 5.20.0v5.20.0Damien Regad1-1/+1
2015-11-26Adjust header comment blocksDamien Regad1-1/+3
- running SED script - manual adjustments for files not processed by regex
2015-09-14sqlite3 driver: use -1 for _numOfRowsAsheesh Laroia1-1/+0
This relies on the superclass's built-in default of $this->_numOfRows being set to -1. That causes the sqlite3 driver to rely on ADODB_COUNTRECS. Before this patch, we were setting _numOfRows to positive 1, which meant that any query that checked how many rows were available in a queryset would see literally the number 1, which was not accurate for queries that returned 0 rows or queries that returned more rows. In the case of sqlite3, there appears to be no efficient way to ask the PHP sqlite3 driver how many rows come back from a query, so relying on ADODB_COUNTRECS is the best we can do.
2015-08-11Fix#139: Remove PHP 4 ConstructorsValentin Sheyretski1-2/+2
This is the original commit from @valioz, rebased on latest master Signed-off-by: Damien Regad <dregad@mantisbt.org> Conflicts: drivers/adodb-db2ora.inc.php drivers/adodb-mssqlpo.inc.php drivers/adodb-odbc_oracle.inc.php
2015-08-11Correct function declarations for strict standards. Fixes #142Andrew Nicols1-2/+2
2015-05-15sqlite3: Fix result-less SQL statements executed twiceDamien Regad1-2/+7
The sqlite3 driver relies on SQLite3::query to execute the statement, which returns an empty SQLite3Result while the ADOConnection::_Execute() method expects true for handling of result-less queries. This causes the query to be executed a second time when ADOdb initializes the recordset for what it wrongly assumes to be a SELECT statement. This also addresses the same behavior with the sqlite driver, but the fix was not tested as I don't have a sqlite 2 setup available. Fixes #99