Commit Graph

103 Commits

Author SHA1 Message Date
Mateusz U 6bb7d5a5f6 Merge pull request #7 from halkyon/close_conn_fix
BUG SQLite database connection not closed properly
2014-10-28 09:53:23 +13:00
Sean Harvey fde3834114 BUG SQLite database connection not closed properly
This was found when performing a load test using HHVM, the sqlite
connections weren't being closed properly so it would throw an
error "Too many open files..." after a number of concurrent
connections were opened.
2014-10-27 19:06:04 +13:00
Simon Welsh bd6bc17fc5 Don't test against unsupported core versions 2014-07-11 09:25:12 +10:00
Simon Welsh c30b79265c Create 1.3 branch for 3.0/.1 compat 2014-07-10 12:33:22 +10:00
Simon Welsh 400920f8de Merge pull request #4 from tractorcow/pulls/deprecate-memory
BUG Properly deprecate old 'memory' config setting
2014-03-06 10:50:50 +13:00
Damian Mooyman c8235c0f06 BUG Properly deprecate old 'memory' config setting 2014-03-06 10:40:14 +13:00
Ingo Schommer 0bd9ef2904 Travis support 2014-02-18 17:59:45 +13:00
Sean Harvey 0a00f5ca9c Cleaning up long line lengths in _config.php 2014-02-18 16:45:59 +13:00
Sean Harvey 69fee85469 Change database path to allow use of ":memory:"
Instead of using a custom "memory" key in the $databaseConfig
which never really got used this now allows someone to simply enable
in-memory databases by setting the path to ":memory:" or to use the
following environment variable:

define('SS_SQLITE_DATABASE_PATH', ':memory:');
2014-02-18 16:44:00 +13:00
Simon Welsh 7a11b353d7 Create LICENSE 2013-09-02 21:20:35 +12:00
Ingo Schommer 3766c67a17 Clarified config settings 2013-04-01 21:24:29 +03:00
Ingo Schommer 06f2559050 Defaulting to memory DB if 'path' not specified
Given that we're only using SQLite3 for testing, this is a
reasonable default - and it means we don't need to have a
special _config.php for CI.
2013-03-28 23:02:41 +01:00
Ingo Schommer 589c35dfdb Defaulting to memory DB if 'path' not specified
Given that we're only using SQLite3 for testing, this is a
reasonable default - and it means we don't need to have a
special _config.php for CI.
2013-03-28 21:01:55 +01:00
Simon Welsh 7e02ff12ea Merge pull request #2 from ss23/patch-1
Update SQLiteDatabaseConfigurationHelper.php
2013-03-24 03:05:23 -07:00
Stephen Shkardoon 5e82d842ad Update SQLiteDatabaseConfigurationHelper.php
In preparation for https://github.com/silverstripe/sapphire/pull/1319
Probably should accept this at the same time.

If someone knows of the relevant ALTER permissions in SQLite, feel free to implement.
2013-03-24 03:31:09 +13:00
Ingo Schommer 426b669233 Minor typos in README 2013-03-15 09:50:53 +01:00
Ingo Schommer 069ed7ff52 BUG Normalize index specs to avoid false positives on schema regen 2012-12-11 14:40:49 +01:00
Ingo Schommer 36f15a52b4 BUG Using GLOB for case sensitive matches in SQLite3
As opposed to LIKE, the GLOB operator is case sensitive by default
in SQlite3. It uses "*" instead of "%" for wildcards,
which necessitated a new SearchFilter->getWildcard() method.

