summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/postgres.py
Commit message (Collapse)AuthorAgeFilesLines
* Added new basic match() operator that performs a full-text search. Supported ↵Michael Trier2008-07-131-0/+1
| | | | on PostgreSQL, SQLite, MySQL, MS-SQL, and Oracle backends.
* - re-fixed the fix to the prefixes fixMike Bayer2008-07-061-10/+1
| | | | | - removed ancient descriptor() functions from dialects; replaced with Dialect.name - removed similarly ancient sys.modules silliness in Engine.name
* Added PGCidr type to postgres. Closes #1092Michael Trier2008-07-031-0/+5
| | | | (cherry picked from commit 2394a6bb6c5f77afd448640ce03cf6fda0335a23)
* merged r4870 from 0.4 branch, index name truncation, [ticket:820]Mike Bayer2008-06-221-1/+1
|
* merged r4857, postgres server_side_cursors fix, from 0.4 branchMike Bayer2008-06-171-1/+4
|
* restored a "distinct" setting that got whackedMike Bayer2008-06-091-1/+1
|
* merged merge fix from r4834/rel_0_4 branchMike Bayer2008-06-031-1/+1
|
* Columns now have default= and server_default=. PassiveDefault fades away.Jason Kirtland2008-05-141-3/+4
|
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-12/+18
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* refactor of default_paramstyle, use paramstyle argument on Dialect to changeMatt Harrison2008-04-071-2/+2
|
* - Got PG server side cursors back into shape, added fixedMike Bayer2008-04-021-9/+14
| | | | | | | unit tests as part of the default test suite. Added better uniqueness to the cursor ID [ticket:1001] - update().values() and insert().values() take keyword arguments.
* - Revamped the Connection memoize decorator a bit, moved to engineJason Kirtland2008-04-021-2/+2
| | | | | - MySQL character set caching is more aggressive but will invalidate the cache if a SET is issued. - MySQL connection memos are namespaced: info[('mysql', 'server_variable')]
* - reverted previous "strings instead of tuples" change due to more specific ↵Mike Bayer2008-03-301-2/+3
| | | | | | test results showing tuples faster - changed cache decorator call on default_schema_name call to a connection.info specific one
* some cache decorator calls...Mike Bayer2008-03-301-4/+3
|
* - like() and ilike() take an optional keyword argumentMike Bayer2008-03-191-2/+2
| | | | | | "escape=<somestring>", which is set as the escape character using the syntax "x LIKE y ESCAPE '<somestring>'" [ticket:993]
* check for NoneMike Bayer2008-03-041-1/+3
|
* - postgres PGArray is a "mutable" type by default;Mike Bayer2008-03-041-2/+15
| | | | | when used with the ORM, mutable-style equality/ copy-on-write techniques are used to test for changes.
* - postgres TIMESTAMP renders correctly [ticket:981]Mike Bayer2008-02-271-0/+7
|
* - added exception wrapping/reconnect support to result setMike Bayer2008-02-251-1/+1
| | | | | | fetching. Reconnect works for those databases that raise a catchable data error during results (i.e. doesn't work on MySQL) [ticket:978]
* - Oracle and others properly encode SQL used for defaultsMike Bayer2008-01-301-1/+1
| | | | | | like sequences, etc., even if no unicode idents are used since identifier preparer may return a cached unicode identifier.
* fixed NOT ILIKEMike Bayer2008-01-111-1/+2
|
* - added "ilike()" operator to column operations.Mike Bayer2008-01-111-1/+2
| | | | | compiles to ILIKE on postgres, lower(x) LIKE lower(y) on all others [ticket:727]
* - Warnings are now issued as SAWarning instead of RuntimeWarning; ↵Jason Kirtland2008-01-111-2/+3
| | | | | | util.warn() wraps this up. - SADeprecationWarning has moved to exceptions. An alias remains in logging until 0.5.
* Include column name in length-less String warning (more [ticket:912])Jason Kirtland2008-01-101-28/+28
|
* - finally added PGMacAddr type to postgresMike Bayer2008-01-101-0/+5
| | | | [ticket:580]
* redid the _for_ddl String/Text deprecation warning correctly [ticket:912]Mike Bayer2008-01-091-2/+2
|
* - changed name of TEXT to Text since its a "generic" type; TEXT name isMike Bayer2008-01-051-2/+2
| | | | | | | deprecated until 0.5. The "upgrading" behavior of String to Text when no length is present is also deprecated until 0.5; will issue a warning when used for CREATE TABLE statements (String with no length for SQL expression purposes is still fine) [ticket:912]
* fix not calling the result processor of PGArray subtypes. (a rather ↵Ants Aasma2008-01-031-1/+1
| | | | embarrasing copypaste error) [ticket:913]
* happy new yearMike Bayer2008-01-011-1/+1
|
* fixed reflection of unicode, [ticket:881]Mike Bayer2007-11-271-6/+9
|
* - named_with_column becomes an attributeMike Bayer2007-11-251-5/+13
| | | | | | | | | - cleanup within compiler visit_select(), column labeling - is_select() removed from dialects, replaced with returns_rows_text(), returns_rows_compiled() - should_autocommit() removed from dialects, replaced with should_autocommit_text() and should_autocommit_compiled() - typemap and column_labels collections removed from Compiler, replaced with single "result_map" collection. - ResultProxy uses more succinct logic in combination with result_map to target columns
* - anonymous column expressions are automatically labeled.Mike Bayer2007-11-101-1/+1
| | | | | | | | | | | | | | | | | | | e.g. select([x* 5]) produces "SELECT x * 5 AS anon_1". This allows the labelname to be present in the cursor.description which can then be appropriately matched to result-column processing rules. (we can't reliably use positional tracking for result-column matches since text() expressions may represent multiple columns). - operator overloading is now controlled by TypeEngine objects - the one built-in operator overload so far is String types overloading '+' to be the string concatenation operator. User-defined types can also define their own operator overloading by overriding the adapt_operator(self, op) method. - untyped bind parameters on the right side of a binary expression will be assigned the type of the left side of the operation, to better enable the appropriate bind parameter processing to take effect [ticket:819]
* - inlined a couple of context variablesMike Bayer2007-10-271-3/+3
| | | | - PG two phase was calling text() without the correct bind param format, previous compiler checkin revealed issue
* - removed regular expression step from most statement compilations.Mike Bayer2007-10-271-14/+18
| | | | | | also fixes [ticket:833] - inlining on PG with_returning() call - extra options added for profiling
* Added support for dialects that have both sequences and autoincrementing PKs.Jason Kirtland2007-10-231-1/+2
|
* - PG reflection, upon seeing the default schema name being used explicitlyMike Bayer2007-10-141-0/+5
| | | | | | | | | as the "schema" argument in a Table, will assume that this is the the user's desired convention, and will explicitly set the "schema" argument in foreign-key-related reflected tables, thus making them match only with Table constructors that also use the explicit "schema" argument (even though its the default schema). In other words, SA assumes the user is being consistent in this usage.
* Snipped another generator expression.Jason Kirtland2007-10-131-1/+2
|
* make two-phase transactions work a bit better by letting psycopg do whatever ↵Ants Aasma2007-10-101-0/+2
| | | | | | it does for implicit transaction starts
* - a better fix for [ticket:810]. The cause was two phase commit/rollback not ↵Ants Aasma2007-10-081-3/+2
| | | | opening a new transaction as the dbapi implementations do.
* - fix multiple consequent two phase transactions not working with postgres. ↵Ants Aasma2007-10-081-0/+3
| | | | | | For some reason implicit transactions are not enough. [ticket:810] - add an option to scoped session mapper extension to not automatically save new objects to session.
* - move PG RETURNING tests to postgres dialect testMike Bayer2007-10-041-0/+7
| | | | | - added server_version_info() support for PG dialect - exclude PG versions < 8.4 for RETURNING tests
* Made the regexp detecting the returning token more readable and fixed a ↵Ants Aasma2007-10-031-2/+13
| | | | couple of corner cases
* add support for returning results from inserts and updates for postgresql ↵Ants Aasma2007-10-021-3/+47
| | | | 8.2+. [ticket:797]
* removed unused _fold_identifier_case methodMike Bayer2007-10-021-3/+0
|
* Make the postgres_where attribute to Index private to postgres module by ↵Ants Aasma2007-10-011-2/+11
| | | | using a kwargs attribute on the Index.
* - added partial index support for postgresAnts Aasma2007-09-291-1/+17
| | | | - fixed create and drop methods on MockConnection
* - adjust server side logic to work with standalone default executionMike Bayer2007-09-271-5/+9
| | | | - a little bit of inlining of same
* - added "FETCH" to the keywords detected by Postgres to indicate a ↵Mike Bayer2007-09-261-0/+7
| | | | | | result-row holding statement (i.e. in addition to "SELECT").
* sequence pre-executes dont create an ExecutionContext, use straight cursorMike Bayer2007-09-011-4/+4
|
* factored out uses_sequences_for_inserts() intoMike Bayer2007-09-011-3/+1
| | | | preexecute_sequence dialect attribute
View Lorry Controller Status