]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/log
thirdparty/sqlalchemy/sqlalchemy.git
19 years agofixed an import
Mike Bayer [Mon, 27 Feb 2006 16:47:08 +0000 (16:47 +0000)] 
fixed an import

19 years agoAdded code to make foreignkey on ActiveMapper accept a string and create the ForeignK...
jeff [Mon, 27 Feb 2006 15:36:48 +0000 (15:36 +0000)] 
Added code to make foreignkey on ActiveMapper accept a string and create the ForeignKey object on the fly. Also added ability to pass args and kwargs to Column constructor. ActiveMapper columns can have keyword args indexed and unique which will automatically create a index or a unique index. dburi in AutoConnectEngine can be a callable.

19 years agoupdates
Mike Bayer [Mon, 27 Feb 2006 06:49:09 +0000 (06:49 +0000)] 
updates

19 years agoformatting
Mike Bayer [Mon, 27 Feb 2006 06:35:46 +0000 (06:35 +0000)] 
formatting

19 years agogot mapper.using() to work, fixed push/pop mapper, custom session assignments
Mike Bayer [Mon, 27 Feb 2006 02:33:47 +0000 (02:33 +0000)] 
got mapper.using() to work, fixed push/pop mapper, custom session assignments

19 years agodoc update for post_update flag
Mike Bayer [Mon, 27 Feb 2006 01:11:56 +0000 (01:11 +0000)] 
doc update for post_update flag

19 years agomore work on cycles, fleshed out tests for post_update, fix to the delete phase of...
Mike Bayer [Mon, 27 Feb 2006 01:05:01 +0000 (01:05 +0000)] 
more work on cycles, fleshed out tests for post_update, fix to the delete phase of a one-to-many post update
closes [ticket:67]

19 years agoimported casacde_mappers
Mike Bayer [Sun, 26 Feb 2006 23:40:15 +0000 (23:40 +0000)] 
imported casacde_mappers

