The fixes and features are bursting at the seams on this one, I like
to wait til theres a relative "peacefulness" of bug reports before
releasing so here we go....I tried to get every new thing (and stuff
from 0.1.3) in the docs to some degree, including indexes, column
defaults, onupdates, column subqueries, the backref() function I dont
think anyone knows about, stuff with engines, pools (just realized I
forgot to update the "types" section though...)...so I suggest you
all read the docs all over again ! (just kidding)...
0.1.4
- create_engine() now uses genericized parameters; host/hostname, db/
dbname/database,
password/passwd, etc. for all engine connections. makes engine URIs
more "universal"
- added support for SELECT statements embedded into a column clause,
using the flag
"scalar=True"
- another overhaul to EagerLoading when used in conjunction with
mappers that
inherit; improvements to eager loads figuring out their aliased queries
correctly, also relations set up against a mapper with inherited
mappers will
create joins against the table that is specific to the mapper itself
(i.e. and
not any tables that are inherited/are further down the inheritance
chain),
this can be overridden by using custom primary/secondary joins.
- added J.Ellis patch to mapper.py so that selectone() throws an
exception
if query returns more than one object row, selectfirst() to not throw
the
exception. also adds selectfirst_by (synonymous with get_by) and
selectone_by
- added onupdate parameter to Column, will exec SQL/python upon an
update
statement.Also adds "for_update=True" to all DefaultGenerator subclasses
- added support for Oracle table reflection contributed by Andrija
Zaric;
still some bugs to work out regarding composite primary keys/
dictionary selection
- checked in an initial Firebird module, awaiting testing.
- added sql.ClauseParameters dictionary object as the result for
compiled.get_params(), does late-typeprocessing of bind parameters so
that the original values are easier to access
- more docs for indexes, column defaults, connection pooling, engine
construction
- overhaul to the construction of the types system. uses a simpler
inheritance pattern
so that any of the generic types can be easily subclassed, with no
need for TypeDecorator.
- added "convert_unicode=False" parameter to SQLEngine, will cause
all String types to
perform unicode encoding/decoding (makes Strings act like Unicodes)
- added 'encoding="utf8"' parameter to engine. the given encoding
will be
used for all encode/decode calls within Unicode types as well as Strings
when convert_unicode=True.
- improved support for mapping against UNIONs, added polymorph.py
example
to illustrate multi-class mapping against a UNION
- fix to SQLite LIMIT/OFFSET syntax
- fix to Oracle LIMIT syntax
- added backref() function, allows backreferences to have keyword
arguments
that will be passed to the backref.
- Sequences and ColumnDefault objects can do execute()/scalar()
standalone
- SQL functions (i.e. func.foo()) can do execute()/scalar() standalone
- fix to SQL functions so that the ANSI-standard functions, i.e.
current_timestamp
etc., do not specify parenthesis. all other functions do.
- added settattr_clean and append_clean to SmartProperty, which set
attributes without triggering a "dirty" event or any history. used as:
myclass.prop1.setattr_clean(myobject, 'hi')
- improved support to column defaults when used by mappers; mappers
will pull
pre-executed defaults from statement's executed bind parameters
(pre-conversion) to populate them into a saved object's attributes;
if any
PassiveDefaults have fired off, will instead post-fetch the row from
the DB to
populate the object.
- added 'get_session().invalidate(*obj)' method to objectstore,
instances will
refresh() themselves upon the next attribute access.
- improvements to SQL func calls including an "engine" keyword
argument so
they can be execute()d or scalar()ed standalone, also added func
accessor to
SQLEngine
- fix to MySQL4 custom table engines, i.e. TYPE instead of ENGINE
- slightly enhanced logging, includes timestamps and a somewhat
configurable
formatting system, in lieu of a full-blown logging system
- improvements to the ActiveMapper class from the TG gang, including
many-to-many relationships
- added Double and TinyInt support to mysql
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
