summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/firebird.py
Commit message (Collapse)AuthorAgeFilesLines
...
* adjusting firebird, obviously needs someone to testMike Bayer2007-09-011-5/+4
|
* factored out uses_sequences_for_inserts() intoMike Bayer2007-09-011-3/+1
| | | | preexecute_sequence dialect attribute
* - got all examples workingMike Bayer2007-09-011-1/+4
| | | | | | | - inline default execution occurs for *all* non-PK columns unconditionally - preexecute only for non-executemany PK cols on PG, Oracle, etc. - new default docs
* engine.url cleanups [ticket:742]Jason Kirtland2007-08-291-1/+1
| | | | | | - translate_connect_args can now take kw args or the classic list - in-tree dialects updated to supply their overrides as keywords - tweaked url parsing in the spirit of the #742 patch, more or less
* - method call removalMike Bayer2007-08-201-9/+5
|
* 1. Module layout. sql.py and related move into a package called "sql".Mike Bayer2007-08-181-25/+17
| | | | | | | | | | | | 2. compiler names changed to be less verbose, unused classes removed. 3. Methods on Dialect which return compilers, schema generators, identifier preparers have changed to direct class references, typically on the Dialect class itself or optionally as attributes on an individual Dialect instance if conditional behavior is needed. This takes away the need for Dialect subclasses to know how to instantiate these objects, and also reduces method overhead by one call for each one. 4. as a result of 3., some internal signatures have changed for things like compiler() (now statement_compiler()), preparer(), etc., mostly in that the dialect needs to be passed explicitly as the first argument (since they are just class references now). The compiler() method on Engine and Connection is now also named statement_compiler(), but as before does not take the dialect as an argument. 5. changed _process_row function on RowProxy to be a class reference, cuts out 50K method calls from insertspeed.py
* switch (simple) occurences of 'if len(x)' to 'if x': find . -name '*.py' ↵Jonathan Ellis2007-08-031-1/+1
| | | | |xargs perl -pi.bak -e 's/if len\((\S+)\):/if $1:/' && find . -name '*.bak' |xargs rm
* engine.table_names()Jonathan Ellis2007-07-291-0/+4
| | | | tested vs sqlite and pg. mssql should also be ok (uses ischema like pg.) others are best-guess based on has_table code.
* merging 0.4 branch to trunk. see CHANGES for details. 0.3 moves to ↵Mike Bayer2007-07-271-26/+31
| | | | maintenance branch in branches/rel_0_3.
* - some execution fixesMike Bayer2007-05-301-13/+5
|
* turned off supports_sane_rowcount until someone wants to fix #370Mike Bayer2007-05-251-1/+1
|
* - set max identifier length to 31Mike Bayer2007-05-081-0/+3
|
* added "is_disconnect()" for firebirdMike Bayer2007-04-181-0/+6
|
* - the dialects within sqlalchemy.databases become a setuptoolsMike Bayer2007-04-171-3/+5
| | | | | | entry points. loading the built-in database dialects works the same as always, but if none found will fall back to trying pkg_resources to load an external module [ticket:521]
* - merged the "execcontext" branch, refactors engine/dialect codepathsMike Bayer2007-04-021-50/+23
| | | | | | | | | | | | | | | | | | | | - much more functionality moved into ExecutionContext, which impacted the API used by dialects to some degree - ResultProxy and subclasses now designed sanely - merged patch for #522, Unicode subclasses String directly, MSNVarchar implements for MS-SQL, removed MSUnicode. - String moves its "VARCHAR"/"TEXT" switchy thing into "get_search_list()" function, which VARCHAR and CHAR can override to not return TEXT in any case (didnt do the latter yet) - implements server side cursors for postgres, unit tests, #514 - includes overhaul of dbapi import strategy #480, all dbapi importing happens in dialect method "dbapi()", is only called inside of create_engine() for default and threadlocal strategies. Dialect subclasses have a datamember "dbapi" referencing the loaded module which may be None. - added "mock" engine strategy, doesnt require DBAPI module and gives you a "Connecition" which just sends all executes to a callable. can be used to create string output of create_all()/drop_all().
* migrated (most) docstrings to pep-257 format, docstring generator using ↵Mike Bayer2007-02-251-6/+12
| | | | | | straight <pre> + trim() func for now. applies most of [ticket:214], compliemnts of Lele Gaifax
* - 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
View Lorry Controller Status