summaryrefslogtreecommitdiff
path: root/test/dialect/postgres.py
Commit message (Collapse)AuthorAgeFilesLines
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-1025/+0
| | | | | See README.unittests for information on how to run the tests. [ticket:970]
* - added unit test for exception formattingMike Bayer2009-05-261-0/+2
| | | | | | | | | | - Deprecated the hardcoded TIMESTAMP function, which when used as func.TIMESTAMP(value) would render "TIMESTAMP value". This breaks on some platforms as Postgres doesn't allow bind parameters to be used in this context. The hard-coded uppercase is also inappropriate and there's lots of other PG casts that we'd need to support. So instead, use text constructs i.e. select(["timestamp '12/05/09'"]).
* extract() is now dialect-sensitive and supports SQLite and others.Jason Kirtland2009-03-301-0/+12
|
* - Added PGUuid and PGBit types toMike Bayer2009-03-011-5/+58
| | | | | | | | | sqlalchemy.databases.postgres. [ticket:1327] - Refection of unknown PG types won't crash when those types are specified within a domain. [ticket:1327] - executemany() in conjunction with INSERT..RETURNING is documented as undefined by psycopg2.
* - PG Index reflection won't fail when an index withMike Bayer2009-02-031-1/+10
| | | | multiple expressions is encountered.
* more session updatesMike Bayer2009-01-171-6/+6
|
* - Added Index reflection support to Postgres, using aMike Bayer2008-12-231-0/+48
| | | | | great patch we long neglected, submitted by Ken Kuhlman. [ticket:714]
* remove errant pdb.set_trace()Mike Bayer2008-11-111-3/+0
|
* Quashed import sets deprecation warning on 2.6.. not wild about this but it ↵Jason Kirtland2008-11-101-1/+3
| | | | seems like it will be ok. [ticket:1209]
* Tiny fix to test setup logic.Jason Kirtland2008-11-041-6/+7
|
* Added new basic match() operator that performs a full-text search. Supported ↵Michael Trier2008-07-131-0/+75
| | | | on PostgreSQL, SQLite, MySQL, MS-SQL, and Oracle backends.
* test coverage for server side statement detectionMike Bayer2008-06-171-0/+10
|
* Columns now have default= and server_default=. PassiveDefault fades away.Jason Kirtland2008-05-141-30/+30
|
* Test suite modernization in progress. Big changes:Jason Kirtland2008-05-091-2/+2
| | | | | | | | | | | - @unsupported now only accepts a single target and demands a reason for not running the test. - @exclude also demands an exclusion reason - Greatly expanded @testing.requires.<feature>, eliminating many decorators in the suite and signficantly easing integration of multi-driver support. - New ORM test base class, and a featureful base for mapped tests - Usage of 'global' for shared setup going away, * imports as well
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-6/+6
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* - Got PG server side cursors back into shape, added fixedMike Bayer2008-04-021-1/+32
| | | | | | | 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.
* - schema-qualified tables now will place the schemanameMike Bayer2008-03-301-1/+25
| | | | | | | | | | ahead of the tablename in all column expressions as well as when generating column labels. This prevents cross- schema name collisions in all cases [ticket:999] - the "use_schema" argument to compiler.visit_column() is removed. It uses schema in all cases now. - added a new test to the PG dialect to test roundtrip insert/update/delete/select statements with full schema qualification
* unit test for mutable PGArray, thanks to AlexB !!!Mike Bayer2008-03-041-0/+42
|
* - postgres TIMESTAMP renders correctly [ticket:981]Mike Bayer2008-02-271-0/+10
|
* - updated the naming scheme of the base test classes in test/testlib/testing.py;Mike Bayer2008-02-111-8/+8
| | | | | tests extend from either TestBase or ORMTest, using additional mixins for special assertion methods as needed
* - testbase is gone, replaced by testenvJason Kirtland2008-01-121-38/+39
| | | | | | - Importing testenv has no side effects- explicit functions provide similar behavior to the old immediate behavior of testbase - testing.db has the configured db - Fixed up the perf/* scripts
* test suite deprecation rampageJason Kirtland2008-01-091-4/+4
|
* fix not calling the result processor of PGArray subtypes. (a rather ↵Ants Aasma2008-01-031-1/+10
| | | | embarrasing copypaste error) [ticket:913]
* - Removed @testing.supported. Dialects in development or maintained outsideJason Kirtland2007-12-131-105/+86
| | | | | | | | | | | the tree can now run the full suite of tests out of the box. - Migrated most @supported to @fails_on, @fails_on_everything_but, or (last resort) @unsupported. @fails_on revealed a slew of bogus test skippage, which was corrected. - Added @fails_on_everything_but. Yes, the first usage *was* "fails_on_everything_but('postgres')". How did you guess! - Migrated @supported in dialect/* to the new test-class attribute __only_on__. - Test classes can also have __unsupported_on__ and __excluded_on__.
* - named_with_column becomes an attributeMike Bayer2007-11-251-0/+3
| | | | | | | | | - 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
* a typo on postgres returning test version check - change <8.4 -> <8.2Ants Aasma2007-10-061-2/+2
|
* - move PG RETURNING tests to postgres dialect testMike Bayer2007-10-041-0/+87
| | | | | - added server_version_info() support for PG dialect - exclude PG versions < 8.4 for RETURNING tests
* - added partial index support for postgresAnts Aasma2007-09-291-0/+14
| | | | - fixed create and drop methods on MockConnection
* - added "schema" argument to Sequence; use this with Postgres /Oracle when ↵Mike Bayer2007-09-221-0/+12
| | | | | | the sequence is located in an alternate schema. Implements part of [ticket:584], should fix [ticket:761].
* - got all examples workingMike Bayer2007-09-011-4/+2
| | | | | | | - inline default execution occurs for *all* non-PK columns unconditionally - preexecute only for non-executemany PK cols on PG, Oracle, etc. - new default docs
* - merged inline inserts branchMike Bayer2007-09-011-0/+272
| | | | | | | | | | | | - all executemany() style calls put all sequences and SQL defaults inline into a single SQL statement and don't do any pre-execution - regular Insert and Update objects can have inline=True, forcing all executions to be inlined. - no last_inserted_ids(), lastrow_has_defaults() available with inline execution - calculation of pre/post execute pushed into compiler; DefaultExecutionContext greatly simplified - fixed postgres reflection of primary key columns with no sequence/default generator, sets autoincrement=False - fixed postgres executemany() behavior regarding sequences present, not present, passivedefaults, etc. - all tests pass for sqlite, mysql, postgres; oracle tests pass as well as they did previously including all insert/update/default functionality
* Added a test for the SELECT DISTINCT ON postgresqlism.Jason Kirtland2007-08-221-0/+18
| | | | | | Test currently fails due to two problems in postgres.py, but I'm leaving it uncorrected for now as its not clear what the original intent was for lists.
* adding an "already exists" catch for CREATE DOMAINMike Bayer2007-08-181-2/+6
|
* merging 0.4 branch to trunk. see CHANGES for details. 0.3 moves to ↵Mike Bayer2007-07-271-39/+89
| | | | maintenance branch in branches/rel_0_3.
* - foreign key specs can have any chararcter in their identifiersMike Bayer2007-07-181-0/+21
| | | | [ticket:667]
* - ForeignKey to a table in a schema thats not the default schemaMike Bayer2007-07-081-0/+44
| | | | | | requires the schema to be explicit; i.e. ForeignKey('alt_schema.users.id') - the fix in "schema" above fixes postgres reflection of foreign keys from an alt-schema table to a public schema table
* - Deprecated DynamicMetaData- use ThreadLocalMetaData or MetaData insteadJason Kirtland2007-07-061-12/+12
| | | | | - Deprecated BoundMetaData- use MetaData instead - Removed DMD and BMD from documentation
* postgres:Mike Bayer2007-06-291-0/+195
- added support for reflection of domains [ticket:570] - types which are missing during reflection resolve to Null type instead of raising an error - moved reflection/types/query unit tests specific to postgres to new postgres unittest module
View Lorry Controller Status