summaryrefslogtreecommitdiff
path: root/test/sql/constraints.py
Commit message (Collapse)AuthorAgeFilesLines
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-337/+0
| | | | | See README.unittests for information on how to run the tests. [ticket:970]
* On MSSQL if a field is part of the primary_key then it should not allow NULLS.Michael Trier2008-12-281-1/+1
|
* Modified fails_on testing decorator to take a reason for the failure.Michael Trier2008-12-121-1/+1
| | | | | This should assist with helping to document the reasons for testing failures. Currently unspecified failures are defaulted to 'FIXME: unknown'.
* - Using the same ForeignKey object repeatedlyMike Bayer2008-12-031-1/+10
| | | | | raises an error instead of silently failing later. [ticket:1238]
* - Removed the 'properties' attribute of theMike Bayer2008-11-091-2/+2
| | | | | Connection object, Connection.info should be used. - Method consoliation in Connection, ExecutionContext
* merged r4870 from 0.4 branch, index name truncation, [ticket:820]Mike Bayer2008-06-221-0/+18
|
* Test suite modernization in progress. Big changes:Jason Kirtland2008-05-091-1/+1
| | | | | | | | | | | - @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-5/+5
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* - updated the naming scheme of the base test classes in test/testlib/testing.py;Mike Bayer2008-02-111-2/+2
| | | | | tests extend from either TestBase or ORMTest, using additional mixins for special assertion methods as needed
* - Added deferrability support to constraintsJason Kirtland2008-02-081-0/+105
|
* - testbase is gone, replaced by testenvJason Kirtland2008-01-121-29/+29
| | | | | | - 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
* sequence pre-executes dont create an ExecutionContext, use straight cursorMike Bayer2007-09-011-2/+2
|
* `from foo import (name, name)` isn't valid syntax for 2.3. ah well.Jason Kirtland2007-08-211-0/+1
| | | | omitting modules from sqlalchemy.__all__...
* 1. Module layout. sql.py and related move into a package called "sql".Mike Bayer2007-08-181-1/+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
* merging 0.4 branch to trunk. see CHANGES for details. 0.3 moves to ↵Mike Bayer2007-07-271-5/+6
| | | | maintenance branch in branches/rel_0_3.
* - Deprecated DynamicMetaData- use ThreadLocalMetaData or MetaData insteadJason Kirtland2007-07-061-1/+1
| | | | | - Deprecated BoundMetaData- use MetaData instead - Removed DMD and BMD from documentation
* - merged the "execcontext" branch, refactors engine/dialect codepathsMike Bayer2007-04-021-5/+7
| | | | | | | | | | | | | | | | | | | | - 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().
* - for hackers, refactored the "visitor" system of ClauseElement andMike Bayer2007-03-111-1/+1
| | | | | | | | | | | | | | | SchemaItem so that the traversal of items is controlled by the ClauseVisitor itself, using the method visitor.traverse(item). accept_visitor() methods can still be called directly but will not do any traversal of child items. ClauseElement/SchemaItem now have a configurable get_children() method to return the collection of child elements for each parent object. This allows the full traversal of items to be clear and unambiguous (as well as loggable), with an easy method of limiting a traversal (just pass flags which are picked up by appropriate get_children() methods). [ticket:501] - accept_schema_visitor() methods removed, replaced with get_children(schema_visitor=True) - various docstring/changelog cleanup/reformatting
* - fixed use_alter flag on ForeignKeyConstraint [ticket:503]Mike Bayer2007-03-071-0/+24
|
* - fixed generation of CHECK constraints on columns [ticket:464]Mike Bayer2007-02-171-1/+2
|
* - added a Sequence to the unicode test tables to help OracleMike Bayer2007-02-171-1/+1
| | | | - fixed named PrimaryKeyConstraint generation on oracle [ticket:466] courtesy andrija at gmail
* - a fair amount of cleanup to the schema package, removal of ambiguousMike Bayer2006-10-141-0/+176
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.