9
:released: Fri May 05 2006
15
some fixes to topological sort algorithm
21
added DISTINCT ON support to Postgres (just supply distinct=[col1,col2..])
27
added __mod__ (% operator) to sql expressions
33
"order_by" mapper property inherited from inheriting mapper
39
fix to column type used when mapper UPDATES/DELETEs
45
with convert_unicode=True, reflection was failing, has been fixed
51
types types types! still werent working....have to use TypeDecorator again :(
57
mysql binary type converts array output to buffer, fixes PickleType
63
fixed the attributes.py memory leak once and for all
69
unittests are qualified based on the databases that support each one
75
fixed bug where column defaults would clobber VALUES clause of insert objects
81
fixed bug where table def w/ schema name would force engine connection
87
fix for parenthesis to work correctly with subqueries in INSERT/UPDATE
93
HistoryArraySet gets extend() method
99
fixed lazyload support for other comparison operators besides =
105
lazyload fix where two comparisons in the join condition point to the
112
added "construct_new" flag to mapper, will use __new__ to create instances
113
instead of __init__ (standard in 0.2)
119
added selectresults.py to SVN, missed it last time
125
tweak to allow a many-to-many relationship from a table to itself via
132
small fix to "translate_row" function used by polymorphic example
138
create_engine uses cgi.parse_qsl to read query string (out the window in 0.2)
144
tweaks to CAST operator
150
fixed function names LOCAL_TIME/LOCAL_TIMESTAMP -> LOCALTIME/LOCALTIMESTAMP
156
fixed order of ORDER BY/HAVING in compile
160
:released: Wed Apr 12 2006
166
support for MS-SQL added courtesy Rick Morrison, Runar Petursson
172
the latest SQLSoup from J. Ellis
178
ActiveMapper has preliminary support for inheritance (Jeff Watkins)
184
added a "mods" system which allows pluggable modules that modify/augment
185
core functionality, using the function "install_mods(*modnames)".
191
added the first "mod", SelectResults, which modifies mapper selects to
192
return generators that turn ranges into LIMIT/OFFSET queries
199
factored out querying capabilities of Mapper into a separate Query object
200
which is Session-centric. this improves the performance of mapper.using(session)
201
and makes other things possible.
207
objectstore/Session refactored, the official way to save objects is now
208
via the flush() method. The begin/commit functionality of Session is factored
209
into LegacySession which is still established as the default behavior, until
216
types system is bound to an engine at query compile time, not schema
217
construction time. this simplifies the types system as well as the ProxyEngine.
223
added 'version_id' keyword argument to mapper. this keyword should reference a
224
Column object with type Integer, preferably non-nullable, which will be used on
225
the mapped table to track version numbers. this number is incremented on each
226
save operation and is specifed in the UPDATE/DELETE conditions so that it
227
factors into the returned row count, which results in a ConcurrencyError if the
228
value received is not the expected count.
234
added 'entity_name' keyword argument to mapper. a mapper is now associated
235
with a class via the class object as well as an optional entity_name parameter,
236
which is a string defaulting to None. any number of primary mappers can be
237
created for a class, qualified by the entity name. instances of those classes
238
will issue all of their load and save operations through their
239
entity_name-qualified mapper, and maintain separate a identity in the identity
240
map for an otherwise equilvalent object.
246
overhaul to the attributes system. code has been clarified, and also fixed to
247
support proper polymorphic behavior on object attributes.
253
added "for_update" flag to Select objects
259
some fixes for backrefs
265
fix for postgres1 DateTime type
271
documentation pages mostly switched over to Markdown syntax
275
:released: Mon Mar 27 2006
281
added SQLSession concept to SQLEngine. this object keeps track of retrieving a
282
connection from the connection pool as well as an in-progress transaction.
283
methods push_session() and pop_session() added to SQLEngine which push/pop a new
284
SQLSession onto the engine, allowing operation upon a second connection "nested"
285
within the previous one, allowing nested transactions. Other tricks are sure to
286
come later regarding SQLSession.
292
added nest_on argument to objectstore.Session. This is a single SQLEngine or
293
list of engines for which push_session()/pop_session() will be called each time
294
this Session becomes the active session (via objectstore.push_session() or
295
equivalent). This allows a unit of work Session to take advantage of the nested
296
transaction feature without explicitly calling push_session/pop_session on the
303
factored apart objectstore/unitofwork to separate "Session scoping" from
304
"uow commit heavy lifting"
310
added populate_instance() method to MapperExtension. allows an extension to
311
modify the population of object attributes. this method can call the
312
populate_instance() method on another mapper to proxy the attribute population
313
from one mapper to another; some row translation logic is also built in to help
320
fixed Oracle8-compatibility "use_ansi" flag which converts JOINs to
321
comparisons with the = and (+) operators, passes basic unittests
327
tweaks to Oracle LIMIT/OFFSET support
333
Oracle reflection uses ALL_** views instead of USER_** to get larger
334
list of stuff to reflect from
340
fixes to Oracle foreign key reflection
346
objectstore.commit(obj1, obj2,...) adds an extra step to seek out private
347
relations on properties and delete child objects, even though its not a global
354
lots and lots of fixes to mappers which use inheritance, strengthened the
355
concept of relations on a mapper being made towards the "local" table for that
356
mapper, not the tables it inherits. allows more complex compositional patterns
357
to work with lazy/eager loading.
363
added support for mappers to inherit from others based on the same table,
364
just specify the same table as that of both parent/child mapper.
370
some minor speed improvements to the attributes system with regards to
371
instantiating and populating new objects.
377
fixed MySQL binary unit test
383
INSERTs can receive clause elements as VALUES arguments, not just literal
390
support for calling multi-tokened functions, i.e. schema.mypkg.func()
396
added J. Ellis' SQLSoup module to extensions package
402
added "polymorphic" examples illustrating methods to load multiple object types
403
from one mapper, the second of which uses the new populate_instance() method.
404
small improvements to mapper, UNION construct to help the examples along
410
improvements/fixes to session.refresh()/session.expire() (which may have
411
been called "invalidate" earlier..)
417
added session.expunge() which totally removes an object from the current
424
added *args, **kwargs pass-thru to engine.transaction(func) allowing easier
425
creation of transactionalizing decorator functions
431
added iterator interface to ResultProxy: "for row in result:..."
437
added assertion to tx = session.begin(); tx.rollback(); tx.begin(), i.e. cant
438
use it after a rollback()
444
added date conversion on bind parameter fix to SQLite enabling dates to
451
improvements to subqueries to more intelligently construct their FROM
458
added PickleType to types.
464
fixed two bugs with column labels with regards to bind parameters: bind param
465
keynames they are now generated from a column "label" in all relevant cases to
466
take advantage of excess-name-length rules, and checks for a peculiar collision
467
against a column named the same as "tablename_colname" added
473
major overhaul to unit of work documentation, other documentation sections.
479
fixed attributes bug where if an object is committed, its lazy-loaded list got
480
blown away if it hadnt been loaded
486
added unique_connection() method to engine, connection pool to return a
487
connection that is not part of the thread-local context or any current
494
added invalidate() function to pooled connection. will remove the connection
495
from the pool. still need work for engines to auto-reconnect to a stale DB
502
added distinct() function to column elements so you can do
503
func.count(mycol.distinct())
509
added "always_refresh" flag to Mapper, creates a mapper that will always
510
refresh the attributes of objects it gets/selects from the DB, overwriting any
515
:released: Mon Mar 13 2006
521
create_engine() now uses genericized parameters; host/hostname,
522
db/dbname/database, password/passwd, etc. for all engine connections. makes
523
engine URIs much more "universal"
529
added support for SELECT statements embedded into a column clause, using the
536
another overhaul to EagerLoading when used in conjunction with mappers that
537
inherit; improvements to eager loads figuring out their aliased queries
538
correctly, also relations set up against a mapper with inherited mappers will
539
create joins against the table that is specific to the mapper itself (i.e. and
540
not any tables that are inherited/are further down the inheritance chain),
541
this can be overridden by using custom primary/secondary joins.
547
added J.Ellis patch to mapper.py so that selectone() throws an exception
548
if query returns more than one object row, selectfirst() to not throw the
549
exception. also adds selectfirst_by (synonymous with get_by) and selectone_by
555
added onupdate parameter to Column, will exec SQL/python upon an update
556
statement.Also adds "for_update=True" to all DefaultGenerator subclasses
562
added support for Oracle table reflection contributed by Andrija Zaric;
563
still some bugs to work out regarding composite primary keys/dictionary selection
569
checked in an initial Firebird module, awaiting testing.
575
added sql.ClauseParameters dictionary object as the result for
576
compiled.get_params(), does late-typeprocessing of bind parameters so
577
that the original values are easier to access
583
more docs for indexes, column defaults, connection pooling, engine construction
589
overhaul to the construction of the types system. uses a simpler inheritance
590
pattern so that any of the generic types can be easily subclassed, with no need
597
added "convert_unicode=False" parameter to SQLEngine, will cause all String
598
types to perform unicode encoding/decoding (makes Strings act like Unicodes)
604
added 'encoding="utf8"' parameter to engine. the given encoding will be
605
used for all encode/decode calls within Unicode types as well as Strings
606
when convert_unicode=True.
612
improved support for mapping against UNIONs, added polymorph.py example
613
to illustrate multi-class mapping against a UNION
619
fix to SQLite LIMIT/OFFSET syntax
625
fix to Oracle LIMIT syntax
631
added backref() function, allows backreferences to have keyword arguments
632
that will be passed to the backref.
638
Sequences and ColumnDefault objects can do execute()/scalar() standalone
644
SQL functions (i.e. func.foo()) can do execute()/scalar() standalone
650
fix to SQL functions so that the ANSI-standard functions, i.e. current_timestamp
651
etc., do not specify parenthesis. all other functions do.
657
added settattr_clean and append_clean to SmartProperty, which set
658
attributes without triggering a "dirty" event or any history. used as:
659
myclass.prop1.setattr_clean(myobject, 'hi')
665
improved support to column defaults when used by mappers; mappers will pull
666
pre-executed defaults from statement's executed bind parameters
667
(pre-conversion) to populate them into a saved object's attributes; if any
668
PassiveDefaults have fired off, will instead post-fetch the row from the DB to
675
added 'get_session().invalidate(*obj)' method to objectstore, instances will
676
refresh() themselves upon the next attribute access.
682
improvements to SQL func calls including an "engine" keyword argument so
683
they can be execute()d or scalar()ed standalone, also added func accessor to
690
fix to MySQL4 custom table engines, i.e. TYPE instead of ENGINE
696
slightly enhanced logging, includes timestamps and a somewhat configurable
697
formatting system, in lieu of a full-blown logging system
703
improvements to the ActiveMapper class from the TG gang, including
704
many-to-many relationships
710
added Double and TinyInt support to mysql
714
:released: Thu Mar 02 2006
720
completed "post_update" feature, will add a second update statement before
721
inserts and after deletes in order to reconcile a relationship without any
722
dependencies being created; used when persisting two rows that are dependent
729
completed mapper.using(session) function, localized per-object Session
730
functionality; objects can be declared and manipulated as local to any
737
fix to Oracle "row_number over" clause with multiple tables
743
mapper.get() was not selecting multiple-keyed objects if the mapper's table was a join,
744
such as in an inheritance relationship, this is fixed.
750
overhaul to sql/schema packages so that the sql package can run all on its own,
751
producing selects, inserts, etc. without any engine dependencies. builds upon
752
new TableClause/ColumnClause lexical objects. Schema's Table/Column objects
753
are the "physical" subclasses of them. simplifies schema/sql relationship,
754
extensions (like proxyengine), and speeds overall performance by a large margin.
755
removes the entire getattr() behavior that plagued 0.1.1.
761
refactoring of how the mapper "synchronizes" data between two objects into a
762
separate module, works better with properties attached to a mapper that has an
763
additional inheritance relationship to one of the related tables, also the same
764
methodology used to synchronize parent/child objects now used by mapper to
765
synchronize between inherited and inheriting mappers.
771
made objectstore "check for out-of-identitymap" more aggressive, will perform the
772
check when object attributes are modified or the object is deleted
778
Index object fully implemented, can be constructed standalone, or via
779
"index" and "unique" arguments on Columns.
785
added "convert_unicode" flag to SQLEngine, will treat all String/CHAR types
786
as Unicode types, with raw-byte/utf-8 translation on the bind parameter and
793
postgres maintains a list of ANSI functions that must have no parenthesis so
794
function calls with no arguments work consistently
800
tables can be created with no engine specified. this will default their engine
801
to a module-scoped "default engine" which is a ProxyEngine. this engine can
802
be connected via the function "global_connect".
808
added "refresh(*obj)" method to objectstore / Session to reload the attributes of
809
any set of objects from the database unconditionally
813
:released: Fri Feb 24 2006
819
fixed a recursive call in schema that was somehow running 994 times then returning
820
normally. broke nothing, slowed down everything. thanks to jpellerin for finding this.
824
:released: Thu Feb 23 2006
830
small fix to Function class so that expressions with a func.foo() use the type of the
831
Function object (i.e. the left side) as the type of the boolean expression, not the
832
other side which is more of a moving target (changeset 1020).
838
creating self-referring mappers with backrefs slightly easier (but still not that easy -
845
fixes to one-to-one mappings (changeset 1015)
851
psycopg1 date/time issue with None fixed (changeset 1005)
857
two issues related to postgres, which doesnt want to give you the "lastrowid"
858
since oids are deprecated:
859
* postgres database-side defaults that are on primary key cols *do* execute
860
explicitly beforehand, even though thats not the idea of a PassiveDefault. this is
861
because sequences on columns get reflected as PassiveDefaults, but need to be explicitly
862
executed on a primary key col so we know what we just inserted.
863
* if you did add a row that has a bunch of database-side defaults on it,
864
and the PassiveDefault thing was working the old way, i.e. they just execute on
865
the DB side, the "cant get the row back without an OID" exception that occurred
866
also will not happen unless someone (usually the ORM) explicitly asks for it.
872
fixed a glitch with engine.execute_compiled where it was making a second
873
ResultProxy that just got thrown away.
879
began to implement newer logic in object properities. you can now say
880
myclass.attr.property, which will give you the PropertyLoader corresponding to that
881
attribute, i.e. myclass.mapper.props['attr']
887
eager loading has been internally overhauled to use aliases at all times. more
888
complicated chains of eager loads can now be created without any need for explicit
889
"use aliases"-type instructions. EagerLoader code is also much simpler now.
895
a new somewhat experimental flag "use_update" added to relations, indicates that
896
this relationship should be handled by a second UPDATE statement, either after a
897
primary INSERT or before a primary DELETE. handles circular row dependencies.
903
added exceptions module, all raised exceptions (except for some
904
KeyError/AttributeError exceptions) descend from these classes.
910
fix to date types with MySQL, returned timedelta converted to datetime.time
916
two-phase objectstore.commit operations (i.e. begin/commit) now return a
917
transactional object (SessionTrans), to more clearly indicate transaction boundaries.
923
Index object with create/drop support added to schema
929
fix to postgres, where it will explicitly pre-execute a PassiveDefault on a table
930
if it is a primary key column, pursuant to the ongoing "we cant get inserted rows
931
back from postgres" issue
937
change to information_schema query that gets back postgres table defs, now
938
uses explicit JOIN keyword, since one user had faster performance with 8.1
944
fix to engine.process_defaults so it works correctly with a table that has
945
different column name/column keys (changset 982)
951
a column can only be attached to one table - this is now asserted
957
postgres time types descend from Time type
963
fix to alltests so that it runs types test (now named testtypes)
969
fix to Join object so that it correctly exports its foreign keys (cs 973)
975
creating relationships against mappers that use inheritance fixed (cs 973)