summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/sql.py
Commit message (Collapse)AuthorAgeFilesLines
* got MS-SQL support largely working, including reflection, basic types, fair ↵Mike Bayer2006-07-011-2/+2
| | | | | | amount of ORM stuff, etc. 'rowcount' label is reseved in MS-SQL and had to change in sql.py count() as well as orm.query
* cast converted into its own ClauseElement so that it can have an explicit ↵rel_0_2_3Mike Bayer2006-06-171-7/+18
| | | | | | | | | | | compilation function in ANSICompiler MySQLCompiler then skips most CAST calls since it only seems to support the standard syntax for Date types; other types now a TODO for MySQL then, polymorphic_union() function now CASTs null()s to the type corresponding to the columns in the UNION, since postgres doesnt like mixing NULL with integer types (long road for that .....)
* adjustment to better allow textual from clausesMike Bayer2006-06-121-2/+2
|
* separated standalone between(), column.between(), put literal checking for ↵Mike Bayer2006-06-081-5/+16
| | | | both, favor column.between()
* fixed typing for between() operator, [ticket:202]Mike Bayer2006-06-081-3/+8
|
* HashSet is gone, uses set() for most sets in py2.4 or sets.Set.Mike Bayer2006-06-051-2/+2
| | | | ordered set functionality supplied by a subclass of sets.Set
* "count" label changed to "rowcount", and default "count" argument is first ↵Mike Bayer2006-06-011-2/+10
| | | | pk col of the table or the first col if no pks
* merged 0.2 branch into trunk; 0.1 now in sqlalchemy/branches/rel_0_1Mike Bayer2006-05-251-154/+212
|
* added explicit check for "==null()" to produce IS NULL, documnted "==None", ↵Mike Bayer2006-05-241-9/+8
| | | | "==null()", [ticket:187]
* rick morrison's CASE statement + unit testMike Bayer2006-05-151-18/+49
|
* added != support for None -> foo IS NOT NULLMike Bayer2006-05-121-2/+6
|
* added __mod__ typerel_0_1_7Mike Bayer2006-05-051-0/+2
|
* fix to subquery parensMike Bayer2006-04-281-3/+2
|
* fixed up expunge() and the continuing circular refs in attributes, added a ↵Mike Bayer2006-04-191-1/+4
| | | | unit test for the whole thing
* added _get_from_obj to TypeClauseMike Bayer2006-04-171-1/+2
|
* had to take out the "treeification" of the dependency sort as it doenst ↵Mike Bayer2006-04-141-1/+2
| | | | really work , added test conditions to the dependency test + the original test that failed
* a little spring cleaning for the util package, etcMike Bayer2006-04-071-3/+2
|
* split up Session into Session/LegacySession, added some new constructor argsMike Bayer2006-04-061-28/+38
| | | | | | | | created AbstractEngine class which provides base for SQLEngine and will also provide base for ConnectionProxy, so SQL binding can be to an engine or specific connection resource ClauseElements get using() method which can take AbstractEngines for execution made more separation between SchemaItems and bound engine
* moves the binding of a TypeEngine object from "schema/statement creation" ↵Mike Bayer2006-04-061-28/+22
| | | | time into "compilation" time
* factored oid column into a consistent late-bound pattern, fixing [ticket:146]Mike Bayer2006-04-041-20/+33
|
* Added cast() to allow use of cast(tbl.c.col as Numeric(4,2)) in select and ↵Robert Leftwich2006-04-041-1/+20
| | | | where clauses. Unit tests for same.
* further order_by: order_by() with no arguments should not affect the ↵Mike Bayer2006-04-031-2/+2
| | | | current order_by clause (same with group_by)
* ack, fixes to the order by stuff from last nightMike Bayer2006-04-031-3/+3
|
* added to_selectable() onto ColumnClause to simplify _get_col_by_originalMike Bayer2006-04-031-0/+6
|
* made order_by/group_by construction a little more simplisitcMike Bayer2006-04-031-46/+31
| | | | | fix to mapper extension CompoundSelect can export all columns now, not sure if theres any advantage there
* added a type to label....Mike Bayer2006-04-031-2/+3
|
* added "parenthesis" check on binary clauses referencing binary clauses, for ↵Mike Bayer2006-04-021-0/+4
| | | | [ticket:144]
* added for_update flag to Select/CompoundSelectMike Bayer2006-03-311-1/+3
|
* fixed "DISTINCT" spellingMike Bayer2006-03-281-1/+1
|
* column label generation checks for a conflict against a column named the ↵Mike Bayer2006-03-261-1/+1
| | | | | | same as the label comment in mapper
* removed all "tablename + '_' + columname" code and replaced with ↵Mike Bayer2006-03-251-1/+1
| | | | | | | | 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 more tweaks to get more advanced polymorphic stuff to workMike Bayer2006-03-241-2/+4
|
* added "name" back to FromClauseMike Bayer2006-03-211-1/+1
|
* a few tweaks and the polymorph example can also use eager loadingMike Bayer2006-03-201-0/+1
|
* added distinct() function to column elements for "DISTINCT <col>"Mike Bayer2006-03-191-0/+2
|
* got rid of from "ids", using the From object itself as identity now. ↵Mike Bayer2006-03-191-22/+16
| | | | improves correlation logic and fixes [ticket:116]
* der + engine...Mike Bayer2006-03-181-1/+1
|
* got oracle parenthesized rules for funcs back, fixed copy_container on functionMike Bayer2006-03-181-2/+2
|
* expanded and integrated qvx's patch for dotted function namesMike Bayer2006-03-161-1/+13
|
* added scalar subqueries within the column clause of another selectMike Bayer2006-03-131-10/+26
|
* oracle is requiring dictionary params to be in a clean dict, added conversionMike Bayer2006-03-131-0/+5
| | | | some fixes to unit tests
* small tweak to select in order to fix [ticket:112]...the exported columns ↵Mike Bayer2006-03-131-1/+1
| | | | 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-0/+23
| | | | | | | | | | | 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
* added 'noninherited table' prop to mapper indicating the "lead" table, in ↵Mike Bayer2006-03-091-0/+1
| | | | | | | | the case of inheritance. relations now create priamry/secondary joins against that lead table. if you want to create it against an inherited table, use explicit join conditions. added 'correlate' argument to CompoundSelect to get polymorph example working again.
* serious overhaul to get eager loads to work inline with an inheriting ↵Mike Bayer2006-03-081-8/+15
| | | | 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.
* took erroneous 'count' off AliasMike Bayer2006-03-081-1/+0
|
* checking in patch for column labels limit at 30 chars...what the heckMike Bayer2006-03-061-4/+10
|
* a mapper with inheritance will place itself as "dependent" on the inherited ↵Mike Bayer2006-03-061-1/+0
| | | | mapper; even though this is not usually needed, it allows certain exotic combinations of mapper setups to work (i.e. the one in the polymorph example)
* added new 'polymorphic' example. still trying to understand it :) .Mike Bayer2006-03-061-3/+5
| | | | | fixes to relation to enable it to locate "direction" more consistently with inheritance relationships more tweaks to parenthesizing subqueries, unions, etc.
* more tweak to compoundselect parenthesizing/subquery flagMike Bayer2006-03-061-4/+2
|
View Lorry Controller Status