I am pleased to announce release 0.1.5 ! thanks to everyone who has
helped patch, identify, suggest, illustrate, and that includes
everyone on this list.
changelog:
0.1.5
- added SQLSession concept to SQLEngine. this object keeps track of
retrieving a
connection from the connection pool as well as an in-progress
transaction.
methods push_session() and pop_session() added to SQLEngine which
push/pop a new
SQLSession onto the engine, allowing operation upon a second
connection "nested"
within the previous one, allowing nested transactions. Other tricks
are sure to
come later regarding SQLSession.
- added nest_on argument to objectstore.Session. This is a single
SQLEngine or
list of engines for which push_session()/pop_session() will be called
each time
this Session becomes the active session (via objectstore.push_session
() or
equivalent). This allows a unit of work Session to take advantage of
the nested
transaction feature without explicitly calling push_session/
pop_session on the
engine.
- factored apart objectstore/unitofwork to separate "Session scoping"
from
"uow commit heavy lifting"
- added populate_instance() method to MapperExtension. allows an
extension to
modify the population of object attributes. this method can call the
populate_instance() method on another mapper to proxy the attribute
population
from one mapper to another; some row translation logic is also built
in to help
with this.
- 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 [ticket:105]
- objectstore.commit(obj1, obj2,...) adds an extra step to seek out
private
relations on properties and delete child objects, even though its not
a global
commit
- lots and lots of fixes to mappers which use inheritance,
strengthened the
concept of relations on a mapper being made towards the "local" table
for that
mapper, not the tables it inherits. allows more complex
compositional patterns
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
values
- 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
from one mapper, the second of which uses the new populate_instance()
method.
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
session
- 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
work with pysqlite1
- improvements to subqueries to more intelligently construct their FROM
clauses [ticket:116]
- added PickleType to types.
- fixed two bugs with column labels with regards to bind parameters:
bind param
keynames they are now generated from a column "label" in all relevant
cases to
take advantage of excess-name-length rules, and checks for a peculiar
collision
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
connection that is not part of the thread-local context or any current
transaction
- added invalidate() function to pooled connection. will remove the
connection
from the pool. still need work for engines to auto-reconnect to a
stale DB
though.
- added distinct() function to column elements so you can do
func.count(mycol.distinct())
- added "always_refresh" flag to Mapper, creates a mapper that will
always
refresh the attributes of objects it gets/selects from the DB,
overwriting any
changes made.
-------------------------------------------------------
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
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
