summaryrefslogtreecommitdiff
path: root/test/select.py
Commit message (Collapse)AuthorAgeFilesLines
* reorganized unit tests into subdirectoriesMike Bayer2006-06-051-649/+0
|
* added has_key to RowProxy, + caching of key lookupsMike Bayer2006-05-271-1/+2
| | | | | fix for mapper translate_row for deferred columns continuing with the "polymorph-tizing" of the unit of work, dependency processing accesses objects on each target task polymorphically
* merged 0.2 branch into trunk; 0.1 now in sqlalchemy/branches/rel_0_1Mike Bayer2006-05-251-54/+46
|
* fix to subquery parensMike Bayer2006-04-281-0/+6
|
* added _get_from_obj to TypeClauseMike Bayer2006-04-171-0/+3
|
* Added cast() to allow use of cast(tbl.c.col as Numeric(4,2)) in select and ↵Robert Leftwich2006-04-041-0/+29
| | | | where clauses. Unit tests for same.
* merged Rick Morrison / Runar Petursson's MS-SQL module, with adjustments to ↵Mike Bayer2006-04-031-0/+2
| | | | alias schema-qualified Table objects
* fix to oeprator test for new parenthesized rulesMike Bayer2006-04-021-1/+1
|
* added "parenthesis" check on binary clauses referencing binary clauses, for ↵Mike Bayer2006-04-021-1/+25
| | | | [ticket:144]
* added for_update flag to Select/CompoundSelectMike Bayer2006-03-311-0/+5
|
* removed all "tablename + '_' + columname" code and replaced with ↵Mike Bayer2006-03-251-10/+10
| | | | | | | | column._label, to take advantage of column labeling rules bind param compilation,when it unique-ifys the name of bind params, maintains the length of the bind parameter name instead of appending to it
* some adjustments to oracle non-ansi join concatenation, 'row number over' syntaxMike Bayer2006-03-231-0/+4
|
* got clause elements inside INSERTs going...Mike Bayer2006-03-191-2/+4
|
* expanded and integrated qvx's patch for dotted function namesMike Bayer2006-03-161-0/+15
|
* added scalar subqueries within the column clause of another selectMike Bayer2006-03-131-32/+67
|
* small tweak to select in order to fix [ticket:112]...the exported columns ↵Mike Bayer2006-03-131-0/+6
| | | | when doing select on a select() will be the column names, not the keys. this is with selects that have use_labels=False. which makes sense since using the "key" and not the name implies a label has to be used.
* refactor to Compiled.get_params() to return new ClauseParameters object, a ↵Mike Bayer2006-03-131-2/+5
| | | | | | | | | | | more intelligent bind parameter dictionary that does type conversions late and preserves the unconverted value; used to fix mappers not comparing correct value in post-fetch [ticket:110] removed pre_exec assertion from oracle/firebird regarding "check for sequence/primary key value" fix to Unicode type to check for null, fixes [ticket:109] create_engine() now uses genericized parameters; host/hostname, db/dbname/database, password/passwd, etc. for all engine connections fix to select([func(column)]) so that it creates a FROM clause to the column's table, fixes [ticket:111] doc updates for column defaults, indexes, connection pooling, engine params unit tests for the above bugfixes
* serious overhaul to get eager loads to work inline with an inheriting ↵Mike Bayer2006-03-081-1/+1
| | | | mapper, when the inheritance/eager loads share the same table. mapper inheritance will also favor the columns from the child table over those of the parent table when assigning column values to object attributes. "correlated subqueries" require a flag "correlated=True" if they are in the FROM clause of another SELECT statement, and they want to be correlated. this flag is set by default when using an "exists" clause.
* removed the dependency of ANSICompiler on SQLEngine. you can now make ↵Mike Bayer2006-03-041-3/+4
| | | | ANSICompilers and compile SQL with no engine at all.
* clauseelement.compile() totally works without an engineMike Bayer2006-02-251-3/+1
|
* merged sql_rearrangement branch , refactors sql package to work standalone withMike Bayer2006-02-251-125/+118
| | | | | clause elements including tables and columns, schema package deals with "physical" representations
* order_by and group_by being output in wrong order. Added tests for same.Robert Leftwich2006-01-221-0/+10
|
* added explicit bind parameters and column type maps to text typeMike Bayer2006-01-201-1/+32
| | | | | | | | | text type also parses :<string> into bind param objects bind parameters convert their incoming type using engine.type_descriptor() methods types.adapt_type() adjusted to not do extra work with incoming types, since the bind param change will cause it to be called a lot more added tests to new text type stuff, bind params, fixed some type tests added basic docs for using text with binde params
* implemented better hash_key on select allowing proper comparisons, implementedMike Bayer2006-01-191-1/+2
| | | | | | hash_key on all clause objects added hash_key test to select util gets extra threadlocal functions and the recursionstack object
* changes related to mapping against arbitrary selects, selects with labels or ↵Mike Bayer2005-12-301-8/+9
| | | | | | | | | | | | | | functions: testfunction has a more complete test (needs an assert tho); added new labels, synonymous with column key, to "select" statements that are subqueries with use_labels=False, since SQLite wants them - this also impacts the names of the columns attached to the select object in the case that the key and name dont match, since it is now the key, not the name; aliases generate random names if name is None (need some way to make them more predictable to help plan caching); select statements have a rowid column of None, since there isnt really a "rowid"...at least cant figure out what it would be yet; mapper creates an alias if given a select to map against, since Postgres wants it; mapper checks if it has pks for a given table before saving/deleting, skips it otherwise; mapper will not try to order by rowid if table doesnt have a rowid (since select statements dont have rowids...)
* updates for assignmapper, inherit_condition not requiredMike Bayer2005-12-291-0/+5
|
* added "late WHERE" compilation to SELECT, adds where criterion based on ↵Mike Bayer2005-12-211-0/+8
| | | | | | extra bind parameters specified at compilation/execution time
* in_ clause uses bind params, for typing etc.Mike Bayer2005-12-201-1/+1
|
* refactoring of execution path, defaults, and treatment of different paramstylesMike Bayer2005-12-171-2/+2
|
* testing functions, operators, better textual stuffMike Bayer2005-12-041-28/+59
|
* migrated __ALL__ to __all__, oops, and reworked moduleMike Bayer2005-11-301-3/+1
| | | | import scheme
* fixes to "AS" on aliases, paramstyle default on ansisqlMike Bayer2005-11-211-9/+9
|
* (no commit message)Mike Bayer2005-11-051-8/+15
|
* (no commit message)Mike Bayer2005-11-051-13/+35
|
* (no commit message)Mike Bayer2005-11-041-1/+1
|
* (no commit message)Mike Bayer2005-11-011-2/+4
|
* (no commit message)Mike Bayer2005-10-301-12/+12
|
* (no commit message)Mike Bayer2005-10-291-2/+37
|
* (no commit message)Mike Bayer2005-10-271-5/+5
|
* (no commit message)Mike Bayer2005-10-031-1/+7
|
* (no commit message)Mike Bayer2005-09-241-1/+1
|
* (no commit message)Mike Bayer2005-09-241-7/+7
|
* (no commit message)Mike Bayer2005-09-221-1/+10
|
* deletes...Mike Bayer2005-09-191-0/+1
|
* (no commit message)Mike Bayer2005-09-171-6/+6
|
* (no commit message)Mike Bayer2005-08-281-0/+6
|
* (no commit message)Mike Bayer2005-08-091-7/+7
|
* (no commit message)Mike Bayer2005-08-071-16/+36
|
* (no commit message)Mike Bayer2005-08-061-74/+74
|
* (no commit message)Mike Bayer2005-08-041-3/+4
|