]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/log
thirdparty/sqlalchemy/sqlalchemy.git
19 years agoadded explicit "session" argument to get(), select_whereclause in mapper, as well...
Mike Bayer [Thu, 6 Apr 2006 19:01:14 +0000 (19:01 +0000)] 
added explicit "session" argument to get(), select_whereclause in mapper, as well as throughout the call-chain for those.  lazy loader honors the "session" of the parent object, + added simple unit test

19 years agothis assertion not really needed, esp. if a PickleType is used to take in a list
Mike Bayer [Thu, 6 Apr 2006 14:54:16 +0000 (14:54 +0000)] 
this assertion not really needed, esp. if a PickleType is used to take in a list

19 years agoadded pickle test
Mike Bayer [Thu, 6 Apr 2006 14:32:57 +0000 (14:32 +0000)] 
added pickle test

19 years agothe ultimate "hands off" approach to the object's dictionary of managed attributes
Mike Bayer [Thu, 6 Apr 2006 14:27:03 +0000 (14:27 +0000)] 
the ultimate "hands off" approach to the object's dictionary of managed attributes

19 years agomoves the binding of a TypeEngine object from "schema/statement creation" time into...
Mike Bayer [Thu, 6 Apr 2006 01:15:46 +0000 (01:15 +0000)] 
moves the binding of a TypeEngine object from "schema/statement creation" time into "compilation" time

19 years agofactored oid column into a consistent late-bound pattern, fixing [ticket:146]
Mike Bayer [Tue, 4 Apr 2006 21:40:18 +0000 (21:40 +0000)] 
factored oid column into a consistent late-bound pattern, fixing [ticket:146]

19 years agoAdded cast() to allow use of cast(tbl.c.col as Numeric(4,2)) in select and where...
Robert Leftwich [Tue, 4 Apr 2006 00:28:33 +0000 (00:28 +0000)] 
Added cast() to allow use of cast(tbl.c.col as Numeric(4,2)) in select and where clauses. Unit tests for same.

19 years agoput proper return type
Mike Bayer [Mon, 3 Apr 2006 22:48:28 +0000 (22:48 +0000)] 
put proper return type

19 years agoadjustments to auto-table-aliasing logic (R. Morrison)
Mike Bayer [Mon, 3 Apr 2006 22:04:08 +0000 (22:04 +0000)] 
adjustments to auto-table-aliasing logic (R. Morrison)

19 years agoadded a unit test for the "version_id" keyword argument, which passes based on previo...
Mike Bayer [Mon, 3 Apr 2006 22:01:35 +0000 (22:01 +0000)] 
added a unit test for the "version_id" keyword argument, which passes based on previous changes to Mapper

19 years agoupdate
Mike Bayer [Mon, 3 Apr 2006 21:46:00 +0000 (21:46 +0000)] 
update

19 years agoadded 'entity_name' keyword argument to mapper. a mapper is now associated with...
Mike Bayer [Mon, 3 Apr 2006 21:43:22 +0000 (21:43 +0000)] 
added 'entity_name' keyword argument to mapper.  a mapper is now associated with a class via
the class object as well as the 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 identity from an otherwise equilvalent object.

19 years agoattributes overhaul #2 - attribute manager now tracks class-level initializers strict...
Mike Bayer [Mon, 3 Apr 2006 21:04:16 +0000 (21:04 +0000)] 
attributes overhaul #2 - attribute manager now tracks class-level initializers strictly through the SmartPropery instances attached to the class, so that attributes retain their natural polymorphic behavior.  naming conventions migrating to "managed_attribute", simplifying codepaths.

19 years agofurther order_by: order_by() with no arguments should not affect the current order_b...
Mike Bayer [Mon, 3 Apr 2006 17:49:41 +0000 (17:49 +0000)] 
further order_by:  order_by() with no arguments should not affect the current order_by clause (same with group_by)

19 years agoack, fixes to the order by stuff from last night
Mike Bayer [Mon, 3 Apr 2006 17:46:08 +0000 (17:46 +0000)] 
ack, fixes to the order by stuff from last night

19 years agoDOH !
Mike Bayer [Mon, 3 Apr 2006 17:13:42 +0000 (17:13 +0000)] 
DOH !

