Sqlalchemy

:released: Fri May 05 2006

.. change::
:tags:
:tickets:

some fixes to topological sort algorithm

.. change::
:tags:
:tickets:

added DISTINCT ON support to Postgres (just supply distinct=[col1,col2..])

.. change::
:tags:
:tickets:

added __mod__ (% operator) to sql expressions

.. change::
:tags:
:tickets:

"order_by" mapper property inherited from inheriting mapper

.. change::
:tags:
:tickets:

fix to column type used when mapper UPDATES/DELETEs

.. change::
:tags:
:tickets:

with convert_unicode=True, reflection was failing, has been fixed

.. change::
:tags:
:tickets:

types types types! still weren't working....have to use TypeDecorator again :(

.. change::
:tags:
:tickets:

mysql binary type converts array output to buffer, fixes PickleType

.. change::
:tags:
:tickets:

fixed the attributes.py memory leak once and for all

.. change::
:tags:
:tickets:

unittests are qualified based on the databases that support each one

.. change::
:tags:
:tickets:

fixed bug where column defaults would clobber VALUES clause of insert objects

.. change::
:tags:
:tickets:

fixed bug where table def w/ schema name would force engine connection

.. change::
:tags:
:tickets:

fix for parenthesis to work correctly with subqueries in INSERT/UPDATE

.. change::
:tags:
:tickets:

HistoryArraySet gets extend() method

.. change::
:tags:
:tickets:

fixed lazyload support for other comparison operators besides =

.. change::
:tags:
:tickets:

lazyload fix where two comparisons in the join condition point to the
samem column

.. change::
:tags:
:tickets:

added "construct_new" flag to mapper, will use __new__ to create instances
instead of __init__ (standard in 0.2)

.. change::
:tags:
:tickets:

added selectresults.py to SVN, missed it last time

.. change::
:tags:
:tickets:

tweak to allow a many-to-many relationship from a table to itself via
an association table

.. change::
:tags:
:tickets:

small fix to "translate_row" function used by polymorphic example

.. change::
:tags:
:tickets:

create_engine uses cgi.parse_qsl to read query string (out the window in 0.2)

.. change::
:tags:
:tickets:

tweaks to CAST operator

.. change::
:tags:
:tickets:

fixed function names LOCAL_TIME/LOCAL_TIMESTAMP -> LOCALTIME/LOCALTIMESTAMP

.. change::
:tags:
:tickets:

fixed order of ORDER BY/HAVING in compile

.. changelog::

:released: Wed Apr 12 2006

.. change::
:tags:
:tickets:

support for MS-SQL added courtesy Rick Morrison, Runar Petursson

.. change::
:tags:
:tickets:

the latest SQLSoup from J. Ellis

.. change::
:tags:
:tickets:

ActiveMapper has preliminary support for inheritance (Jeff Watkins)

.. change::
:tags:
:tickets:

added a "mods" system which allows pluggable modules that modify/augment
core functionality, using the function "install_mods(\*modnames)".

.. change::
:tags:
:tickets:

