summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/mssql.py
Commit message (Collapse)AuthorAgeFilesLines
* merge 0.6 series to trunk.Mike Bayer2009-08-061-1771/+0
|
* Corrected annoying deprecation warning on 2.6+ related to mssql and the ↵Michael Trier2009-07-261-2/+2
| | | | __new__ calls.
* Modified savepoint logic in mssql to ensure that it does not step on ↵Michael Trier2009-04-281-8/+4
| | | | non-savepoint oriented routines. Savepoint support is still very experimental.
* Added in MSSQL reserved words list. Fixes #1310Michael Trier2009-04-121-2/+31
|
* Added multi part schema name support. Closes #594 and #1341.Michael Trier2009-04-111-0/+5
|
* extract() is now dialect-sensitive and supports SQLite and others.Jason Kirtland2009-03-301-0/+12
|
* Modified information_schema change to keep it backwards compatible.Michael Trier2009-03-291-12/+71
|
* Corrected problem with information schema not working with binary collation ↵Michael Trier2009-03-271-27/+17
| | | | on mssql. Fixes #1343.
* Corrected issue on mssql where max_identifier_length was not being respected.Michael Trier2009-02-181-1/+2
|
* Preliminary support for pymssql 1.0.1 [Ticket:1318]Rick Morrison2009-02-131-1/+8
|
* Correction to reflection fix r5718 to handle Binary / other numeric types.Michael Trier2009-01-231-2/+2
|
* mssql: modified table reflection code to use only kwargs when constructing ↵Rick Morrison2009-01-231-17/+13
| | | | coldefs.
* Trying one more time to get the decimal handling on mssql right. Closes #1282.Michael Trier2009-01-221-10/+28
|
* Restored convert_unicode handling on mssql. Fixes #1291.Michael Trier2009-01-221-3/+0
|
* Corrected handling of large decimal values on mssql. Added more robust tests.Michael Trier2009-01-171-25/+10
| | | | | | - Removed string manipulation on floats. Float types are now passed through to mssql as is. - Fixes #1280
* NotSupportedError is a DBAPI wrapper which takes four args and is expected ↵Mike Bayer2009-01-111-1/+1
| | | | | | to originate from the DBAPI layer. Moved those error throws to CompileError/InvalidRequestError.
* Corrected SAVEPOINT support on the adodbapi dialect by changing the handlingMichael Trier2009-01-111-3/+3
| | | | | | | of savepoint_release, which is unsupported on mssql. The way it was being discarded previously resulted in an empty execute being called on the dialect; adodbapi didn't like that much.
* Modified the do_begin handling in mssql to use the Cursor not the Connection.Michael Trier2009-01-111-2/+7
| | | | | | | This corrects a problem where we were trying to call execute on the Connection object instead of against the cursor. This is supported on pyodbc but not in the DBAPI. Overrode the behavior in pymssql to not do special do_begin processing on that dialect.
* Forgot to sqash a commit. Follow up on mssql dates refactoring.Michael Trier2009-01-051-8/+11
|
* mssql date / time refactor.Michael Trier2009-01-051-43/+91
| | | | | | | - Added new MSSmallDateTime, MSDateTime2, MSDateTimeOffset, MSTime types - Refactored the Date/Time types. The smalldatetime data type no longer truncates to a date only, and will now be mapped to the MSSmallDateTime type. Closes #1254.
* Corrected a few docs and didn't realize we put pyodbc first in the search list.Michael Trier2009-01-041-2/+11
|
* Corrected an issue on mssql where Numerics would not accept an int.Michael Trier2009-01-031-2/+4
|
* Added a note about mssql compatibility levels.Michael Trier2009-01-031-0/+11
|
* found some more _Function->FunctionMike Bayer2009-01-021-1/+1
|
* Marked mssql test as failing since it cannot update identity columns.Michael Trier2009-01-021-1/+0
|
* Mapped char_length to the LEN() function for mssql.Michael Trier2009-01-021-1/+2
|
* Added ability to use subselects within INSERTS on mssql.Michael Trier2009-01-021-0/+27
|
* Turned off the implicit transaction behavior of MSSQL.Michael Trier2009-01-021-0/+4
| | | | This corrects the savepoint tests.
* Cleanup of r5556. Makes the description_encoding less public since this is aMichael Trier2009-01-021-3/+4
| | | | workaround for the pyodbc dbapi.
* Modifications to the mssql dialect in order to to pass through unicode in ↵Michael Trier2008-12-301-37/+30
| | | | the pyodbc dialect.
* Added a new description_encoding attribute on the dialect.Michael Trier2008-12-301-6/+8
| | | | | This is used for encoding the column name when processing the metadata. This usually defaults to utf-8.
* - added another usage recipe for contains_eager()Mike Bayer2008-12-291-1/+1
| | | | - some typos
* Added in a new MSGenericBinary type.Michael Trier2008-12-281-4/+25
| | | | | | This maps to the Binary type so it can implement the specialized behavior of treating length specified types as fixed-width Binary types and non-length types as an unbound variable length Binary type.
* Corrected reflection issue in mssql where include_columns doesn't include ↵Michael Trier2008-12-281-2/+2
| | | | the PK.
* On MSSQL if a field is part of the primary_key then it should not allow NULLS.Michael Trier2008-12-281-1/+1
|
* MSSQL refactoring of BINARY type and addition of MSVarBinary and MSImage.Michael Trier2008-12-281-2/+19
| | | | | | - Added in new types: MSVarBinary and MSImage - Modified MSBinary to now return BINARY instead of IMAGE. This is a backwards incompatible change. Closes #1249.
* - Reflected foreign keys will properly locateMike Bayer2008-12-261-2/+2
| | | | | | | | | | | | | | | | | | | | | | | their referenced column, even if the column was given a "key" attribute different from the reflected name. This is achieved via a new flag on ForeignKey/ForeignKeyConstraint called "link_to_name", if True means the given name is the referred-to column's name, not its assigned key. [ticket:650] - removed column types from sqlite doc, we aren't going to list out "implementation" types since they aren't significant and are less present in 0.6 - mysql will report on missing reflected foreign key targets in the same way as other dialects (we can improve that to be immediate within reflecttable(), but it should be within ForeignKeyConstraint()). - postgres dialect can reflect table with an include_columns list that doesn't include one or more primary key columns
* Added MSSQL support for introspecting the default schema name for the logged ↵Michael Trier2008-12-231-0/+18
| | | | in user. Thanks Randall Smith. Fixes #1258.
* Merge branch 'collation'Michael Trier2008-12-231-28/+314
|
* Major refactoring of the MSSQL dialect. Thanks zzzeek.Michael Trier2008-12-221-197/+299
| | | | | | Includes simplifying the IDENTITY handling and the exception handling. Also includes a cleanup of the connection string handling for pyodbc to favor the DSN syntax.
* removed the "create_execution_context()" method from dialects and replacedMike Bayer2008-12-191-5/+2
| | | | with a more succinct "dialect.execution_ctx_cls" member
* *most* py3k warnings are resolved, with the exception of the various ↵Mike Bayer2008-12-181-1/+1
| | | | | | __setslice__ related warnings I don't really know how to get rid of
* Support for three levels of column nullability: NULL, NOT NULL, and the ↵Michael Trier2008-12-121-3/+19
| | | | | | database's configured default. The default Column configuration (nullable=True) will now generate NULL in the DDL. Previously no specification was emitted and the database default would take effect (usually NULL, but not always). To explicitly request the database default, configure columns with nullable=None and no specification will be emitted in DDL. Fixes #1243.
* We don't need two of these.Michael Trier2008-12-111-3/+0
|
* Implemented experimental savepoint support in mssql. There are still some ↵Michael Trier2008-12-111-0/+10
| | | | failing savepoint related tests.
* Pulled out values test that uses boolean evaluation in the SELECT in order ↵Michael Trier2008-11-141-3/+4
| | | | to appropriately flag it as not supported on mssql. I sure hope I didn't jack things up for other dialects. Cleaned up a comment and removed some commented pdb statements.
* Fixed a problem with the casting of a zero length type to a varchar. It now ↵Michael Trier2008-11-141-1/+1
| | | | correctly adjusts the CAST accordingly.
* The str(query) output is also correct on the mssql dialect.Michael Trier2008-11-141-1/+2
|
* Corrected mssql schema named subqueries from not properly aliasing the ↵Michael Trier2008-11-121-3/+4
| | | | columns. Fixes #973.
* Handle the mssql port properly. If we're using the SQL Server driver then ↵Michael Trier2008-11-101-3/+9
| | | | use the correct host,port syntax, otherwise use the Port= parameter in the connection string. Fixes #1192.