summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/mssql.py
Commit message (Collapse)AuthorAgeFilesLines
...
* explicit zero was failing for float colsRick Morrison2007-04-041-1/+3
|
* for #516, moved the "disconnect check" step out of pool and back into ↵Mike Bayer2007-04-031-12/+6
| | | | | | base.py. dialects have is_disconnect() method now. simpler design which also puts control of the ultimate "execute" call back into the hands of the dialects.
* - merged the patch from #516 + fixesMike Bayer2007-04-021-0/+16
| | | | | | | | - improves the framework for auto-invalidation of connections that have lost their underlying database - the error catching/invalidate step is totally moved to the connection pool. - added better condition checking for do_rollback() and do_commit() including SQLError excepetion wrapping
* - merged the "execcontext" branch, refactors engine/dialect codepathsMike Bayer2007-04-021-88/+71
| | | | | | | | | | | | | | | | | | | | - much more functionality moved into ExecutionContext, which impacted the API used by dialects to some degree - ResultProxy and subclasses now designed sanely - merged patch for #522, Unicode subclasses String directly, MSNVarchar implements for MS-SQL, removed MSUnicode. - String moves its "VARCHAR"/"TEXT" switchy thing into "get_search_list()" function, which VARCHAR and CHAR can override to not return TEXT in any case (didnt do the latter yet) - implements server side cursors for postgres, unit tests, #514 - includes overhaul of dbapi import strategy #480, all dbapi importing happens in dialect method "dbapi()", is only called inside of create_engine() for default and threadlocal strategies. Dialect subclasses have a datamember "dbapi" referencing the loaded module which may be None. - added "mock" engine strategy, doesnt require DBAPI module and gives you a "Connecition" which just sends all executes to a callable. can be used to create string output of create_all()/drop_all().
* better explicit PK insert checkingRick Morrison2007-03-281-3/+3
|
* Change to ParameterClause object changeRick Morrison2007-03-281-3/+6
| | | | New syntax for adodbapi connection string with port
* msssql: more unit tests now passRick Morrison2007-03-271-1/+10
|
* mssql: now passes still more unit tests, [ticket:481]Rick Morrison2007-03-191-3/+13
|
* - added db modules to genned docstringsMike Bayer2007-03-181-7/+15
| | | | | | | - had to tweak out latest MS-SQL module change. cant do ImportErrors right now until module importing is moved to the connection phase across all dialects. - took out "his" from url docstrings - postgres doesnt do an import *
* mssql: cleanup of module importing code; specifiable DB-API module; more ↵Rick Morrison2007-03-181-151/+150
| | | | explicit ordering of module preferences. [ticket:480]
* mssql: optionally use VARCHAR(max) instead of TEXT. [ticket:509]Rick Morrison2007-03-181-8/+23
|
* MSSQL now passes still more unit tests [ticket:481]Rick Morrison2007-03-151-20/+46
| | | | | | | Fix to null FLOAT fields in mssql-trusted.patch MSSQL: LIMIT with OFFSET now raises an error MSSQL: can now specify Windows authorization MSSQL: ignores seconds on DATE columns (DATE fix, part 1)
* - for hackers, refactored the "visitor" system of ClauseElement andMike Bayer2007-03-111-3/+3
| | | | | | | | | | | | | | | SchemaItem so that the traversal of items is controlled by the ClauseVisitor itself, using the method visitor.traverse(item). accept_visitor() methods can still be called directly but will not do any traversal of child items. ClauseElement/SchemaItem now have a configurable get_children() method to return the collection of child elements for each parent object. This allows the full traversal of items to be clear and unambiguous (as well as loggable), with an easy method of limiting a traversal (just pass flags which are picked up by appropriate get_children() methods). [ticket:501] - accept_schema_visitor() methods removed, replaced with get_children(schema_visitor=True) - various docstring/changelog cleanup/reformatting
* migrated (most) docstrings to pep-257 format, docstring generator using ↵Mike Bayer2007-02-251-37/+61
| | | | | | straight <pre> + trim() func for now. applies most of [ticket:214], compliemnts of Lele Gaifax
* Tested with pymssql 0.8.0Rick Morrison2007-02-211-4/+13
| | | | mssql: added query_timeout, fixes for passing auto_insert in dburl
* (no commit message)Rick Morrison2007-02-191-13/+21
|
* Completed previously missed patches from tickets 422 and 415Rick Morrison2007-02-181-13/+26
| | | | | get unit tests to work with pyodbc [ticket:481] fix blank password on adodbapi [ticket:371]
* commented out ImportError for now; will issue new ticket for handling ↵Mike Bayer2007-02-171-3/+3
| | | | dialect importerrors more effectively
* better MSSSQL support for implicit sequences and auto-insert, ticket 415Rick Morrison2007-02-161-13/+22
|
* Fix Fix for adodbapi bug introduced by ticket 419Rick Morrison2007-02-161-13/+22
|
* Func rewrite for better unittest compatibilityRick Morrison2007-02-161-28/+38
| | | | Simplified transaction handling for pymssql
* revert old unittest patch for MSSQLRick Morrison2007-02-151-0/+2
|
* MSSSQL is now passing unit tests (well, some) thanks to Paul JohnstonRick Morrison2007-02-151-8/+19
|
* run-time selectable DB-API modules for mssql [ticket:419]Rick Morrison2007-02-141-22/+62
| | | | preliminary support for pyodbc
* Fix for ticket 473Rick Morrison2007-02-141-0/+7
|
* Fix query.get for MSSQL tables with schema specifiedRick Morrison2007-02-141-0/+1
|
* ticket 298 plus transaction fixes for pymssqlRick Morrison2007-02-061-6/+18
|
* - added "schema" argument to all has_table() calls, only supported so far by PGMike Bayer2007-02-041-2/+2
| | | | - added basic unit test for PG reflection of tables in an alternate schema
* - postgres cursor option is now server_side_cursors=False; some users get ↵Mike Bayer2007-01-141-5/+7
| | | | | | | | | bad results using them so theyre off by default - type system slightly modified to support TypeDecorators that can be overridden by the dialect - added an NVarchar type to mssql (produces NVARCHAR), also MSUnicode which provides Unicode-translation for the NVarchar regardless of dialect convert_unicode setting.
* typo fix (thanks Paul J)Rick Morrison2007-01-061-1/+1
|
* Removed "burned-in" schema name of "dbo". Suggested by janezjRick Morrison2007-01-041-3/+7
|
* Patch from Paul Johnston that refactors adodbapi vs. pymssql a bit, fixes ↵Rick Morrison2007-01-041-52/+37
| | | | broken COMMITS in adodbapi
* reversing last commitRick Morrison2006-12-181-6/+1
|
* added missing ref to between in sql.py __all__Rick Morrison2006-12-171-1/+6
|
* fix: auto_identity_insert was not working with non-list insert parmsRick Morrison2006-11-071-3/+5
|
* - a fair amount of cleanup to the schema package, removal of ambiguousMike Bayer2006-10-141-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | methods, methods that are no longer needed. slightly more constrained useage, greater emphasis on explicitness. - table_iterator signature fixup, includes fix for [ticket:288] - the "primary_key" attribute of Table and other selectables becomes a setlike ColumnCollection object; is no longer ordered or numerically indexed. a comparison clause between two pks that are derived from the same underlying tables (i.e. such as two Alias objects) can be generated via table1.primary_key==table2.primary_key - append_item() methods removed from Table and Column; preferably construct Table/Column/related objects inline, but if needed use append_column(), append_foreign_key(), append_constraint(), etc. - table.create() no longer returns the Table object, instead has no return value. the usual case is that tables are created via metadata, which is preferable since it will handle table dependencies. - added UniqueConstraint (goes at Table level), CheckConstraint (goes at Table or Column level) fixes [ticket:217] - index=False/unique=True on Column now creates a UniqueConstraint, index=True/unique=False creates a plain Index, index=True/unique=True on Column creates a unique Index. 'index' and 'unique' keyword arguments to column are now boolean only; for explcit names and groupings of indexes or unique constraints, use the UniqueConstraint/Index constructs explicitly. - relationship of Metadata/Table/SchemaGenerator/Dropper has been improved so that the schemavisitor receives the metadata object for greater control over groupings of creates/drops. - added "use_alter" argument to ForeignKey, ForeignKeyConstraint, but it doesnt do anything yet. will utilize new generator/dropper behavior to implement.
* added 'ntext' reflected typeMike Bayer2006-10-131-0/+1
|
* some cleanup submitted by Lele GalifaxMike Bayer2006-10-131-3/+0
|
* fix PK redefinitionRick Morrison2006-09-291-3/+1
|
* NCHAR and NVARCHAR support for MS-SQL. Patch from Kent JohnsonRick Morrison2006-09-271-2/+12
|
* Simplified MSSQL table reflection codeRick Morrison2006-09-261-34/+47
| | | | added support for multi-column foreign keys
* fix misspelled func callsRick Morrison2006-09-261-4/+4
|
* Fixes use of port for pymssqlRick Morrison2006-09-231-15/+36
| | | | | Introduces new auto_indentity_insert option Fixes bug #261
* - added autoincrement=True to Column; will disable schema generationMike Bayer2006-09-231-1/+1
| | | | | of SERIAL/AUTO_INCREMENT/identity seq for postgres/mysql/mssql if explicitly set to False. #303
* no KeyError if url params not providedMike Bayer2006-09-191-1/+1
|
* - postgres reflection moved to use pg_schema tables, can be overriddenMike Bayer2006-08-211-3/+3
| | | | | | | | with use_information_schema=True argument to create_engine [ticket:60], [ticket:71] - added natural_case argument to Table, Column, semi-experimental flag for use with table reflection to help with quoting rules [ticket:155]
* added MSTinyInteger to MS-SQL [ticket:263]Mike Bayer2006-08-121-1/+5
|
* quoting facilities set up so that database-specific quoting can beMike Bayer2006-08-121-1/+14
| | | | | | | turned on for individual table, schema, and column identifiers when used in all queries/creates/drops. Enabled via "quote=True" in Table or Column, as well as "quote_schema=True" in Table. Thanks to Aaron Spike for his excellent efforts. [ticket:155]
* fixed ms-sql connect() to work with adodbapiMike Bayer2006-08-111-7/+3
|
* added reflected 'tinyint' type to MS-SQL [ticket:263]Mike Bayer2006-08-041-0/+1
|
View Lorry Controller Status