Sean Harvey
50f8ee7d6a
MINOR Renamed variables and keys to conincide with r98795
2010-02-11 09:59:52 +00:00
Sean Harvey
68757c72a6
FEATURE Added MSSQLDatabaseConfigurationHelper which is related to the installer
2010-02-11 07:38:10 +00:00
Sean Harvey
a2c2b3ebc0
BUGFIX Added MSSQLDatabase::set() - it doesn't do anything different to enum at the moment
2010-02-07 01:59:13 +00:00
Andreas Piening
6b82e2b1c2
MINOR: cast to datetime for higher precision
2010-02-04 04:53:25 +00:00
Sean Harvey
ab1b49fdf0
MINOR Removed query to enable fulltext each time MSSQLDatabase::createFullTextCatalog() was called - it's already enabled on databases where fulltext is supported
2010-02-03 08:24:33 +00:00
Sean Harvey
9bbe3603ee
BUGFIX Check value() return on MSSQLDatabase::fullTextEnabled()
2010-02-03 08:13:41 +00:00
Sean Harvey
adef3ced70
ENHANCEMENT Automatic checking of fulltext support by looking into the sys.databases table for MSSQLDatabase
2010-02-03 08:11:31 +00:00
Sean Harvey
7d67d25402
MINOR Changed MSSQLDatabase::now() block comment to be more useful
2010-02-03 07:53:08 +00:00
Sean Harvey
de7068d591
MINOR Removed redundant code from various MSSQLDatabase methods - it is now more inline with MySQLDatabase
2010-02-03 07:50:29 +00:00
Sean Harvey
b8b85a12a2
ENHANCEMENT MSSQLDatabase::decimal() field type now accepts user defined default values if it's available
2010-02-03 07:27:50 +00:00
Andreas Piening
9c1bda45ff
FEATURE: added datetime helper functions
2010-02-03 05:01:37 +00:00
Sean Harvey
27975ad20f
BUGFIX Fixed error when connecting to the database
2010-02-02 02:41:52 +00:00
Sean Harvey
6f42abda19
MINOR Fixed error
2010-02-02 02:34:40 +00:00
Sean Harvey
72a1381455
MINOR Changed the way MSSQLAzureDatabase connects
2010-02-02 02:30:50 +00:00
Sean Harvey
2a1cee6f3a
ENHANCEMENT Added MSSQLAzureDatabase->selectDatabase() support - it doesn't work the same way as SQL Server, we have to re-create the database connection
2010-02-02 02:19:43 +00:00
Sean Harvey
adb7369f5f
MINOR Removed MSSQLDatabase::$mssqlVersion - it's not used
2010-02-02 02:08:02 +00:00
Sean Harvey
4b3d185c67
FEATURE Added MSSQLAzureDatabase - subclass of MSSQLDatabase which has a different constructor for initialising the database specifically for SQL Azure
2010-02-01 23:26:22 +00:00
Sean Harvey
b8b44eaef5
BUGFIX Fixed proper checking of $this->fullTextIndexExists() when checking for indexes - NULL case means it's fulltext isn't enabled
...
ENHANCEMENT Support for only one active result set when building a SQL Server database
ENHANCEMENT Removed deprecated two-part syntax for DROP INDEX and used ON instead
2010-02-01 23:24:02 +00:00
Sean Harvey
b7f44bf043
MINOR Ease up restrictions of private variables and methods on MSSQLDatabase - this allows for a subclass for a more specific subset of SQL Server functionality
2010-02-01 21:45:01 +00:00
Sean Harvey
05d2831fb9
BUGFIX Fixed conflict of temp table creation between sites in MSSQLDatabase::createTable() by randomizing the table name
2009-12-15 00:58:58 +00:00
Sean Harvey
7e01c97e53
MINOR Use $this->query instead of DB::query() for instance MSSQLDatabase::createTable() temp table drop queries
2009-12-15 00:19:37 +00:00
Sean Harvey
6ae790f3a3
BUGFIX MSSQL stores temporary tables in the "tempdb" database, so special requirements are needed to make this work correctly with SapphireTest assumptions that this table exists in the same database as the project
2009-12-14 23:57:30 +00:00
Sean Harvey
6bfa6e9d0f
BUGFIX Make use of fulltextIndexExists() in MSSQLDatabase::getIndexSqlDefinition() instead of issuing it's own query to do so
2009-12-08 20:53:15 +00:00
Sean Harvey
3bba7b9ef1
ENHANCEMENT Added MSSQLDatabase::fulltextIndexExists() to check if an index exists before dropping it in MSSQLDatabase::alterTableAlterColumn()
...
BUGFIX Fixed alterting field types with a fulltext index on a table - an error would complain that a fulltext index exists, which needs to be dropped before the column can be altered
2009-12-07 05:38:26 +00:00
Sean Harvey
5bd3bcac67
BUGFIX Ensure that the ID is returned as a string when coming out of the database using the mssql_*() functions. This is NOT set to an integer, because there are many places in the sapphire framework that expect ID to be a string
2009-11-13 03:46:43 +00:00
Sean Harvey
7e45cfda78
ENHANCEMENT Support for Windows authentication for MSSQLDatabase - this is a more secure way of connecting to the database server, because a username and password is not required in the _ss_environment.php file
2009-11-12 09:23:46 +00:00
Sean Harvey
e4fe94aae3
BUGFIX If full text not enabled, return empty DataObjectSet in MSSQLDatabase::searchEngine() instead of null (undefined variable)
2009-10-27 07:08:51 +00:00
Sean Harvey
3e04b42048
MINOR Removed incorrect Exception thrown from MSSQLDatabase::searchEngine() - it should still carry on if there's no records anyway
2009-10-27 06:59:47 +00:00
Sean Harvey
1157f3e0db
ENHANCEMENT Added support for sqlsrv_num_rows in MSSQLQuery::numRecords() - this feature was added in version 1.1 of the sqlsrv driver
...
MINOR Documentation updates
2009-10-26 23:44:08 +00:00
Sean Harvey
2b7c27382d
MINOR Updated inaccurate documentation of methods due to class name changes in r90075
2009-10-26 21:16:37 +00:00
Sean Harvey
1f9af45389
BUGFIX Fixed incorrect method name ssdatetime due to changes in sapphre (r90075)
2009-10-26 21:12:42 +00:00
Sean Harvey
c751b64eab
API CHANGE MSSQLDatabase now extends from SS_Database and SS_Query due to changes in sapphire (r90075)
2009-10-26 20:59:29 +00:00
Sean Harvey
eb10888c08
BUGFIX MSSQLDatabase::getIndexSqlDefinition() - before trying to create an index that may exist, check if it exists and drop it if necessary
...
ENHANCEMENT Tidied up MSSQLDatabase::alterTable()
MINOR Code formatting fixes
2009-10-22 06:51:35 +00:00
Sean Harvey
edfa1dde19
MINOR Spelling mistake in class documentation for MSSQLDatabase
2009-10-22 04:02:40 +00:00
Sean Harvey
1ea7a2fec8
MINOR Class documentation for MSSQLDatabase
...
MINOR Code formatting cleanup for MSSQLDatabase::__destruct()
MINOR phpDoc for class variables
2009-10-22 04:01:17 +00:00
Mateusz Uzdowski
5eec769564
BUGFIX: disabling database connection reuse. This resulted in fail if two parallel connections to the same server were estabilished, each using different database. Second MSSQLDatabase object would change the DB also for the first one, resulting in invalid queries afterwards.
2009-10-15 22:04:55 +00:00
Sean Harvey
fe67223740
BUGFIX Added missing parameters to MSSQLDatabase::createTable() and MSSQLDatabase::alterTable() that were introuced in r88293
2009-10-14 05:51:43 +00:00
Geoff Munn
fb5dc5c298
API CHANGE: database extensions now supported by MSSQL
2009-10-11 22:04:24 +00:00
Geoff Munn
ad3c2d91be
API CHANGE: Transaction stubs created
2009-10-01 21:11:18 +00:00
Sean Harvey
91ee7ca80d
BUGFIX Added missing MSSQLDatabase::random() method
2009-09-17 07:07:02 +00:00
Andrew O'Neil
bdddbc61a5
BUGFIX: sqlserv crashes php if there are too many open handles - free the handle as soon as the end of the dataset is reached
2009-09-14 01:44:58 +00:00
Sam Minnee
ddbd0fda5d
Updated MSSQLDatabase and MSSQLQuery to suit r84061
2009-08-08 02:57:37 +00:00
Geoff Munn
396384e709
MINOR FIX: ID column protected against index and column alterations
2009-07-28 21:15:27 +00:00
Sean Harvey
82dcbb89d2
BUGFIX MSSQLDatabase::__destruct() should check if the db handle is a resource before attempting to close it, otherwise it'll give a warning about an invalid MSSQL link, when it should've said "unable to connect to server"
2009-07-28 04:07:42 +00:00
Sean Harvey
4c2cb7f3e9
BUGFIX MSSQLDatabase - fixed bigint broken on dev/build, it shouldn't have a column width
2009-07-28 03:48:52 +00:00
Sam Minnee
8e7516e537
BUGFIX: Fix the generation of fields to be more accurate, and detection of existing fields to be more accurate, so as not to run unnecessary field type change operations.
2009-07-27 22:39:57 +00:00
Sean Harvey
f555c3518f
MINOR Check for $this->mssql in MSSQLDatabase::__destruct()
...
MINOR Removed Debug from MSSQLQuery::__destruct()
MINOR Code formatting fixes in MSSQLQuery
2009-07-27 21:50:54 +00:00
Sean Harvey
915457b86b
BUGFIX Ensure that dbConn is a resource before attempting to close it
2009-07-23 04:45:16 +00:00
Sean Harvey
8b3f4f9963
MINOR phpDoc of MSSQLDatabase methods
2009-07-20 09:09:53 +00:00
Sean Harvey
b6a0c4f8a4
BUGFIX Ensure that the current DB connection is properly closed when scripts stop executing (applies to mssql_close and sqlsrv_close)
2009-07-20 07:23:38 +00:00
Sean Harvey
333ac5f26a
MINOR Removed unncessary whitespace from MSSQLDatabase and double up of phpDoc tags
2009-07-15 23:39:35 +00:00
Tom Rix
5293397e42
MINOR fix private static typo
2009-07-09 03:59:44 +00:00
Tom Rix
808f10e1d0
FEATURE function to strip SQL Server noise words from a full-text query.
2009-07-09 01:11:02 +00:00
Sean Harvey
f5d41cedfd
BUGFIX Fixed MSSQLDatabase::searchEngine() to search keywords properly by connecting them with AND to go in the CONTAINS() function
2009-07-07 05:38:16 +00:00
Andrew O'Neil
31cedd108b
BUGFIX: Fix times returned after midday being 12 hours early
2009-06-30 02:09:02 +00:00
Geoff Munn
c3a0542c66
MINOR FIX: 'DISTINCT' keyword must come before 'TOP'
2009-06-29 00:08:22 +00:00
Andrew O'Neil
0ec54f3359
Fix defaults
2009-06-25 02:27:02 +00:00
Tom Rix
2217918a2b
MINOR passing more unit tests with MSSQL Search
2009-06-23 00:20:39 +00:00
Sam Minnee
ff739d1786
BUGFIX: Remove an extraneous space from the generated queries so that SQLQueryTest passes
2009-06-16 05:32:31 +00:00
Sam Minnee
0585ef3908
BUGFIX: Fixed limit/offset code in MSSQL
2009-06-16 04:04:01 +00:00
Sam Minnee
bff10ffc99
BUGFIX: Refactored SQL generation so that limit/offset queries work
2009-06-16 02:51:42 +00:00
Sam Minnee
acc2d7f531
BUGFIX: Fixed MSSQLDatabase::dropDatabase()
2009-06-16 02:13:00 +00:00
Sean Harvey
efb03701ca
BUGFIX MSSQLDatabase::indexList() should always return an array, even if it's empty to be consistent with MSSQLDatabase::tableList()
2009-06-15 06:41:36 +00:00
Andrew O'Neil
4f1f1f9082
FEATURE: Add table renaming support
2009-06-15 01:34:22 +00:00
Sam Minnee
cedc941410
BUGFIX: Made MSSQLDatabase::EnumValuesFromConstraint more robust
2009-06-10 01:21:15 +00:00
Sam Minnee
7a1d6d7bcf
BUGFIX: Get MSSQL to handle the '## offset ##' style of limit value.
2009-06-08 03:45:54 +00:00
Tom Rix
58cca2dfeb
BUGFIX fixing the build, making the code happier
2009-06-05 04:37:45 +00:00
Tom Rix
3c1eed05ed
FEATURE Microsoft Sequel Server fulltext searching.
...
FEATURE sqlsrv_num_rows emulation (set $query->forceNumRows = true;)
2009-06-05 03:44:28 +00:00
Tom Rix
a2d2b73893
Better support for LIMIT, minimal support for OFFSET.
2009-06-04 03:02:35 +00:00
Sean Harvey
1290b0e4c7
BUGFIX Fixed undefined varible $dbname, this should have been $this->database instead
2009-06-03 23:35:24 +00:00
Tom Rix
39c250af7f
BUGFIX FEATURE semi-numRows support on SQLSRV
2009-06-02 22:32:45 +00:00
Tom Rix
ab245adc60
FEATURE semi-numRows support on SQLSRV
2009-06-02 21:01:15 +00:00
Tom Rix
f728294be2
BUGFIX error handling
2009-06-02 01:33:10 +00:00
Sam Minnee
3c00238cdf
ENHANCEMENT: Added support sqlsrv PHP module as well as the mssql PHP module.
2009-05-28 02:07:11 +00:00
Sean Harvey
ed19021ea0
MINOR Moved SET TEXTSIZE query into the else statement on MSSQLDatabase::__construct()
2009-05-27 00:51:47 +00:00
Sean Harvey
42d70770f0
BUGFIX Fixed SQL server case where text size limit for varchar and text was too small (probably imposed by FreeTDS) so we need to force a 2GB maximum
...
BUGFIX MSSQLDatabase::text() should return "varchar(max)" as text is deprecated (see http://msdn.microsoft.com/en-us/library/ms187993.aspx )
2009-05-27 00:50:48 +00:00
Sam Minnee
3abcfaf833
BUGFIX: Changed date type to use datetime internally, for MSSQL2005 support.
...
BUGFIX: Don't crash if the database doesn't exist yet.
2009-05-27 00:36:53 +00:00
Sam Minnee
a7328a7316
API CHANGE: Allow use of temporary option in MSSQLDatabase::createTable()
2009-05-21 05:10:46 +00:00
Ingo Schommer
b39b915a2f
BUGFIX Fixed MSSQLDatabase->createTable() definition to match changed parent (added $options parameter)
2009-05-19 20:33:11 +00:00
Geoff Munn
ee850f1a50
Default constraints removed
2009-05-19 02:24:27 +00:00
Geoff Munn
98bb7ef777
Default values changed to constraints, and Enum fields improved
2009-05-18 21:23:41 +00:00
Sean Harvey
d3eeee21e4
BUGFIX Allow null values for "time" to be consistent with datetime
2009-05-16 01:33:45 +00:00
Sean Harvey
2c193e51d3
BUGFIX Fixed bug where an empty query would break dev/build in MSSQLDatabase
2009-05-12 23:07:21 +00:00
Sam Minnee
87760aa5b3
ENCHANCEMENT: Added fullTextEnabled property to MSSQLDatabase object, to let developers completely disabled all fulltext functionality.
2009-05-08 03:37:31 +00:00
Sam Minnee
3fbf62c4cd
BUGFIX: Fixed field renaming in MSSQLDatabase.
...
ENHANCEMENT: Added MSSQLDatabase::fullTextSearchSQL() for generating full-text queries in an abstract fashion.
2009-05-07 06:32:08 +00:00
Sam Minnee
dc080b0e28
BUGFIX: Added default value to decimal field type.
...
ENHANCEMENT: Added MSSQL::allowPrimaryKeyEditing() method to access SET IDENTITY_INSERT method.
BUGFIX: Fix sort by RAND()
2009-05-07 05:55:05 +00:00
Geoff Munn
293b156cb7
BUGFIX: regex fixed
2009-05-07 04:55:09 +00:00
Sam Minnee
231696bb76
BUGFIX: Make database creation / deletion more robust so that test execution can work.
...
API CHANGE: Added MSSQLDatabase::clearTable()
BUGFIX: Get fulltext indexes being created more robustly.
2009-05-07 03:47:59 +00:00
Geoff Munn
703fde9fb5
BUG FIX: constraints fixed for very long constraint data
2009-05-06 00:02:43 +00:00
Geoff Munn
72e8d924e7
BUGFIX: default enum values now have single quotes
2009-04-29 22:49:48 +00:00
Sean Harvey
8b8dc91e7c
MINOR Set the database as active if changed the connection using selectDatabase()
2009-04-28 05:41:43 +00:00
Sean Harvey
0d1b808700
MINOR Code formatting fixes
2009-04-28 05:33:26 +00:00
Sean Harvey
874f28aa71
BUGFIX Removed MySQL specific stuff that was copied across on MSSQLDatabase
2009-04-28 05:13:23 +00:00
Geoff Munn
1964ac5907
Table alterations refactored
2009-04-21 23:14:43 +00:00
Geoff Munn
59d4622bc7
ALTER commands now work
2009-04-21 22:19:45 +00:00
Sean Harvey
c6c8a9a2a5
BUGFIX Fixed select database SQL statements that don't work because they were copied over as MySQL ones
...
MINOR phpDoc to MSSQLDatabase comments
2009-04-13 22:02:55 +00:00
Sean Harvey
0159e3c5fb
BUGFIX Fixed alterations to existing tables - SQL server requires a single "ADD" clause followed by a list of columns instead of individual ADD clauses.
2009-04-08 22:11:38 +00:00
Sean Harvey
87419c77f1
Removed echo statement
2009-04-08 05:10:12 +00:00
Geoff Munn
18789c5d84
sqlsrv instances removed
2009-04-07 02:57:16 +00:00
Geoff Munn
058466ea87
Sqlsrv now returns false
2009-04-06 23:08:08 +00:00
Geoff Munn
36c4145ffe
debug data enabled
2009-04-06 22:14:58 +00:00
Geoff Munn
881a602894
debug data enabled
2009-04-06 21:53:23 +00:00
Geoff Munn
b50f0baa6e
seek() function created for sqlsrv
2009-04-06 05:30:15 +00:00
Geoff Munn
a8650e3366
test function for MSSQL
2009-04-06 05:21:06 +00:00
Geoff Munn
a67b9a77f9
debug data enabled
2009-04-06 03:41:45 +00:00
Geoff Munn
25293f7f35
sqlsrv_query fixed
2009-04-06 03:16:35 +00:00
Geoff Munn
1aecbddb6e
SQL connection string fixed for IIS
2009-04-06 02:57:42 +00:00
Geoff Munn
20e4e95958
SQL connection string fixed for IIS
2009-04-06 02:57:01 +00:00
Geoff Munn
d8a04c98a1
sqlsrv detection improved
2009-04-06 02:42:58 +00:00
Geoff Munn
e1d9e6ba44
Page types now appear in the CMS dropdowns
2009-04-05 22:23:58 +00:00
Geoff Munn
6a9253430f
Alter tables function now supports constraints
2009-04-01 03:37:39 +00:00
Geoff Munn
1d06cfc10e
@@indentity changed to something a bit more stable
2009-03-30 03:06:25 +00:00
Geoff Munn
bb4acb78c8
MSSQL now works for GW on IIS
2009-03-29 21:43:48 +00:00
Geoff Munn
ebd9fa4671
MSSQL -> Sqlsrv swtich included
2009-03-29 21:33:52 +00:00
Geoff Munn
772fb23e22
MSSQL versions of MySQL commands implemented
2009-03-29 21:28:55 +00:00
Geoff Munn
8b6e13a823
MSSQL enabled for GW metlink
2009-03-25 21:06:06 +00:00
Geoff Munn
5b5f43f905
Basic search functionality included
2009-03-24 22:07:47 +00:00
Sean Harvey
7c6c3166ee
BUGFIX Make use $this->database instead of $GLOBALS['database'] which doesn't always exist.
2009-03-23 01:21:28 +00:00
Sean Harvey
cf26621d57
MINOR Fixed PHP notices in MSSQLDatabase
2009-03-23 00:59:39 +00:00
Geoff Munn
b219062d4d
latest updates for MSSQL
2009-03-23 00:51:28 +00:00
Geoff Munn
6352ea3f18
Modify index function created
2009-03-17 19:27:15 +00:00
Geoff Munn
c1bbed165d
API CHANGE: Indexes and fulltext search now supported
2009-03-17 03:58:58 +00:00
Geoff Munn
4712fc4b92
API CHANGE: fields now detected properly upon dev/rebuild in MSSQL
2009-03-12 02:43:10 +00:00
Geoff Munn
c80d8faf92
API CHANGE: dates default to null
2009-03-11 23:04:01 +00:00
Geoff Munn
2666d961db
API CHANGE: changes needed to get /dev/build working
2009-03-11 21:47:06 +00:00
Sam Minnee
b55e15c4e4
Minor updates to MS SQL support
2009-03-10 01:19:46 +00:00
Sam Minnee
41c2cea173
Initial import of MS SQL module
2009-02-25 05:44:52 +00:00
