summaryrefslogtreecommitdiff
path: root/test/sql/case_statement.py
Commit message (Collapse)AuthorAgeFilesLines
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-137/+0
| | | | | See README.unittests for information on how to run the tests. [ticket:970]
* Modified fails_on testing decorator to take a reason for the failure.Michael Trier2008-12-121-2/+4
| | | | | This should assist with helping to document the reasons for testing failures. Currently unspecified failures are defaulted to 'FIXME: unknown'.
* Tag some tests that fail under FirebirdLele Gaifax2008-05-131-2/+2
|
* Test suite modernization in progress. Big changes:Jason Kirtland2008-05-091-0/+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-2/+2
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* - merged -r4458:4466 of query_columns branchMike Bayer2008-04-071-1/+1
| | | | | | | - this branch changes query.values() to immediately return an iterator, adds a new "aliased" construct which will be the primary method to get at aliased columns when using values() - tentative ORM versions of _join and _outerjoin are not yet public, would like to integrate with Query better (work continues in the branch) - lots of fixes to expressions regarding cloning and correlation. Some apparent ORM bug-workarounds removed. - to fix a recursion issue with anonymous identifiers, bind parameters generated against columns now just use the name of the column instead of the tablename_columnname label (plus the unique integer counter). this way expensive recursive schemes aren't needed for the anon identifier logic. This, as usual, impacted a ton of compiler unit tests which needed a search-n-replace for the new bind names.
* - case() interprets the "THEN" expressionsMike Bayer2008-04-031-12/+23
| | | | | | | | | as values by default, meaning case([(x==y, "foo")]) will interpret "foo" as a bound value, not a SQL expression. use text(expr) for literal SQL expressions in this case. For the criterion itself, these may be literal strings only if the "value" keyword is present, otherwise SA will force explicit usage of either text() or literal().
* The case() function now also takes a dictionary as its whens parameter. But ↵Ants Aasma2008-04-031-0/+33
| | | | beware that it doesn't escape literals, use the literal construct for that.
* - updated the naming scheme of the base test classes in test/testlib/testing.py;Mike Bayer2008-02-111-1/+1
| | | | | 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-17/+17
| | | | | | - 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
* Migrated maxdb behavioral assumptions from unsupported to fails_onJason Kirtland2007-11-051-8/+8
|
* - Added initial version of MaxDB dialect.Jason Kirtland2007-10-231-0/+1
| | | | - All optional test Sequences are now optional=True
* merging 0.4 branch to trunk. see CHANGES for details. 0.3 moves to ↵Mike Bayer2007-07-271-7/+9
| | | | maintenance branch in branches/rel_0_3.
* fix CASE statement when else_ is zeroRick Morrison2007-03-151-5/+33
|
* added string length to avoid LOB col type in oracleMike Bayer2006-10-221-1/+1
|
* reorganized unit tests into subdirectoriesMike Bayer2006-06-051-0/+59