19 years agostill tryin to clarify....
Mike Bayer [Mon, 3 Apr 2006 05:50:34 +0000 (05:50 +0000)] 
still tryin to clarify....

19 years agoadded to_selectable() onto ColumnClause to simplify _get_col_by_original
Mike Bayer [Mon, 3 Apr 2006 05:22:42 +0000 (05:22 +0000)] 
added to_selectable() onto ColumnClause to simplify _get_col_by_original

19 years agomade order_by/group_by construction a little more simplisitc
Mike Bayer [Mon, 3 Apr 2006 05:00:53 +0000 (05:00 +0000)] 
made order_by/group_by construction a little more simplisitc
fix to mapper extension
CompoundSelect can export all columns now, not sure if theres any advantage there

19 years agoadded a type to label....
Mike Bayer [Mon, 3 Apr 2006 03:24:06 +0000 (03:24 +0000)] 
added a type to label....

19 years agoconverted to markdown, added MS-SQL
Mike Bayer [Mon, 3 Apr 2006 02:00:18 +0000 (02:00 +0000)] 
converted to markdown, added MS-SQL

19 years agomerged Rick Morrison / Runar Petursson's MS-SQL module, with adjustments to alias...
Mike Bayer [Mon, 3 Apr 2006 01:35:48 +0000 (01:35 +0000)] 
merged Rick Morrison / Runar Petursson's MS-SQL module, with adjustments to alias schema-qualified Table objects

19 years agoextra sql statements...
Mike Bayer [Sun, 2 Apr 2006 22:56:19 +0000 (22:56 +0000)] 
extra sql statements...

19 years agogot SQL blocks to work with markdown system, other enhancements
Mike Bayer [Sun, 2 Apr 2006 22:52:13 +0000 (22:52 +0000)] 
got SQL blocks to work with markdown system, other enhancements
sqlconstruction converted to markdown syntax

19 years agofixed reset_history method when applied to an attribute that had an attribute-level...
Mike Bayer [Sun, 2 Apr 2006 04:13:03 +0000 (04:13 +0000)] 
fixed reset_history method when applied to an attribute that had an attribute-level TriggeredAttribute set on it, added unit test.

19 years agofix to oeprator test for new parenthesized rules
Mike Bayer [Sun, 2 Apr 2006 04:09:05 +0000 (04:09 +0000)] 
fix to oeprator test for new parenthesized rules

