Commit Graph

  • fc58ae6571 Removing redundant information from README Sean Harvey 2013-09-13 16:16:30 +1200
  • 988d36d0d3 Upping requirements to 3.0+ in latest version of the module. Sean Harvey 2013-09-13 16:10:35 +1200
  • 91a2a6ceb4 Merge branch '3.0-index-fixes' of git://github.com/tractorcow/silverstripe-mssql into tractorcow-3.0-index-fixes Sean Harvey 2013-09-13 15:15:10 +1200
  • 696c889fc1 Merge pull request #6 from ss23/patch-1 Sean Harvey 2013-06-20 20:04:47 -0700
  • 9aa62b6c20 Merge e500b024e3 into 01d376f501 Stephen Shkardoon 2013-06-20 20:04:12 -0700
  • 01d376f501 BUG Fixing problem where duplicate items appear on pages Sean Harvey 2013-05-27 15:21:24 +1200
  • 1560bad60c Free the result when at the end of a set using mssql drivers Sean Harvey 2013-05-22 22:38:05 +1200
  • 7119d5ac80 Merge pull request #11 from mattgunn/patch-1 Sean Harvey 2013-05-16 17:07:27 -0700
  • 19cac69300 Merge 13cdb07539 into 9ae0cecc36 Matt Gunn 2013-05-16 16:46:38 -0700
  • 13cdb07539 Removing paging subset occuring before pagination is set Matt Gunn 2013-05-17 11:45:15 +1200
  • 9ae0cecc36 Revert fc3df54eab Sean Harvey 2013-04-25 11:33:54 +1200
  • 55c56b9b66 default float spec to 53 so dev/build doesn't continually show as changed Sean Harvey 2013-04-25 11:28:05 +1200
  • fc3df54eab Removing dropping of indexes, has problems with running dev/build twice Sean Harvey 2013-04-05 17:23:13 +1300
  • e500b024e3 Update MSSQLDatabaseConfigurationHelper.php Stephen Shkardoon 2013-03-24 03:05:04 +1300
  • bd18c0a1f3 removing double up of quotes in getIndexSqlDefinition() Sean Harvey 2013-01-07 17:40:30 +1300
  • d6a075f9c7 Fixing MSSQLDatabase to conform to dev/build change detection Sean Harvey 2013-01-07 16:25:31 +1300
  • 61b27ce835 Added composer.json 0.8 Ingo Schommer 2013-01-03 21:42:05 +0100
  • 99bb016ede BUGFIX Includes all children of a class when building the query for SearchEngine, not only the ones that have a table in the db (ie if the Page class doesn't have a $db property, pages with this page type would be excluded from the search results) Jean-Fabien 2011-10-18 15:27:59 +1300
  • 91548f76be Checking for underscore in SortColumn just to be sure Sean Harvey 2012-12-20 16:04:44 +1300
  • 7c369a383a BUG Fix SortColumn ORDER BY not working when using a limit Sean Harvey 2012-12-20 15:56:11 +1300
  • baf3d39cc0 Adding location of known issues to README.md Sean Harvey 2012-12-19 20:56:41 +1300
  • e527665c5c Show the last error a bit more clearly if available Sean Harvey 2012-12-19 11:39:51 +1300
  • f64c662124 Tidying up error reporting in databaseError() and adding getLastError() Sean Harvey 2012-12-19 11:27:49 +1300
  • f34996ae1c BUG Remove "empty" keywords when building search SQL Sean Harvey 2012-12-19 11:19:21 +1300
  • d17ae37411 BUG Support for case sensitive searches Ingo Schommer 2012-12-11 01:47:35 +0100
  • 334c2634ac Removed deprecated transaction methods on MSSQLDatabase Sean Harvey 2012-11-16 14:25:13 +1300
  • 37b4005052 Added composer file Sam Minnee 2012-11-03 14:14:17 +1300
  • 8e99427195 Merge 93eab9c132 into 4de7829e4c Damian Mooyman 2012-09-23 21:47:46 -0700
  • 93eab9c132 FIXED: Repaired failing test cases (DataObjectSchemaGenerationTest) FIXED: Incorrect implementation of alterIndex UPDATED: Improved parsing of index specification by including code borrowed from the postgres database connector module. Possibly a candidate for refactor into SS_Database. Damian Mooyman 2012-09-24 15:36:59 +1200
  • e4bcc4e417 Merge bebd0ead8a into 4de7829e4c vikas srivastava 2012-09-22 14:13:33 -0700
  • bebd0ead8a New : Added composer.json Added composer.json file which will help this module for submission on proposed extension.silverstripe.org website. Please add more fields according to requirement. vikas srivastava 2012-09-22 19:28:54 +0530
  • 4de7829e4c Use more robust Format() in test instead of strtotime() Sean Harvey 2012-09-07 16:23:59 +1200
  • 08eea5cde3 Ensure date test is Y-m-d Sean Harvey 2012-09-07 16:21:13 +1200
  • 932db2f3a7 Merge a1184b5f6f into a74470ff52 Damian Mooyman 2012-09-05 16:10:35 -0700
  • 31ea9351e5 Merge 7d7654caa0 into a74470ff52 Damian Mooyman 2012-09-05 16:06:18 -0700
  • a74470ff52 Merge pull request #3 from silverstripe-rebelalliance/7813 0.9.7 Sean Harvey 2012-08-28 16:28:20 -0700
  • 472b6d3761 Merge 357482d6c9 into 530c97f671 kmayo-ss 2012-08-27 15:07:01 -0700
  • 357482d6c9 BUG: open ticket 7813 fixing dobule quoting issue in getIndexSqlDefinition Kirk Mayo 2012-08-27 15:05:37 +1200
  • a1184b5f6f FIXED: Paging issue in full text search results. Damian Mooyman 2012-08-24 16:10:05 +1200
  • 7d7654caa0 FIXED: Critical issue where index columns would be split apart and rejoined assuming they were not quoted. Already quoted columns would end up quad (dobule x double) quoted. Damian Mooyman 2012-08-24 12:28:28 +1200
  • 530c97f671 Added supportsTimezoneOverride() method Ingo Schommer 2012-07-06 11:35:58 +0200
  • e752144a6e Added Macports locations to README Ingo Schommer 2012-07-02 10:24:25 +0300
  • 05e706ea18 BUG: Fixed MSSQL index name generation for tables with \ in the name. 0.9.6 Sam Minnee 2012-06-26 14:52:18 +1200
  • 22d53b036b BUG: Fixed index generation to meet new SS3 expectations. Sam Minnee 2012-06-26 14:35:59 +1200
  • 0465f1b1a2 MINOR Performance optimisation in MSSQLDatabase::nextRecord() by building field meta-data only on construct of MSSQLQuery Sean Harvey 2012-06-12 13:31:29 +1200
  • a4c269bf62 BUGFIX Fixing date/datetime handling in MSSQLDatabase Sean Harvey 2012-06-12 12:55:27 +1200
  • 49625242c1 MINOR Updating README to include error message Sean Harvey 2012-06-12 10:05:40 +1200
  • 84ec3a2014 BUGFIX Fixed undefined notice regression Sean Harvey 2012-05-08 17:41:01 +1200
  • f1daa29592 BUGFIX Fixing MSSQLDatabase to work with latest SQLQuery changes in SS3 Sean Harvey 2012-05-07 16:40:09 +1200
  • 05d24b0843 BUGFIX Ensure DateTime objects are handled correctly Sean Harvey 2012-05-04 21:58:48 +1200
  • 30f017335b BUGFIX Fixing SS3 broken search, use simpler query syntax Sean Harvey 2012-05-03 14:33:17 +1200
  • 731874772c BUGFIX Fixing broken SS3 query code in MSSQLDatabase Sean Harvey 2012-05-03 12:01:50 +1200
  • a872e30256 BUGFIX Fixing database to use prepareWhere instead which is renamed Sean Harvey 2012-05-01 12:08:19 +1200
  • cb01716d39 BUGFIX Fixing order by fields for SS 3.0 in MSSQLDatabase::sqlQueryToString() Sean Harvey 2012-04-27 17:25:50 +1200
  • c7ae517c99 BUGFIX Fixed support for SS 3.0 with SQLQuery changes in 9938b64cf6ed0e05583633f1b894f89bd1e9f71f Sean Harvey 2012-04-27 17:16:51 +1200
  • b6082a023e ENHANCEMENT Use CONTAINSTABLE for fulltext searches, as it provides better fuzzy search results. Sean Harvey 2012-04-26 17:31:12 +1200
  • 375d440677 BUGFIX Ensure that values with unicode characters like macrons are saved to the database correctly. Overload the prepStringForDB() method and include an "N" prefix. Sean Harvey 2012-03-21 12:03:11 +1300
  • 4ae94d286f MINOR Tidy Sean Harvey 2012-03-05 18:31:04 +1300
  • cdf1c475a5 MINOR Cleaned up question on connecting with non-default instance name Sean Harvey 2012-03-05 18:28:39 +1300
  • e4349f83a6 MINOR Updated README on setting the server without adding more freetds entries Sean Harvey 2012-03-05 18:21:25 +1300
  • 2312b49b9c BUGFIX Fixes to searchEngine() to support SS 3.0 ORM changes Sean Harvey 2011-12-17 12:43:09 +1300
  • a9444a8313 MINOR Removed unused variables from MSSQLDatabase::alterTable() Sean Harvey 2011-10-13 14:13:33 +1300
  • 6cbe886a33 BUGFIX Fixed case where DROP FULLTEXT INDEX failed because it was being called twice, unncessarily. Do it once when altering a table structure. MINOR Cleanup of code in MSSQLDatabase Sean Harvey 2011-10-13 14:12:58 +1300
  • c1ba0fafc9 BUGFIX MSSQLDatabase::getIndexSqlDefinition() should check a primary key exists before trying to use an empty variable and causing dev/build failures Sean Harvey 2011-10-13 13:57:04 +1300
  • 4b933d7e73 ENHANCEMENT Optionally filtering by new File.ShowInSearch flag in MSSQLDatabase->searcnEngine() Ingo Schommer 2011-09-15 16:02:23 +0200
  • 00b81bbdd4 BUGFIX MSSQLDatabase::alterTableAlterColumn() creates ALTER COLUMN clauses twice in the same query for the same column unnecessarily Sean Harvey 2011-06-09 13:56:55 +1200
  • b772956ce8 BUGFIX Allow omitting FROM clause in sqlQueryToString() Ingo Schommer 2011-05-19 11:36:14 +1200
  • 6f5de764d2 API CHANGE Renamed transactions methods from endTransaction() to transactionEnd(), startTransaction() to transactionStart() to comply with new sapphire trunk API Ingo Schommer 2011-03-11 16:41:14 +1300
  • e15e444acc MINOR added link to extension page on silverstripe.org Sean Harvey 2011-02-23 11:03:26 +1300
  • 718de0b232 Fixed minor formatting issue Sean Harvey 2011-02-23 11:02:31 +1300
  • c8d1fbe03f MINOR Fixed formatting of troubleshooting section of README.md Sean Harvey 2011-02-23 11:00:01 +1300
  • ddd0794720 MINOR Migrated most of the content from http://doc.silverstripe.org/old/modules:mssql to README.md Sean Harvey 2011-02-23 10:58:38 +1300
  • 3542d25c4c MINOR Added short intro to mssql README.md file Sean Harvey 2011-02-23 10:37:41 +1300
  • 7ea6652e56 MINOR: MSSQL stub function created for Postgres-specific functionality Geoff Munn 2011-01-12 02:05:32 +0000
  • c104222019 MINOR Clean up code of MSSQLDatabase::addslashes() Sean Harvey 2010-12-15 23:18:27 +0000
  • bff9718dd6 MINOR: allow backslashes Andreas Piening 2010-12-15 21:48:05 +0000
  • 8f3b255c5e ENHANCEMENT Implemented MSSQLDatabase::allDatabaseNames() and MSSQLDatabase::dropDatabaseByName() so that dev/tests/cleanupdb will work on this database Sean Harvey 2010-11-04 22:06:29 +0000
  • 9e1cdc8cfa BUGFIX Ensure that Relevance field check in MSSQLDatabase::searchEngine() also checks for Relevance escaped in double quotes Sean Harvey 2010-11-01 03:20:52 +0000
  • 7b6899b3f0 MINOR Clearer documentation on MSSQLDatabase::getPrimaryKey() Sean Harvey 2010-10-20 03:21:54 +0000
  • 9a86a6d9a5 MINOR Update on compatibility of MSSQLAzureDatabase Sean Harvey 2010-10-20 03:17:19 +0000
  • 058c29bf69 ENHANCEMENT: allow custom columns in search, honour the classesToSearch, join all objects with base class, so we can query ClassName Mateusz Uzdowski 2010-10-20 00:52:44 +0000
  • e83c14236c MINOR: fixed case of tableList(), MINOR: added getIdentityColumn() Andreas Piening 2010-10-15 00:55:49 +0000
  • 247470ccc8 API CHANGE Removed MSSQLDatabase::getNextID() as this is deprecated MINOR Removed commented out code Sean Harvey 2010-10-15 00:25:29 +0000
  • ecea643f76 API CHANGE Renamed EnumValuesFromConstraint() to enumValuesFromCheckClause() as it's more specific to what the method is actually doing, which is parsing a constraint clause Sean Harvey 2010-10-14 22:36:55 +0000
  • 14cf1d243c ENHANCEMENT Performance improvements to MSSQLDatabase, mostly involves per-request caching of constraint check clauses since it's such an expensive query. Getting constraint names has been split out into a separate method, as it's a relatively cheap query to make without caching Sean Harvey 2010-10-14 21:11:20 +0000
  • ae1494c313 BUGFIX Renamed MSSQLQuery::destroy() renamed to destruct() so that it is called properly after the object is destroyed Sean Harvey 2010-10-14 05:03:01 +0000
  • 35d04ac387 MINOR Tidied up comments, added is_resource() check on MSSQLQuery::seek() to be consistent with the other methods Sean Harvey 2010-10-05 00:55:16 +0000
  • d2082107b5 API CHANGE Re-enabled transaction support in MSSQLDatabase transaction methods. TransactionTest appears to pass on sqlsrv and mssql now Sean Harvey 2010-10-02 03:36:04 +0000
  • e8ba221024 MINOR Reverted r111461, as it's not specific to SQL Server, but a framework level issue. FulltextSearchable decorator should be used instead to decorate existing SiteTree for example Sean Harvey 2010-10-02 01:59:20 +0000
  • 159dc13659 ENHANCEMENT: FTS now supports external tables to be specified as part of the value Geoff Munn 2010-09-30 23:58:21 +0000
  • ba4f843819 BUGFIX MSSQLDatabase::formattedDatetimeClause() should account for the timezone when returning a UNIX timestamp Sean Harvey 2010-09-29 10:10:51 +0000
  • 083517d02b MINOR Tidy up of code in MSSQLDatabase::__construct() Sean Harvey 2010-09-29 04:30:05 +0000
  • 75b1933ca3 BUGFIX #6042 Use single quotes for MSSQLDatabase::$noiseWords as some PHP versions/settings might have trouble with this (thanks mattclegg!) Sean Harvey 2010-09-28 19:44:08 +0000
  • 338cceeeab Created 0.9.5 release 0.9.5 Sean Harvey 2010-09-23 03:00:11 +0000
  • 27b44a3722 BUGFIX: numRecords not supported on sqlsrv, need to count manually Mateusz Uzdowski 2010-09-01 04:49:07 +0000
  • 2b5f25455f BUGFIX: limit the query results for pagination Mateusz Uzdowski 2010-09-01 04:06:36 +0000
  • 2aff1a9196 ENHANCEMENT: check for empty clause which will break the sql query Mateusz Uzdowski 2010-08-31 22:19:58 +0000
  • bef5b0ed05 BUGFIX: fix TranslatableSearchFormText by supporting fulltext search for MSSQL and using extendedSQL function call that augments queries properly (previously it was using DB::query which does not augment). Added wait to TranslatableSearchFormText so the test actually passes. Mateusz Uzdowski 2010-08-31 05:52:48 +0000
  • da356e5a01 BUGFIX: repair the transactions for sqlsrv driver on Windows. They are still not fully supported, so mark the driver as not supporting transactions. Mateusz Uzdowski 2010-08-31 03:18:00 +0000
  • d066f99d5e BUGFIX: re-enabling MARS, framework assumes it can run DB::query without fetching the results, which leaves the result set open and prohibits executing another query in the mean time Mateusz Uzdowski 2010-08-30 21:51:09 +0000