summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/firebird/base.py
Commit message (Collapse)AuthorAgeFilesLines
* - implement kwarg validation and type system for dialect-specificMike Bayer2014-01-181-0/+2
| | | | | arguments; [ticket:2866] - add dialect specific kwarg functionality to ForeignKeyConstraint, ForeignKey
* - happy new yearMike Bayer2014-01-051-1/+1
|
* - Changed the queries used by Firebird to list table and view namesMike Bayer2013-12-271-5/+21
| | | | | | | | | to query from the ``rdb$relations`` view instead of the ``rdb$relation_fields`` and ``rdb$view_relations`` views. Variants of both the old and new queries are mentioned on many FAQ and blogs, however the new queries are taken straight from the "Firebird FAQ" which appears to be the most official source of info. [ticket:2898]
* - The firebird dialect will quote identifiers which begin with anMike Bayer2013-12-271-0/+1
| | | | underscore. Courtesy Treeve Jelbert. [ticket:2897]
* - Fixed bug in Firebird index reflection where the columns within theMike Bayer2013-12-271-1/+1
| | | | | index were not sorted correctly; they are now sorted in order of RDB$FIELD_POSITION.
* Added new flag ``retaining=False`` to the kinterbasdb and fdb dialects.Mike Bayer2013-06-301-12/+0
| | | | | | | This controls the value of the ``retaining`` flag sent to the ``commit()`` and ``rollback()`` methods of the DBAPI connection. Defaults to False. Also in 0.8.2, where it defaults to True. [ticket:2763]
* Type lookup when reflecting the Firebird types LONG andMike Bayer2013-06-281-7/+6
| | | | | | | | INT64 has been fixed so that LONG is treated as INTEGER, INT64 treated as BIGINT, unless the type has a "precision" in which case it's treated as NUMERIC. Patch courtesy Russell Stuart. [ticket:2757]
* - the raw 2to3 runMike Bayer2013-04-271-2/+2
| | | | - went through examples/ and cleaned out excess list() calls
* happy new year (see #2645)Diana Clarke2013-01-011-1/+1
|
* - recognize that do_rollback() and do_commit() work with a DBAPI connection,Mike Bayer2012-11-221-4/+4
| | | | | | | | | | | | | | | | | | whereas the other do_rollback_twophase(), savepoint etc. work with :class:`.Connection`. the context on these are different as twophase/savepoint are available at the :class:`.Connection` level, whereas commit/rollback are needed at a lower level as well. Rename the argument to "dbapi_connection" when the conneciton is in fact the DBAPI interface. - start thinking about being able to track "autocommit" vs. "commit", but not sure we have a need for this yet. - have Pool call out to a Dialect for all rollback/commit/close operations now. Pool no longer calls DBAPI methods directly. May use this for a workaround for [ticket:2611] - add a new Pool event reset() to allow the pool's reset of the connection to be intercepted. - remove methods in Informix dialect which appear to be hardcoding some isolation settings on new Transaction only; the isolation API should be implemented for Informix. also removed "flag" for transaction commit/rollback being not available; this should be based on server/DBAPI version and we will need someone with test access in order to help determine how this should work
* kill me now, pep8 pass, so closeDiana Clarke2012-11-201-1/+1
|
* just a pep8 passDiana Clarke2012-11-201-14/+13
|
* juts a 'expected 2 blank lines' pep8 passDiana Clarke2012-11-191-0/+2
|
* - rework the sphinx customizations into distinct modulesMike Bayer2012-10-191-11/+2
| | | | | | | - build a new Sphinx extension that allows dialect info to be entered as directives which is then rendered consistently throughout all dialect/dbapi sections - break out the "empty_strings" requirement for oracle test
* - move out maxdbMike Bayer2012-10-181-5/+14
| | | | | | - begin consolidating docs for dialects to be more self contained - add a separate section for "external" dialects - not sure how we're going to go with this yet.
* - fix fb function thing here, need **kw to break the loopMike Bayer2012-09-231-2/+2
|
* - got firebird runningMike Bayer2012-09-231-4/+20
| | | | | | | | | | | | - add some failure cases - [bug] Firebird now uses strict "ansi bind rules" so that bound parameters don't render in the columns clause of a statement - they render literally instead. - [bug] Support for passing datetime as date when using the DateTime type with Firebird; other dialects support this.
* - [bug] CompileError is raised when VARCHAR withMike Bayer2012-09-101-0/+4
| | | | | no length is attempted to be emitted, same way as MySQL. [ticket:2505]
* - [feature] Reworked the startswith(), endswith(),Mike Bayer2012-08-271-2/+18
| | | | | | | | | | | | contains() operators to do a better job with negation (NOT LIKE), and also to assemble them at compilation time so that their rendered SQL can be altered, such as in the case for Firebird STARTING WITH [ticket:2470] - [feature] firebird - The "startswith()" operator renders as "STARTING WITH", "~startswith()" renders as "NOT STARTING WITH", using FB's more efficient operator. [ticket:2470]
* - [feature] To complement [ticket:2547], typesMike Bayer2012-08-171-6/+2
| | | | | | | | | | | | | | | | can now provide "bind expressions" and "column expressions" which allow compile-time injection of SQL expressions into statements on a per-column or per-bind level. This is to suit the use case of a type which needs to augment bind- and result- behavior at the SQL level, as opposed to in the Python level. Allows for schemes like transparent encryption/ decryption, usage of Postgis functions, etc. [ticket:1534] - update postgis example fully. - still need to repair the result map propagation here to be transparent for cases like "labeled column".
* - update all the visit_mod() functions with new naming schemeMike Bayer2012-08-141-5/+3
| | | | | | - visit_mods all seemed to not propagate **kw down to process(). this is [ticket:2548] which may be backported to 0.7 pending a test case to illustrate wrong behavior.
* trailing whitespace bonanzaMike Bayer2012-07-281-9/+9
|
* deprecate inspector.get_primary_keys() in favor of inspector.get_pk_constraint()Diana Clarke2012-04-021-3/+4
| | | | - see #2422
* typoes in lib/sqlalchemy/dialectsDiana Clarke2012-03-171-2/+2
|
* - [bug] A significant change to how labelingMike Bayer2012-02-051-1/+1
| | | | | | | | | | | | | | is applied to columns in SELECT statements allows "truncated" labels, that is label names that are generated in Python which exceed the maximum identifier length (note this is configurable via label_length on create_engine()), to be properly referenced when rendered inside of a subquery, as well as to be present in a result set row using their original in-Python names. [ticket:2396] - apply pep8 to test_labels
* happy new yearMike Bayer2012-01-041-1/+1
|
* - Firebird - the "implicit_returning" flag on create_engine() isMike Bayer2011-03-161-3/+3
| | | | honored if set to False. [ticket:2083]
* - need to limit the list of oracle fn's that don't get parens to aMike Bayer2011-02-111-0/+4
| | | | fixed list. window functions need parens
* - Some adjustments so that Interbase is supported as well.Mike Bayer2011-02-011-3/+9
| | | | | | | | FB/Interbase version idents are parsed into a structure such as (8, 1, 1, 'interbase') or (2, 1, 588, 'firebird') so they can be distinguished. [ticket:1885] - fixed relfection of the "autoincrement" flag against a default placed on the column.
* Regarding reflection for this case, reflection of an int PK colMike Bayer2011-01-151-1/+2
| | | | | | with a server_default sets the "autoincrement" flag to False, except in the case of a PG SERIAL col where we detected a sequence default. [ticket:2020] [ticket:2021]
* - the _pk_processors/_prefetch_processors approach relied upon calling RPs ↵Mike Bayer2011-01-151-2/+2
| | | | | | | | without a cursor.description result, also generates procs that are not used in most cases. simplify the approach by passing type to _exec_default() to be used if needed by _execute_scalar(), looking for the proc on just t._autoincrement_column in post_insert().
* - A TypeDecorator of Integer can be used with a primary keyMike Bayer2011-01-111-2/+3
| | | | | | | | | | | | | | | | | | | column, and the "autoincrement" feature of various dialects as well as the "sqlite_autoincrement" flag will honor the underlying database type as being Integer-based. [ticket:2005] - Result-row processors are applied to pre-executed SQL defaults, as well as cursor.lastrowid, when determining the contents of result.inserted_primary_key. [ticket:2006] - Bind parameters present in the "columns clause" of a select are now auto-labeled like other "anonymous" clauses, which among other things allows their "type" to be meaningful when the row is fetched, as in result row processors. - TypeDecorator is present in the "sqlalchemy" import space.
* - Firebird numeric type now checks for Decimal explicitly,Mike Bayer2011-01-031-1/+1
| | | | | lets float() pass right through, thereby allowing special values such as float('inf'). [ticket:2012]
* - whitespace removal bonanzaMike Bayer2011-01-021-1/+1
|
* - clean up copyright, update for 2011, stamp every file withMike Bayer2011-01-021-2/+2
| | | | | a consistent tag - AUTHORS file
* merge tipMike Bayer2010-09-191-1/+2
|\
| * - Fixed FB bug whereby a column default would fail toMike Bayer2010-09-061-1/+2
| | | | | | | | reflect if the "default" keyword were lower case.
* | - move LIMIT/OFFSET rendering to be as bind parameters, for all backendsMike Bayer2010-08-291-2/+2
|/ | | | | | | | | | which support it. This includes SQLite, MySQL, Postgresql, Firebird, Oracle (already used binds with ROW NUMBER OVER), MSSQL (when ROW NUMBER is used, not TOP). Not included are Informix, Sybase, MaxDB, Access [ticket:805] - LIMIT/OFFSET parameters need to stay as literals within SQL constructs. This because they may not be renderable as binds on some backends.
* - idle 78-char adjustmentsMike Bayer2010-07-031-32/+63
|
* - Firebird dialect adds CHAR, VARCHAR types whichMike Bayer2010-06-191-2/+39
| | | | | accept a "charset" flag, to support Firebird "CHARACTER SET" clause. [ticket:1813]
* - Fixed incorrect signature in do_execute() for firebird, access, errorMike Bayer2010-06-091-1/+1
| | | | introduced in 0.6.1. [ticket:1823]
* - Added a label to the query used within has_table() andMike Bayer2010-04-261-2/+2
| | | | | has_sequence() to work with older versions of Firebird that don't provide labels for result columns. [ticket:1521]
* removed all dialect table_names() methods and standardizedMike Bayer2010-03-191-5/+2
| | | | on get_table_names(). [ticket:1739]
* - moved most Decimal bind/result handling into types.py, out of sqlite, ↵Mike Bayer2010-03-181-1/+1
| | | | | | | mysql dialects. - added an explicit test for [ticket:1216] - some questions remain about MSSQL - would like to simplify/remove bind handling for numerics
* Fix #1663: the whitespace after DEFAULT may start with a newlineLele Gaifax2010-01-281-9/+10
|
* - oracle + firebird: "case sensitivity" feature will detect an all-lowercaseMike Bayer2010-01-241-1/+5
| | | | | | case-sensitive column name during reflect and add "quote=True" to the generated Column, so that proper quoting is maintained.
* happy new yearMike Bayer2010-01-071-1/+1
|
* - The Boolean type, when used on a backend that doesn'tMike Bayer2009-12-061-23/+4
| | | | | | | | | | have native boolean support, will generate a CHECK constraint "col IN (0, 1)" along with the int/smallint- based column type. This can be switched off if desired with create_constraint=False. Note that MySQL has no native boolean *or* CHECK constraint support so this feature isn't available on that platform. [ticket:1589]
* - pg8000 + postgresql dialects now check for float/numeric returnMike Bayer2009-11-151-1/+1
| | | | | | | | | | types to more intelligently determine float() vs. Decimal(), [ticket:1567] - since result processing is a hot issue of late, the DBAPI type returned from cursor.description is certainly useful in cases like these to determine an efficient result processor. There's likely other result processors that can make use of it. But, backwards incompat change to result_processor(). Happy major version number..
* - The "start" and "increment" attributes on Sequence nowMike Bayer2009-11-031-1/+8
| | | | | | generate "START WITH" and "INCREMENT BY" by default, on Oracle and Postgresql. Firebird doesn't support these keywords right now. [ticket:1545]
View Lorry Controller Status