]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/log
thirdparty/sqlalchemy/sqlalchemy.git
15 years ago- beef up the --reversetop test option to embed RandomSet throughout the ORM
Mike Bayer [Thu, 15 Apr 2010 04:13:48 +0000 (00:13 -0400)] 
- beef up the --reversetop test option to embed RandomSet throughout the ORM
- with m2m we have to go back to the previous approach of having both sides of
the DP fire off, tracking each pair of objects.   history may not be consistently present
in one side or the other
- this revealed a whole lot of issues with self-referential m2m, which are fixed

15 years agodont use collections on 2.4
Mike Bayer [Wed, 14 Apr 2010 22:38:11 +0000 (18:38 -0400)] 
dont use collections on 2.4

15 years ago0.6.0 prep
Mike Bayer [Wed, 14 Apr 2010 22:11:16 +0000 (18:11 -0400)] 
0.6.0 prep

15 years agomerge tip
Mike Bayer [Wed, 14 Apr 2010 22:00:59 +0000 (18:00 -0400)] 
merge tip

15 years agoupdate language regarding the behavior of expire/refresh with regards to relationship...
Mike Bayer [Wed, 14 Apr 2010 21:58:08 +0000 (17:58 -0400)] 
update language regarding the behavior of expire/refresh with regards to relationships, [ticket:1762]

15 years agomerge tip
Mike Bayer [Tue, 13 Apr 2010 17:31:41 +0000 (13:31 -0400)] 
merge tip

15 years agomerge tip
Chris Withers [Tue, 13 Apr 2010 15:48:24 +0000 (16:48 +0100)] 
merge tip

15 years agodocs for new mixin class control abilities
Chris Withers [Tue, 13 Apr 2010 15:46:07 +0000 (16:46 +0100)] 
docs for new mixin class control abilities

15 years agoadd another edge case example
Chris Withers [Tue, 13 Apr 2010 15:28:32 +0000 (16:28 +0100)] 
add another edge case example

15 years agowire in utility docs
Chris Withers [Tue, 13 Apr 2010 11:47:37 +0000 (12:47 +0100)] 
wire in utility docs

15 years agoadd utility docs
Chris Withers [Tue, 13 Apr 2010 11:47:12 +0000 (12:47 +0100)] 
add utility docs

15 years agostop Sphinx whining about this file, I believe it's used direct from a template
Chris Withers [Tue, 13 Apr 2010 11:05:45 +0000 (12:05 +0100)] 
stop Sphinx whining about this file, I believe it's used direct from a template

15 years agohelper method for spotting inherited tables
Chris Withers [Tue, 13 Apr 2010 10:29:39 +0000 (11:29 +0100)] 
helper method for spotting inherited tables

15 years agoI think I'm about to have a When Harry Met Sally moment
Chris Withers [Tue, 13 Apr 2010 09:02:22 +0000 (10:02 +0100)] 
I think I'm about to have a When Harry Met Sally moment

15 years agoclose, but still no cigar
Chris Withers [Tue, 13 Apr 2010 00:55:54 +0000 (01:55 +0100)] 
close, but still no cigar

15 years agocorrect ordering
Chris Withers [Tue, 13 Apr 2010 00:55:32 +0000 (01:55 +0100)] 
correct ordering

15 years agoremove tortology
Chris Withers [Tue, 13 Apr 2010 00:27:24 +0000 (01:27 +0100)] 
remove tortology

15 years agomerge tip
Mike Bayer [Tue, 13 Apr 2010 00:24:08 +0000 (20:24 -0400)] 
merge tip

15 years agofurther testing reveals that cursor.rowcount is only called with update/delete and...
Mike Bayer [Tue, 13 Apr 2010 00:20:50 +0000 (20:20 -0400)] 
further testing reveals that cursor.rowcount is only called with update/delete and DDL,
and also that FB's cursor.rowcount is a little expensive, but not dramatically.
added a test to ensure cursor.rowcount is only called on update/delete.
the current default for firebird enable_rowcount is now True, leaving all the
options to turn it off etc..

