summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/postgres.py
Commit message (Collapse)AuthorAgeFilesLines
...
* - column labels are now generated in the compilation phase, whichMike Bayer2007-03-241-0/+3
| | | | | | | | | | | | | | | means their lengths are dialect-dependent. So on oracle a label that gets truncated to 30 chars will go out to 63 characters on postgres. Also, the true labelname is always attached as the accessor on the parent Selectable so theres no need to be aware of the genrerated label names [ticket:512]. - ResultProxy column targeting is greatly simplified, and relies upon the ANSICompiler's column_labels map to translate the built-in label on a _ColumnClause (which is now considered to be a unique identifier of that column) to the label which was generated at compile time. - still need to put a baseline of ColumnClause targeting for ResultProxy objects that originated from a textual query.
* various cleanup, docs and things, getting ready for 0.3.6Mike Bayer2007-03-231-1/+1
|
* - added db modules to genned docstringsMike Bayer2007-03-181-5/+4
| | | | | | | - had to tweak out latest MS-SQL module change. cant do ImportErrors right now until module importing is moved to the connection phase across all dialects. - took out "his" from url docstrings - postgres doesnt do an import *
* migrated (most) docstrings to pep-257 format, docstring generator using ↵Mike Bayer2007-02-251-44/+71
| | | | | | straight <pre> + trim() func for now. applies most of [ticket:214], compliemnts of Lele Gaifax
* added PGInet type [ticket:444]Mike Bayer2007-02-171-0/+5
|
* - added PGInterval type [ticket:460]Mike Bayer2007-02-061-1/+5
|
* - sequences on a non-pk column will properly fire off on INSERT for PG/oracleMike Bayer2007-02-021-4/+6
|
* added regexp search for "schema" in sequence reflection for [ticket:442], ↵Mike Bayer2007-01-281-0/+6
| | | | courtesy david.mugnai@spacespa.it
* oracle can conditionally decide if it wants to say "use rowid" in a select ↵Mike Bayer2007-01-241-1/+1
| | | | | | | statement. needs to be tweaked vs. when ROW NUMBER OVER ORDER BY is being used, but currently fixes [ticket:436]
* has_table wasnt handling case-sensitive table namesMike Bayer2007-01-191-2/+2
|
* - fix to the initial checkfirst for tables to take current schema into ↵Mike Bayer2007-01-171-3/+6
| | | | account [ticket:424]
* - postgres cursor option is now server_side_cursors=False; some users get ↵Mike Bayer2007-01-141-6/+5
| | | | | | | | | bad results using them so theyre off by default - type system slightly modified to support TypeDecorators that can be overridden by the dialect - added an NVarchar type to mssql (produces NVARCHAR), also MSUnicode which provides Unicode-translation for the NVarchar regardless of dialect convert_unicode setting.
* - postgres no longer uses client-side cursors, uses more efficient server sideMike Bayer2007-01-101-3/+12
| | | | | cursors via apparently undocumented psycopg2 behavior recently discovered on the mailing list. disable it via create_engine('postgres://', client_side_cursors=True)
* copyright updateMike Bayer2007-01-051-1/+1
|
* - fixes to postgres reflection to better handle when schema names are present;Mike Bayer2006-12-241-53/+34
| | | | thanks to jason (at) ncsmags.com [ticket:402]
* - added "BIGSERIAL" support for postgres table with PGBigInteger/autoincrementMike Bayer2006-12-151-1/+4
|
* PGBigInteger subclasses PGInteger so it gets usedMike Bayer2006-12-151-1/+1
|
* - support for None as precision/length in numeric types for postgres, ↵Mike Bayer2006-12-091-21/+25
| | | | | | sqlite, mysql - postgres reflection fixes: [ticket:349] [ticket:382]
* - fix to postgres sequence quoting when using schemasMike Bayer2006-10-301-1/+1
|
* converted imports to absoluteMike Bayer2006-10-261-1/+1
|
* fixed pg reflection of timezonesMike Bayer2006-10-201-2/+8
|
* - a fair amount of cleanup to the schema package, removal of ambiguousMike Bayer2006-10-141-5/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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.
* some cleanup submitted by Lele GalifaxMike Bayer2006-10-131-4/+0
|
* added PGBigInteger typeMike Bayer2006-10-111-1/+4
|
* - the "foreign_key" attribute on Column and ColumnElement in generalMike Bayer2006-10-081-1/+1
| | | | | | | | | is deprecated, in favor of the "foreign_keys" list/set-based attribute, which takes into account multiple foreign keys on one column. "foreign_key" will return the first element in the "foreign_keys" list/set or None if the list is empty. - added a user test to the relationships test, testing various new things this change allows
* - added autoincrement=True to Column; will disable schema generationMike Bayer2006-09-231-2/+2
| | | | | of SERIAL/AUTO_INCREMENT/identity seq for postgres/mysql/mssql if explicitly set to False. #303
* no SERIAL for smallinteger columnsMike Bayer2006-09-191-1/+1
|
* since casing is figured out quasi-automatically when creating table/column/etc,Mike Bayer2006-08-311-9/+3
| | | | removed casing checks within pg reflection
* pg formats sequence name, more quote test fixesMike Bayer2006-08-311-1/+1
|
* - added case_sensitive argument to MetaData, Table, Column, determinesMike Bayer2006-08-311-16/+5
| | | | | | | | | | | | itself automatically based on if a parent schemaitem has a non-None setting for the flag, or if not, then whether the identifier name is all lower case or not. when set to True, quoting is applied to identifiers with mixed or uppercase identifiers. quoting is also applied automatically in all cases to identifiers that are known to be reserved words or contain other non-standard characters. various database dialects can override all of this behavior, but currently they are all using the default behavior. tested with postgres, mysql, sqlite. needs more testing with firebird, oracle, ms-sql. part of the ongoing work with [ticket:155]
* - added "timezone=True" flag to DateTime and Time types. postgresMike Bayer2006-08-261-4/+4
| | | | | | | | so far will convert this to "TIME[STAMP] (WITH|WITHOUT) TIME ZONE", so that control over timezone presence is more controllable (psycopg2 returns datetimes with tzinfo's if available, which can create confusion against datetimes that dont). [ticket:275]
* working on sequence quoting support....Mike Bayer2006-08-211-1/+3
|
* postgres reflection uses dialect-wide preparerMike Bayer2006-08-211-1/+1
|
* - postgres reflection moved to use pg_schema tables, can be overriddenMike Bayer2006-08-211-4/+176
| | | | | | | | 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:277] check if pg/oracle sequence exists. checks in all cases before ↵Mike Bayer2006-08-161-2/+7
| | | | CREATE SEQUENCE/ DROP SEQUENCE
* quoting facilities set up so that database-specific quoting can beMike Bayer2006-08-121-1/+7
| | | | | | | 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/+1
|
* 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.
* dont put SERIAL on a column if it has a ForeignKeyMike Bayer2006-06-261-1/+1
|
* dbengine doc: no support for pg1Mike Bayer2006-06-031-2/+4
| | | | postgres: if module is none, still use pyformat for some unit tests
* merged 0.2 branch into trunk; 0.1 now in sqlalchemy/branches/rel_0_1Mike Bayer2006-05-251-68/+66
|
* gambit's patch to add DISTINCT ONMike Bayer2006-05-021-0/+14
|
* fix for [ticket:169], moves the creation of "default" parameters more accuratelyMike Bayer2006-04-281-2/+2
| | | | where theyre supposed to be
* added patch for mxDateTime support, [ticket:5], courtesy jkakar@kakar.caMike Bayer2006-04-111-5/+22
|
* 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-1/+1
| | | | | | | | | | | 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
* got column onupdate workingMike Bayer2006-03-051-16/+0
| | | | improvement to Function so that they can more easily be called standalone without having to throw them into a select().
* making sequences, column defaults independently executeableMike Bayer2006-03-041-2/+2
|
* 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.
* made SchemaEngine more prominent as the base of Table associationMike Bayer2006-03-011-2/+4
| | | | | | | | | BaseProxyEngine descends from SchemaEngine fixes to sqlite/postgres reflection to use the correct engine for table lookups Table engine can be none which will default to schema.default_engine (although its still positional for now, so still needs to be explicit to make room for Columns) __init__ sets default_engine to be a blank ProxyEngine fixes to test suite to allow --db proxy.<dbname> to really test proxyengine
View Lorry Controller Status