summaryrefslogtreecommitdiff
path: root/test/sql
Commit message (Collapse)AuthorAgeFilesLines
* - Temporarily rolled back the "ORDER BY" enhancementMike Bayer2008-08-061-47/+1
| | | | | from [ticket:1068]. This feature is on hold pending further development.
* - compiler visit_label() checks a flag "within_order_by" and will render its ↵Mike Bayer2008-08-032-0/+81
| | | | | | | | | | | | | | | | | | | own name and not its contained expression, if the dialect reports true for supports_simple_order_by_label. the flag is not propagated forwards, meant to closely mimic the syntax Postgres expects which is that only a simple name can be in the ORDER BY, not a more complex expression or function call with the label name embedded (mysql and sqlite support more complex expressions). This further sets the standard for propigation of **kwargs within compiler, that we can't just send **kwargs along blindly to each XXX.process() call; whenever a **kwarg needs to propagate through, most methods will have to be aware of it and know when they should send it on forward and when not. This was actually already the case with result_map as well. The supports_simple_order_by dialect flag defaults to True but is conservatively explicitly set to False on all dialects except SQLite/MySQL/Postgres to start. [ticket:1068]
* - func.count() with no argument emits COUNT(*)Jason Kirtland2008-07-241-0/+9
|
* - Spiffed up the deprecated decorators & @flipped 'em up topJason Kirtland2008-07-161-1/+1
|
* - Removed 2.3 Decimal compatJason Kirtland2008-07-151-4/+4
|
* - Removed 2.3 set emulations/enhancements.Jason Kirtland2008-07-152-2/+1
| | | | (sets.Set-based collections & DB-API returns still work.)
* - Fixed bug when calling select([literal('foo')])Mike Bayer2008-07-151-0/+3
| | | | or select([bindparam('foo')]).
* possible fix for MS-SQL version of match() test, but the real solution here ↵Mike Bayer2008-07-141-1/+1
| | | | may be to have the correct default paramstyle set up on the MS-SQL dialect.
* Added new basic match() operator that performs a full-text search. Supported ↵Michael Trier2008-07-131-0/+10
| | | | on PostgreSQL, SQLite, MySQL, MS-SQL, and Oracle backends.
* merge r4889, SQLite Float type, from 0.4 branchMike Bayer2008-07-021-1/+4
|
* merged r4870 from 0.4 branch, index name truncation, [ticket:820]Mike Bayer2008-06-221-0/+18
|
* - merged r4868, disallow overly long names from create/drop, from 0.4 ↵Mike Bayer2008-06-221-0/+9
| | | | branch, [ticket:571]
* - Quick cleanup of defaults.py. The main DefaultTest is still a mess.Jason Kirtland2008-05-202-151/+155
|
* Split out a couple true autoincrement/identity tests from ↵Jason Kirtland2008-05-191-30/+43
| | | | emulated-with-sequences autoincrement=True tests.
* - changed char_length() to use a fake, neutral "generic function"Mike Bayer2008-05-191-1/+10
| | | | - assert_compile() reports the dialect in use
* - added some help for a heavily flush-order-dependent testMike Bayer2008-05-161-1/+24
| | | | - quote flag propagates to _Label, [ticket:1045]
* Don't blat Table.quote= when resolving foreign keys.Jason Kirtland2008-05-151-0/+15
|
* Corrected Firebird failure reasonsLele Gaifax2008-05-151-7/+7
|
* - Removed @unsupportedJason Kirtland2008-05-144-32/+32
|
* Columns now have default= and server_default=. PassiveDefault fades away.Jason Kirtland2008-05-142-37/+134
|
* Tag some tests that fail under FirebirdLele Gaifax2008-05-132-4/+5
|
* - clause adaption hits _raw_columns of a select() (though no ORM tests need ↵Mike Bayer2008-05-121-0/+6
| | | | | | this feature currently) - broke up adapter chaining in eagerload, erroneous "wrapping" in row_decorator. column_property() subqueries are now affected only by the ORMAdapter for that mapper. fixes [ticket:1037], and may possibly impact some of [ticket:949]
* Tagged two tests that fail under FirebirdLele Gaifax2008-05-121-1/+2
|
* - fixed a fairly critical bug in clause adaption/corresponding column in ↵Mike Bayer2008-05-091-13/+33
| | | | | | | conjunction with annotations - implicit order by is removed, modified many tests to explicitly set ordering, probably many more to go once it hits the buildbot.
* Test suite modernization in progress. Big changes:Jason Kirtland2008-05-098-47/+77
| | | | | | | | | | | - @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
* MSText no longer implicitly creates TEXT for string with no lengthMike Bayer2008-05-091-1/+1
| | | | (this actually allows CAST (foo, VARCHAR) to render too)
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-0911-166/+250
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* - _Label adds itself to the proxy collection so that it works in ↵Mike Bayer2008-05-061-0/+9
| | | | | | correspoinding column. fixes some eager load with column_property bugs. - this partially fixes some issues in [ticket:1022] but leaving the "unlabeled" fix for 0.5 for now
* - an unfortunate naming conflictMike Bayer2008-05-021-1/+1
| | | | - needed sql import on and()
* - factored out the logic used by Join to create its join conditionMike Bayer2008-05-021-0/+13
| | | | | | | - With declarative, joined table inheritance mappers use a slightly relaxed function to create the "inherit condition" to the parent table, so that other foreign keys to not-yet-declared Table objects don't trigger an error.
* fix order by for MySQL environmentMike Bayer2008-04-261-0/+2
|
* - improved behavior of text() expressions when used asMike Bayer2008-04-261-0/+11
| | | | | | | FROM clauses, such as select().select_from(text("sometext")) [ticket:1014] - removed _TextFromClause; _TextClause just adds necessary FromClause descriptors at the class level
* - Support for COLLATE: collate(expr, col) and expr.collate(col)Jason Kirtland2008-04-161-0/+29
|
* refactor of default_paramstyle, use paramstyle argument on Dialect to changeMatt Harrison2008-04-071-1/+1
|
* - merged -r4458:4466 of query_columns branchMike Bayer2008-04-075-132/+188
| | | | | | | - 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.
* factored down exportable_columns/flatten_cols/proxy_column/oid_etc_yada down ↵Mike Bayer2008-04-041-0/+3
| | | | to a single, streamlined "_populate_column_collection" method called for all selectables
* fixed union() bug whereby oid_column would not be available if no oid_column ↵Mike Bayer2008-04-041-0/+7
| | | | in embedded selects
* - 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.
* fixed OracleRaw type adaptation [ticket:902]Mike Bayer2008-04-021-0/+1
|
* - schema-qualified tables now will place the schemanameMike Bayer2008-03-301-7/+7
| | | | | | | | | | 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
* - can now allow selects which correlate all FROM clausesMike Bayer2008-03-281-0/+9
| | | | | | and have no FROM themselves. These are typically used in a scalar context, i.e. SELECT x, (SELECT x WHERE y) FROM table. Requires explicit correlate() call.
* - 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
|
* removed AbstractClauseProcessor, merged its copy-and-visit behavior into ↵Mike Bayer2008-03-241-1/+32
| | | | ClauseVisitor
* added escape kw arg to contains(), startswith(), endswith(), [ticket:791]Mike Bayer2008-03-191-1/+4
|
* - like() and ilike() take an optional keyword argumentMike Bayer2008-03-191-8/+17
| | | | | | "escape=<somestring>", which is set as the escape character using the syntax "x LIKE y ESCAPE '<somestring>'" [ticket:993]
* - Column._set_parent will complete the key==name contract for instances ↵Jason Kirtland2008-03-181-0/+12
| | | | constructed anonymously
* - 'name' is no longer a require constructor argument for Column(). It (and ↵Jason Kirtland2008-03-182-0/+49
| | | | .key) may now be deferred until the Column is added to a Table.
* Added support for vendor-extended INSERT syntax like INSERT DELAYED INTOJason Kirtland2008-03-071-0/+45
|
View Lorry Controller Status