summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/sql/functions.py
Commit message (Collapse)AuthorAgeFilesLines
* happy new yearMike Bayer2012-01-041-1/+1
|
* - Added new generic function "next_value()", acceptsMike Bayer2011-03-201-1/+25
| | | | | | | | | | | | | | | | | | | | a Sequence object as its argument and renders the appropriate "next value" generation string on the target platform, if supported. Also provides ".next_value()" method on Sequence itself. [ticket:2085] - added tests for all the conditions described in [ticket:2085] - postgresql dialect will exec/compile a Sequence that has "optional=True". the optional flag is now only checked specifically in the context of a Table primary key evaulation. - func.next_value() or other SQL expression can be embedded directly into an insert() construct, and if implicit or explicit "returning" is used in conjunction with a primary key column, the newly generated value will be present in result.inserted_primary_key. [ticket:2084]
* - whitespace removal bonanzaMike Bayer2011-01-021-1/+1
|
* - clean up copyright, update for 2011, stamp every file withMike Bayer2011-01-021-0/+6
| | | | | a consistent tag - AUTHORS file
* - Added a tuple_() construct, allows sets of expressionsMike Bayer2010-01-251-7/+1
| | | | | | | | | to be compared to another set, typically with IN against composite primary keys or similar. Also accepts an IN with multiple columns. The "scalar select can have only one column" error message is removed - will rely upon the database to report problems with col mismatch.
* - _CalculatedClause is goneMike Bayer2009-01-281-7/+2
| | | | | | | | - Function rolls the various standalone execution functionality of CC into itself, accesses its internal state more directly - collate just uses _BinaryExpression, don't know why it didn't do this already - added new _Case construct, compiles directly - the world is a happier place
* - sqlalchemy.sql.expression.Function is now a publicMike Bayer2009-01-021-2/+2
| | | | | | | class. It can be subclassed to provide user-defined SQL functions in an imperative style, including with pre-established behaviors. The postgis.py example illustrates one usage of this.
* - turn __visit_name__ into an explicit member.Mike Bayer2008-12-111-4/+0
| | | | [ticket:1244]
* - merged -r5338:5429 of sphinx branch.Mike Bayer2008-12-061-1/+1
| | | | | | | | | | | | | - Documentation has been converted to Sphinx. In particular, the generated API documentation has been constructed into a full blown "API Reference" section which organizes editorial documentation combined with generated docstrings. Cross linking between sections and API docs are vastly improved, a javascript-powered search feature is provided, and a full index of all classes, functions and members is provided.
* - moved _FigureVisitName into visitiors.VisitorType, added Visitor base ↵Mike Bayer2008-10-251-3/+3
| | | | | | | class to reduce dependencies - implemented _generative decorator for select/update/insert/delete constructs - other minutiae
* - Added func.min(), func.max(), func.sum() as "generic functions",Mike Bayer2008-09-081-2/+15
| | | | | | | | | | 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.
* - func.count() with no argument emits COUNT(*)Jason Kirtland2008-07-241-1/+11
|
* - Moved to 2.4+ import syntax (w/ some experimental merge-friendly formatting)Jason Kirtland2008-07-151-2/+3
|
* factored down exportable_columns/flatten_cols/proxy_column/oid_etc_yada down ↵Mike Bayer2008-04-041-1/+0
| | | | to a single, streamlined "_populate_column_collection" method called for all selectables
* - Added generic func.random (non-standard SQL)Jason Kirtland2008-03-251-11/+23
|
* - some consolidation of tests in select.py, movedMike Bayer2008-02-011-0/+3
| | | | | | | 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]
* get most oracle tests in sql working again....Mike Bayer2007-12-181-1/+4
|
* - basic framework for generic functions, [ticket:615]Mike Bayer2007-12-051-0/+78
- 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.
View Lorry Controller Status