summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/firebird.py
Commit message (Collapse)AuthorAgeFilesLines
* merge 0.6 series to trunk.Mike Bayer2009-08-061-768/+0
|
* Fix deprecated usage of on numeric typeLele Gaifax2009-06-231-2/+2
|
* happy new yearMike Bayer2009-01-121-1/+1
|
* - Reflected foreign keys will properly locateMike Bayer2008-12-261-1/+1
| | | | | | | | | | | | | | | | | | | | | | | 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
* removed the "create_execution_context()" method from dialects and replacedMike Bayer2008-12-191-3/+1
| | | | with a more succinct "dialect.execution_ctx_cls" member
* - Simplified the check for ResultProxy "autoclose without results"Mike Bayer2008-11-041-36/+1
| | | | | | to be based solely on presence of cursor.description. All the regexp-based guessing about statements returning rows has been removed [ticket:1212].
* - The 'length' argument to all Numeric types has been renamedMike Bayer2008-08-241-3/+3
| | | | | | | | | | | | | | | | to 'scale'. 'length' is deprecated and is still accepted with a warning. [ticket:827] - The 'length' argument to MSInteger, MSBigInteger, MSTinyInteger, MSSmallInteger and MSYear has been renamed to 'display_width'. [ticket:827] - mysql._Numeric now consumes 'unsigned' and 'zerofill' from the given kw, so that the same kw can be passed along to Numeric and allow the 'length' deprecation logic to still take effect - added testlib.engines.all_dialects() to return a dialect for every db module - informix added to sqlalchemy.databases.__all__. Since other "experimental" dbs like access and sybase are there, informix should be as well.
* - Temporarily rolled back the "ORDER BY" enhancementMike Bayer2008-08-061-1/+0
| | | | | from [ticket:1068]. This feature is on hold pending further development.
* - compiler visit_label() checks a flag "within_order_by" and will render its ↵Mike Bayer2008-08-031-1/+2
| | | | | | | | | | | | | | | | | | | own name and not its contained expression, if the dialect reports true for supports_simple_order_by_label. the flag is not propagated forwards, meant to closely mimic the syntax Postgres expects which is that only a simple name can be in the ORDER BY, not a more complex expression or function call with the label name embedded (mysql and sqlite support more complex expressions). This further sets the standard for propigation of **kwargs within compiler, that we can't just send **kwargs along blindly to each XXX.process() call; whenever a **kwarg needs to propagate through, most methods will have to be aware of it and know when they should send it on forward and when not. This was actually already the case with result_map as well. The supports_simple_order_by dialect flag defaults to True but is conservatively explicitly set to False on all dialects except SQLite/MySQL/Postgres to start. [ticket:1068]
* Corrects reflecttable in firebird database. Closes #1119.Michael Trier2008-07-291-1/+1
|
* - Removed 2.3 Decimal compatJason Kirtland2008-07-151-2/+2
|
* - Removed 2.3 set emulations/enhancements.Jason Kirtland2008-07-151-1/+1
| | | | (sets.Set-based collections & DB-API returns still work.)
* - re-fixed the fix to the prefixes fixMike Bayer2008-07-061-12/+1
| | | | | - removed ancient descriptor() functions from dialects; replaced with Dialect.name - removed similarly ancient sys.modules silliness in Engine.name
* Fix typoLele Gaifax2008-05-151-1/+1
|
* Columns now have default= and server_default=. PassiveDefault fades away.Jason Kirtland2008-05-141-1/+1
|
* Support Firebird 2.0+ RETURNINGLele Gaifax2008-05-141-2/+85
|
* Check for the presence of the Firebird generator, when creating/dropping a ↵Lele Gaifax2008-05-121-4/+6
| | | | sequence
* Add another exception case to Firebird' is_disconnect()Lele Gaifax2008-05-121-1/+3
|
* TypoLele Gaifax2008-05-121-1/+1
|
* Use a BLOB when asked for a [VAR]CHAR without a length under FirebirdLele Gaifax2008-05-121-2/+8
|
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-9/+10
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* Firebird 2 has a SUBSTRING() builtin, expose it thru a functionLele Gaifax2008-04-111-0/+12
|
* Reverted to False Firebird's supports_sane_rowcountLele Gaifax2008-01-111-1/+1
| | | | Slipped in: even if it seems it could be set to True, I'm still testing the rowcount affair
* Try to reflect also the Sequence on the PK under FirebirdLele Gaifax2008-01-111-3/+30
|
* - Warnings are now issued as SAWarning instead of RuntimeWarning; ↵Jason Kirtland2008-01-111-2/+2
| | | | | | 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-1/+1
|
* Recognize another Firebird exception in dialect.is_disconnect()Lele Gaifax2008-01-101-0/+2
|
* redid the _for_ddl String/Text deprecation warning correctly [ticket:912]Mike Bayer2008-01-091-1/+1
|
* - 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]
* happy new yearMike Bayer2008-01-011-1/+1
|
* Revert to use default poolclass under FirebirdLele Gaifax2007-12-151-2/+20
| | | | | | | This partially reverts [3562] and instead documents the problem suggesting a possible workaround. For the tests, the occurence of the problem is largely reduced by using a TCP connection (that is, 'localhost:/some/file.fdb' instead of '/some/file.fdb')
* Remove some spurious spacesLele Gaifax2007-12-151-3/+7
|
* Implemented FBDialect.server_version_info()Lele Gaifax2007-12-151-5/+34
|
* Firebird module documentationLele Gaifax2007-12-141-12/+125
|
* Use the external strlen UDF for func.length() under FirebirdLele Gaifax2007-12-131-0/+6
|
* Use an external UDF to implement the mod operator under FirebirdLele Gaifax2007-12-121-1/+8
|
* Reflect Firebird PassiveDefaultsLele Gaifax2007-12-121-11/+32
| | | | | | - column's default values are properly reflected (also those coming from DOMAINs) - implemented .has_sequence() - fix type on FK reflection
* Cosmetic changes to the Firebird reflection queries.Lele Gaifax2007-12-111-59/+63
| | | | | This brings them more consistent with the syntax of the statements generated by SA, using lowercase field names.
* Better reflection of Firebird data types.Lele Gaifax2007-12-091-19/+23
| | | | | Instead of relying on internal numeric code, lookup the associated real name. This has the extra benefit of properly handling of DOMAINs.
* - basic framework for generic functions, [ticket:615]Mike Bayer2007-12-051-3/+3
| | | | | | | - changed the various "literal" generation functions to use an anonymous bind parameter. not much changes here except their labels now look like ":param_1", ":param_2" instead of ":literal" - from_obj keyword argument to select() can be a scalar or a list.
* repaired FB functions, [ticket:862]Mike Bayer2007-11-181-3/+3
|
* Added support for dialects that have both sequences and autoincrementing PKs.Jason Kirtland2007-10-231-1/+2
|
* Unused imports.Jason Kirtland2007-10-131-1/+1
|
* firebird: Fixed reflection for Integer and Numeric (after introducing Float ↵Roger Demetrescu2007-10-121-1/+1
| | | | column type). Need to review 'column_func' from reflecttable() and write some unit tests...
* Firebird: added Float and Time types (FBFloat and FBTime). Fixed BLOB ↵Roger Demetrescu2007-10-121-3/+42
| | | | | | SUB_TYPE for TEXT and Binary types. Firebird's string types are tested in testtypes.py
* Firebird now uses dialect.preparer to format sequences names.Roger Demetrescu2007-10-081-4/+5
| | | | UnicodeTest (reflection.py) runs ok now.
* Firebird dialect now uses SingletonThreadPool as its poolclass.Roger Demetrescu2007-10-071-1/+2
| | | | | | (this fixes all "unsuccessful metadata update\n object XXXXX is in use" test errors) Minor fixes in tests
* Firebird now passes all tests from /test/engine/reflection.py (except ↵Roger Demetrescu2007-10-041-35/+48
| | | | | | | | UnicodeTest). * FBDialect now mimics OracleDialect, regarding case-sensitivity of TABLE and COLUMN names * FBDialect.table_names() doesn't bring system tables (ticket #796) * FB now reflects Column's nullable property correctly.
* firebird doesn't support sane rowcount.Roger Demetrescu2007-09-281-2/+2
|
* fixed firebird visit_alias [ticket:779]Mike Bayer2007-09-221-2/+2
|