SQlite3 doesn't support per-term modifiers,
COLLATE BINARY LIKE is case insensitive by default
unless the field collation is set up accordingly.
There's connection-level modifiers (PRAGMA case_sensitive_like = true),
but that would affect all comparisators in the executed query.
2012-12-11 01:43:37 +01:00
Ingo Schommer 96fdd9178a BUG Removed MetaTitle and MetaKeywords cols from search engine
They have been removed from core in the 3.1 release line.
2012-12-10 23:38:35 +01:00
Sam Minnee faa611172f Added composer config 2012-11-03 14:28:55 +13:00
Normann Lou 1df648f6bb MINOR: use framework to replace sapphire for inline document. 2012-07-16 14:53:17 +12:00
Normann Lou 583e88b571 MINOR: use framework to replace sapphire for inline document. 2012-07-16 14:45:36 +12:00
Ingo Schommer 66ec67f838 Updated compat in README 2012-07-06 15:57:01 +02:00
Ingo Schommer 7c9156ebaf BUG Ignore col quotes in renameTable() 2012-07-06 14:05:59 +02:00
Ingo Schommer 356872236a Added supportsTimezoneOverride() method 2012-07-06 11:37:11 +02:00
Ingo Schommer 5594036d0c BUGFIX: indexList() returns indexes escaped by double quotes
See a1e7c1f9b in framework for same commit related to MySQLDatabase.
2012-07-05 15:08:01 +02:00
Ingo Schommer 14601368b8 API Don't run in-memory by default.
While the SQLite3 module is predominantly used for testing,
its best to leave this decision to the code using it.
We should default to a conservative setting (slower, but persistent).
Also remove coupling to SapphireTest when setting this value.
Don't bother creating the directory if running in-memory.
2012-07-05 13:43:46 +02:00
Ingo Schommer 7061e7a7c6 BUG Allow backslashes in fieldList() for namespaced classes 2012-07-05 12:16:20 +02:00
Sean Harvey 9502c7d5a5 MINOR Remove useless comment about another database 2012-06-12 14:41:18 +12:00
Sean Harvey 43433fbe46 BUGFIX Updating SQLite3Database::searchEngine() for SS3 2012-05-08 15:19:28 +12:00
Sean Harvey ecda380925 ENHANCEMENT Use simpler query syntax for SS3 2012-05-04 10:02:00 +12:00
Sean Harvey e9edf8b381 MINOR Removing sqlQueryToString as it's not required anymore in SS 3.0, SQLQuery does all the work for us instead. 2012-05-01 12:12:25 +12:00
Sean Harvey 932ffec5b6 BUGFIX Fixing support for SS 3.0 2012-05-01 11:27:22 +12:00
Sean Harvey 9dfebd8732 MINOR Fixing undefined variable 2012-04-30 11:18:52 +12:00
Sam Minnee bac4aac13f BUGFIX: Updated sqlite3 module to work in SS3 while still supporting SS2.4. 2011-12-17 12:05:42 +13:00
Ingo Schommer 61820b08de MINOR Using new PaginatedList API in searchEngine() (if available) 2011-10-07 11:30:27 +02:00
Ingo Schommer 294c0d5c6d Merge remote-tracking branch 'smindel/master' 2011-09-15 16:06:00 +02:00
Ingo Schommer 1b36c75f0a ENHANCEMENT Optionally filtering by new File.ShowInSearch flag in SQLite3Database->searcnEngine() 2011-09-15 16:03:03 +02:00
Ingo Schommer 2e1dc517e6 BUGFIX Allow omitting FROM clause in sqlQueryToString() 2011-05-19 11:36:39 +12:00
Ingo Schommer 0dfbf538b6 BUGFIX Fixed supportsTransactions() to use version_compare() so it doesn't break on non-scalar versions like '3.7.1' 2011-04-06 14:12:47 +02:00
Ingo Schommer f7fd2d46da BUGFIX Fixed supportsTransactions() to use version_compare() so it doesn't break on non-scalar versions like '3.7.1' 2011-04-06 22:39:57 +12:00
Stig Lindqvist b65482f8d1 Added missing method clear_cached_fieldlist existing in tests and at least in MySQLDatabase 2011-03-28 13:18:35 +02:00
Ingo Schommer a4f4d14eb9 API CHANGE Renamed transactions methods from endTransaction() to transactionEnd(), startTransaction() to transactionStart() to comply with new sapphire trunk API 2011-03-28 12:22:00 +02:00
Ingo Schommer 7205a9861f API CHANGE Renamed transactions methods from endTransaction() to transactionEnd(), startTransaction() to transactionStart() to comply with new sapphire trunk API 2011-03-11 16:37:22 +13:00
Andreas Piening 7f2718cfea Updated and renamed README 2011-01-17 13:14:30 +13:00
Andreas Piening b0cba1f81b MINOR: created new release 2011-01-16 23:50:04 +00:00
Andreas Piening 9445be1802 MINOR: created branch 1.1 2011-01-16 23:49:13 +00:00
Andreas Piening a2b2b116f5 MINOR: fix case in tablelist() returned array index 2010-12-16 02:54:04 +00:00
Sean Harvey d1a024d7b1 BUGFIX Renamed SQLite3Query::destroy() renamed to destruct() so that it is called properly after the object is destroyed 2010-10-14 05:07:55 +00:00
Sean Harvey 290250b1ec MINOR SQLite3Database no longer shows an alteration message on dev/build with SQLite version. This is already done in r111851 2010-10-12 01:50:12 +00:00