summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/mssql/base.py
Commit message (Collapse)AuthorAgeFilesLines
...
* | - [bug] removed legacy behavior wherebyMike Bayer2012-04-241-48/+1
| | | | | | | | | | | | | | | | | | | | a column comparison to a scalar SELECT via == would coerce to an IN with the SQL server dialect. This is implicit behavior which fails in other scenarios so is removed. Code which relies on this needs to be modified to use column.in_(select) explicitly. [ticket:2277]
* | - [bug] UPDATE..FROM syntax with SQL ServerMike Bayer2012-04-181-0/+16
| | | | | | | | | | | | | | | | | | | | requires that the updated table be present in the FROM clause when an alias of that table is also present in the FROM clause. The updated table is now always present in the FROM, when FROM is present in the first place. Courtesy sayap. [ticket:2468]
* | - [bug] Repaired the use_scope_identityMike Bayer2012-04-051-10/+15
|/ | | | | | | | | | create_engine() flag when using the pyodbc dialect. Previously this flag would be ignored if set to False. When set to False, you'll get "SELECT @@identity" after each INSERT to get at the last inserted ID, for those tables which have "implicit_returning" set to False.
* typoes in lib/sqlalchemy/dialectsDiana Clarke2012-03-171-2/+2
|
* - [feature] Added support for MSSQL INSERT,Mike Bayer2012-03-131-0/+3
| | | | | | UPDATE, and DELETE table hints, using new with_hint() method on UpdateBase. [ticket:2430]
* - [feature] Added cte() method to Query,Mike Bayer2012-03-031-0/+7
| | | | | | | | | | | | invokes common table expression support from the Core (see below). [ticket:1859] - [feature] Added support for SQL standard common table expressions (CTE), allowing SELECT objects as the CTE source (DML not yet supported). This is invoked via the cte() method on any select() construct. [ticket:1859]
* - [feature] Dialect-specific compilers now raiseMike Bayer2012-01-281-2/+2
| | | | | | | | CompileException for all type/statement compilation issues, instead of InvalidRequestError or ArgumentError. The DDL for CREATE TABLE will re-raise CompileExceptions to include table/column information for the problematic column. [ticket:2361]
* - [bug] Adjusted the regexp used in theMike Bayer2012-01-221-1/+1
| | | | | | | | | | mssql.TIME type to ensure only six digits are received for the "microseconds" portion of the value, which is expected by Python's datetime.time(). Note that support for sending microseconds doesn't seem to be possible yet with pyodbc at least. [ticket:2340]
* happy new yearMike Bayer2012-01-041-1/+1
|
* - enable SAVEPOINT support fully, remove warning, [ticket:822].Mike Bayer2011-12-061-3/+6
| | | | It's not known what the potential "data loss" issues are, tests seem to pass.
* - [bug] Decode incoming values when retrievingMike Bayer2011-12-061-2/+9
| | | | | | | list of index names and the names of columns within those indexes. [ticket:2269] - rewrite unicode reflection test to be of more general use on broken backends
* - [bug] don't cast "table name" as NVARCHARMike Bayer2011-12-061-1/+7
| | | | | | | on SQL Server 2000. Still mostly in the dark what incantations are needed to make PyODBC work fully with FreeTDS 0.91 here, however. [ticket:2343]
* - [bug] repaired the with_hint() feature whichMike Bayer2011-12-031-2/+1
| | | | | | | | wasn't implemented correctly on MSSQL - usually used for the "WITH (NOLOCK)" hint (which you shouldn't be using anyway ! use snapshot isolation instead :) ) [ticket:2336]
* - The behavior of =/!= when comparing a scalar selectMike Bayer2011-09-231-1/+28
| | | | | | | | | | | to a value will no longer produce IN/NOT IN as of 0.8; this behavior is a little too heavy handed (use in_() if you want to emit IN) and now emits a deprecation warning. To get the 0.8 behavior immediately and remove the warning, a compiler recipe is given at http://www.sqlalchemy.org/docs/07/dialects/mssql.html#scalar-select-comparisons to override the behavior of visit_binary(). [ticket:2277]
* - Changes to attempt support of FreeTDS 0.91 withMike Bayer2011-09-181-4/+3
| | | | | | | | | | | | | Pyodbc. This includes that string binds are sent as Python unicode objects when FreeTDS 0.91 is detected, and a CAST(? AS NVARCHAR) is used when we detect for a table. However, I'd continue to characterize Pyodbc + FreeTDS 0.91 behavior as pretty crappy, there are still many queries such as used in reflection which cause a core dump on Linux, and it is not really usable at all on OSX, MemoryErrors abound and just plain broken unicode support. [ticket:2273]
* undo accidental patch commitMike Bayer2011-08-181-3/+1
|
* document autocommit when using the compiler extension, update the ↵Mike Bayer2011-08-181-1/+3
| | | | "understanding autocommit" section
* - Query will convert an OFFSET of zero whenMike Bayer2011-08-061-2/+2
| | | | | | | | slicing into None, so that needless OFFSET clauses are not invoked. - mssql: "0" is accepted as an argument for limit() which will produce "TOP 0". [ticket:2222] - add tests to default compiler test for LIMIT/OFFSET generation
* - document that pysqlite does not share temporary tablesMike Bayer2011-06-291-0/+3
| | | | | across multiple connections therefore a non-standard pool should be used [ticket:2203]
* - Fixed bug in MSSQL dialect whereby the aliasingMike Bayer2011-05-191-1/+0
| | | | | | applied to a schema-qualified table would leak into enclosing select statements [ticket:2169]. Also in 0.6.8.
* - REAL has been added to the core types. SupportedMike Bayer2011-04-051-7/+3
| | | | | | | by Postgresql, SQL Server, MySQL, SQLite. Note that the SQL Server and MySQL versions, which add extra arguments, are also still available from those dialects. [ticket:2081]
* - add a note about snapshot isolation [ticket:2078]Mike Bayer2011-03-271-0/+17
|
* - some doc reorgMike Bayer2011-03-171-1/+1
| | | | | | | | | | - change engine.Connection to _connection_cls so sphinx doesn't get upset - globally add "." to all :class:`Foo` - start naming sections that are mostly docstrings "API Documentation - blah blah" - move some ad-hoc docstrings into "API" sections, there is some inconsistency here and it may be that we just have to leave it that way - add "internals" rsts to core, orm, I'm not super thrilled how these look but they are targeted by some of the public api docs, users typically become aware of these anyway
* - Rewrote the query used to get the definition of a view,Mike Bayer2011-03-161-10/+21
| | | | | | | typically when using the Inspector interface, to use sys.sql_modules instead of the information schema, thereby allowing views definitions longer than 4000 characters to be fully returned. [ticket:2071]
* - mssql VARBINARY emits 'max' for length when no length specified, as isMike Bayer2011-02-101-0/+6
| | | | the case already for VARCHAR, NVARCHAR [ticket:1833]
* crappy docs, lets try that againMike Bayer2011-01-081-4/+5
|
* - merge r43460573c27a:4993c7eae8e5d117ff342bdc59f3b0635b898e2c of 0.6 branchMike Bayer2011-01-081-0/+26
|
* - whitespace removal bonanzaMike Bayer2011-01-021-52/+52
|
* - clean up copyright, update for 2011, stamp every file withMike Bayer2011-01-021-1/+5
| | | | | a consistent tag - AUTHORS file
* - apply pep8 to compiler.pyMike Bayer2010-12-211-1/+1
| | | | | - deprecate Compiled.compile() - have __init__ do compilation if statement is present.
* Ridding the world of a few wasteful imports.Michael Trier2010-12-191-4/+3
|
* merge tipMike Bayer2010-12-171-6/+11
|\
| * - MSSQL - the String/Unicode types, and their counterparts VARCHAR/Mike Bayer2010-12-161-6/+11
| | | | | | | | | | | | | | 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.
* | merge tipMike Bayer2010-12-151-4/+8
|\ \ | |/
| * - fix mssql index bug, regression post 0.6.4Mike Bayer2010-12-151-11/+18
| | | | | | | | | | - dont emit unicode warning if _warn_on_bytestring is false, including for in-python string conversion
* | - an approach I like better, remove most adapt() methods and use a genericMike Bayer2010-12-151-30/+26
| | | | | | | | | | copier - mssql reflection fix, but this will come in again from the tip merge
* | some tests, should be OKMike Bayer2010-12-131-3/+5
|/
* - repair MS-SQL handling of LIMIT/OFFSET as binds, add bindparam() to the ↵Mike Bayer2010-11-291-4/+4
| | | | | | compile stream so they function correctly
* merge tipMike Bayer2010-11-141-24/+55
|\
| * - Rewrote the reflection of indexes to use sys.Mike Bayer2010-10-231-15/+46
| | | | | | | | | | | | | | 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-3/+3
| | | | | | | | fail to compile properly. [ticket:1943]
| * - Fixed MSSQL reflection bug which did not properly handleMike Bayer2010-10-161-6/+6
| | | | | | | | reflection of unknown types. [ticket:1946]
* | merge tipMike Bayer2010-09-191-1/+1
|\ \ | |/
| * - rewrote the "connections" sectionMike Bayer2010-09-051-1/+1
| | | | | | | | | | | | | | | | | | - improved pool docs - typos etc. - ClauseElement.execute() and scalar() make no sense - these are depreacted. The official home is Executable. - alias() is not executable, allowing it is sloppy so this goes under the deprecated umbrella
* | - move LIMIT/OFFSET rendering to be as bind parameters, for all backendsMike Bayer2010-08-291-4/+7
|/ | | | | | | | | | which support it. This includes SQLite, MySQL, Postgresql, Firebird, Oracle (already used binds with ROW NUMBER OVER), MSSQL (when ROW NUMBER is used, not TOP). Not included are Informix, Sybase, MaxDB, Access [ticket:805] - LIMIT/OFFSET parameters need to stay as literals within SQL constructs. This because they may not be renderable as binds on some backends.
* reformatting /cleanup of column type docs, including [ticket:1858]Mike Bayer2010-08-011-4/+8
|
* - Fixed "default schema" query to work withMike Bayer2010-07-291-4/+4
| | | | pymssql backend.
* - Changed the scheme used to generate truncatedMike Bayer2010-07-211-1/+1
| | | | | | | | | | | | "auto" index names when using the "index=True" flag on Column. The truncation only takes place with the auto-generated name, not one that is user-defined (an error would be raised instead), and the truncation scheme itself is now based on a fragment of an md5 hash of the identifier name, so that multiple indexes on columns with similar names still have unique names. [ticket:1855]
* - idle 78-char adjustmentsMike Bayer2010-07-031-64/+109
|
* - If server_version_info is outside the usualMike Bayer2010-07-021-0/+10
| | | | | | | 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]
View Lorry Controller Status