:released: Fri May 05 2006
some fixes to topological sort algorithm
added DISTINCT ON support to Postgres (just supply distinct=[col1,col2..])
added __mod__ (% operator) to sql expressions
"order_by" mapper property inherited from inheriting mapper
fix to column type used when mapper UPDATES/DELETEs
with convert_unicode=True, reflection was failing, has been fixed
types types types! still werent working....have to use TypeDecorator again :(
mysql binary type converts array output to buffer, fixes PickleType
fixed the attributes.py memory leak once and for all
unittests are qualified based on the databases that support each one
fixed bug where column defaults would clobber VALUES clause of insert objects
fixed bug where table def w/ schema name would force engine connection
fix for parenthesis to work correctly with subqueries in INSERT/UPDATE
HistoryArraySet gets extend() method
fixed lazyload support for other comparison operators besides =
lazyload fix where two comparisons in the join condition point to the
added "construct_new" flag to mapper, will use __new__ to create instances
instead of __init__ (standard in 0.2)
added selectresults.py to SVN, missed it last time
tweak to allow a many-to-many relationship from a table to itself via
small fix to "translate_row" function used by polymorphic example
create_engine uses cgi.parse_qsl to read query string (out the window in 0.2)
fixed function names LOCAL_TIME/LOCAL_TIMESTAMP -> LOCALTIME/LOCALTIMESTAMP
fixed order of ORDER BY/HAVING in compile
:released: Wed Apr 12 2006
support for MS-SQL added courtesy Rick Morrison, Runar Petursson
the latest SQLSoup from J. Ellis
ActiveMapper has preliminary support for inheritance (Jeff Watkins)
added a "mods" system which allows pluggable modules that modify/augment
core functionality, using the function "install_mods(*modnames)".
added the first "mod", SelectResults, which modifies mapper selects to
factored out querying capabilities of Mapper into a separate Query object
and makes other things possible.
objectstore/Session refactored, the official way to save objects is now
types system is bound to an engine at query compile time, not schema
construction time. this simplifies the types system as well as the ProxyEngine.
added 'version_id' keyword argument to mapper. this keyword should reference a
value received is not the expected count.
added 'entity_name' keyword argument to mapper. a mapper is now associated
map for an otherwise equilvalent object.
overhaul to the attributes system. code has been clarified, and also fixed to
support proper polymorphic behavior on object attributes.
added "for_update" flag to Select objects
fix for postgres1 DateTime type
documentation pages mostly switched over to Markdown syntax
:released: Mon Mar 27 2006
added SQLSession concept to SQLEngine. this object keeps track of retrieving a
come later regarding SQLSession.
added nest_on argument to objectstore.Session. This is a single SQLEngine or
factored apart objectstore/unitofwork to separate "Session scoping" from
"uow commit heavy lifting"
added populate_instance() method to MapperExtension. allows an extension to
fixed Oracle8-compatibility "use_ansi" flag which converts JOINs to
comparisons with the = and (+) operators, passes basic unittests
tweaks to Oracle LIMIT/OFFSET support
Oracle reflection uses ALL_** views instead of USER_** to get larger
list of stuff to reflect from
fixes to Oracle foreign key reflection
objectstore.commit(obj1, obj2,...) adds an extra step to seek out private
lots and lots of fixes to mappers which use inheritance, strengthened the
to work with lazy/eager loading.
added support for mappers to inherit from others based on the same table,
just specify the same table as that of both parent/child mapper.
some minor speed improvements to the attributes system with regards to
instantiating and populating new objects.
fixed MySQL binary unit test
INSERTs can receive clause elements as VALUES arguments, not just literal
support for calling multi-tokened functions, i.e. schema.mypkg.func()
added J. Ellis' SQLSoup module to extensions package
added "polymorphic" examples illustrating methods to load multiple object types
small improvements to mapper, UNION construct to help the examples along
improvements/fixes to session.refresh()/session.expire() (which may have
been called "invalidate" earlier..)
added session.expunge() which totally removes an object from the current
added *args, **kwargs pass-thru to engine.transaction(func) allowing easier
creation of transactionalizing decorator functions
added iterator interface to ResultProxy: "for row in result:..."
added assertion to tx = session.begin(); tx.rollback(); tx.begin(), i.e. cant
use it after a rollback()
added date conversion on bind parameter fix to SQLite enabling dates to
improvements to subqueries to more intelligently construct their FROM
added PickleType to types.
fixed two bugs with column labels with regards to bind parameters: bind param
against a column named the same as "tablename_colname" added
major overhaul to unit of work documentation, other documentation sections.
fixed attributes bug where if an object is committed, its lazy-loaded list got
blown away if it hadnt been loaded
added unique_connection() method to engine, connection pool to return a
added invalidate() function to pooled connection. will remove the connection
added distinct() function to column elements so you can do
added "always_refresh" flag to Mapper, creates a mapper that will always
:released: Mon Mar 13 2006
create_engine() now uses genericized parameters; host/hostname,
engine URIs much more "universal"
added support for SELECT statements embedded into a column clause, using the
another overhaul to EagerLoading when used in conjunction with mappers that
this can be overridden by using custom primary/secondary joins.
added J.Ellis patch to mapper.py so that selectone() throws an exception
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
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
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
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
improved support to column defaults when used by mappers; mappers will pull
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
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
added Double and TinyInt support to mysql
:released: Thu Mar 02 2006
completed "post_update" feature, will add a second update statement before
completed mapper.using(session) function, localized per-object Session
fix to Oracle "row_number over" clause with multiple tables
mapper.get() was not selecting multiple-keyed objects if the mapper's table was a join,
such as in an inheritance relationship, this is fixed.
overhaul to sql/schema packages so that the sql package can run all on its own,
removes the entire getattr() behavior that plagued 0.1.1.
refactoring of how the mapper "synchronizes" data between two objects into a
synchronize between inherited and inheriting mappers.
made objectstore "check for out-of-identitymap" more aggressive, will perform the
check when object attributes are modified or the object is deleted
Index object fully implemented, can be constructed standalone, or via
"index" and "unique" arguments on Columns.
added "convert_unicode" flag to SQLEngine, will treat all String/CHAR types
postgres maintains a list of ANSI functions that must have no parenthesis so
function calls with no arguments work consistently
tables can be created with no engine specified. this will default their engine
be connected via the function "global_connect".
added "refresh(*obj)" method to objectstore / Session to reload the attributes of
:released: Fri Feb 24 2006
fixed a recursive call in schema that was somehow running 994 times then returning
:released: Thu Feb 23 2006
small fix to Function class so that expressions with a func.foo() use the type of the
other side which is more of a moving target (changeset 1020).
creating self-referring mappers with backrefs slightly easier (but still not that easy -
fixes to one-to-one mappings (changeset 1015)
psycopg1 date/time issue with None fixed (changeset 1005)
two issues related to postgres, which doesnt want to give you the "lastrowid"
also will not happen unless someone (usually the ORM) explicitly asks for it.
fixed a glitch with engine.execute_compiled where it was making a second
ResultProxy that just got thrown away.
began to implement newer logic in object properities. you can now say
attribute, i.e. myclass.mapper.props['attr']
eager loading has been internally overhauled to use aliases at all times. more
"use aliases"-type instructions. EagerLoader code is also much simpler now.
a new somewhat experimental flag "use_update" added to relations, indicates that
primary INSERT or before a primary DELETE. handles circular row dependencies.
added exceptions module, all raised exceptions (except for some
KeyError/AttributeError exceptions) descend from these classes.
fix to date types with MySQL, returned timedelta converted to datetime.time
two-phase objectstore.commit operations (i.e. begin/commit) now return a
transactional object (SessionTrans), to more clearly indicate transaction boundaries.
Index object with create/drop support added to schema
fix to postgres, where it will explicitly pre-execute a PassiveDefault on a table
back from postgres" issue
change to information_schema query that gets back postgres table defs, now
uses explicit JOIN keyword, since one user had faster performance with 8.1
fix to engine.process_defaults so it works correctly with a table that has
different column name/column keys (changset 982)
a column can only be attached to one table - this is now asserted
postgres time types descend from Time type
fix to alltests so that it runs types test (now named testtypes)
fix to Join object so that it correctly exports its foreign keys (cs 973)
creating relationships against mappers that use inheritance fixed (cs 973)