summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases
Commit message (Collapse)AuthorAgeFilesLines
...
* Trying one more time to get the decimal handling on mssql right. Closes #1282.Michael Trier2009-01-221-10/+28
|
* Restored convert_unicode handling on mssql. Fixes #1291.Michael Trier2009-01-221-3/+0
|
* added some missing internal types for reflection, [ticket:1287]Mike Bayer2009-01-201-0/+2
|
* Corrected handling of large decimal values on mssql. Added more robust tests.Michael Trier2009-01-171-25/+10
| | | | | | - Removed string manipulation on floats. Float types are now passed through to mssql as is. - Fixes #1280
* happy new yearMike Bayer2009-01-127-7/+7
|
* NotSupportedError is a DBAPI wrapper which takes four args and is expected ↵Mike Bayer2009-01-112-3/+3
| | | | | | to originate from the DBAPI layer. Moved those error throws to CompileError/InvalidRequestError.
* Corrected SAVEPOINT support on the adodbapi dialect by changing the handlingMichael Trier2009-01-111-3/+3
| | | | | | | of savepoint_release, which is unsupported on mssql. The way it was being discarded previously resulted in an empty execute being called on the dialect; adodbapi didn't like that much.
* Modified the do_begin handling in mssql to use the Cursor not the Connection.Michael Trier2009-01-111-2/+7
| | | | | | | This corrects a problem where we were trying to call execute on the Connection object instead of against the cursor. This is supported on pyodbc but not in the DBAPI. Overrode the behavior in pymssql to not do special do_begin processing on that dialect.
* Added the missing keywords from MySQL 4.1 so they get escaped properly.Ants Aasma2009-01-081-1/+1
|
* Forgot to sqash a commit. Follow up on mssql dates refactoring.Michael Trier2009-01-051-8/+11
|
* mssql date / time refactor.Michael Trier2009-01-051-43/+91
| | | | | | | - 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.
* assume table.schema, not None, when constraint reflection has no explicit ↵Mike Bayer2009-01-051-1/+1
| | | | schema. unit test TBD.
* Corrected a few docs and didn't realize we put pyodbc first in the search list.Michael Trier2009-01-041-2/+11
|
* Corrected an issue on mssql where Numerics would not accept an int.Michael Trier2009-01-031-2/+4
|
* - Fixed bug which was preventing out params of certain typesMike Bayer2009-01-031-1/+5
| | | | | from being received; thanks a ton to huddlej at wwu.edu ! [ticket:1265]
* identified the SQLite changes which affect default reflectionMike Bayer2009-01-031-4/+1
|
* Added a note about mssql compatibility levels.Michael Trier2009-01-031-0/+11
|
* send a NASA probe to the buildbotMike Bayer2009-01-031-1/+4
|
* sqlite reflection now stores the actual DefaultClause value for the column.Michael Trier2009-01-021-4/+4
|
* - mysql, postgres: "%" signs in text() constructs are automatically escaped ↵Mike Bayer2009-01-022-0/+10
| | | | | | | to "%%". Because of the backwards incompatible nature of this change, a warning is emitted if '%%' is detected in the string. [ticket:1267]
* found some more _Function->FunctionMike Bayer2009-01-024-4/+4
|
* Marked mssql test as failing since it cannot update identity columns.Michael Trier2009-01-021-1/+0
|
* Mapped char_length to the LEN() function for mssql.Michael Trier2009-01-021-1/+2
|
* Added ability to use subselects within INSERTS on mssql.Michael Trier2009-01-021-0/+27
|
* Turned off the implicit transaction behavior of MSSQL.Michael Trier2009-01-021-0/+4
| | | | This corrects the savepoint tests.
* Cleanup of r5556. Makes the description_encoding less public since this is aMichael Trier2009-01-021-3/+4
| | | | workaround for the pyodbc dbapi.
* Modifications to the mssql dialect in order to to pass through unicode in ↵Michael Trier2008-12-301-37/+30
| | | | the pyodbc dialect.
* Added a new description_encoding attribute on the dialect.Michael Trier2008-12-301-6/+8
| | | | | This is used for encoding the column name when processing the metadata. This usually defaults to utf-8.
* - added another usage recipe for contains_eager()Mike Bayer2008-12-291-1/+1
| | | | - some typos
* - Added OracleNVarchar type, produces NVARCHAR2, and alsoMike Bayer2008-12-281-1/+6
| | | | | | | subclasses Unicode so that convert_unicode=True by default. NVARCHAR2 reflects into this type automatically so these columns pass unicode on a reflected table with no explicit convert_unicode=True flags. [ticket:1233]
* Added in a new MSGenericBinary type.Michael Trier2008-12-281-4/+25
| | | | | | 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.
* Corrected reflection issue in mssql where include_columns doesn't include ↵Michael Trier2008-12-281-2/+2
| | | | the PK.
* On MSSQL if a field is part of the primary_key then it should not allow NULLS.Michael Trier2008-12-281-1/+1
|
* MSSQL refactoring of BINARY type and addition of MSVarBinary and MSImage.Michael Trier2008-12-281-2/+19
| | | | | | - Added in new types: MSVarBinary and MSImage - Modified MSBinary to now return BINARY instead of IMAGE. This is a backwards incompatible change. Closes #1249.
* - Reflected foreign keys will properly locateMike Bayer2008-12-2610-24/+21
| | | | | | | | | | | | | | | | | | | | | | | their referenced column, even if the column was given a "key" attribute different from the reflected name. This is achieved via a new flag on ForeignKey/ForeignKeyConstraint called "link_to_name", if True means the given name is the referred-to column's name, not its assigned key. [ticket:650] - removed column types from sqlite doc, we aren't going to list out "implementation" types since they aren't significant and are less present in 0.6 - mysql will report on missing reflected foreign key targets in the same way as other dialects (we can improve that to be immediate within reflecttable(), but it should be within ForeignKeyConstraint()). - postgres dialect can reflect table with an include_columns list that doesn't include one or more primary key columns
* Fixed bugs in sqlalchemy documentation. Closes #1263.Michael Trier2008-12-241-1/+1
|
* Added MSSQL support for introspecting the default schema name for the logged ↵Michael Trier2008-12-231-0/+18
| | | | in user. Thanks Randall Smith. Fixes #1258.
* - Added Index reflection support to Postgres, using aMike Bayer2008-12-231-0/+38
| | | | | great patch we long neglected, submitted by Ken Kuhlman. [ticket:714]
* Merge branch 'collation'Michael Trier2008-12-232-28/+315
|
* Major refactoring of the MSSQL dialect. Thanks zzzeek.Michael Trier2008-12-221-197/+299
| | | | | | 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.
* - Fixed mysql bug in exception raise when FK columns not presentMike Bayer2008-12-211-1/+1
| | | | during reflection. [ticket:1241]
* removed the "create_execution_context()" method from dialects and replacedMike Bayer2008-12-1910-54/+17
| | | | with a more succinct "dialect.execution_ctx_cls" member
* *most* py3k warnings are resolved, with the exception of the various ↵Mike Bayer2008-12-181-1/+1
| | | | | | __setslice__ related warnings I don't really know how to get rid of
* merged -r5299:5438 of py3k warnings branch. this fixes some sqlite py2.6 ↵Mike Bayer2008-12-181-3/+3
| | | | | | | | testing issues, and also addresses a significant chunk of py3k deprecations. It's mainly expicit __hash__ methods. Additionally, most usage of sets/dicts to store columns uses util-based placeholder names.
* - _execute_clauseelement() goes back to beingMike Bayer2008-12-171-5/+2
| | | | | | | | | | | | | | | | a private method. Subclassing Connection is not needed now that ConnectionProxy is available. - tightened the interface for the various _execute_XXX() methods to reduce ambiguity - __distill_params() no longer creates artificial [{}] entry, blank dict is no longer passed through to do_execute() in any case unless explicitly sent from the outside as in connection.execute("somestring"), {}) - fixed a few old sql.query tests which were doing that - removed needless do_execute() from mysql dialect - fixed charset param not properly being sent to _compat_fetchone() in mysql
* - added sphinx handler to allow __init__ methods throughMike Bayer2008-12-171-0/+115
| | | | | | - sqlite module documentation - some corrections to pool docs - the example in URL.translate_connect_args() never made any sense anyway so removed it
* Support for three levels of column nullability: NULL, NOT NULL, and the ↵Michael Trier2008-12-121-3/+19
| | | | | | 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.
* We don't need two of these.Michael Trier2008-12-111-3/+0
|
* Implemented experimental savepoint support in mssql. There are still some ↵Michael Trier2008-12-111-0/+10
| | | | failing savepoint related tests.
* - postgres docstringMike Bayer2008-12-062-23/+102
| | | | | | - insert/update/delete are documented generatively - values({}) is no longer deprecated, thus enabling unicode/Columns as keys
View Lorry Controller Status