summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/mssql.py
Commit message (Collapse)AuthorAgeFilesLines
* some fixes to the MS-SQL aliasing so that result_map is properly populatedMike Bayer2008-04-021-3/+9
|
* MSSQL adjustments to pyodbc connection string buildingRick Morrison2008-03-311-38/+5
|
* Add a new 'driver' keyword to the MSSQL pyodbc Dialect.Rick Morrison2008-03-311-24/+14
| | | | Refresh items that were recently reverted by another checkin
* - schema-qualified tables now will place the schemanameMike Bayer2008-03-301-2/+0
| | | | | | | | | | ahead of the tablename in all column expressions as well as when generating column labels. This prevents cross- schema name collisions in all cases [ticket:999] - the "use_schema" argument to compiler.visit_column() is removed. It uses schema in all cases now. - added a new test to the PG dialect to test roundtrip insert/update/delete/select statements with full schema qualification
* MSSQL fixes for tickets 979, 916, 884Rick Morrison2008-03-301-5/+34
|
* - Fixed a couple pyflakes, cleaned up imports & whitespaceJason Kirtland2008-02-141-1/+1
|
* MSSQL now compiles func.now() to CURRENT_TIMESTAMPRick Morrison2008-02-141-1/+9
|
* Added EXEC to MSSQL _is_select regexp; should now detect row-returning ↵Rick Morrison2008-02-141-8/+40
| | | | | | stored procedures Added experimental implementation of limit/offset using row_number()
* Fix: deletes with schemas on MSSQL 2000 [ticket:967]Paul Johnston2008-02-081-0/+2
|
* - Warnings are now issued as SAWarning instead of RuntimeWarning; ↵Jason Kirtland2008-01-111-2/+3
| | | | | | util.warn() wraps this up. - SADeprecationWarning has moved to exceptions. An alias remains in logging until 0.5.
* Include column name in length-less String warning (more [ticket:912])Jason Kirtland2008-01-101-61/+61
|
* redid the _for_ddl String/Text deprecation warning correctly [ticket:912]Mike Bayer2008-01-091-1/+1
|
* Fix for ticket [923]Rick Morrison2008-01-071-17/+13
|
* - changed name of TEXT to Text since its a "generic" type; TEXT name isMike Bayer2008-01-051-2/+2
| | | | | | | deprecated until 0.5. The "upgrading" behavior of String to Text when no length is present is also deprecated until 0.5; will issue a warning when used for CREATE TABLE statements (String with no length for SQL expression purposes is still fine) [ticket:912]
* Fix for autoload of non-identity PK integer columns [824]Rick Morrison2007-12-191-7/+13
| | | | | | Better datetime checking/conversion for pyodbc adodbapi [842] Fix for autoloading schema-qualified tables [901] Convert_unicode support for all dialects [839]
* - cleanup; lambdas removed from properties; properties mirror same-named ↵Mike Bayer2007-12-181-1/+1
| | | | | | functions (more like eventual decorator syntax); remove some old methods, factor out some "raiseerr" ugliness to outer lying functions. - corresponding_column() integrates "require_embedded" flag with other set arithmetic
* un-screw up the attribute manager checkinMike Bayer2007-11-271-30/+2
|
* AttributeManager class and "cached" state removed....attribute listingMike Bayer2007-11-271-2/+30
| | | | is tracked from _sa_attrs class collection
* Fix: MSSQL set identity_insert and errors [ticket:538]Paul Johnston2007-11-251-17/+23
|
* Fix: test_decimal on MSSQL - use a value that is accurately represented as a ↵Paul Johnston2007-11-251-1/+12
| | | | float, and make when asdecimal=False, convert Decimal to float
* Fix: MSSQL concatenate operator is + not || [ticket:879]Paul Johnston2007-11-251-1/+4
|
* Avoid doubling quoting of identifier in MSSQL reflectionPaul Johnston2007-11-251-1/+1
|
* Make function a reserved word in MSSQLPaul Johnston2007-11-251-5/+5
|
* MSSQL/PyODBC no longer has a global set nocount onPaul Johnston2007-11-251-10/+3
|
* Change to make PyODBC result fetching a bit more reliablePaul Johnston2007-11-251-8/+8
|
* column.foreign_key -> foreign_keys in MSSQLPaul Johnston2007-11-251-2/+2
|
* - named_with_column becomes an attributeMike Bayer2007-11-251-4/+4
| | | | | | | | | - cleanup within compiler visit_select(), column labeling - is_select() removed from dialects, replaced with returns_rows_text(), returns_rows_compiled() - should_autocommit() removed from dialects, replaced with should_autocommit_text() and should_autocommit_compiled() - typemap and column_labels collections removed from Compiler, replaced with single "result_map" collection. - ResultProxy uses more succinct logic in combination with result_map to target columns
* - MSSQL anonymous labels for selection of functions made deterministicMike Bayer2007-11-181-6/+6
| | | | - propagate correct **kwargs through mssql methods
* - anonymous column expressions are automatically labeled.Mike Bayer2007-11-101-2/+2
| | | | | | | | | | | | | | | | | | | e.g. select([x* 5]) produces "SELECT x * 5 AS anon_1". This allows the labelname to be present in the cursor.description which can then be appropriately matched to result-column processing rules. (we can't reliably use positional tracking for result-column matches since text() expressions may represent multiple columns). - operator overloading is now controlled by TypeEngine objects - the one built-in operator overload so far is String types overloading '+' to be the string concatenation operator. User-defined types can also define their own operator overloading by overriding the adapt_operator(self, op) method. - untyped bind parameters on the right side of a binary expression will be assigned the type of the left side of the operation, to better enable the appropriate bind parameter processing to take effect [ticket:819]
* Fixup sp_columns callPaul Johnston2007-10-311-1/+1
|
* - attempted to add a test for #622 / #751, but cant reproduce the failing ↵Mike Bayer2007-10-141-1/+1
| | | | | | | condition - fixed major oracle bug introduced by r3561, since colnames come back as unicode now, need to encode keys in setinputsizes() step
* Unused imports.Jason Kirtland2007-10-131-1/+1
|
* Fix broken update/delete queries on MSSQL when tables have a schemaPaul Johnston2007-10-121-1/+1
|
* applied patch for pymssql 30-char limitRick Morrison2007-10-101-2/+3
|
* removed unused _fold_identifier_case methodMike Bayer2007-10-021-4/+0
|
* Don't use unicode with pyodbc on UCS-4 platforms [ticket:787]Paul Johnston2007-09-191-3/+6
|
* Set supports_sane_multi_rowcount for MSSQLPaul Johnston2007-09-041-0/+3
|
* - removed "parameters" argument from clauseelement.compile(), replaced withMike Bayer2007-09-041-2/+2
| | | | | | | | "column_keys". the parameters sent to execute() only interact with the insert/update statement compilation process in terms of the column names present but not the values for those columns. produces more consistent execute/executemany behavior, simplifies things a bit internally.
* Minor fixes to MSSQL reflectionPaul Johnston2007-09-031-3/+3
|
* - merged inline inserts branchMike Bayer2007-09-011-1/+1
| | | | | | | | | | | | - all executemany() style calls put all sequences and SQL defaults inline into a single SQL statement and don't do any pre-execution - regular Insert and Update objects can have inline=True, forcing all executions to be inlined. - no last_inserted_ids(), lastrow_has_defaults() available with inline execution - calculation of pre/post execute pushed into compiler; DefaultExecutionContext greatly simplified - fixed postgres reflection of primary key columns with no sequence/default generator, sets autoincrement=False - fixed postgres executemany() behavior regarding sequences present, not present, passivedefaults, etc. - all tests pass for sqlite, mysql, postgres; oracle tests pass as well as they did previously including all insert/update/default functionality
* engine.url cleanups [ticket:742]Jason Kirtland2007-08-291-1/+1
| | | | | | - translate_connect_args can now take kw args or the classic list - in-tree dialects updated to supply their overrides as keywords - tweaked url parsing in the spirit of the #742 patch, more or less
* - method call removalMike Bayer2007-08-201-25/+8
|
* One more change of preparer() to identifier_preparerPaul Johnston2007-08-191-1/+1
|
* Use identifier_preparer instead of preparer()Paul Johnston2007-08-191-2/+2
|
* Fix broken importsPaul Johnston2007-08-191-1/+1
|
* 1. Module layout. sql.py and related move into a package called "sql".Mike Bayer2007-08-181-28/+18
| | | | | | | | | | | | 2. compiler names changed to be less verbose, unused classes removed. 3. Methods on Dialect which return compilers, schema generators, identifier preparers have changed to direct class references, typically on the Dialect class itself or optionally as attributes on an individual Dialect instance if conditional behavior is needed. This takes away the need for Dialect subclasses to know how to instantiate these objects, and also reduces method overhead by one call for each one. 4. as a result of 3., some internal signatures have changed for things like compiler() (now statement_compiler()), preparer(), etc., mostly in that the dialect needs to be passed explicitly as the first argument (since they are just class references now). The compiler() method on Engine and Connection is now also named statement_compiler(), but as before does not take the dialect as an argument. 5. changed _process_row function on RowProxy to be a class reference, cuts out 50K method calls from insertspeed.py
* merge changset [3347] into trunkPaul Johnston2007-08-171-5/+9
|
* Merge [3345] into trunk. Unit test still TODOPaul Johnston2007-08-171-4/+28
|
* Disable MSSQL unicode statements on UCS-4 platforms, ticket #731Paul Johnston2007-08-171-2/+2
|
* mass has_key->__contains__ migration, [ticket:738]Mike Bayer2007-08-151-5/+5
|
View Lorry Controller Status