added the first "mod", SelectResults, which modifies mapper selects to
return generators that turn ranges into LIMIT/OFFSET queries
(Jonas Borgstr?

.. change::
:tags:
:tickets:

factored out querying capabilities of Mapper into a separate Query object
which is Session-centric. this improves the performance of mapper.using(session)
and makes other things possible.

.. change::
:tags:
:tickets:

objectstore/Session refactored, the official way to save objects is now
via the flush() method. The begin/commit functionality of Session is factored
into LegacySession which is still established as the default behavior, until
the 0.2 series.

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

added 'version_id' keyword argument to mapper. this keyword should reference a
Column object with type Integer, preferably non-nullable, which will be used on
the mapped table to track version numbers. this number is incremented on each
save operation and is specified in the UPDATE/DELETE conditions so that it
factors into the returned row count, which results in a ConcurrencyError if the
value received is not the expected count.

.. change::
:tags:
:tickets:

added 'entity_name' keyword argument to mapper. a mapper is now associated
with a class via the class object as well as an optional entity_name parameter,
which is a string defaulting to None. any number of primary mappers can be
created for a class, qualified by the entity name. instances of those classes
will issue all of their load and save operations through their
entity_name-qualified mapper, and maintain separate a identity in the identity
map for an otherwise equivalent object.

.. change::
:tags:
:tickets:

overhaul to the attributes system. code has been clarified, and also fixed to
support proper polymorphic behavior on object attributes.

.. change::
:tags:
:tickets:

added "for_update" flag to Select objects

.. change::
:tags:
:tickets:

some fixes for backrefs

.. change::
:tags:
:tickets:

fix for postgres1 DateTime type

.. change::
:tags:
:tickets:

documentation pages mostly switched over to Markdown syntax

.. changelog::

:released: Mon Mar 27 2006

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

factored apart objectstore/unitofwork to separate "Session scoping" from
"uow commit heavy lifting"

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

fixed Oracle8-compatibility "use_ansi" flag which converts JOINs to
comparisons with the = and (+) operators, passes basic unittests

.. change::
:tags:
:tickets:

tweaks to Oracle LIMIT/OFFSET support

.. change::
:tags:
:tickets:

Oracle reflection uses ALL_** views instead of USER_** to get larger
list of stuff to reflect from

.. change::
:tags:
:tickets: 105

fixes to Oracle foreign key reflection

.. change::
:tags:
:tickets:

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

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

some minor speed improvements to the attributes system with regards to
instantiating and populating new objects.

.. change::
:tags:
:tickets:

fixed MySQL binary unit test

.. change::
:tags:
:tickets:

INSERTs can receive clause elements as VALUES arguments, not just literal
values

.. change::
:tags:
:tickets:

support for calling multi-tokened functions, i.e. schema.mypkg.func()

.. change::
:tags:
:tickets:

added J. Ellis' SQLSoup module to extensions package

.. change::
:tags:
:tickets:

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

.. change::
:tags:
:tickets:

improvements/fixes to session.refresh()/session.expire() (which may have
been called "invalidate" earlier..)

.. change::
:tags:
:tickets:

added session.expunge() which totally removes an object from the current
session

.. change::
:tags:
:tickets:

added \*args, \**kwargs pass-through to engine.transaction(func) allowing easier
creation of transactionalizing decorator functions

.. change::
:tags:
:tickets:

added iterator interface to ResultProxy: "for row in result:..."

.. change::
:tags:
:tickets:

added assertion to tx = session.begin(); tx.rollback(); tx.begin(), i.e. can't
use it after a rollback()

.. change::
:tags:
:tickets:

added date conversion on bind parameter fix to SQLite enabling dates to
work with pysqlite1

.. change::
:tags:
:tickets: 116

improvements to subqueries to more intelligently construct their FROM
clauses

.. change::
:tags:
:tickets:

added PickleType to types.

.. change::
:tags:
:tickets:

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

.. change::
:tags:
:tickets:

major overhaul to unit of work documentation, other documentation sections.

.. change::
:tags:
:tickets:

fixed attributes bug where if an object is committed, its lazy-loaded list got
blown away if it hadn't been loaded

.. change::
:tags:
:tickets:

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

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

added distinct() function to column elements so you can do
func.count(mycol.distinct())

.. change::
:tags:
:tickets:

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.

.. changelog::

:released: Mon Mar 13 2006

.. change::
:tags:
:tickets:

create_engine() now uses genericized parameters; host/hostname,
db/dbname/database, password/passwd, etc. for all engine connections. makes
engine URIs much more "universal"

.. change::
:tags:
:tickets:

added support for SELECT statements embedded into a column clause, using the
flag "scalar=True"

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

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

.. change::
:tags:
:tickets:

added onupdate parameter to Column, will exec SQL/python upon an update
statement.Also adds "for_update=True" to all DefaultGenerator subclasses

.. change::
:tags:
:tickets:

added support for Oracle table reflection contributed by Andrija Zaric;
still some bugs to work out regarding composite primary keys/dictionary selection

.. change::
:tags:
:tickets:

checked in an initial Firebird module, awaiting testing.

.. change::
:tags:
:tickets:

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

.. change::
:tags:
:tickets:

more docs for indexes, column defaults, connection pooling, engine construction

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

added "convert_unicode=False" parameter to SQLEngine, will cause all String
types to perform unicode encoding/decoding (makes Strings act like Unicodes)

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

improved support for mapping against UNIONs, added polymorph.py example
to illustrate multi-class mapping against a UNION

.. change::
:tags:
:tickets:

fix to SQLite LIMIT/OFFSET syntax

.. change::
:tags:
:tickets:

fix to Oracle LIMIT syntax

.. change::
:tags:
:tickets:

added backref() function, allows backreferences to have keyword arguments
that will be passed to the backref.

.. change::
:tags:
:tickets:

Sequences and ColumnDefault objects can do execute()/scalar() standalone

.. change::
:tags:
:tickets:

SQL functions (i.e. func.foo()) can do execute()/scalar() standalone

.. change::
:tags:
:tickets:

fix to SQL functions so that the ANSI-standard functions, i.e. current_timestamp
etc., do not specify parenthesis. all other functions do.

.. change::
:tags:
:tickets:

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')

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

added 'get_session().invalidate(\*obj)' method to objectstore, instances will
refresh() themselves upon the next attribute access.

.. change::
:tags:
:tickets:

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

.. change::
:tags:
:tickets:

fix to MySQL4 custom table engines, i.e. TYPE instead of ENGINE

.. change::
:tags:
:tickets:

slightly enhanced logging, includes timestamps and a somewhat configurable
formatting system, in lieu of a full-blown logging system

.. change::
:tags:
:tickets:

improvements to the ActiveMapper class from the TG gang, including
many-to-many relationships

.. change::
:tags:
:tickets:

added Double and TinyInt support to mysql

.. changelog::

:released: Thu Mar 02 2006

.. change::
:tags:
:tickets:

completed "post_update" feature, will add a second update statement before
inserts and after deletes in order to reconcile a relationship without any
dependencies being created; used when persisting two rows that are dependent
on each other

.. change::
:tags:
:tickets:

completed mapper.using(session) function, localized per-object Session
functionality; objects can be declared and manipulated as local to any
user-defined Session

.. change::
:tags:
:tickets:

fix to Oracle "row_number over" clause with multiple tables

.. change::
:tags:
:tickets:

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.

.. change::
:tags:
:tickets:

overhaul to sql/schema packages so that the sql package can run all on its own,
producing selects, inserts, etc. without any engine dependencies. builds upon
new TableClause/ColumnClause lexical objects. Schema's Table/Column objects
are the "physical" subclasses of them. simplifies schema/sql relationship,
extensions (like proxyengine), and speeds overall performance by a large margin.
removes the entire getattr() behavior that plagued 0.1.1.

.. change::
:tags:
:tickets:

refactoring of how the mapper "synchronizes" data between two objects into a
separate module, works better with properties attached to a mapper that has an
additional inheritance relationship to one of the related tables, also the same
methodology used to synchronize parent/child objects now used by mapper to
synchronize between inherited and inheriting mappers.

.. change::
:tags:
:tickets:

made objectstore "check for out-of-identitymap" more aggressive, will perform the
check when object attributes are modified or the object is deleted

.. change::
:tags:
:tickets:

Index object fully implemented, can be constructed standalone, or via
"index" and "unique" arguments on Columns.

.. change::
:tags:
:tickets:

added "convert_unicode" flag to SQLEngine, will treat all String/CHAR types
as Unicode types, with raw-byte/utf-8 translation on the bind parameter and
result set side.

.. change::
:tags:
:tickets:

postgres maintains a list of ANSI functions that must have no parenthesis so
function calls with no arguments work consistently

.. change::
:tags:
:tickets:

tables can be created with no engine specified. this will default their engine
to a module-scoped "default engine" which is a ProxyEngine. this engine can
be connected via the function "global_connect".

.. change::
:tags:
:tickets:

added "refresh(\*obj)" method to objectstore / Session to reload the attributes of
any set of objects from the database unconditionally

.. changelog::

:released: Fri Feb 24 2006

.. change::
:tags:
:tickets:

fixed a recursive call in schema that was somehow running 994 times then returning
normally. broke nothing, slowed down everything. thanks to jpellerin for finding this.

.. changelog::