summaryrefslogtreecommitdiff
path: root/test/engine/reflection.py
Commit message (Collapse)AuthorAgeFilesLines
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-820/+0
| | | | | See README.unittests for information on how to run the tests. [ticket:970]
* - use ForeignKey.column as _colspec source in Column._make_proxy(), ↵Mike Bayer2009-01-141-0/+4
| | | | | | | | | | | | | preventing needless redundant string arithmetic in memoized ForeignKey.column method - _pre_existing_column attribute becomes optional, only needed for original Table-bound column, not proxies - compare two ForeignKeys based on target_fullname, don't assume self._colspec is a string - Fixed bug when overriding a Column with a ForeignKey on a reflected table, where derived columns (i.e. the "virtual" columns of a select, etc.) would inadvertently call upon schema-level cleanup logic intended only for the original column. [ticket:1278]
* - Reflected foreign keys will properly locateMike Bayer2008-12-261-11/+57
| | | | | | | | | | | | | | | | | | | | | | | their referenced column, even if the column was given a "key" attribute different from the reflected name. This is achieved via a new flag on ForeignKey/ForeignKeyConstraint called "link_to_name", if True means the given name is the referred-to column's name, not its assigned key. [ticket:650] - removed column types from sqlite doc, we aren't going to list out "implementation" types since they aren't significant and are less present in 0.6 - mysql will report on missing reflected foreign key targets in the same way as other dialects (we can improve that to be immediate within reflecttable(), but it should be within ForeignKeyConstraint()). - postgres dialect can reflect table with an include_columns list that doesn't include one or more primary key columns
* fix imports for index reflection unit testMike Bayer2008-12-261-4/+4
|
* - Added Index reflection support to Postgres, using aMike Bayer2008-12-231-1/+32
| | | | | great patch we long neglected, submitted by Ken Kuhlman. [ticket:714]
* Modified fails_on testing decorator to take a reason for the failure.Michael Trier2008-12-121-2/+3
| | | | | This should assist with helping to document the reasons for testing failures. Currently unspecified failures are defaulted to 'FIXME: unknown'.
* Corrected problems with reflection on mssql when dealing with schemas. Fixes ↵Michael Trier2008-11-091-1/+1
| | | | #1217.
* Fixed mysql FK reflection for the edge case where a Table has expicitly ↵Jason Kirtland2008-10-271-0/+4
| | | | provided a schema= that matches the connection's default schema.
* - fixed a bug in declarative test which was looking for old version of historyMike Bayer2008-08-191-2/+2
| | | | | | | | | | - Added "sorted_tables" accessor to MetaData, which returns Table objects sorted in order of dependency as a list. This deprecates the MetaData.table_iterator() method. The "reverse=False" keyword argument has also been removed from util.sort_tables(); use the Python 'reversed' function to reverse the results. [ticket:1033]
* Corrected problem with detecting closed connections. Fixed issues in ↵Michael Trier2008-07-231-1/+1
| | | | reflecttable for reflecting the mssql tables. Removed unicode reflection test from mssql. Need to investigate this further.
* - Removed 2.3 set emulations/enhancements.Jason Kirtland2008-07-151-3/+1
| | | | (sets.Set-based collections & DB-API returns still work.)
* merged r4809 from rel_0_4, oracle fixMike Bayer2008-05-241-1/+1
|
* Correct failure reasonLele Gaifax2008-05-151-1/+1
|
* - Removed @unsupportedJason Kirtland2008-05-141-2/+2
|
* Columns now have default= and server_default=. PassiveDefault fades away.Jason Kirtland2008-05-141-1/+1
|
* Test suite modernization in progress. Big changes:Jason Kirtland2008-05-091-17/+24
| | | | | | | | | | | - @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-137/+146
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* Pass connection to get_default_schema_nameJason Kirtland2008-04-131-1/+1
|
* fixing recent schema.py changes to work with oracle 'owner' attributerel_0_4_3Mike Bayer2008-02-141-2/+1
|
* - updated the naming scheme of the base test classes in test/testlib/testing.py;Mike Bayer2008-02-111-6/+6
| | | | | tests extend from either TestBase or ORMTest, using additional mixins for special assertion methods as needed
* - Table columns and constraints can be overridden on aMike Bayer2008-02-101-272/+171
| | | | | | | | an existing table (such as a table that was already reflected) using the 'useexisting=True' flag, which now takes into account the arguments passed along with it. - fixed one element of [ticket:910] - refactored reflection test
* - testbase is gone, replaced by testenvJason Kirtland2008-01-121-79/+79
| | | | | | - 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
* - Undeclared SAWarnings are now fatal to tests as well.Jason Kirtland2008-01-121-9/+7
| | | | - Fixed typo that was killing runs of individual named tests.
* - added extra fk override testMike Bayer2008-01-101-2/+22
| | | | | | - proper error message is raised when trying to access expired instance attributes with no session present
* test suite deprecation rampageJason Kirtland2008-01-091-14/+25
|
* redid the _for_ddl String/Text deprecation warning correctly [ticket:912]Mike Bayer2008-01-091-3/+4
|
* - Removed @testing.supported. Dialects in development or maintained outsideJason Kirtland2007-12-131-32/+21
| | | | | | | | | | | 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__.
* New simple test for Dialect.has_sequence()Lele Gaifax2007-12-121-1/+18
|
* - tables with schemas can still be used in sqlite, firebird,Mike Bayer2007-12-051-3/+7
| | | | schema name just gets dropped [ticket:890]
* opened up the test for "reflection with convert_unicode=True". this is ↵Mike Bayer2007-11-271-2/+6
| | | | | | since convert_unicode by default has assert_unicode, want to ensure that other dialects (at least oracle) support this (i.e. not unicode schema names themselves, just that they dont sent thru bytestrings to a String). if maxdb or sybase *should* be able to handle this too though I can't test on this end.
* - oracle will now reflect "DATE" as an OracleDateTime column, notMike Bayer2007-11-181-2/+2
| | | | | | | OracleDate - added awareness of schema name in oracle table_names() function, fixes metadata.reflect(schema='someschema') [ticket:847]
* - Added initial version of MaxDB dialect.Jason Kirtland2007-10-231-12/+13
| | | | - All optional test Sequences are now optional=True
* - added test coverage for unknown type reflection, fixedMike Bayer2007-10-181-1/+29
| | | | sqlite/mysql handling of type reflection for unknown types
* - PG reflection, upon seeing the default schema name being used explicitlyMike Bayer2007-10-141-5/+3
| | | | | | | | | 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.
* - sqlite housekeeping- added dialect test & moved tests there, pruned the ↵Jason Kirtland2007-10-111-27/+0
| | | | dialect's reserved words.
* - initial sybase support checkin, [ticket:785]Mike Bayer2007-10-101-0/+1
|
* - oracle does not implicitly convert to unicode for non-typed resultMike Bayer2007-10-061-1/+5
| | | | | | | | | sets (i.e. when no TypeEngine/String/Unicode type is even being used; previously it was detecting DBAPI types and converting regardless). should fix [ticket:800] - fixed oracle out_parameters, likely broke in beta6 - fixed oracle _normalize_case for encoded names, gets unicode reflection test to work - a few extra tests tweaked/unsupported for oracle
* - fixed sqlite reflection of BOOL/BOOLEAN [ticket:808]Mike Bayer2007-10-051-0/+1
|
* Adjusted reserved word reflection test for oracle-style identifier dialects. ↵Jason Kirtland2007-10-041-12/+8
| | | | But probably the CheckConstraint part of this test should just be removed, as it's testing a non-extant feature.
* Some fixes on reflection tests (firebird):Roger Demetrescu2007-10-021-74/+85
| | | | | * firebird doesn't support create table tablename (columnname type NULL)" syntax (only NOT NULL) * firebird doesn't support schemas
* [ticket:728] foreign key checks for existing reflected FK and replaces itselfMike Bayer2007-09-081-4/+43
|
* Fixed OrderedProperties pickling [ticket:762]Jason Kirtland2007-08-281-0/+1
|
* `from foo import (name, name)` isn't valid syntax for 2.3. ah well.Jason Kirtland2007-08-211-2/+2
| | | | omitting modules from sqlalchemy.__all__...
* 1. Module layout. sql.py and related move into a package called "sql".Mike Bayer2007-08-181-2/+1
| | | | | | | | | | | | 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
* adjustment to table_names test such that the DB can have extra tables aroundMike Bayer2007-08-141-1/+1
|
* removed assertion for "no tables in db"rel_0_4beta2Mike Bayer2007-08-141-1/+0
|
* - oracle reflection of case-sensitive names all fixed upMike Bayer2007-08-101-1/+4
| | | | - other unit tests corrected for oracle
* - fixes to PG unicode table/sequence reflection/create/dropsMike Bayer2007-08-101-1/+1
|
* Added explicit Unicode table_names testJason Kirtland2007-08-041-3/+32
|
* - Dialects can be queried for the server version (sqlite and mysql only with ↵Jason Kirtland2007-08-031-58/+10
| | | | | | | | | | | | | | this commit) - Mark everything in a test suite as failed when setUpAll fails. - Added test coverage for Unicode table names in metadata.reflect() - @testing.exclude() filters out tests by server version - Applied exclude to the test suite, MySQL 4.1 passes again (no XA or SAVEPOINT) - Removed MySQL charset-setting pool hook- charset=utf8&use_unicode=0 works just as well. (Am I nuts? I'd swear this didn't work before.) - Finally migrated some old MySQL-tests into the dialect test module - Corrected 'commit' and 'rollback' logic (and comment) for ancient MySQL versions lacking transactions entirely - Deprecated the MySQL get_version_info in favor of server_version_info - Added a big hunk-o-doc for MySQL.