summaryrefslogtreecommitdiff
path: root/test/dialect/mssql.py
Commit message (Collapse)AuthorAgeFilesLines
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-1146/+0
| | | | | See README.unittests for information on how to run the tests. [ticket:970]
* Added multi part schema name support. Closes #594 and #1341.Michael Trier2009-04-111-0/+24
|
* extract() is now dialect-sensitive and supports SQLite and others.Jason Kirtland2009-03-301-0/+8
|
* Added a few IDENTITY tests for mssql.Michael Trier2009-01-311-0/+55
|
* Trying one more time to get the decimal handling on mssql right. Closes #1282.Michael Trier2009-01-221-3/+8
|
* Restored convert_unicode handling on mssql. Fixes #1291.Michael Trier2009-01-221-0/+23
|
* Corrected handling of large decimal values on mssql. Added more robust tests.Michael Trier2009-01-171-17/+36
| | | | | | - Removed string manipulation on floats. Float types are now passed through to mssql as is. - Fixes #1280
* more session updatesMike Bayer2009-01-171-1/+1
|
* mssql date / time refactor.Michael Trier2009-01-051-1/+95
| | | | | | | - 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 an issue on mssql where Numerics would not accept an int.Michael Trier2009-01-031-2/+3
|
* Swap out text_as_varchar on the mssql dialect for the Types tests.Michael Trier2009-01-021-0/+6
|
* Added in MSGenericBinary to the mssql dialect tests.Michael Trier2008-12-291-4/+13
|
* Added in a new MSGenericBinary type.Michael Trier2008-12-281-2/+74
| | | | | | 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.
* On MSSQL if a field is part of the primary_key then it should not allow NULLS.Michael Trier2008-12-281-10/+7
|
* MSSQL refactoring of BINARY type and addition of MSVarBinary and MSImage.Michael Trier2008-12-281-4/+16
| | | | | | - Added in new types: MSVarBinary and MSImage - Modified MSBinary to now return BINARY instead of IMAGE. This is a backwards incompatible change. Closes #1249.
* Merge branch 'collation'Michael Trier2008-12-231-0/+314
|
* Major refactoring of the MSSQL dialect. Thanks zzzeek.Michael Trier2008-12-221-2/+60
| | | | | | 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.
* Support for three levels of column nullability: NULL, NOT NULL, and the ↵Michael Trier2008-12-121-0/+42
| | | | | | 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.
* Corrected mssql schema named subqueries from not properly aliasing the ↵Michael Trier2008-11-121-0/+3
| | | | columns. Fixes #973.
* Fixed E notation problem in mssql. Closes #1216.Michael Trier2008-11-081-0/+34
|
* Corrected a lot of mssql limit / offset issues. Also ensured that mssql uses ↵Michael Trier2008-11-081-22/+10
| | | | the IN / NOT IN syntax when using a binary expression with a subquery.
* - CompileTests run without the DBAPI being usedMike Bayer2008-10-231-1/+0
| | | | - added stack logic back to visit_compound(), pared down is_subquery
* Corrected missing declaration in the mssql dialect test.Michael Trier2008-10-211-0/+1
|
* Cleaned up the create_connect_args so that it makes no expectations about ↵Michael Trier2008-10-191-0/+16
| | | | keys. Fixes 1193. Added server version info into mssql pyodbc dialect.
* Removed the visit_function stuff in mssql dialect. Added some tests for the ↵Michael Trier2008-10-111-0/+4
| | | | function overrides. Fixed up the test_select in the sql/defaults.py tests which was a mess.
* 2.4 support !Mike Bayer2008-07-141-4/+5
|
* Added new basic match() operator that performs a full-text search. Supported ↵Michael Trier2008-07-131-0/+105
| | | | on PostgreSQL, SQLite, MySQL, MS-SQL, and Oracle backends.
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-2/+2
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* - merged -r4458:4466 of query_columns branchMike Bayer2008-04-071-5/+5
| | | | | | | - this branch changes query.values() to immediately return an iterator, adds a new "aliased" construct which will be the primary method to get at aliased columns when using values() - tentative ORM versions of _join and _outerjoin are not yet public, would like to integrate with Query better (work continues in the branch) - lots of fixes to expressions regarding cloning and correlation. Some apparent ORM bug-workarounds removed. - to fix a recursion issue with anonymous identifiers, bind parameters generated against columns now just use the name of the column instead of the tablename_columnname label (plus the unique integer counter). this way expensive recursive schemes aren't needed for the anon identifier logic. This, as usual, impacted a ton of compiler unit tests which needed a search-n-replace for the new bind names.
* some fixes to the MS-SQL aliasing so that result_map is properly populatedMike Bayer2008-04-021-0/+11
|
* fix up some unit testsMike Bayer2008-04-011-1/+1
|
* - updated the naming scheme of the base test classes in test/testlib/testing.py;Mike Bayer2008-02-111-4/+4
| | | | | tests extend from either TestBase or ORMTest, using additional mixins for special assertion methods as needed
* Fix: deletes with schemas on MSSQL 2000 [ticket:967]Paul Johnston2008-02-081-0/+18
|
* Fix some mssql unit testsPaul Johnston2008-02-081-0/+7
|
* - some consolidation of tests in select.py, movedMike Bayer2008-02-011-0/+33
| | | | | | | other tests to more specific modules - added "now()" as a generic function; on SQLite and Oracle compiles as "CURRENT_TIMESTAMP"; "now()" on all others [ticket:943]
* - testbase is gone, replaced by testenvJason Kirtland2008-01-121-15/+14
| | | | | | - Importing testenv has no side effects- explicit functions provide similar behavior to the old immediate behavior of testbase - testing.db has the configured db - Fixed up the perf/* scripts
* - Removed @testing.supported. Dialects in development or maintained outsideJason Kirtland2007-12-131-6/+135
| | | | | | | | | | | the tree can now run the full suite of tests out of the box. - Migrated most @supported to @fails_on, @fails_on_everything_but, or (last resort) @unsupported. @fails_on revealed a slew of bogus test skippage, which was corrected. - Added @fails_on_everything_but. Yes, the first usage *was* "fails_on_everything_but('postgres')". How did you guess! - Migrated @supported in dialect/* to the new test-class attribute __only_on__. - Test classes can also have __unsupported_on__ and __excluded_on__.
* changed the anonymous numbering scheme to be more appealingMike Bayer2007-12-081-2/+4
| | | | got tests running
* - generation of "unique" bind parameters has been simplified to use the sameMike Bayer2007-12-061-4/+4
| | | | | | | | | | "unique identifier" mechanisms as everything else. This doesn't affect user code, except any code that might have been hardcoded against the generated names. Generated bind params now have the form "<paramname>_<num>", whereas before only the second bind of the same name would have this form. - bindparam() objects themselves can be used as keys for execute(), i.e. statement.execute({bind1:'foo', bind2:'bar'})
* - basic framework for generic functions, [ticket:615]Mike Bayer2007-12-051-1/+1
| | | | | | | - changed the various "literal" generation functions to use an anonymous bind parameter. not much changes here except their labels now look like ":param_1", ":param_2" instead of ":literal" - from_obj keyword argument to select() can be a scalar or a list.
* un-screw up the attribute manager checkinMike Bayer2007-11-271-32/+0
|
* AttributeManager class and "cached" state removed....attribute listingMike Bayer2007-11-271-0/+32
| | | | is tracked from _sa_attrs class collection
* - MSSQL anonymous labels for selection of functions made deterministicMike Bayer2007-11-181-0/+9
| | | | - propagate correct **kwargs through mssql methods
* change the in_ API to accept a sequence or a selectable [ticket:750]Ants Aasma2007-10-161-2/+2
|
* - omitted 'table' and 'column' from 'from sqlalchemy import *'Jason Kirtland2007-08-211-0/+1
| | | | | | | - also omitted all modules and classes that aren't expicitly public - omitted 'Smallinteger' (small i), but it's still in schema - omitted NullType-related items from types.__all__ - patched up a few tests to use sql.table and sql.column, other related.
* fix line ending svn propJason Kirtland2007-08-211-47/+47
|
* - generalized a SQLCompileTest out of select.py, installedMike Bayer2007-08-131-16/+7
| | | | | into dialect/mssql.py, dialect/oracle.py, sql/generative.py - fixed oracle issues [ticket:732], [ticket:733], [ticket:734]
* - got is_subquery() working in the case of compound selects, test for ms-sqlMike Bayer2007-08-121-2/+24
|
* - fixed compiler bug in mssqlMike Bayer2007-08-121-0/+34
- marked as unsupported for mssql all two-phase and nested transcation tests - marked as unsupported for mssql various transactional/session tests which require two connections looking at uncommitted/external data at the same time (ms-sql cant handle it) - put better explicit closeout step in unitofwork.py tests to appease ms-sqls hard locking
View Lorry Controller Status