summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/firebird.py
Commit message (Collapse)AuthorAgeFilesLines
* - added "schema" argument to all has_table() calls, only supported so far by PGMike Bayer2007-02-041-1/+1
| | | | - added basic unit test for PG reflection of tables in an alternate schema
* copyright updateMike Bayer2007-01-051-1/+1
|
* - Firebird fix to autoload multifield foreign keys [ticket:409]Mike Bayer2007-01-031-52/+70
| | | | - Firebird NUMERIC type properly handles a type without precision [ticket:409]
* various huge fixes from [ticket:330], thanks to Lele GaifaxMike Bayer2006-10-191-16/+48
|
* - a fair amount of cleanup to the schema package, removal of ambiguousMike Bayer2006-10-141-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | methods, methods that are no longer needed. slightly more constrained useage, greater emphasis on explicitness. - table_iterator signature fixup, includes fix for [ticket:288] - the "primary_key" attribute of Table and other selectables becomes a setlike ColumnCollection object; is no longer ordered or numerically indexed. a comparison clause between two pks that are derived from the same underlying tables (i.e. such as two Alias objects) can be generated via table1.primary_key==table2.primary_key - append_item() methods removed from Table and Column; preferably construct Table/Column/related objects inline, but if needed use append_column(), append_foreign_key(), append_constraint(), etc. - table.create() no longer returns the Table object, instead has no return value. the usual case is that tables are created via metadata, which is preferable since it will handle table dependencies. - added UniqueConstraint (goes at Table level), CheckConstraint (goes at Table or Column level) fixes [ticket:217] - index=False/unique=True on Column now creates a UniqueConstraint, index=True/unique=False creates a plain Index, index=True/unique=True on Column creates a unique Index. 'index' and 'unique' keyword arguments to column are now boolean only; for explcit names and groupings of indexes or unique constraints, use the UniqueConstraint/Index constructs explicitly. - relationship of Metadata/Table/SchemaGenerator/Dropper has been improved so that the schemavisitor receives the metadata object for greater control over groupings of creates/drops. - added "use_alter" argument to ForeignKey, ForeignKeyConstraint, but it doesnt do anything yet. will utilize new generator/dropper behavior to implement.
* - remove spurious semicomma from Firebird SQL statement (Lele Gaifax)Mike Bayer2006-10-131-2/+2
|
* some cleanup submitted by Lele GalifaxMike Bayer2006-10-131-6/+0
|
* assorted firebird fixes from Lele GaifaxMike Bayer2006-10-071-4/+14
|
* - postgres reflection moved to use pg_schema tables, can be overriddenMike Bayer2006-08-211-3/+3
| | | | | | | | with use_information_schema=True argument to create_engine [ticket:60], [ticket:71] - added natural_case argument to Table, Column, semi-experimental flag for use with table reflection to help with quoting rules [ticket:155]
* [ticket:268]Mike Bayer2006-08-121-17/+69
|
* quoting facilities set up so that database-specific quoting can beMike Bayer2006-08-121-2/+8
| | | | | | | turned on for individual table, schema, and column identifiers when used in all queries/creates/drops. Enabled via "quote=True" in Table or Column, as well as "quote_schema=True" in Table. Thanks to Aaron Spike for his excellent efforts. [ticket:155]
* [ticket:256] propigating url.query arguments to connect() function for all db'sMike Bayer2006-07-251-0/+4
|
* overhaul to schema, addition of ForeignKeyConstraint/Mike Bayer2006-07-141-5/+1
| | | | | | | | PrimaryKeyConstraint objects (also UniqueConstraint not completed yet). table creation and reflection modified to be more oriented towards these new table-level objects. reflection for sqlite/postgres/mysql supports composite foreign keys; oracle/mssql/firebird not converted yet.
* ordering of UPDATE and DELETE statements within groups is nowMike Bayer2006-07-031-1/+1
| | | | | | | in order of primary key values, for more deterministic ordering after_insert/delete/update mapper extensions now called per object, not per-object-per-table fixed import in firebird.py
* firebird patch with support for type_convMike Bayer2006-06-281-8/+16
|
* added "NonExistentTable" exception throw to reflection, courtesy ↵Mike Bayer2006-06-061-0/+5
| | | | lbruno@republico.estv.ipv.pt, for [ticket:138]
* adjustment to datetimeMike Bayer2006-06-021-1/+4
|
* brad clement's 0.2 firebird support !Mike Bayer2006-06-011-70/+112
|
* merged 0.2 branch into trunk; 0.1 now in sqlalchemy/branches/rel_0_1Mike Bayer2006-05-251-19/+22
|
* Implemented the changes from ticket 94jralston2006-05-231-22/+19
|
* moves the binding of a TypeEngine object from "schema/statement creation" ↵Mike Bayer2006-04-061-1/+1
| | | | time into "compilation" time
* refactor to Compiled.get_params() to return new ClauseParameters object, a ↵Mike Bayer2006-03-131-13/+2
| | | | | | | | | | | more intelligent bind parameter dictionary that does type conversions late and preserves the unconverted value; used to fix mappers not comparing correct value in post-fetch [ticket:110] removed pre_exec assertion from oracle/firebird regarding "check for sequence/primary key value" fix to Unicode type to check for null, fixes [ticket:109] create_engine() now uses genericized parameters; host/hostname, db/dbname/database, password/passwd, etc. for all engine connections fix to select([func(column)]) so that it creates a FROM clause to the column's table, fixes [ticket:111] doc updates for column defaults, indexes, connection pooling, engine params unit tests for the above bugfixes
* removed the dependency of ANSICompiler on SQLEngine. you can now make ↵Mike Bayer2006-03-041-1/+1
| | | | ANSICompilers and compile SQL with no engine at all.
* firebird module initial checkinMike Bayer2006-03-041-0/+282