19 years agoMerge indexes [1047]:[1048] into trunk (for #6)
Jason Pellerin [Sun, 26 Feb 2006 22:57:46 +0000 (22:57 +0000)] 
Merge indexes [1047]:[1048] into trunk (for #6)

19 years agoimplemented SyncRules for mapper with inheritance relationship, fixes [ticket:81]
Mike Bayer [Sun, 26 Feb 2006 22:23:01 +0000 (22:23 +0000)] 
implemented SyncRules for mapper with inheritance relationship, fixes [ticket:81]
TableFinder becomes a list-implementing object (should probably create clauseutils or sqlutils for these little helper visitors)

19 years agofactored out "syncrule" logic to a separate package, so mapper will be able to make...
Mike Bayer [Sun, 26 Feb 2006 21:45:10 +0000 (21:45 +0000)] 
factored out "syncrule" logic to a separate package, so mapper will be able to make use of it as well as properties.  also clarifies the "synchronization" idea

19 years agoplace _instance_key on object only when objectstore finally register_clean's on it...
Mike Bayer [Sun, 26 Feb 2006 21:39:14 +0000 (21:39 +0000)] 
place _instance_key on object only when objectstore finally register_clean's on it, to make
room for more aggressive "identity map" assertion when modifying objects incoming from a result set

19 years agopostgres wraps exec's in SQLError catch
Mike Bayer [Sun, 26 Feb 2006 20:15:02 +0000 (20:15 +0000)] 
postgres wraps exec's in SQLError catch

19 years agoregister_deleted/register_dirty perform pre-check before doing the "validate" operati...
Mike Bayer [Sun, 26 Feb 2006 19:15:43 +0000 (19:15 +0000)] 
register_deleted/register_dirty perform pre-check before doing the "validate" operation to cut down on method overhaed

19 years agofixed exception import. check for objects being present in the identity map occurs...
Mike Bayer [Sun, 26 Feb 2006 19:09:42 +0000 (19:09 +0000)] 
fixed exception import.  check for objects being present in the identity map occurs not just
at commit time but also when its logged as "dirty" or "deleted".

19 years agoadded test to illustrate wacky inhertitance/many-to-many thing
Mike Bayer [Sun, 26 Feb 2006 06:17:21 +0000 (06:17 +0000)] 
added test to illustrate wacky inhertitance/many-to-many thing

19 years agoadjustment to compile synchronizers which allows many-to-many synchronize to work...
Mike Bayer [Sun, 26 Feb 2006 06:14:12 +0000 (06:14 +0000)] 
adjustment to compile synchronizers which allows many-to-many synchronize to work even when one side of the relation has both tables in it (new unittest will be added to inheritance.py to show this...)

19 years agofixed ticket 72, where a copied clause was using the identical bind param object...
Mike Bayer [Sun, 26 Feb 2006 02:25:42 +0000 (02:25 +0000)] 
fixed ticket 72, where a copied clause was using the identical bind param object thereby screwing up a generated statement that included both the original clause and the copied clause, when positional parameters were used

19 years agocreate() statements return the created object so they can be instantiated and
Mike Bayer [Sun, 26 Feb 2006 02:24:42 +0000 (02:24 +0000)] 
create() statements return the created object so they can be instantiated and
create()'ed in one line

19 years agofixed many-to-many example, which was utterly incorrect in many ways
Mike Bayer [Sun, 26 Feb 2006 00:04:43 +0000 (00:04 +0000)] 
fixed many-to-many example, which was utterly incorrect in many ways

19 years agoRefactored ProxyEngine into BaseProxyEngine and ProxyEngine. Also added an AutoConnec...
jeff [Sat, 25 Feb 2006 17:50:46 +0000 (17:50 +0000)] 
Refactored ProxyEngine into BaseProxyEngine and ProxyEngine. Also added an AutoConnectProxyEngine to late bind to a particular dburi. I ran the proxy_engine test, however, I don't have postgresql installed so not all tests worked. Also, I don't have an WSGI package installed to run the wsgi tests.

19 years agoclauseelement.compile() totally works without an engine
Mike Bayer [Sat, 25 Feb 2006 07:22:01 +0000 (07:22 +0000)] 
clauseelement.compile() totally works without an engine

19 years agomerged sql_rearrangement branch , refactors sql package to work standalone with
Mike Bayer [Sat, 25 Feb 2006 07:12:50 +0000 (07:12 +0000)] 
merged sql_rearrangement branch , refactors sql package to work standalone with
clause elements including tables and columns, schema package deals with "physical"
representations

19 years agotentative fix for oracle row_number over syntax
Mike Bayer [Fri, 24 Feb 2006 17:12:02 +0000 (17:12 +0000)] 
tentative fix for oracle row_number over syntax

19 years agoupdate
Mike Bayer [Fri, 24 Feb 2006 17:01:56 +0000 (17:01 +0000)] 
update

19 years agoget() method needs to use the full table, not just the 'primary' table, to get the...
Mike Bayer [Fri, 24 Feb 2006 16:54:30 +0000 (16:54 +0000)] 
get() method needs to use the full table, not just the 'primary' table, to get the full list of primary key cols

19 years agofix to silent "recursive" bug in schema getattr that was somehow running only 994... rel_0_1_2
Mike Bayer [Fri, 24 Feb 2006 00:28:10 +0000 (00:28 +0000)] 
fix to silent "recursive" bug in schema getattr that was somehow running only 994 times

19 years agorelease time rel_0_1_1
Mike Bayer [Thu, 23 Feb 2006 02:47:07 +0000 (02:47 +0000)] 
release time

19 years agoupdate
Mike Bayer [Thu, 23 Feb 2006 02:43:14 +0000 (02:43 +0000)] 
update

19 years agoFunction needed compare_type so that its type is set as the type in boolean expressions
Mike Bayer [Thu, 23 Feb 2006 01:32:26 +0000 (01:32 +0000)] 
Function needed compare_type so that its type is set as the type in boolean expressions

19 years agomoved iteration of props so that props can set up self-referring backref properties...
Mike Bayer [Wed, 22 Feb 2006 08:50:45 +0000 (08:50 +0000)] 
moved iteration of props so that props can set up self-referring backref properties without getting a "list changed during iteration" error

19 years agotest commit
Mike Bayer [Wed, 22 Feb 2006 08:13:25 +0000 (08:13 +0000)] 
test commit

19 years agoone more test commit
Mike Bayer [Wed, 22 Feb 2006 07:47:58 +0000 (07:47 +0000)] 
one more test commit

19 years agothis is a test commit
Mike Bayer [Wed, 22 Feb 2006 06:40:14 +0000 (06:40 +0000)] 
this is a test commit

19 years agomore fix to one-to-one: 'unchanged_items' can be [None] also with one to one so check...
Mike Bayer [Wed, 22 Feb 2006 06:29:05 +0000 (06:29 +0000)] 
more fix to one-to-one: 'unchanged_items' can be [None] also with one to one so check for this
during delete

19 years agowhen begin/commit, an exception should still reset the transactional state
Mike Bayer [Wed, 22 Feb 2006 00:33:38 +0000 (00:33 +0000)] 
when begin/commit, an exception should still reset the transactional state

19 years agofix to EagerLoad where it late-initializes its eager chain, thereby not getting messe...
Mike Bayer [Wed, 22 Feb 2006 00:28:59 +0000 (00:28 +0000)] 
fix to EagerLoad where it late-initializes its eager chain, thereby not getting messed up by late add_property() calls

19 years agowhen creating lazy clause both sides of each clause must be Column
Mike Bayer [Tue, 21 Feb 2006 03:01:43 +0000 (03:01 +0000)] 
when creating lazy clause both sides of each clause must be Column

19 years agoworking on postupdate idea, refactoring to dependency processing
Mike Bayer [Tue, 21 Feb 2006 02:57:38 +0000 (02:57 +0000)] 
working on postupdate idea, refactoring to dependency processing

19 years agomerged eager loading overhaul rev 1001:1009
Mike Bayer [Mon, 20 Feb 2006 19:45:08 +0000 (19:45 +0000)] 
merged eager loading overhaul rev 1001:1009
this includes:
sql.Alias object keeps track of the immediate thing it aliased as well
as the ultimate non-aliased (usually a Table) object, so that proxied columns can have
a "parent" attribute
some cleanup to SelectBaseMixin.order_by_clause to allow easier access, needs more cleanup
engine has been making two ResultProxies all this time, added "return_raw" quickie flag to
disable that
some cleanup to _get_col_by_original so that it also works for oid columns, new eager load stuff
more aggressively aliaseses orderby's so this was needed
EagerLoader now makes "chains" of unique aliased eager loaders in all cases.  no need for
use_alias/selectalias anymore since it aliases every time.
properly detects recursive eager loads and terminates them with a lazyloader, instead of
raising an exception.  totally simplified setup() and init() is more straightforward and has
a single codepath now instead of two or three.

19 years agomade 'assign_mapper' doc more explicit
Mike Bayer [Mon, 20 Feb 2006 16:34:02 +0000 (16:34 +0000)] 
made 'assign_mapper' doc more explicit
added doc for overriding properties

19 years agonone check for pg1 date/time values
Mike Bayer [Mon, 20 Feb 2006 16:13:54 +0000 (16:13 +0000)] 
none check for pg1 date/time values

19 years agosome comments, changed SmartProperty to be smarter, UOW
Mike Bayer [Sun, 19 Feb 2006 01:25:56 +0000 (01:25 +0000)] 
some comments, changed SmartProperty to be smarter, UOW
version has "property" accessor which returns MapperProperty at
the class level

19 years agodoc
Mike Bayer [Sun, 19 Feb 2006 00:42:50 +0000 (00:42 +0000)] 
doc

19 years agosome docstrings etc
Mike Bayer [Sun, 19 Feb 2006 00:35:54 +0000 (00:35 +0000)] 
some docstrings etc

19 years agoexceptions added
Mike Bayer [Sun, 19 Feb 2006 00:26:22 +0000 (00:26 +0000)] 
exceptions added
postgres last_inserted_ids will raise an error unless OID's are turned on
(INSERT with PK defaults + no OIDs wont fail unless this method is called)

19 years agoexception package added, support throughout
Mike Bayer [Sun, 19 Feb 2006 00:19:16 +0000 (00:19 +0000)] 
exception package added, support throughout

19 years agoonetoone
Mike Bayer [Sun, 19 Feb 2006 00:18:38 +0000 (00:18 +0000)] 
onetoone

19 years agoconverted to a unittest
Mike Bayer [Sun, 19 Feb 2006 00:18:00 +0000 (00:18 +0000)] 
converted to a unittest

19 years agotest only for postgres
Mike Bayer [Sun, 19 Feb 2006 00:17:27 +0000 (00:17 +0000)] 
test only for postgres

19 years agobeginning of a row cycle test
Mike Bayer [Sat, 18 Feb 2006 23:44:37 +0000 (23:44 +0000)] 
beginning of a row cycle test

19 years agoupdating
Mike Bayer [Sat, 18 Feb 2006 23:07:07 +0000 (23:07 +0000)] 
updating

19 years agoadded hooks for engines to add stuff to SELECT, etc.
Mike Bayer [Sat, 18 Feb 2006 22:37:22 +0000 (22:37 +0000)] 
added hooks for engines to add stuff to SELECT, etc.

19 years agobase begin method returns transaciton object
Mike Bayer [Sat, 18 Feb 2006 22:31:47 +0000 (22:31 +0000)] 
base begin method returns transaciton object

19 years agoongoing
Mike Bayer [Sat, 18 Feb 2006 21:21:25 +0000 (21:21 +0000)] 
ongoing

19 years agoadded new style of begin/commit which returns a tranactional object
Mike Bayer [Sat, 18 Feb 2006 21:11:20 +0000 (21:11 +0000)] 
added new style of begin/commit which returns a tranactional object

19 years agoadded indexes to schema/ansisql/engine
Mike Bayer [Sat, 18 Feb 2006 20:33:20 +0000 (20:33 +0000)] 
added indexes to schema/ansisql/engine
slightly different index syntax for mysql
fixed mysql Time type to convert from a timedelta to time
tweaks to date unit tests for mysql

19 years agocomment verbiage
Mike Bayer [Sat, 18 Feb 2006 16:37:35 +0000 (16:37 +0000)] 
comment verbiage

19 years agopostgres needs to explicitly pre-execute PassiveDefaults on primary key columns,...
Mike Bayer [Sat, 18 Feb 2006 16:32:33 +0000 (16:32 +0000)] 
postgres needs to explicitly pre-execute PassiveDefaults on primary key columns, test added

19 years agomodified query that uses JOIN keyword explicitly. a user gets much better performanc...
Mike Bayer [Fri, 17 Feb 2006 22:28:06 +0000 (22:28 +0000)] 
modified query that uses JOIN keyword explicitly.  a user gets much better performance with it (though I dont)

19 years agobind params upon insert are totally column "name" based, so in process_defaults set...
Mike Bayer [Fri, 17 Feb 2006 22:10:14 +0000 (22:10 +0000)] 
bind params upon insert are totally column "name" based, so in process_defaults set newly acquired parameter by name also

19 years agoadded an assertion to insure that a column is only attached to one table
Mike Bayer [Fri, 17 Feb 2006 18:29:26 +0000 (18:29 +0000)] 
added an assertion to insure that a column is only attached to one table

19 years agoModified objectstore to look for primary key param values by column name not key...
Robert Leftwich [Fri, 17 Feb 2006 12:35:52 +0000 (12:35 +0000)] 
Modified objectstore to look for primary key param values by column name not key name. Added test for same.

19 years agotweak to get tables to show up
Mike Bayer [Fri, 17 Feb 2006 05:32:30 +0000 (05:32 +0000)] 
tweak to get tables to show up

19 years agoadded another multi-pk test
Mike Bayer [Fri, 17 Feb 2006 05:29:16 +0000 (05:29 +0000)] 
added another multi-pk test

19 years agofix to types test, postgres time types descend from Time type
Mike Bayer [Fri, 17 Feb 2006 04:49:04 +0000 (04:49 +0000)] 
fix to types test, postgres time types descend from Time type

19 years agogot inheritance into alltest
Mike Bayer [Thu, 16 Feb 2006 06:40:20 +0000 (06:40 +0000)] 
got inheritance into alltest

19 years agook now they worked...
Mike Bayer [Thu, 16 Feb 2006 06:38:49 +0000 (06:38 +0000)] 
ok now they worked...

19 years agoinheritance test
Mike Bayer [Thu, 16 Feb 2006 06:37:41 +0000 (06:37 +0000)] 
inheritance test
tweaking to try to get alltests to work, unsuccessful

19 years agoJoin object wasnt exporting foreign keys correctly
Mike Bayer [Thu, 16 Feb 2006 06:13:16 +0000 (06:13 +0000)] 
Join object wasnt exporting foreign keys correctly
compile_synchronizers in PropertyLoader needed to take into account the full list of tables for each mapper when looking for synchronization rules, not just primary table

19 years agocomment rel_0_1_0
Mike Bayer [Tue, 14 Feb 2006 02:40:07 +0000 (02:40 +0000)] 
comment

19 years agothe list-based foreign key doenst seem to work quite right, rolling it back
Mike Bayer [Tue, 14 Feb 2006 02:15:47 +0000 (02:15 +0000)] 
the list-based foreign key doenst seem to work quite right, rolling it back

19 years agobind_to fix
Mike Bayer [Tue, 14 Feb 2006 01:49:33 +0000 (01:49 +0000)] 
bind_to fix

19 years ago0.1.0
Mike Bayer [Tue, 14 Feb 2006 01:22:38 +0000 (01:22 +0000)] 
0.1.0

19 years agofixed FLOAT type
Mike Bayer [Tue, 14 Feb 2006 01:21:12 +0000 (01:21 +0000)] 
fixed FLOAT type

19 years agofix
Mike Bayer [Tue, 14 Feb 2006 01:18:46 +0000 (01:18 +0000)] 
fix

19 years agotweaks for order_by
Mike Bayer [Tue, 14 Feb 2006 01:15:53 +0000 (01:15 +0000)] 
tweaks for order_by

19 years agotweak to oracle limit/offset to not put ora_rn in the select list
Mike Bayer [Tue, 14 Feb 2006 01:15:43 +0000 (01:15 +0000)] 
tweak to oracle limit/offset to not put ora_rn in the select list

19 years agofixes mostly to get the important unit tests to run for Oracle, boxesw without wsgi_utils
Mike Bayer [Tue, 14 Feb 2006 01:02:50 +0000 (01:02 +0000)] 
fixes mostly to get the important unit tests to run for Oracle, boxesw without wsgi_utils

19 years agooracle likes to use VARCHAR isntead of CLOB so put limits on String
Mike Bayer [Tue, 14 Feb 2006 00:50:02 +0000 (00:50 +0000)] 
oracle likes to use VARCHAR isntead of CLOB so put limits on String

19 years agotweak
Mike Bayer [Tue, 14 Feb 2006 00:42:34 +0000 (00:42 +0000)] 
tweak

19 years agodocstring...
Mike Bayer [Tue, 14 Feb 2006 00:41:20 +0000 (00:41 +0000)] 
docstring...

19 years agolatest reorgnanization of the objectstore, the Session is a simpler object that just...
Mike Bayer [Tue, 14 Feb 2006 00:30:30 +0000 (00:30 +0000)] 
latest reorgnanization of the objectstore, the Session is a simpler object that just maintains begin/commit state

19 years agolazy load column fix courtesy raul garcia garcia
Mike Bayer [Tue, 14 Feb 2006 00:29:48 +0000 (00:29 +0000)] 
lazy load column fix courtesy raul garcia garcia

19 years agofix to string concatenation operator courtesy Marko Mikulicic
Mike Bayer [Tue, 14 Feb 2006 00:28:52 +0000 (00:28 +0000)] 
fix to string concatenation operator courtesy Marko Mikulicic

19 years agoadded import for pysqlite1
Mike Bayer [Tue, 14 Feb 2006 00:21:42 +0000 (00:21 +0000)] 
added import for pysqlite1

19 years agotweak to TableImpl/ColumnImpl with the way they get their attribute
Mike Bayer [Tue, 14 Feb 2006 00:20:23 +0000 (00:20 +0000)] 
tweak to TableImpl/ColumnImpl with the way they get their attribute

19 years agosome updates to UOW, fixes to all those relation() calls
Mike Bayer [Tue, 14 Feb 2006 00:19:22 +0000 (00:19 +0000)] 
some updates to UOW, fixes to all those relation() calls

19 years agoadded 'post_update' attribute to PropertyLoader, means to defer processing of this...
Mike Bayer [Mon, 13 Feb 2006 00:51:37 +0000 (00:51 +0000)] 
added 'post_update' attribute to PropertyLoader, means to defer processing of this property until after the object has been saved, and then to re-sync and force an update.  used to break otherwise intra-row cycles.  added for "many-to-one" so far.

19 years agomore refactoring to session/UOW scope management...under construction !
Mike Bayer [Sun, 12 Feb 2006 21:27:20 +0000 (21:27 +0000)] 
more refactoring to session/UOW scope management...under construction !

19 years agosome tweaks to options, use_alias, live removed
Mike Bayer [Sun, 12 Feb 2006 21:26:24 +0000 (21:26 +0000)] 
some tweaks to options, use_alias, live removed

19 years agoassertion
Mike Bayer [Sun, 12 Feb 2006 06:43:05 +0000 (06:43 +0000)] 
assertion

19 years ago'column' function (make a ColumnClause) is more useful from sql module, removed ...
Mike Bayer [Sun, 12 Feb 2006 06:39:29 +0000 (06:39 +0000)] 
'column' function (make a ColumnClause) is more useful from sql module, removed 'column' (make a ColumnProperty) from __init__

19 years agocleanup and organization of code mostly in properties, making SyncRules clearer,
Mike Bayer [Sun, 12 Feb 2006 06:32:11 +0000 (06:32 +0000)] 
cleanup and organization of code mostly in properties, making SyncRules clearer,
also "foreignkey" property can be a list, particularly for a self-referential table with a multi-column join condition

19 years agoslight glitch when the same clause is compiled repeatedly and contains redundant...
Mike Bayer [Sun, 12 Feb 2006 06:29:57 +0000 (06:29 +0000)] 
slight glitch when the same clause is compiled repeatedly and contains redundant bind parameters...this fix prevents the binds from stepping on each other....

19 years agosome comments for default test
Mike Bayer [Sun, 12 Feb 2006 06:28:10 +0000 (06:28 +0000)] 
some comments for default test

19 years agomore hammering of defaults. ORM will properly execute defaults and post-fetch rows...
Mike Bayer [Sat, 11 Feb 2006 23:29:02 +0000 (23:29 +0000)] 
more hammering of defaults.  ORM will properly execute defaults and post-fetch rows that contain passive defaults

19 years agointegrating Jonathan LaCour's declarative layer
Mike Bayer [Sat, 11 Feb 2006 21:24:54 +0000 (21:24 +0000)] 
integrating Jonathan LaCour's declarative layer

19 years agotableimpl and columnimpl proxy to actual impl objects per engine
Mike Bayer [Sat, 11 Feb 2006 21:04:48 +0000 (21:04 +0000)] 
tableimpl and columnimpl proxy to actual impl objects per engine

19 years agostreamlined engine.schemagenerator and engine.schemadropper methodology
Mike Bayer [Sat, 11 Feb 2006 20:50:41 +0000 (20:50 +0000)] 
streamlined engine.schemagenerator and engine.schemadropper methodology
added support for creating PassiveDefault (i.e. regular DEFAULT) on table columns
postgres can reflect default values via information_schema
added unittests for PassiveDefault values getting created, inserted, coming back in result sets