15 years agobeef up test cases to reveal that I'm not as close as I'd thought :-(
Chris Withers [Mon, 12 Apr 2010 23:56:15 +0000 (00:56 +0100)] 
beef up test cases to reveal that I'm not as close as I'd thought :-(

15 years agohandle propagation
Chris Withers [Mon, 12 Apr 2010 22:23:27 +0000 (23:23 +0100)] 
handle propagation

15 years agocorrect this test case
Chris Withers [Mon, 12 Apr 2010 22:22:44 +0000 (23:22 +0100)] 
correct this test case

15 years agorefactor to highlight the problem areas
Chris Withers [Mon, 12 Apr 2010 15:36:49 +0000 (16:36 +0100)] 
refactor to highlight the problem areas

15 years agomuch more descriptive message for bind param name conflict, [ticket:1766]
Mike Bayer [Mon, 12 Apr 2010 15:30:01 +0000 (11:30 -0400)] 
much more descriptive message for bind param name conflict, [ticket:1766]

15 years agomerge
Chris Withers [Mon, 12 Apr 2010 09:35:30 +0000 (10:35 +0100)] 
merge

15 years ago- The functionality of result.rowcount is now disabled
Mike Bayer [Sun, 11 Apr 2010 20:37:49 +0000 (16:37 -0400)] 
- The functionality of result.rowcount is now disabled
by default, and can be re-enabled using the 'enable_rowcount'
flag with create_engine(), as well as the 'enable_rowcount'
execution context flag on a per-execute basis.  This because
cursor.rowcount requires cursor access (can't be evaluated
lazily since the result auto-closes) and also incurs an
expensive round-trip.

15 years ago- added a test for the solution in [ticket:1757].
Mike Bayer [Sun, 11 Apr 2010 19:37:20 +0000 (15:37 -0400)] 
- added a test for the solution in [ticket:1757].
- this does imply that a lot of the "test the RowProxy" tests in sql/test_query might be better off in engine/test_execute or perhaps engine/test_resultproxy

15 years agomerge branch
Gaëtan de Menten [Sun, 11 Apr 2010 18:58:37 +0000 (20:58 +0200)] 
merge branch

15 years ago- engines
Gaëtan de Menten [Sun, 11 Apr 2010 18:56:39 +0000 (20:56 +0200)] 
- engines
  - The C extension now also works with DBAPIs which use custom
    sequences as row (and not only tuples). [ticket:1757]

15 years agomove factory function to classmethod
Mike Bayer [Sun, 11 Apr 2010 16:21:36 +0000 (12:21 -0400)] 
move factory function to classmethod

15 years agomerge trunk
Mike Bayer [Sun, 11 Apr 2010 16:18:50 +0000 (12:18 -0400)] 
merge trunk

15 years ago- somejoin.select(fold_equivalents=True) is no longer
Mike Bayer [Sun, 11 Apr 2010 16:03:41 +0000 (12:03 -0400)] 
- somejoin.select(fold_equivalents=True) is no longer
deprecated, and will eventually be rolled into a more
comprehensive version of the feature for [ticket:1729].

15 years agocheck_reverse was failing a not well covered m2m case.
Mike Bayer [Sun, 11 Apr 2010 00:13:51 +0000 (20:13 -0400)] 
check_reverse was failing a not well covered m2m case.

15 years agomerge default
Mike Bayer [Sat, 10 Apr 2010 23:45:34 +0000 (19:45 -0400)] 
merge default

15 years ago- starting to groom the branch for its inclusion
Mike Bayer [Sat, 10 Apr 2010 23:21:54 +0000 (19:21 -0400)] 
- starting to groom the branch for its inclusion
- one-to-many relationships now maintain a list of positive
parent-child associations within the flush, preventing
previous parents marked as deleted from cascading a
delete or NULL foreign key set on those child objects,
despite the end-user not removing the child from the old
association. [ticket:1764]
- re-established Preprocess as unique on their arguments,
as they were definitely duped in inheritance scenarios
- added a "memo" feature to UOWTransaction which represents the usual
pattern of using the .attributes collection
- added the test case from [ticket:1081] into perf/

15 years agocomment
Mike Bayer [Fri, 9 Apr 2010 22:40:28 +0000 (18:40 -0400)] 
comment

15 years agoattempt to reduce redundant calc of pk_switched
Mike Bayer [Fri, 9 Apr 2010 22:17:06 +0000 (18:17 -0400)] 
attempt to reduce redundant calc of pk_switched

15 years agofix bug + add coverage to ensure unneeded SaveUpdateAll/DeleteAll plus extra
Mike Bayer [Fri, 9 Apr 2010 22:04:18 +0000 (18:04 -0400)] 
fix bug + add coverage to ensure unneeded SaveUpdateAll/DeleteAll plus extra
work doesn't occur during per-state usage

15 years agogot DetectKeySwitch into the fold, can now greatly collapse a lot of the preprocess...
Mike Bayer [Fri, 9 Apr 2010 21:43:50 +0000 (17:43 -0400)] 
got DetectKeySwitch into the fold, can now greatly collapse a lot of the preprocess/process down

15 years agoremoves some unneeded methods, initial DetectKeySwitch not present unnecessarily
Mike Bayer [Fri, 9 Apr 2010 20:36:58 +0000 (16:36 -0400)] 
removes some unneeded methods, initial DetectKeySwitch not present unnecessarily

15 years agoimprove test case correctness
Chris Withers [Fri, 9 Apr 2010 18:02:32 +0000 (19:02 +0100)] 
improve test case correctness

15 years agono need for this to be a function
Chris Withers [Fri, 9 Apr 2010 18:02:08 +0000 (19:02 +0100)] 
no need for this to be a function

15 years agorefined system bywhich dependencyprocessor per-state actions
Mike Bayer [Fri, 9 Apr 2010 17:57:49 +0000 (13:57 -0400)] 
refined system bywhich dependencyprocessor per-state actions
are established

15 years agomerge
Chris Withers [Fri, 9 Apr 2010 17:44:29 +0000 (18:44 +0100)] 
merge

15 years agomade this easier to read
Chris Withers [Fri, 9 Apr 2010 17:02:06 +0000 (18:02 +0100)] 
made this easier to read

15 years agomade this easier to read
Chris Withers [Fri, 9 Apr 2010 17:02:06 +0000 (18:02 +0100)] 
made this easier to read

15 years ago- fixed numeric test for pg8000, factored out decimal/float codes
Mike Bayer [Fri, 9 Apr 2010 17:01:17 +0000 (13:01 -0400)] 
- fixed numeric test for pg8000, factored out decimal/float codes

15 years agolearn to spell
Chris Withers [Fri, 9 Apr 2010 16:35:16 +0000 (17:35 +0100)] 
learn to spell

15 years agomore testcases for propogation with mixins in declarative
Chris Withers [Fri, 9 Apr 2010 16:32:05 +0000 (17:32 +0100)] 
more testcases for propogation with mixins in declarative

15 years agoignore egg-info directories
Chris Withers [Fri, 9 Apr 2010 15:54:08 +0000 (16:54 +0100)] 
ignore egg-info directories

15 years agostart adding tests to ensure the size of the uow
Mike Bayer [Thu, 8 Apr 2010 22:52:04 +0000 (18:52 -0400)] 
start adding tests to ensure the size of the uow

15 years agostarting to arrange things such that unneeded executors aren't getting
Mike Bayer [Thu, 8 Apr 2010 22:21:02 +0000 (18:21 -0400)] 
starting to arrange things such that unneeded executors aren't getting
pulled into the unit of work at all.   this involves dancing around lists
of states, seeing if child objects exist, not adding excessive callcounts
while doing that, etc.

15 years agowe can load this sum ahead of time, and if there is none, we dont need a per-state...
Mike Bayer [Thu, 8 Apr 2010 18:15:11 +0000 (14:15 -0400)] 
we can load this sum ahead of time, and if there is none, we dont need a per-state/proc for this at all.
this greatly reduces unnecessary crap in the UOW for complex models.

15 years agoduh
Mike Bayer [Thu, 8 Apr 2010 01:16:11 +0000 (21:16 -0400)] 
duh

15 years ago- make it exceedlingly obvious that all topological/unitofwork code is
Mike Bayer [Thu, 8 Apr 2010 01:00:16 +0000 (21:00 -0400)] 
- make it exceedlingly obvious that all topological/unitofwork code is
being rewritten, and nothing here should be consulted for any
future activity.
- underscore current topological methods as their API behavior
is changing, possibly in 0.6.1 if [ticket:1742] remains on track

15 years agofix this test for oracle
Mike Bayer [Thu, 8 Apr 2010 00:25:37 +0000 (20:25 -0400)] 
fix this test for oracle

15 years agoadd example for changing TypeEngine compilation
Mike Bayer [Wed, 7 Apr 2010 20:21:01 +0000 (16:21 -0400)] 
add example for changing TypeEngine compilation

15 years ago- Repaired missing import in psycopg2._PGNumeric type when
Mike Bayer [Wed, 7 Apr 2010 20:07:55 +0000 (16:07 -0400)] 
- Repaired missing import in psycopg2._PGNumeric type when
unknown numeric is received.

- psycopg2/pg8000 dialects now aware of REAL[], FLOAT[],
DOUBLE_PRECISION[], NUMERIC[] return types without
raising an exception.

- introducing testing.provide_metadata for all these stupid little
create/drop tests

15 years ago- ah. oursql didn't have "extra steps" here, the previous system within execution_op...
Mike Bayer [Wed, 7 Apr 2010 19:20:20 +0000 (15:20 -0400)] 
- ah.  oursql didn't have "extra steps" here, the previous system within execution_options()
used by oursql would generate a proxied connection from within the dialect.initialize() phase.  the new
clone system bypasses that.

15 years agozoomark has additional callcount drops on this side
Mike Bayer [Wed, 7 Apr 2010 18:28:33 +0000 (14:28 -0400)] 
zoomark has additional callcount drops on this side

15 years agomerge default
Mike Bayer [Wed, 7 Apr 2010 18:26:47 +0000 (14:26 -0400)] 
merge default

15 years agoholy callcount batman
Mike Bayer [Wed, 7 Apr 2010 18:23:06 +0000 (14:23 -0400)] 
holy callcount batman

15 years agomerge default
Mike Bayer [Wed, 7 Apr 2010 18:00:23 +0000 (14:00 -0400)] 
merge default

15 years ago- Added new 'compiled_cache' execution option. A dictionary
Mike Bayer [Wed, 7 Apr 2010 17:59:18 +0000 (13:59 -0400)] 
- Added new 'compiled_cache' execution option.  A dictionary
where Compiled objects will be cached when the Connection
compiles a clause expression into a dialect- and parameter-
specific Compiled object.  It is the user's responsibility to
manage the size of this dictionary, which will have keys
corresponding to the dialect, clause element, the column
names within the VALUES or SET clause of an INSERT or UPDATE,
as well as the "batch" mode for an INSERT or UPDATE statement.

15 years ago- Fixed bug in execution_options() feature whereby the existing
Mike Bayer [Wed, 7 Apr 2010 17:42:31 +0000 (13:42 -0400)] 
- Fixed bug in execution_options() feature whereby the existing
Transaction and other state information from the parent
connection would not be propagated to the sub-connection.

15 years agough, didn't mean to commit that :-S
Chris Withers [Wed, 7 Apr 2010 17:14:06 +0000 (18:14 +0100)] 
ugh, didn't mean to commit that :-S

15 years agomerge in tip?
Chris Withers [Wed, 7 Apr 2010 17:10:32 +0000 (18:10 +0100)] 
merge in tip?

15 years agoAdd instructions to install nose adn NB that it won't happen by magic
Chris Withers [Wed, 7 Apr 2010 17:09:21 +0000 (18:09 +0100)] 
Add instructions to install nose adn NB that it won't happen by magic

15 years agomerge from default
Mike Bayer [Wed, 7 Apr 2010 16:31:15 +0000 (12:31 -0400)] 
merge from default

15 years ago- dict_ becomes explicit on _get_state_attr_by_column, _set_state_attr_by_column...
Mike Bayer [Wed, 7 Apr 2010 16:30:02 +0000 (12:30 -0400)] 
- dict_ becomes explicit on _get_state_attr_by_column, _set_state_attr_by_column, others,
to reduce on expensive state.dict calls.
- internal getattr(), setattr(), getcommitted() methods
on ColumnProperty, CompositeProperty, RelationshipProperty
have been underscored, signature has changed.

15 years ago- Postgresql now reflects sequence names associated with
Mike Bayer [Tue, 6 Apr 2010 22:53:51 +0000 (18:53 -0400)] 
- Postgresql now reflects sequence names associated with
SERIAL columns correctly, after the name of of the sequence
has been changed.  Thanks to Kumar McMillan for the patch.
[ticket:1071]

15 years ago- added missing coverage for self-referential many-to-many flushes
Mike Bayer [Tue, 6 Apr 2010 22:28:40 +0000 (18:28 -0400)] 
- added missing coverage for self-referential many-to-many flushes
- some other areas where per-state deps are called and an empty result returned
are still lacking coverage.

15 years agoremove mostly unneeded calls to conditional_post_update
Mike Bayer [Tue, 6 Apr 2010 18:16:07 +0000 (14:16 -0400)] 
remove mostly unneeded calls to conditional_post_update

15 years ago- EdgeCollection can now go away
Mike Bayer [Tue, 6 Apr 2010 17:20:31 +0000 (13:20 -0400)] 
- EdgeCollection can now go away
- fix reflection test

15 years agoa RandomSet implementation useful for swapping into topological
Mike Bayer [Tue, 6 Apr 2010 17:07:17 +0000 (13:07 -0400)] 
a RandomSet implementation useful for swapping into topological

15 years agoadd batch execute to ProcessState
Mike Bayer [Tue, 6 Apr 2010 16:54:29 +0000 (12:54 -0400)] 
add batch execute to ProcessState

15 years agomerge default
Mike Bayer [Tue, 6 Apr 2010 16:44:35 +0000 (12:44 -0400)] 
merge default

15 years agotest another version of the mixin here
Mike Bayer [Tue, 6 Apr 2010 16:32:51 +0000 (12:32 -0400)] 
test another version of the mixin here

15 years ago- Further reworked the "mixin" logic in declarative to
Mike Bayer [Tue, 6 Apr 2010 16:27:01 +0000 (12:27 -0400)] 
- Further reworked the "mixin" logic in declarative to
additionally allow __mapper_args__ as a @classproperty
on a mixin, such as to dynamically assign polymorphic_identity.

15 years ago- Fixed an error in expression typing which caused an endless
Mike Bayer [Tue, 6 Apr 2010 15:39:09 +0000 (11:39 -0400)] 
- Fixed an error in expression typing which caused an endless
loop for expressions with two NULL types.

15 years agoremove prints
Mike Bayer [Tue, 6 Apr 2010 05:42:58 +0000 (01:42 -0400)] 
remove prints

15 years ago- cleanup, factoring, had some heisenbugs. more test coverage
Mike Bayer [Tue, 6 Apr 2010 05:23:54 +0000 (01:23 -0400)] 
- cleanup, factoring, had some heisenbugs.   more test coverage
 will be needed overall as missing dependency rules lead
to subtle bugs pretty easily

15 years agoall tests pass with this version
Mike Bayer [Tue, 6 Apr 2010 03:21:02 +0000 (23:21 -0400)] 
all tests pass with this version

15 years agobeginning to get post_update working, will need more tests
Mike Bayer [Tue, 6 Apr 2010 01:29:51 +0000 (21:29 -0400)] 
beginning to get post_update working, will need more tests

15 years agobreakthrough, wow
Mike Bayer [Mon, 5 Apr 2010 22:48:57 +0000 (18:48 -0400)] 
breakthrough, wow

15 years agoso here is kind of the idea. but it doesn't work like it used to.
Mike Bayer [Mon, 5 Apr 2010 21:49:58 +0000 (17:49 -0400)] 
so here is kind of the idea.   but it doesn't work like it used to.
so I think I want to try to build a smarter "find everything without a dependency"
system that is more inline with how this is running now anyway - i.e.
go through the whole list, find nodes with no dependencies.  maybe the
original topological.sort() can do that, not sure.

15 years agolooks like most of the issues are because we're losing insert ordering
Mike Bayer [Mon, 5 Apr 2010 21:24:00 +0000 (17:24 -0400)] 
looks like most of the issues are because we're losing insert ordering
on cycles.  so lets reintroduce the organize as tree component, which
works here.   still need to make it meaningful by teaching the save/delete state
actions to receive a set of items to match up

15 years ago- many-to-many is up.
Mike Bayer [Mon, 5 Apr 2010 20:52:56 +0000 (16:52 -0400)] 
- many-to-many is up.
- now running on the full suite of tests.   unsurprisingly, it appears
there are subtle self-referential issues causing many tests to fail.

15 years agobetter assertions, the concern is that an object will change state and not have been
Mike Bayer [Mon, 5 Apr 2010 20:13:51 +0000 (16:13 -0400)] 
better assertions, the concern is that an object will change state and not have been
appropriately preprocessed

15 years agothese are some assertions that would make things easier, if they can be maintained.
Mike Bayer [Mon, 5 Apr 2010 18:53:19 +0000 (14:53 -0400)] 
these are some assertions that would make things easier, if they can be maintained.
otherwise, if listonly can go from True to False, then there's the whole cascades issue
to deal with, same for delete moving from False to True and vice versa.

15 years ago- enabled the DetectKeySwitch, and additionally added that it need
Mike Bayer [Mon, 5 Apr 2010 18:49:35 +0000 (14:49 -0400)] 
- enabled the DetectKeySwitch, and additionally added that it need
not execute at all when a one-to-many is present on the reverse side.
- OneToMany can establish a state as "listonly" when passive_updates are enabled
and the change is due to key switch.

15 years agobranch merge
Mike Bayer [Mon, 5 Apr 2010 17:48:52 +0000 (13:48 -0400)] 
branch merge

15 years agobetter yet
Mike Bayer [Mon, 5 Apr 2010 17:16:29 +0000 (13:16 -0400)] 
better yet

15 years agoclarify intent and reduce lookups here
Mike Bayer [Mon, 5 Apr 2010 17:09:24 +0000 (13:09 -0400)] 
clarify intent and reduce lookups here

15 years ago- further reduce what topological has to do, expects full list of nodes
Mike Bayer [Sun, 4 Apr 2010 16:24:01 +0000 (12:24 -0400)] 
- further reduce what topological has to do, expects full list of nodes
- fix some side-effect-dependent behaviors in uow.  we can now
unconditionally remove "disabled" actions without rewriting

15 years agothis fully moves the per_state methods to work with all states at once
Mike Bayer [Sun, 4 Apr 2010 15:29:41 +0000 (11:29 -0400)] 
this fully moves the per_state methods to work with all states at once

15 years agomoving the per-states operations to be aggreagted on the endpoints to reduce
Mike Bayer [Sun, 4 Apr 2010 15:08:00 +0000 (11:08 -0400)] 
moving the per-states operations to be aggreagted on the endpoints to reduce
procesing overhead.

15 years agomerge default branch
Mike Bayer [Sun, 4 Apr 2010 14:38:29 +0000 (10:38 -0400)] 
merge default branch

15 years ago- apparently [ticket:1761] was covered in tests already.
Mike Bayer [Sun, 4 Apr 2010 14:18:16 +0000 (10:18 -0400)] 
- apparently [ticket:1761] was covered in tests already.
- Usage of version_id_col on a backend that supports
cursor.rowcount for execute() but not executemany() now works
when a delete is issued (already worked for saves, since those
don't use executemany()). For a backend that doesn't support
cursor.rowcount at all, a warning is emitted the same
as with saves.  [ticket:1761]

15 years agocleanup and callcount reduction in mapper._save_obj, _delete_obj.
Mike Bayer [Sun, 4 Apr 2010 01:42:41 +0000 (21:42 -0400)] 
cleanup and callcount reduction in mapper._save_obj, _delete_obj.
includes an untested fix for [ticket:1761]