summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/firebird
Commit message (Collapse)AuthorAgeFilesLines
...
* - 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.
* - The "asdecimal" flag used with the :class:`.Float` type will nowMike Bayer2013-12-271-1/+8
| | | | | | work with Firebird dialects; previously the decimal conversion was not occurring. - scale back some firebird FP numeric tests
* Added new flag ``retaining=False`` to the kinterbasdb and fdb dialects.Mike Bayer2013-06-303-46/+83
| | | | | | | 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]
* - fdb is now official, [ticket:2504]Mike Bayer2013-06-032-5/+5
| | | | | - restore the rollback cleanup handler, pg8000 is mostly obsolete as a dialect and the firebird drivers need it
* - the raw 2to3 runMike Bayer2013-04-271-2/+2
| | | | - went through examples/ and cleaned out excess list() calls
* - remove all compat items that are pre-2.5 (hooray)Mike Bayer2013-03-091-1/+1
| | | | | | - other cleanup - don't need compat.decimal, that approach never panned out. hopefully outside libs aren't pulling it in, they shouldn't be
* formattingMike Bayer2013-02-021-1/+2
|
* happy new year (see #2645)Diana Clarke2013-01-014-4/+4
|
* Added missing import for "fdb" to the experimentalMike Bayer2012-11-291-1/+1
| | | | "firebird+fdb" dialect. [ticket:2622]
* - 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-203-4/+2
|
* just a pep8 passDiana Clarke2012-11-202-15/+14
|
* juts a 'expected 2 blank lines' pep8 passDiana Clarke2012-11-193-0/+5
|
* - rework the sphinx customizations into distinct modulesMike Bayer2012-10-193-36/+14
| | | | | | | - 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-183-11/+28
| | | | | | - 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
|
* - [feature] An experimental dialect for the fdbMike Bayer2012-09-232-10/+82
| | | | | driver is added, but is untested as I cannot get the fdb package to build. [ticket:2504]
* - 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.
* -whitespace bonanza, contdMike Bayer2012-07-281-1/+1
|
* trailing whitespace bonanzaMike Bayer2012-07-282-21/+21
|
* 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-043-3/+3
|
* - 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
* - add connection and cursor to is_disconnect(). We aren't using it yet,Mike Bayer2011-02-091-1/+1
| | | | | | | | | | | | | | | but we'd like to. Most DBAPIs don't give us anything we can do with it. Some research was done on psycopg2 and it still seems like they give us no adequate method (tried connection.closed, cursor.closed, connection.status). mxodbc claims their .closed attribute will work (but I am skeptical). - remove beahvior in pool that auto-invalidated a connection when the cursor failed to create. That's not the pool's job. we need the conn for the error logic. Can't get any tests to fail, curious why that behavior was there, guess we'll find out (or not). - add support for psycopg2 version detection. even though we have no use for it yet... - adjust one of the reconnect tests to work with oracle's horrendously slow connect speed
* - Some adjustments so that Interbase is supported as well.Mike Bayer2011-02-012-9/+22
| | | | | | | | 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-032-3/+4
| | | | | lets float() pass right through, thereby allowing special values such as float('inf'). [ticket:2012]
* - whitespace removal bonanzaMike Bayer2011-01-023-16/+16
|
* - clean up copyright, update for 2011, stamp every file withMike Bayer2011-01-023-4/+10
| | | | | 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-032-44/+82
|
* - 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 'connection shutdown' to the list of exception stringsMike Bayer2010-05-081-1/+2
| | | | which indicate a dropped connection. [ticket:1646]
* - Added integer coercion to the "type_conv" attribute whenMike Bayer2010-04-261-2/+4
| | | | | passed via query string, so that it is properly interpreted by Kinterbasdb. [ticket:1779]
* - 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]
* further testing reveals that cursor.rowcount is only called with ↵Mike Bayer2010-04-121-10/+14
| | | | | | | | | update/delete and DDL, and also that FB's cursor.rowcount is a little expensive, but not dramatically. added a test to ensure cursor.rowcount is only called on update/delete. the current default for firebird enable_rowcount is now True, leaving all the options to turn it off etc..
* - The functionality of result.rowcount is now disabledMike Bayer2010-04-111-9/+34
| | | | | | | | | by default, and can be re-enabled using the 'enable_rowcount' flag with create_engine(), as well as the 'enable_rowcount' execution context flag on a per-execute basis. This because cursor.rowcount requires cursor access (can't be evaluated lazily since the result auto-closes) and also incurs an expensive round-trip.
View Lorry Controller Status