summaryrefslogtreecommitdiff
path: root/test/sql/functions.py
Commit message (Collapse)AuthorAgeFilesLines
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-319/+0
| | | | | See README.unittests for information on how to run the tests. [ticket:970]
* extract() is now dialect-sensitive and supports SQLite and others.Jason Kirtland2009-03-301-0/+38
|
* - Fixed missing _label attribute on Function object, othersMike Bayer2009-02-011-1/+5
| | | | | when used in a select() with use_labels (such as when used in an ORM column_property()). [ticket:1302]
* - Added func.min(), func.max(), func.sum() as "generic functions",Mike Bayer2008-09-081-5/+14
| | | | | | | | | | which basically allows for their return type to be determined automatically. Helps with dates on SQLite, decimal types, others. [ticket:1160] - added decimal.Decimal as an "auto-detect" type; bind parameters and generic functions will set their type to Numeric when a Decimal is used.
* - The 'length' argument to all Numeric types has been renamedMike Bayer2008-08-241-10/+4
| | | | | | | | | | | | | | | | to 'scale'. 'length' is deprecated and is still accepted with a warning. [ticket:827] - The 'length' argument to MSInteger, MSBigInteger, MSTinyInteger, MSSmallInteger and MSYear has been renamed to 'display_width'. [ticket:827] - mysql._Numeric now consumes 'unsigned' and 'zerofill' from the given kw, so that the same kw can be passed along to Numeric and allow the 'length' deprecation logic to still take effect - added testlib.engines.all_dialects() to return a dialect for every db module - informix added to sqlalchemy.databases.__all__. Since other "experimental" dbs like access and sybase are there, informix should be as well.
* - func.count() with no argument emits COUNT(*)Jason Kirtland2008-07-241-0/+9
|
* - changed char_length() to use a fake, neutral "generic function"Mike Bayer2008-05-191-1/+10
| | | | - assert_compile() reports the dialect in use
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-1/+1
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* - fixed SQL function truncation of trailing underscoresMike Bayer2008-03-251-1/+4
| | | | [ticket:996]
* - Added generic func.random (non-standard SQL)Jason Kirtland2008-03-251-3/+15
|
* - 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
* - some consolidation of tests in select.py, movedMike Bayer2008-02-011-1/+82
| | | | | | | other tests to more specific modules - added "now()" as a generic function; on SQLite and Oracle compiles as "CURRENT_TIMESTAMP"; "now()" on all others [ticket:943]
* - testbase is gone, replaced by testenvJason Kirtland2008-01-121-15/+15
| | | | | | - 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
* - Removed @testing.supported. Dialects in development or maintained outsideJason Kirtland2007-12-131-11/+18
| | | | | | | | | | | 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__.
* - basic framework for generic functions, [ticket:615]Mike Bayer2007-12-051-0/+153
- changed the various "literal" generation functions to use an anonymous bind parameter. not much changes here except their labels now look like ":param_1", ":param_2" instead of ":literal" - from_obj keyword argument to select() can be a scalar or a list.