summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/sql.py
Commit message (Collapse)AuthorAgeFilesLines
* mass has_key->__contains__ migration, [ticket:738]Mike Bayer2007-08-151-2/+2
|
* - merged "fasttypes" branch. this branch changes the signatureMike Bayer2007-08-141-15/+48
| | | | | | | | | | | | | of convert_bind_param() and convert_result_value() to callable-returning bind_processor() and result_processor() methods. if no callable is returned, no pre/post processing function is called. - hooks added throughout base/sql/defaults to optimize the calling of bind param/result processors so that method call overhead is minimized. special cases added for executemany() scenarios such that unneeded "last row id" logic doesn't kick in, parameters aren't excessively traversed. - new performance tests show a combined mass-insert/mass-select test as having 68% fewer function calls than the same test run against 0.3. - general performance improvement of result set iteration is around 10-20%.
* - base_mapper() becomes a plain attributeMike Bayer2007-08-141-21/+49
| | | | | | | | - session.execute() and scalar() can search for a Table with which to bind from using the given ClauseElement - session automatically extrapolates tables from mappers with binds, also uses base_mapper so that inheritance hierarchies bind automatically - moved ClauseVisitor traversal back to inlined non-recursive
* - precompiled regexp for anonymous labelsMike Bayer2007-08-111-3/+3
| | | | - has_key()->__contains__()
* - removed _calculate_correlations() methods, removed correlation_stack, ↵Mike Bayer2007-08-111-100/+8
| | | | | | | select_stack; all are merged into a single stack thats all within ansicompiler. clause visiting cut down significantly.
* - case_sensitive=(True|False) setting removed from schema items, sinceMike Bayer2007-08-111-9/+1
| | | | | | | checking this state added a lot of method call overhead and there was no decent reason to ever set it to False. Table and column names which are all lower case will be treated as case-insenstive (yes we adjust for Oracle's UPPERCASE style too).
* removed unused method from last checkinMike Bayer2007-08-091-3/+0
|
* - decoupled all ColumnElements from also being Selectables. this meansMike Bayer2007-08-091-34/+63
| | | | | | | | that anything which is a column expression does not have a "c" or a "columns" attribute. Also works for select().as_scalar(); _ScalarSelect is a columnelement, so you can't say select().as_scalar().c.foo, which is a pretty confusing mistake to make. in the case of _ScalarSelect made an explicit raise if you try to access 'c'.
* - migrated 'desc', 'asc', and 'distinct' to be in the Operators frameworkMike Bayer2007-08-071-9/+31
| | | | - fixes to operator() method signature/calling
* - added desc() and asc() directly to CompareMixinMike Bayer2007-08-061-1/+11
|
* - docsMike Bayer2007-08-061-2/+58
| | | | | - added some convenience functions to selects, clauseelements - fixed distinct()
* - draft sqlexpression tutorialMike Bayer2007-08-061-2/+23
| | | | | - added some generative methods to exists() - got clause adapter to work with join()
* switch (simple) occurences of 'if len(x)' to 'if x': find . -name '*.py' ↵Jonathan Ellis2007-08-031-6/+6
| | | | |xargs perl -pi.bak -e 's/if len\((\S+)\):/if $1:/' && find . -name '*.bak' |xargs rm
* - added inline UPDATE/INSERT clauses, settable as regular object attributes.Mike Bayer2007-08-021-0/+4
| | | | the clause gets executed inline during a flush().
* added values() generative method to Insert/UpdateMike Bayer2007-08-021-0/+28
|
* - restored old assign_mapper monkey patched query methods but with two ↵Gaëtan de Menten2007-07-311-2/+2
| | | | | | | | differences: * added a deprecation warning * check if a method with that name already exist in the class - more foolproof deprecation warning for scalar kwarg
* add warnings for deprecated methods and optionsJonathan Ellis2007-07-301-0/+2
|
* fixed 'column_literal' to 'literal_column' [ticket:626]Mike Bayer2007-07-291-2/+2
|
* fixed pydoc bug in [ticket:564]Mike Bayer2007-07-291-1/+8
|
* fixed glitch in Select visit traversal, fixes #693Mike Bayer2007-07-271-1/+1
|
* merging 0.4 branch to trunk. see CHANGES for details. 0.3 moves to ↵Mike Bayer2007-07-271-882/+1064
| | | | maintenance branch in branches/rel_0_3.
* Merged reference fixes from r2986Jason Kirtland2007-07-191-2/+2
|
* - merged some more of the SessionTransaction connection-bound checks from 0.4Mike Bayer2007-07-181-1/+7
| | | | | - _BinaryExpression.compare() checks for a base set of "commutative" operators and checks for itself in reverse if so - added ORM-based unit test for the above, fixes [ticket:664]
* - columns can be overridden in a reflected table with a "key"Mike Bayer2007-07-151-0/+7
| | | | | | attribute different than the column's name, including for primary key columns [ticket:650] - more docs
* - improved ability to get the "correct" and most minimal set of primary keyMike Bayer2007-07-141-19/+49
| | | | | | | columns from a join, equating foreign keys and otherwise equated columns. this is also mostly to help inheritance scenarios formulate the best choice of primary key columns. [ticket:185] - added 'bind' argument to Sequence.create()/drop(), ColumnDefault.execute()
* - composite primary key is represented as a non-keyed set to allow forMike Bayer2007-07-131-1/+20
| | | | | | composite keys consisting of cols with the same name; occurs within a Join. helps inheritance scenarios formulate correct PK. - ticket #185 reopened. still need to get Join to produce a minmal PK for fk'ed columns
* - the various "engine" arguments, such as "engine", "connectable",Mike Bayer2007-07-121-38/+50
| | | | | | | | | "engine_or_url", "bind_to", etc. are all present, but deprecated. they all get replaced by the single term "bind". you also set the "bind" of MetaData using metadata.bind = <engine or connection>. this is part of 0.4 forwards compatibility where "bind" is the only keyword. [ticket:631]
* changed "_source_column" to simpler "_distance"Mike Bayer2007-07-101-15/+8
|
* more "column targeting" enhancements..columns have a "depth" from their ↵Mike Bayer2007-07-101-6/+20
| | | | ultimate source column so that corresponding_column() can find the column that is "closest" (i.e. fewest levels of proxying) to the requested column
* add missing grouping for compound selects. fixes ticket #623Ants Aasma2007-06-261-1/+6
|
* fix precedence of between (ticket #621)Ants Aasma2007-06-251-11/+5
|
* - fixed precedence of operators so that parenthesis are correctly appliedMike Bayer2007-06-251-16/+38
| | | | | | | | [ticket:620] - calling <column>.in_() (i.e. with no arguments) will return "CASE WHEN (<column> IS NULL) THEN NULL ELSE 0 END = 1)", so that NULL or False is returned in all cases, rather than throwing an error [ticket:545]
* - fixed "where"/"from" criterion of select() to accept a unicode stringMike Bayer2007-06-231-2/+2
| | | | in addition to regular string - both convert to text()
* - added standalone distinct() function in addition to column.distinct()Mike Bayer2007-06-211-1/+9
| | | | [ticket:558]
* orig_set is a Set [ticket:614]Mike Bayer2007-06-201-1/+1
|
* Multiple MSSQL fixes; see ticket #581Paul Johnston2007-06-131-0/+1
|
* extra test for corresponding column fixMike Bayer2007-06-071-0/+2
|
* - fixed bug where selectable.corresponding_column(selectable.c.col)Mike Bayer2007-06-061-1/+3
| | | | | | would not return selectable.c.col, if the selectable is a join of a table and another join involving the same table. messed up ORM decision making [ticket:593]
* another object.__init__() call with args....might need to build py2.6 to ↵Mike Bayer2007-05-261-1/+1
| | | | test this more completely....
* removed ClauseVisitor.__init__(), doesnt work with python trunkMike Bayer2007-05-261-2/+1
|
* CompoundSelect (i.e. UNION etc.) needed self_group() to provide parenthesisMike Bayer2007-05-231-0/+3
|
* restored comparison of 1-element clause list -> ClauseElement, which was ↵Mike Bayer2007-05-201-1/+3
| | | | broken in [changeset:2620]
* - removed "no group by's in a select thats part of a UNION"Mike Bayer2007-05-181-1/+0
| | | | restriction [ticket:578]
* fixed LoggingClauseVisitorMike Bayer2007-05-151-13/+19
|
* - parenthesis are applied to clauses via a new _Grouping construct.Mike Bayer2007-05-141-187/+223
| | | | | | | | uses operator precedence to more intelligently apply parenthesis to clauses, provides cleaner nesting of clauses (doesnt mutate clauses placed in other clauses, i.e. no 'parens' flag) - added 'modifier' keyword, works like func.<foo> except does not add parenthesis. e.g. select([modifier.DISTINCT(...)]) etc.
* - _Label propigates "_hide_froms()" so that scalar selectsMike Bayer2007-05-111-1/+4
| | | | behave more properly with regards to FROM clause #574
* - _Label class overrides compare_self to return its ultimate object.Mike Bayer2007-05-031-0/+3
| | | | | meaning, if you say someexpr.label('foo') == 5, it produces the correct "someexpr == 5".
* - Aliasizer removed. hooray !Mike Bayer2007-05-021-1/+15
| | | | - ClauseVisitor has handy chain() method.
* - applied YAGNI to supports_autoclose_results (this issue would be handled ↵Mike Bayer2007-04-301-4/+4
| | | | | | by BufferedColumnResultProxy) - the docstrings, they do not end
* - restored old "column_property()" ORM function (used to be calledMike Bayer2007-04-291-1/+1
| | | | | | | "column()") to force any column expression to be added as a property on a mapper, particularly those that aren't present in the mapped selectable. this allows "scalar expressions" of any kind to be added as relations (though they have issues with eager loads).
View Lorry Controller Status