summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases
Commit message (Collapse)AuthorAgeFilesLines
...
* 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
* - merged -r5338:5429 of sphinx branch.Mike Bayer2008-12-061-411/+385
| | | | | | | | | | | | | - Documentation has been converted to Sphinx. In particular, the generated API documentation has been constructed into a full blown "API Reference" section which organizes editorial documentation combined with generated docstrings. Cross linking between sections and API docs are vastly improved, a javascript-powered search feature is provided, and a full index of all classes, functions and members is provided.
* - Adjusted the format of create_xid() to repairMike Bayer2008-12-051-2/+2
| | | | | | two-phase commit. We now have field reports of Oracle two-phase commit working properly with this change.
* - bump, this may become 0.5.0Mike Bayer2008-11-141-1/+2
| | | | | - Calling alias.execute() in conjunction with server_side_cursors won't raise AttributeError.
* Pulled out values test that uses boolean evaluation in the SELECT in order ↵Michael Trier2008-11-141-3/+4
| | | | to appropriately flag it as not supported on mssql. I sure hope I didn't jack things up for other dialects. Cleaned up a comment and removed some commented pdb statements.
* Fixed a problem with the casting of a zero length type to a varchar. It now ↵Michael Trier2008-11-141-1/+1
| | | | correctly adjusts the CAST accordingly.
* The str(query) output is also correct on the mssql dialect.Michael Trier2008-11-141-1/+2
|
* Corrected mssql schema named subqueries from not properly aliasing the ↵Michael Trier2008-11-121-3/+4
| | | | columns. Fixes #973.
* Handle the mssql port properly. If we're using the SQL Server driver then ↵Michael Trier2008-11-101-3/+9
| | | | use the correct host,port syntax, otherwise use the Port= parameter in the connection string. Fixes #1192.
* Corrected issue with decimal e notation that broke regular decimal tests for ↵Michael Trier2008-11-101-1/+1
| | | | mssql.
* If there's a zero offset with mssql just ignore it.Michael Trier2008-11-101-1/+1
|
* Corrected problem in access dialect that was still referring to the old ↵Michael Trier2008-11-101-2/+2
| | | | column.foreign_key property.
* flattened _get_from_objects() into a descriptor/class-bound attributeMike Bayer2008-11-092-5/+4
|
* Corrected problems with Access dialect. Corrected issue with reflection due ↵Michael Trier2008-11-091-1/+6
| | | | to missing Currency type. Functions didn't return the value. JOINS must be specified as LEFT OUTER JOIN or INNER JOIN. Fixes #1017.
* Corrected problems with reflection on mssql when dealing with schemas. Fixes ↵Michael Trier2008-11-091-4/+4
| | | | #1217.
* Fixed E notation problem in mssql. Closes #1216.Michael Trier2008-11-081-1/+8
|
* Corrected a lot of mssql limit / offset issues. Also ensured that mssql uses ↵Michael Trier2008-11-081-13/+20
| | | | the IN / NOT IN syntax when using a binary expression with a subquery.
* docstring fixMike Bayer2008-11-071-1/+1
|
View Lorry Controller Status