19 years agoadded "parenthesis" check on binary clauses referencing binary clauses, for [ticket...
Mike Bayer [Sun, 2 Apr 2006 03:22:17 +0000 (03:22 +0000)] 
added "parenthesis" check on binary clauses referencing binary clauses, for [ticket:144]

19 years agocleanup of attributes, better naming, added weak reference to base managed attribute...
Mike Bayer [Sat, 1 Apr 2006 21:00:41 +0000 (21:00 +0000)] 
cleanup of attributes, better naming, added weak reference to base managed attribute to break circular refs, slightly shorter codepaths in some cases. added performance tester

19 years agosecond assertion
Mike Bayer [Fri, 31 Mar 2006 23:46:02 +0000 (23:46 +0000)] 
second assertion

19 years agoadded unit test for the old commit that was in [changeset:1186]. modified its behavi...
Mike Bayer [Fri, 31 Mar 2006 23:43:20 +0000 (23:43 +0000)] 
added unit test for the old commit that was in [changeset:1186].  modified its behavior a bit to not delete private relationships unless they were already marked as deleted at the attribute manipulation level.  got "switching" behavior from one private relationship to another to work, added a unit test for that.

19 years agoadded for_update flag to Select/CompoundSelect
Mike Bayer [Fri, 31 Mar 2006 22:28:17 +0000 (22:28 +0000)] 
added for_update flag to Select/CompoundSelect

19 years agoadjustments...
Mike Bayer [Fri, 31 Mar 2006 07:36:51 +0000 (07:36 +0000)] 
adjustments...

19 years agotweak...
Mike Bayer [Fri, 31 Mar 2006 07:29:28 +0000 (07:29 +0000)] 
tweak...

19 years agogot install_mods to work
Mike Bayer [Fri, 31 Mar 2006 07:22:45 +0000 (07:22 +0000)] 
got install_mods to work

19 years agointroducing...the mods package ! the SelectResults thing moves as the first mod
Mike Bayer [Fri, 31 Mar 2006 07:20:13 +0000 (07:20 +0000)] 
introducing...the mods package ! the SelectResults thing moves as the first mod

19 years agostarting to refactor mapper slightly, adding entity_name, version_id_col, allowing...
Mike Bayer [Fri, 31 Mar 2006 04:27:05 +0000 (04:27 +0000)] 
starting to refactor mapper slightly, adding entity_name, version_id_col, allowing keywords in mapper.options()

19 years agowow, __len__ is a real disaster when combined with list()...turning that off
Mike Bayer [Fri, 31 Mar 2006 02:41:32 +0000 (02:41 +0000)] 
wow, __len__ is a real disaster when combined with list()...turning that off

19 years agoJonas Borgström's fantastic SelectRsults patch that adds dynamic list argument suppor...
Mike Bayer [Fri, 31 Mar 2006 02:25:59 +0000 (02:25 +0000)] 
Jonas Borgström's fantastic SelectRsults patch that adds dynamic list argument support to the mapper.select() methd.  associated unit test tweaks and mapper integration.

19 years agofixed default example
Mike Bayer [Tue, 28 Mar 2006 03:07:50 +0000 (03:07 +0000)] 
fixed default example

19 years agofixed "DISTINCT" spelling
Mike Bayer [Tue, 28 Mar 2006 02:04:32 +0000 (02:04 +0000)] 
fixed "DISTINCT" spelling

19 years agod rel_0_1_5
Mike Bayer [Mon, 27 Mar 2006 03:12:27 +0000 (03:12 +0000)] 
d

19 years agotweak to mapper to allow inheritance on the same table.
Mike Bayer [Mon, 27 Mar 2006 02:58:20 +0000 (02:58 +0000)] 
tweak to mapper to allow inheritance on the same table.

19 years agobackrefs on cyclical relationships were breaking for the "root" node which had None...
Mike Bayer [Mon, 27 Mar 2006 02:02:06 +0000 (02:02 +0000)] 
backrefs on cyclical relationships were breaking for the "root" node which had None for a parent, due to addition in [changeset:1186] which added a "deletion" traversal for many-to-one relationships.  added unittest.

19 years ago0.1.5 prep
Mike Bayer [Mon, 27 Mar 2006 00:51:51 +0000 (00:51 +0000)] 
0.1.5 prep

19 years agoremoved..
Mike Bayer [Mon, 27 Mar 2006 00:16:54 +0000 (00:16 +0000)] 
removed..

19 years agoadded always_refresh flag. when the mapper loads rows, it will pull objects from...
Mike Bayer [Sun, 26 Mar 2006 23:51:13 +0000 (23:51 +0000)] 
added always_refresh flag.  when the mapper loads rows, it will pull objects from the identity map normally, but always blows away their attributes and replaces with those from the database, including changes

19 years agorework to expire() to make it smarter. when you expire(), history is immediately...
Mike Bayer [Sun, 26 Mar 2006 21:44:22 +0000 (21:44 +0000)] 
rework to expire() to make it smarter.  when you expire(), history is immediately removed as well as explicit from dirty/deleted lists.  this also changes uow.rollback_object() to remove from those lists, which is strange that it didnt do that before.  anyway the mapper, when selecting and creating instances, asks the uow if this already identity-mapped instance is expired, and if so refreshes it on the fly, saving the need for the re-_get() operation, if some other query happens to touch upon the expired object.  unit test added to confirm this.

19 years agofixed pickle example, its standard anyway....
Mike Bayer [Sun, 26 Mar 2006 19:58:08 +0000 (19:58 +0000)] 
fixed pickle example, its standard anyway....

19 years agocolumn label generation checks for a conflict against a column named the same as...
Mike Bayer [Sun, 26 Mar 2006 15:36:43 +0000 (15:36 +0000)] 
column label generation checks for a conflict against a column named the same as the label
comment in mapper

19 years agoimproved translation of rows when proxying rows from one mapper to another.
Mike Bayer [Sun, 26 Mar 2006 07:21:28 +0000 (07:21 +0000)] 
improved translation of rows when proxying rows from one mapper to another.

19 years agoa cool example that illustrates vertical table storage, and objects that automaticall...
Mike Bayer [Sun, 26 Mar 2006 06:30:21 +0000 (06:30 +0000)] 
a cool example that illustrates vertical table storage, and objects that automatically configure themselves for this type of storage

19 years agoexcept it fails a unit test. OK, make it ia KeyError
Mike Bayer [Sun, 26 Mar 2006 06:29:47 +0000 (06:29 +0000)] 
except it fails  a unit test.  OK, make it ia KeyError

19 years agoutil: the __setitem__ method on historyarraylist was meaningless, surprising nobody...
Mike Bayer [Sun, 26 Mar 2006 06:26:02 +0000 (06:26 +0000)] 
util: the __setitem__ method on historyarraylist was meaningless, surprising nobody noticed that.
types:  added PickleType, its slightly trickier than trivial, so OK now its standard.
attributes: the level of pain if an AttributeError occurs inside a CallableProp, in combination with an object that implements __getattr__,  is too deep for me to put the users through....so convert AttributeErrors to Assertions...
engine: im not a fan of catching universal exceptions and squashing them

19 years agoremoved circular loop in creating new list elements, fixes a common refresh() condition
Mike Bayer [Sat, 25 Mar 2006 21:44:42 +0000 (21:44 +0000)] 
removed circular loop in creating new list elements, fixes a common refresh() condition
added None check in PropertyLoader many-to-one private deletion traversal, fixes byroot_tree (add a unit test for that)

19 years agoremoved all "tablename + '_' + columname" code and replaced with column._label, to...
Mike Bayer [Sat, 25 Mar 2006 21:14:54 +0000 (21:14 +0000)] 
removed all "tablename + '_' + columname" code and replaced with column._label, to take
advantage of column labeling rules
bind param compilation,when it unique-ifys the name of bind params, maintains the length
of the bind parameter name instead of appending to it

19 years agoadded *args **kwargs pass-thru to transaction()
Mike Bayer [Sat, 25 Mar 2006 20:32:10 +0000 (20:32 +0000)] 
added *args **kwargs pass-thru to transaction()

19 years agomethod add
Mike Bayer [Sat, 25 Mar 2006 20:28:01 +0000 (20:28 +0000)] 
method add

19 years agoadded expire/refresh/expunge to assign_mapper
Mike Bayer [Sat, 25 Mar 2006 20:27:25 +0000 (20:27 +0000)] 
added expire/refresh/expunge to assign_mapper

19 years agoah well the overflow doesnt work
Mike Bayer [Sat, 25 Mar 2006 19:52:37 +0000 (19:52 +0000)] 
ah well the overflow doesnt work

19 years agodev
Mike Bayer [Sat, 25 Mar 2006 19:46:04 +0000 (19:46 +0000)] 
dev

19 years agodev
Mike Bayer [Sat, 25 Mar 2006 19:34:34 +0000 (19:34 +0000)] 
dev

19 years agodoc dev...
Mike Bayer [Sat, 25 Mar 2006 18:53:51 +0000 (18:53 +0000)] 
doc dev...

19 years agodoc dev
Mike Bayer [Sat, 25 Mar 2006 18:13:01 +0000 (18:13 +0000)] 
doc dev

19 years agodoc devel
Mike Bayer [Sat, 25 Mar 2006 17:23:41 +0000 (17:23 +0000)] 
doc devel

19 years agoupdate to types doc
Mike Bayer [Sat, 25 Mar 2006 15:25:29 +0000 (15:25 +0000)] 
update to types doc
commented out 'tutorial' from docuemnt_base until its complete
float extends numeric type

19 years agoResultProxy has an iterator interface
Mike Bayer [Sat, 25 Mar 2006 02:49:10 +0000 (02:49 +0000)] 
ResultProxy has an iterator interface

19 years agogot some support for mapping to a select that only selects some of the columns of...
Mike Bayer [Sat, 25 Mar 2006 02:25:59 +0000 (02:25 +0000)] 
got some support for mapping to a select that only selects some of the columns of an underlying table

19 years agoadded check in SessionTrans.begin() that the underlying unit of work is still the...
Mike Bayer [Sat, 25 Mar 2006 01:58:27 +0000 (01:58 +0000)] 
added check in SessionTrans.begin() that the underlying unit of work is still the current uow

19 years agoadded expunge() method to objectstore
Mike Bayer [Sat, 25 Mar 2006 00:17:51 +0000 (00:17 +0000)] 
added expunge() method to objectstore
correction in attributes reset_history to really reset in all cases
added unit tests testing refresh()/expire() bug that was fixed by reset_history thing

19 years agoadded overrideable managed_attribute_dict() function which can be changed
Mike Bayer [Fri, 24 Mar 2006 23:06:07 +0000 (23:06 +0000)] 
added overrideable managed_attribute_dict() function which can be changed
to eliminate circular references on objects

19 years agosome more tweaks to get more advanced polymorphic stuff to work
Mike Bayer [Fri, 24 Mar 2006 06:28:27 +0000 (06:28 +0000)] 
some more tweaks to get more advanced polymorphic stuff to work

19 years agoadded explicit "convert date types to a string in bind params", since pysqlite1 doesn...
Mike Bayer [Thu, 23 Mar 2006 07:38:28 +0000 (07:38 +0000)] 
added explicit "convert date types to a string in bind params", since pysqlite1 doesnet seem to do it, operation is synymous with what pysqlite2 does

19 years agoadded oracle8 test target, sets use_ansi to false
Mike Bayer [Thu, 23 Mar 2006 06:35:27 +0000 (06:35 +0000)] 
added oracle8 test target, sets use_ansi to false
got mapper, objectstore, inheritance unittest working with oracle8, tweaks to join syntax

19 years agoanother adjustment...
Mike Bayer [Thu, 23 Mar 2006 06:19:26 +0000 (06:19 +0000)] 
another adjustment...

19 years agosome adjustments to oracle non-ansi join concatenation, 'row number over' syntax
Mike Bayer [Thu, 23 Mar 2006 06:17:29 +0000 (06:17 +0000)] 
some adjustments to oracle non-ansi join concatenation, 'row number over' syntax

19 years agoadded some extra traversal for one-to-many/many-to-one "private" relations to allow...
Mike Bayer [Wed, 22 Mar 2006 21:25:10 +0000 (21:25 +0000)] 
added some extra traversal for one-to-many/many-to-one "private" relations to allow single-object commits to cascade into private child objects

19 years agoremoved print
Mike Bayer [Wed, 22 Mar 2006 17:06:49 +0000 (17:06 +0000)] 
removed print

19 years agofixed oracle's efforts to get an ORDER BY for its ROW NUMBER OVER clause, fixed suppo...
Mike Bayer [Wed, 22 Mar 2006 16:57:46 +0000 (16:57 +0000)] 
fixed oracle's efforts to get an ORDER BY for its ROW NUMBER OVER clause, fixed support for multi-leveled Alias objects to render correctly

19 years agoadded Mapper class to the docstrings
Mike Bayer [Wed, 22 Mar 2006 15:39:57 +0000 (15:39 +0000)] 
added Mapper class to the docstrings

19 years agoadded some references to selectfirst
Mike Bayer [Wed, 22 Mar 2006 15:33:26 +0000 (15:33 +0000)] 
added some references to selectfirst

19 years agoadded "nest_on" option for Session, so nested transactions can occur mostly at the...
Mike Bayer [Wed, 22 Mar 2006 01:16:16 +0000 (01:16 +0000)] 
added "nest_on" option for Session, so nested transactions can occur mostly at the Session level,
fixes [ticket:113]

19 years agoadded unit test to test proper construction of lazy clause against inherited mapper
Mike Bayer [Wed, 22 Mar 2006 00:22:26 +0000 (00:22 +0000)] 
added unit test to test proper construction of lazy clause against inherited mapper

19 years agofixed lazy clause construction to go off...you guessed it...the noninherited table !
Mike Bayer [Tue, 21 Mar 2006 20:15:44 +0000 (20:15 +0000)] 
fixed lazy clause construction to go off...you guessed it...the noninherited table !

19 years agoadded "name" back to FromClause
Mike Bayer [Tue, 21 Mar 2006 20:03:45 +0000 (20:03 +0000)] 
added "name" back to FromClause

19 years agoa few changes to attributes.py to allow faster initialization of object attributes...
Mike Bayer [Tue, 21 Mar 2006 04:38:54 +0000 (04:38 +0000)] 
a few changes to attributes.py to allow faster initialization of object attributes on new objects

19 years agoa refactoring to the EagerLoaders' _instance method to do a bunch of column arithmeti...
Mike Bayer [Tue, 21 Mar 2006 02:43:58 +0000 (02:43 +0000)] 
a refactoring to the EagerLoaders' _instance method to do a bunch of column arithmetic up front, instead of on each row

19 years agoa few tweaks and the polymorph example can also use eager loading
Mike Bayer [Mon, 20 Mar 2006 01:16:16 +0000 (01:16 +0000)] 
a few tweaks and the polymorph example can also use eager loading

19 years agoprint remove
Mike Bayer [Sun, 19 Mar 2006 21:24:05 +0000 (21:24 +0000)] 
print remove

19 years agoadded size limit on test BLOB since mysql has a configured limit of 65535 (at least...
Mike Bayer [Sun, 19 Mar 2006 21:23:19 +0000 (21:23 +0000)] 
added size limit on test BLOB since mysql has a configured limit of 65535 (at least on my server....)

19 years agogot dilbert to be properly modified....
Mike Bayer [Sun, 19 Mar 2006 21:12:10 +0000 (21:12 +0000)] 
got dilbert to be properly modified....

19 years agoadded distinct() function to column elements for "DISTINCT <col>"
Mike Bayer [Sun, 19 Mar 2006 16:21:33 +0000 (16:21 +0000)] 
added distinct() function to column elements for "DISTINCT <col>"

19 years agogot rid of from "ids", using the From object itself as identity now. improves correl...
Mike Bayer [Sun, 19 Mar 2006 05:05:01 +0000 (05:05 +0000)] 
got rid of from "ids", using the From object itself as identity now.  improves correlation logic and fixes [ticket:116]

19 years agogot clause elements inside INSERTs going...
Mike Bayer [Sun, 19 Mar 2006 04:20:06 +0000 (04:20 +0000)] 
got clause elements inside INSERTs going...

19 years agoder + engine...
Mike Bayer [Sat, 18 Mar 2006 00:33:50 +0000 (00:33 +0000)] 
der + engine...

19 years agogot oracle parenthesized rules for funcs back, fixed copy_container on function
Mike Bayer [Sat, 18 Mar 2006 00:32:49 +0000 (00:32 +0000)] 
got oracle parenthesized rules for funcs back, fixed copy_container on function

19 years agoPropertyLoader will not re-determine direction when initialized a second time, as...
Mike Bayer [Sat, 18 Mar 2006 00:12:59 +0000 (00:12 +0000)] 
PropertyLoader will not re-determine direction when initialized a second time, as it is re-initialized as a copy made for an inheriting mapper, and no longer can get to the correct inheriting table.

19 years agorolled back the operationalerror catch...definitely doesnt work right now
Mike Bayer [Fri, 17 Mar 2006 23:56:54 +0000 (23:56 +0000)] 
rolled back the operationalerror catch...definitely doesnt work right now

19 years agoput a try/finally to insure that SQLSession is cleaned out on rollback/commit regardl...
Mike Bayer [Fri, 17 Mar 2006 22:00:24 +0000 (22:00 +0000)] 
put a try/finally to insure that SQLSession is cleaned out on rollback/commit regardless of issues

19 years agooverhaul to SQLSession change from yesterday, needs to use the threadlocal capability...
Mike Bayer [Fri, 17 Mar 2006 21:58:00 +0000 (21:58 +0000)] 
overhaul to SQLSession change from yesterday, needs to use the threadlocal capability of the pool after all

19 years agoattempting to catch OperationalErrors and invalidate the connection
Mike Bayer [Fri, 17 Mar 2006 21:22:30 +0000 (21:22 +0000)] 
attempting to catch OperationalErrors and invalidate the connection