Commits

Show all
Author Commit Message Labels Comments Date
Mike Bayer
- 0.5.0rc1 - removed unneeded grouping from BooleanClauseList, generated needless parens
Tags
rel_0_5rc1
Mike Bayer
- Added scalar() and value() methods to Query, each return a single scalar value. scalar() takes no arguments and is roughly equivalent to first()[0], value() takes a single column expression and is roughly equivalent to values(expr).next()[0].
jason kirtland
Note to self: save buffers before committing.
jason kirtland
Added Query.scalar() sugar method, eases migration from old query.sum() methods. Needs tests.
Mike Bayer
- the function func.utc_timestamp() compiles to UTC_TIMESTAMP, without the parenthesis, which seem to get in the way when using in conjunction with executemany().
Mike Bayer
return type of exists() is boolean, duh
Mike Bayer
- Bind params now subclass ColumnElement which allows them to be selectable by orm.query (they already had most ColumnElement semantics). - Added select_from() method to exists() construct, which becomes more and more compatible with a regular select(). - Bind parameters/literals given a True/False value will detect their type as Boolean
paj
Fix bug with MSSQL reflecting and schemas
Mike Bayer
- The exists() construct won't "export" its contained list of elements as FROM clauses, allowing them to be used more effectively in the columns clause of a SELECT. - and_() and or_() now generate a ColumnElement, allowing boolean expressions as result columns, i.e. select([and_(1, 0)]). [ticket:798]
Mike Bayer
reverted inheritance tweak which fails tests on non-sqlite
Mike Bayer
- Added func.min(), func.max(), func.sum() as "generic functions", 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.
Mike Bayer
- Removed conflicting `contains()` operator from `InstrumentedAttribute` which didn't accept `escape` kwaarg [ticket:1153].
Mike Bayer
- Dropped 0.3-compatibility for user defined types (convert_result_value, convert_bind_param).
Mike Bayer
- query.order_by().get() silently drops the "ORDER BY" from the query issued by GET but does not raise an exception.
Mike Bayer
- rearranged delete() so that the object is attached before cascades fire off [ticket:5058] - after_attach() only fires if the object was not previously attached
Mike Bayer
synchronize inherited does not need to be called for the full mapper hierarchy
Mike Bayer
- Fixed exception throw which would occur when string-based primaryjoin condition was used in conjunction with backref.
Mike Bayer
allow the no_criterion call in _get() to copy the method name thorugh
Mike Bayer
- Fixed bug whereby mapper couldn't initialize if a composite primary key referenced another table that was not defined yet [ticket:1161]
Mike Bayer
added BFILE to reflected type names [ticket:1121]
Mike Bayer
correct extra space in SQL assertions
Mike Bayer
- has_sequence() now takes the current "schema" argument into account [ticket:1155]
Mike Bayer
- limit/offset no longer uses ROW NUMBER OVER to limit rows, and instead uses subqueries in conjunction with a special Oracle optimization comment. Allows LIMIT/OFFSET to work in conjunction with DISTINCT. [ticket:536]
Ants Aasma
Make Query.update and Query.delete return the amount of rows matched
Mike Bayer
correction
Mike Bayer
- column_property(), composite_property(), and relation() now accept a single or list of AttributeExtensions using the "extension" keyword argument. - Added a Validator AttributeExtension, as well as a @validates decorator which is used in a similar fashion as @reconstructor, and marks a method as validating one or more mapped attributes. - removed validate_attributes example, the new methodology replaces it
Mike Bayer
- AttributeListener has been refined such that the event is fired before the mutation actually occurs. Addtionally, the append() and set() methods must now return the given value, which is used as the value to be used in the mutation operation. This allows creation of validating AttributeListeners which raise before the action actually occurs, and which can change the given value into something else before its used. A new example "validate_attributes.p…
Mike Bayer
- Fixed custom instrumentation bug whereby get_instance_dict() was not called for newly constructed instances not loaded by the ORM.
Mike Bayer
- broke pool tests out into QueuePoolTest/SingletonThreadPoolTest - added test for r5061/r5062 [ticket:1157]
Mike Bayer
recheck the dirty list if extensions are present
  1. Prev
  2. Next