summaryrefslogtreecommitdiff
path: root/test/dialect/test_mssql.py
Commit message (Collapse)AuthorAgeFilesLines
...
* - MSSQL - the String/Unicode types, and their counterparts VARCHAR/Mike Bayer2010-12-161-7/+7
| | | | | | | NVARCHAR, emit "max" as the length when no length is specified. This makes it more compatible with Postgresql's VARCHAR type which is similarly unbounded when no length specified.
* - support for cdecimalMike Bayer2010-12-111-1/+1
| | | | | | | | | | | | | | | | | | - add --with-cdecimal flag to tests, monkeypatches cdecimal in - fix mssql/pyodbc.py to not use private '_int' accessor in decimal conversion routines - pyodbc version 2.1.8 is needed for cdecimal in any case as previous versions also called '_int', 2.1.8 adds the same string logic as our own dialect, so that logic is skipped for modern pyodbc version - make the imports for "Decimal" consistent across the whole lib. not sure yet how we should be importing "Decimal" or what the best way forward is that would allow a clean user-invoked swap of cdecimal; for now, added docs suggesting a global monkeypatch - the two decimal libs are not compatible with each other so any chance of mixing produces serious issues. adding adapters to DBAPIs tedious and adds in-python overhead. suggestions welcome on how we should be doing Decimal/cdecimal.
* - repair MS-SQL handling of LIMIT/OFFSET as binds, add bindparam() to the ↵Mike Bayer2010-11-291-0/+42
| | | | | | compile stream so they function correctly
* - move sqlalchemy.test to test.libMike Bayer2010-11-151-3/+3
|
* - mssql+pymssql dialect now honors the "port" portionMike Bayer2010-10-241-4/+22
| | | | | of the URL instead of discarding it. [ticket:1952] - testing.only_on() accepts db specs optionally as a list
* - Rewrote the reflection of indexes to use sys.Mike Bayer2010-10-231-17/+59
| | | | | | | catalogs, so that column names of any configuration (spaces, embedded commas, etc.) can be reflected. Note that reflection of indexes requires SQL Server 2005 or greater. [ticket:1770]
* - Fixed bug where aliasing of tables with "schema" wouldMike Bayer2010-10-201-2/+14
| | | | fail to compile properly. [ticket:1943]
* - Fixed MSSQL reflection bug which did not properly handleMike Bayer2010-10-161-2/+15
| | | | reflection of unknown types. [ticket:1946]
* test/dialectMike Bayer2010-07-111-350/+576
|
* - If server_version_info is outside the usualMike Bayer2010-07-021-1/+9
| | | | | | | range of (8, ), (9, ), (10, ), a warning is emitted which suggests checking that the FreeTDS version configuration is using 7.0 or 8.0, not 4.2. [ticket:1825]
* mssql+mxodbc should use executedirect for all selects and execute for ↵Mike Bayer2010-03-261-2/+1
| | | | insert/update/delete. To support this, an is_crud property has been added to the DefaultExecutionContext. The behavior is forcable either way per execution using execution_options(native_odbc_parameters=True|False). Some tests have been added to demonstrate usage. (patch by zzzeek committed by bradallen)
* try < 0Mike Bayer2010-03-191-1/+0
|
* just mark this test as crashing for nowMike Bayer2010-03-191-1/+2
|
* - the string approach appears to be necessary for large numbers, however.Mike Bayer2010-03-191-3/+3
| | | | Don't know how to get large decimals through to Sybase.
* Because of changes to SQLAlchemy bind parameter placement, removed all ↵Brad Allen2010-03-171-3/+0
| | | | mxodbc test disabling statements having this pattern: @testing.crashes('mssql+mxodbc', """Invalid bind parameter placement:
* Merged from main tip, and resolved conflicts in mxodbc dialect and connector.Brad Allen2010-03-171-9/+46
|\
| * - mxodbc can use default execute() callMike Bayer2010-03-161-9/+46
| | | | | | | | | | | | | | | | | | | | | | | | | | - modified SQLCompiler to support rendering of bind parameters as literal inline strings for specific sections, if specified by the compiler subclass, using either literal_binds=True passed to process() or any visit method, or by setting to False the "binds_in_columns_clause" flag for SQL-92 compatible columns clauses.. The compiler subclass is responsible for implementing the literal quoting function which should make use of the DBAPI's native capabilities. - SQLCompiler now passes **kw to most process() methods (should be all, ideally) so that literal_binds is propagated. - added some rudimentary tests for mxodbc.
* | Disabling tests for mssql+mxodbc where mxODBC cursor.execute chokes on ↵Brad Allen2010-03-161-1/+4
|/ | | | invalid placement of bind parameter "?" within the SQL statement.
* Added decorators to suppress unwanted warning messages during testing (not ↵Brad Allen2010-03-111-5/+5
| | | | working yet, but committed for review purposes).
* Improved the docstring of test_fetchid_triggerBrad Allen2010-03-091-11/+20
|
* Added docstring & comments explaining test_fetchid_triggerBrad Allen2010-03-081-1/+27
|
* some ms/odbc fixesMike Bayer2010-02-281-6/+11
|
* working on pyodbc / mxodbcMike Bayer2010-02-271-9/+15
|
* Match tests have been completely wrong.Michael Trier2010-02-261-2/+2
|
* Corrected a lot of mssql test issues related to Binary being deprecated and ↵Michael Trier2010-02-251-4/+4
| | | | replaced with LargeBinary.
* Copy paste fail.Michael Trier2010-02-251-0/+1
|
* Fixed binary tests for mssql based on how the new types are being used.Michael Trier2010-02-241-6/+13
|
* - The Boolean type, when used on a backend that doesn'tMike Bayer2009-12-061-1/+1
| | | | | | | | | | have native boolean support, will generate a CHECK constraint "col IN (0, 1)" along with the int/smallint- based column type. This can be switched off if desired with create_constraint=False. Note that MySQL has no native boolean *or* CHECK constraint support so this feature isn't available on that platform. [ticket:1589]
* Removed references to sequence in MSSQLMichael Trier2009-10-221-3/+4
| | | | | | | Implicit identities in mssql work the same as implicit sequences on any other dialects. Explicit sequences are enabled through the use of "default=Sequence()". See the MSSQL dialect documentation for more information.
* Corrected problem with a Trusted Connection under MSSQL 2008 native driver.Michael Trier2009-10-051-2/+2
|
* o don't need to str() Jython arrays twicePhilip Jenvey2009-09-121-7/+10
| | | | o map the Binary types w/ new str handling in mssql's BinaryTest.test_binary
* don't assume dict orderingPhilip Jenvey2009-09-111-1/+4
|
* clean up the way we detect MSSQL's form of RETURNINGMike Bayer2009-08-081-0/+14
|
* merge 0.6 series to trunk.Mike Bayer2009-08-061-245/+287
|
* Corrected problem with binary test on mssql. Still having issues with ↵Michael Trier2009-07-261-2/+2
| | | | prepared statements.
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-0/+1152
See README.unittests for information on how to run the tests. [ticket:970]
View Lorry Controller Status