]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/log
thirdparty/sqlalchemy/sqlalchemy.git
19 years agoput assertion in to check for secondary table if secondaryjoin explicit
Mike Bayer [Sat, 11 Feb 2006 15:43:52 +0000 (15:43 +0000)] 
put assertion in to check for secondary table if secondaryjoin explicit

19 years agoadded before_update/after_update
Mike Bayer [Sat, 11 Feb 2006 15:26:24 +0000 (15:26 +0000)] 
added before_update/after_update

19 years agoobjectstore refactored to have more flexible scopes for UnitOfWork
Mike Bayer [Fri, 10 Feb 2006 23:46:42 +0000 (23:46 +0000)] 
objectstore refactored to have more flexible scopes for UnitOfWork
central access point is now a Session object which maintains different
kinds of scopes for collections of one or more UnitOfWork objects
individual object instances get bound to a specific Session

19 years agocommented out print statement
Mike Bayer [Thu, 9 Feb 2006 00:50:22 +0000 (00:50 +0000)] 
commented out print statement

19 years agosomewhat of an overhaul, got alltests to work again
Mike Bayer [Thu, 9 Feb 2006 00:34:07 +0000 (00:34 +0000)] 
somewhat of an overhaul, got alltests to work again

19 years agoderefences connection pool upon dispose()
Mike Bayer [Thu, 9 Feb 2006 00:33:41 +0000 (00:33 +0000)] 
derefences connection pool upon dispose()

19 years agodeprecated "selectalias" argument on eager loader, do use_alias=True
Mike Bayer [Thu, 9 Feb 2006 00:33:26 +0000 (00:33 +0000)] 
deprecated "selectalias" argument on eager loader, do use_alias=True
"eager alias" flag will propigate to child eager loaders so the full query comes
out OK.  mappers/properties have overhauled "copy" methodology.  mappers
are no longer "singleton" and no longer have elaborate "hash_key" methods - there
is a primary mapper associated with a class which is done via direct dictionary
relationship, and the options() method on mapper does its own lighter-weight caching
of created mappers.  the unitofwork does extra work with the mappers it receives
to insure its dealing with "the primary" mapper, so that properties can be more liberal
about which mapper they reference (i.e. not the primary one).
options() works better but still could use a looking-at to see that
its not wasteful.  simplified mapper() method in __init__.

19 years agotook out print statement
Mike Bayer [Tue, 7 Feb 2006 04:55:12 +0000 (04:55 +0000)] 
took out print statement

19 years agotrying to get mappers to support having versions against different tables for the...
Mike Bayer [Tue, 7 Feb 2006 02:54:26 +0000 (02:54 +0000)] 
trying to get mappers to support having versions against different tables for the same class,
that dont affect the original class mapper and create objects with the correct identity key
support in EagerLoader to better handle "selectalias" when the eager mapper hits another eager mapper, etc

19 years agotook mysql foriegn key thing out
Mike Bayer [Mon, 6 Feb 2006 01:23:51 +0000 (01:23 +0000)] 
took mysql foriegn key thing out

19 years agoforeign key reflection !!!!!
Mike Bayer [Mon, 6 Feb 2006 01:23:00 +0000 (01:23 +0000)] 
foreign key reflection !!!!!

19 years agomoved stylesheets into section_wrapper so that autohandler can be more easily replaced
Mike Bayer [Mon, 6 Feb 2006 01:06:38 +0000 (01:06 +0000)] 
moved stylesheets into section_wrapper so that autohandler can be more easily replaced
(when used on the site)

19 years agoadded 'engine' to convert_result_value/convert_bind_param
Mike Bayer [Mon, 6 Feb 2006 01:03:20 +0000 (01:03 +0000)] 
added 'engine' to convert_result_value/convert_bind_param

19 years agoadded cascade_mappers function. somewhat experimental !
Mike Bayer [Mon, 6 Feb 2006 01:00:02 +0000 (01:00 +0000)] 
added cascade_mappers function.  somewhat experimental !

19 years agodocs
Mike Bayer [Mon, 6 Feb 2006 00:51:51 +0000 (00:51 +0000)] 
docs

19 years agoadded between(), column.label()
Mike Bayer [Sun, 5 Feb 2006 23:45:26 +0000 (23:45 +0000)] 
added between(), column.label()

19 years agotable supports per-engine-type options, ansisql allows engines
Mike Bayer [Sun, 5 Feb 2006 23:45:07 +0000 (23:45 +0000)] 
table supports per-engine-type options, ansisql allows engines
to add a "post table create" string
mysql gets mysql_engine argument
InnoDB set as default in engines test

19 years agoadded is_dirty method at module level and within UnitOfWork
Mike Bayer [Sun, 5 Feb 2006 23:27:25 +0000 (23:27 +0000)] 
added is_dirty method at module level and within UnitOfWork

19 years ago__init__ monkeypatch looks for __init__ in the class' dict rather than via getattr...
Mike Bayer [Sun, 5 Feb 2006 19:16:34 +0000 (19:16 +0000)] 
__init__ monkeypatch looks for __init__ in the class' dict rather than via getattr(), to bypass inheritance lookups

19 years agowrites foreign keys as individual FOREIGN KEY objects, syntax seems to work better
Mike Bayer [Sun, 5 Feb 2006 18:28:02 +0000 (18:28 +0000)] 
writes foreign keys as individual FOREIGN KEY objects, syntax seems to work better

19 years agogot oracle LIMIT/OFFSET to use row_number() syntax
Mike Bayer [Sun, 5 Feb 2006 17:04:37 +0000 (17:04 +0000)] 
got oracle LIMIT/OFFSET to use row_number() syntax
sql: ColumnClause will use the given name when proxying itself (used for the "ora_rn" label)
ansisql: When adding on ORDER_BY, GROUP_BY, etc. clauses, if there is no string for the column list,
then dont add the clause (this allows oracle to strip out the ORDER BY)
Oracle is modifying the select statement, which is not ideal - should fix that

19 years agomore Sequences needed for oracle
Mike Bayer [Sun, 5 Feb 2006 17:02:18 +0000 (17:02 +0000)] 
more Sequences needed for oracle

19 years agoordering of queries can be different based on platform dictionary ordering
Mike Bayer [Sun, 5 Feb 2006 16:25:27 +0000 (16:25 +0000)] 
ordering of queries can be different based on platform dictionary ordering

19 years agonow lets do that properly
Mike Bayer [Sun, 5 Feb 2006 16:20:16 +0000 (16:20 +0000)] 
now lets do that properly

19 years agoerror message if pysqlite2 couldnt be imported
Mike Bayer [Sun, 5 Feb 2006 16:17:23 +0000 (16:17 +0000)] 
error message if pysqlite2 couldnt be imported

19 years agoneeded optional sequence for oracle support
Mike Bayer [Sun, 5 Feb 2006 16:10:28 +0000 (16:10 +0000)] 
needed optional sequence for oracle support

19 years agodont mask engine compilation error
Mike Bayer [Sun, 5 Feb 2006 16:09:50 +0000 (16:09 +0000)] 
dont mask engine compilation error

19 years agoProvisional fix for #51, very slightly adapted from the patch posted in the ticket...
Jason Pellerin [Sun, 5 Feb 2006 14:43:10 +0000 (14:43 +0000)] 
Provisional fix for #51, very slightly adapted from the patch posted in the ticket. Tests added to verify fix.

19 years agostarted PassiveDefault, which is a "database-side" default. mapper will go
Mike Bayer [Sun, 5 Feb 2006 00:19:14 +0000 (00:19 +0000)] 
started PassiveDefault, which is a "database-side" default.  mapper will go
fetch the most recently inserted row if a table has PassiveDefault's set on it

19 years agocolumns can be specified to override those from autoload=True
Mike Bayer [Sat, 4 Feb 2006 23:41:07 +0000 (23:41 +0000)] 
columns can be specified to override those from autoload=True

19 years agois_unicode propigated into String subclasses
Mike Bayer [Sat, 4 Feb 2006 23:38:38 +0000 (23:38 +0000)] 
is_unicode propigated into String subclasses

19 years agoadded BETWEEN, courtesy Rick Morrison. go Rick !
Mike Bayer [Sat, 4 Feb 2006 21:51:46 +0000 (21:51 +0000)] 
added BETWEEN, courtesy Rick Morrison.  go Rick !

19 years agofixes involving when child object from list items is None - onetoone must pass, objec...
Mike Bayer [Sat, 4 Feb 2006 17:31:38 +0000 (17:31 +0000)] 
fixes involving when child object from list items is None - onetoone must pass, objectstore.testbackwardsmanipulations with postgres passes

19 years agoadded ISchema object to engine/information_schema, provides somewhat generic informat...
Mike Bayer [Sat, 4 Feb 2006 17:24:12 +0000 (17:24 +0000)] 
added ISchema object to engine/information_schema, provides somewhat generic information_schema access for db's that support it, i.e. postgres, mysql 5

19 years agoa future unit-test for testing one-to-one relationships
Mike Bayer [Sat, 4 Feb 2006 17:07:49 +0000 (17:07 +0000)] 
a future unit-test for testing one-to-one relationships

19 years agoone-to-one support:
Mike Bayer [Sat, 4 Feb 2006 17:05:09 +0000 (17:05 +0000)] 
one-to-one support:
rolled the BackrefExtensions into a single GenericBackrefExtension to handle
all combinations of list/nonlist properties (such as one-to-one)
tweak to properties.py which may receive "None" as "added_items()", in the case of a scalar property
instead of a list
PropHistory masquerades as a List on the setattr/append delattr/remove side to make one-to-one's automatically
work

19 years agoadded DATE, TIME, SMALLINT to __all__
Mike Bayer [Sat, 4 Feb 2006 16:47:12 +0000 (16:47 +0000)] 
added DATE, TIME, SMALLINT to __all__

19 years agoRick Morrison's patch adding Smallint, Date, and Time support !
Mike Bayer [Sat, 4 Feb 2006 16:44:00 +0000 (16:44 +0000)] 
Rick Morrison's patch adding Smallint, Date, and Time support !

19 years agobeginnings of a "multilple relations to the same table" test
Mike Bayer [Sat, 4 Feb 2006 16:43:36 +0000 (16:43 +0000)] 
beginnings of a "multilple relations to the same table" test

19 years agoverbiage edits
Mike Bayer [Sat, 4 Feb 2006 06:57:49 +0000 (06:57 +0000)] 
verbiage edits

19 years agoattempting to get MTOBackrefExtension to handle many-to-one, one-to-one equally
Mike Bayer [Fri, 3 Feb 2006 01:15:06 +0000 (01:15 +0000)] 
attempting to get MTOBackrefExtension to handle many-to-one, one-to-one equally

19 years agofixed set() to not re-set the same value
Mike Bayer [Fri, 3 Feb 2006 01:03:00 +0000 (01:03 +0000)] 
fixed set() to not re-set the same value

19 years agoswitched objectstore begin/commit behavior to do "reentrant counter"
Mike Bayer [Fri, 3 Feb 2006 00:42:22 +0000 (00:42 +0000)] 
switched objectstore begin/commit behavior to do "reentrant counter"

19 years agodeprecated relation(class, table)
Mike Bayer [Thu, 2 Feb 2006 23:28:23 +0000 (23:28 +0000)] 
deprecated relation(class, table)
changed unit tests/examples to not do it

19 years agoself->compare_self()
Mike Bayer [Thu, 2 Feb 2006 23:27:44 +0000 (23:27 +0000)] 
self->compare_self()

19 years agoadded doc for ProxyEngine
Mike Bayer [Wed, 1 Feb 2006 23:31:15 +0000 (23:31 +0000)] 
added doc for ProxyEngine

19 years agounit tests for proxy engine
Mike Bayer [Wed, 1 Feb 2006 23:27:36 +0000 (23:27 +0000)] 
unit tests for proxy engine

19 years agoinit
Mike Bayer [Wed, 1 Feb 2006 23:27:24 +0000 (23:27 +0000)] 
init

19 years agomight add scalar() to select which does limit=1
Mike Bayer [Wed, 1 Feb 2006 23:26:18 +0000 (23:26 +0000)] 
might add scalar() to select which does limit=1

19 years agonew ProxyEngine dispatches to multiple engines; contributed by jason pellerin
Mike Bayer [Wed, 1 Feb 2006 23:23:37 +0000 (23:23 +0000)] 
new ProxyEngine dispatches to multiple engines; contributed by jason pellerin

19 years agounit tests for merged cylical code
Mike Bayer [Wed, 1 Feb 2006 23:21:57 +0000 (23:21 +0000)] 
unit tests for merged cylical code

19 years agomerged new cyclical dependency code
Mike Bayer [Wed, 1 Feb 2006 23:21:36 +0000 (23:21 +0000)] 
merged new cyclical dependency code
EagerRelation gets a fix w/ regards to selectalias

19 years agomoved dict init to setattr for auto-__init__ thing
Mike Bayer [Wed, 1 Feb 2006 23:20:40 +0000 (23:20 +0000)] 
moved dict init to setattr for auto-__init__ thing

19 years agodev on uow docs
Mike Bayer [Wed, 1 Feb 2006 23:20:01 +0000 (23:20 +0000)] 
dev on uow docs

19 years agomerged fix that insures unrealized connections dont fill up the pool
Mike Bayer [Tue, 31 Jan 2006 05:20:19 +0000 (05:20 +0000)] 
merged fix that insures unrealized connections dont fill up the pool

19 years agofixed code error
Mike Bayer [Tue, 31 Jan 2006 02:15:16 +0000 (02:15 +0000)] 
fixed code error

19 years agoadded to trunk
Mike Bayer [Sun, 29 Jan 2006 21:51:59 +0000 (21:51 +0000)] 
added to trunk

19 years agoTabs to spaces
Robert Leftwich [Sun, 29 Jan 2006 12:35:27 +0000 (12:35 +0000)] 
Tabs to spaces

19 years agoReworked RowProxy to restore column order preservation and to remove some dictionary...
Robert Leftwich [Sun, 29 Jan 2006 12:30:32 +0000 (12:30 +0000)] 
Reworked RowProxy to restore column order preservation and to remove some dictionary-like behaviour that was unnecessary and caused breakage in existing code. Added tests for column preservation.

19 years agoAdded __len__ to RowProxy to allow len(r) and test for same.
Robert Leftwich [Sun, 29 Jan 2006 04:04:17 +0000 (04:04 +0000)] 
Added __len__ to RowProxy to allow len(r) and test for same.

19 years agoRowProxy changes - added keys(), used keys() to add more dictionary-like behaviour...
Robert Leftwich [Sat, 28 Jan 2006 22:24:16 +0000 (22:24 +0000)] 
RowProxy changes - added keys(), used keys() to add more dictionary-like behaviour (values(), iteritems(), iterkeys(), etc). Made parent and row private. Modified tests that used RowProxy.row to use values().

19 years agotook out print statement
Mike Bayer [Sat, 28 Jan 2006 18:05:45 +0000 (18:05 +0000)] 
took out print statement

19 years agotopological sort can detect cycles, and assemble them into a "big node" with all
Mike Bayer [Sat, 28 Jan 2006 18:02:42 +0000 (18:02 +0000)] 
topological sort can detect cycles, and assemble them into a "big node" with all
the nodes in the cycle aggregated into one node

19 years agoworking on representing longer circular relationships
Mike Bayer [Sat, 28 Jan 2006 06:18:08 +0000 (06:18 +0000)] 
working on representing longer circular relationships

19 years ago2nd scalar fix
Mike Bayer [Fri, 27 Jan 2006 23:59:12 +0000 (23:59 +0000)] 
2nd scalar fix

19 years agoscalar() returns None if no rows
Mike Bayer [Fri, 27 Jan 2006 23:56:13 +0000 (23:56 +0000)] 
scalar() returns None if no rows

19 years agostarting uow doc....
Mike Bayer [Fri, 27 Jan 2006 00:34:38 +0000 (00:34 +0000)] 
starting uow doc....

19 years agoconverted LEFT,RIGHT, CENTER to more reasonable names
Mike Bayer [Fri, 27 Jan 2006 00:34:18 +0000 (00:34 +0000)] 
converted LEFT,RIGHT, CENTER to more reasonable names

19 years agotask dump checks for None
Mike Bayer [Fri, 27 Jan 2006 00:33:54 +0000 (00:33 +0000)] 
task dump checks for None

19 years agorefactoring to allow column.label() to work in selects, etc.
Mike Bayer [Fri, 27 Jan 2006 00:33:15 +0000 (00:33 +0000)] 
refactoring to allow column.label() to work in selects, etc.
fixed superfluous codeline in ForeignKey

19 years agotest for inheritance, tests objectstore post_exec works fully
Mike Bayer [Thu, 26 Jan 2006 00:28:10 +0000 (00:28 +0000)] 
test for inheritance, tests objectstore post_exec works fully

19 years agorefactoring of objectstore to handle cleaning up after itself with less
Mike Bayer [Thu, 26 Jan 2006 00:27:14 +0000 (00:27 +0000)] 
refactoring of objectstore to handle cleaning up after itself with less
instruction from properties/mapper
objectstore gets an assertion for appending a deleted item
mapper has fix for inheritance
mapper selectone() etc. set "limit=1"

19 years agoai more reasonable hash_key that works across serializations
Mike Bayer [Thu, 26 Jan 2006 00:25:36 +0000 (00:25 +0000)] 
ai more reasonable hash_key that works across serializations
might want to get the DB password out of it tho....

19 years agoadded __repr__ to HashSet
Mike Bayer [Thu, 26 Jan 2006 00:24:54 +0000 (00:24 +0000)] 
added __repr__ to HashSet

19 years agofix to inheritance example
Mike Bayer [Thu, 26 Jan 2006 00:23:43 +0000 (00:23 +0000)] 
fix to inheritance example

19 years agoAdded column accessor to RowProxy, tests and note in documentation for same.
Robert Leftwich [Wed, 25 Jan 2006 01:07:26 +0000 (01:07 +0000)] 
Added column accessor to RowProxy, tests and note in documentation for same.

19 years agoadds a traversed list to the list of things to clean up
Mike Bayer [Tue, 24 Jan 2006 04:20:11 +0000 (04:20 +0000)] 
adds a traversed list to the list of things to clean up

19 years agopostgres checks for string/int port ID, converts to int for pg2 and string for pg1
Mike Bayer [Sun, 22 Jan 2006 23:18:22 +0000 (23:18 +0000)] 
postgres checks for string/int port ID, converts to int for pg2 and string for pg1

19 years agoorder_by and group_by being output in wrong order. Added tests for same.
Robert Leftwich [Sun, 22 Jan 2006 12:08:10 +0000 (12:08 +0000)] 
order_by and group_by being output in wrong order. Added tests for same.

19 years agoadded some echo arguments for uow, pool, propigated from the engine
Mike Bayer [Sat, 21 Jan 2006 06:33:33 +0000 (06:33 +0000)] 
added some echo arguments for uow, pool, propigated from the engine

19 years agoadjustment to dependencies+childtasks attached to circular task - they go
Mike Bayer [Sat, 21 Jan 2006 05:41:16 +0000 (05:41 +0000)] 
adjustment to dependencies+childtasks attached to circular task - they go
on just the lead task instead of each per-object task.
more tweaks to dumper output

19 years agorewrote objectstore logging
Mike Bayer [Sat, 21 Jan 2006 01:24:36 +0000 (01:24 +0000)] 
rewrote objectstore logging

19 years agocomment out dump, reverse check for self-ref task/delete-matchup
Mike Bayer [Fri, 20 Jan 2006 04:06:51 +0000 (04:06 +0000)] 
comment out dump, reverse check for self-ref task/delete-matchup

19 years agowhen breaking a circular task into child tasks, propigate the child tasks and the...
Mike Bayer [Fri, 20 Jan 2006 03:49:35 +0000 (03:49 +0000)] 
when breaking a circular task into child tasks, propigate the child tasks and the non-self-referring dependencies of the lead task to each child task...else they dont happen !

19 years agoformatting?
Mike Bayer [Fri, 20 Jan 2006 01:05:39 +0000 (01:05 +0000)] 
formatting?

19 years agosome docstrings
Mike Bayer [Fri, 20 Jan 2006 01:03:55 +0000 (01:03 +0000)] 
some docstrings

19 years agounset attributes on an object instance just return None instead of raising attributeerror
Mike Bayer [Fri, 20 Jan 2006 00:53:47 +0000 (00:53 +0000)] 
unset attributes on an object instance just return None instead of raising attributeerror

19 years agoadded explicit bind parameters and column type maps to text type
Mike Bayer [Fri, 20 Jan 2006 00:42:07 +0000 (00:42 +0000)] 
added explicit bind parameters and column type maps to text type
text type also parses :<string> into bind param objects
bind parameters convert their incoming type using engine.type_descriptor() methods
types.adapt_type() adjusted to not do extra work with incoming types, since the bind
param change will cause it to be called a lot more
added tests to new text type stuff, bind params, fixed some type tests
added basic docs for using text with binde params

19 years agoimplemented better hash_key on select allowing proper comparisons, implemented
Mike Bayer [Thu, 19 Jan 2006 01:43:26 +0000 (01:43 +0000)] 
implemented better hash_key on select allowing proper comparisons, implemented
hash_key on all clause objects
added hash_key test to select
util gets extra threadlocal functions and the recursionstack object

19 years agotabbing fix
Mike Bayer [Thu, 19 Jan 2006 00:28:57 +0000 (00:28 +0000)] 
tabbing fix

19 years agomore whitespace
Mike Bayer [Wed, 18 Jan 2006 06:56:23 +0000 (06:56 +0000)] 
more whitespace

19 years agowhitespace wrangling
Mike Bayer [Wed, 18 Jan 2006 06:50:16 +0000 (06:50 +0000)] 
whitespace wrangling

19 years agofix
Mike Bayer [Wed, 18 Jan 2006 06:13:31 +0000 (06:13 +0000)] 
fix

19 years agodispose() added to pool/engine to allow engines to fall out of scope
Mike Bayer [Wed, 18 Jan 2006 05:49:01 +0000 (05:49 +0000)] 
dispose() added to pool/engine to allow engines to fall out of scope

19 years agochanges to support docs in IE, adds a lot of whitespace....
Mike Bayer [Wed, 18 Jan 2006 00:30:32 +0000 (00:30 +0000)] 
changes to support docs in IE, adds a lot of whitespace....

19 years agoFormatting fix.
Robert Leftwich [Mon, 16 Jan 2006 06:34:10 +0000 (06:34 +0000)] 
Formatting fix.

19 years agoFixed problem in Column.copy(), _make_proxy() with nullable and hidden not being...
Robert Leftwich [Mon, 16 Jan 2006 06:22:52 +0000 (06:22 +0000)] 
Fixed problem in Column.copy(), _make_proxy() with nullable and hidden not being reflected into new Column. Added test for same. Removed reference to non-existant columns test from list of tests in alltests.

19 years agoassign_mapper will create a default __init__ method if one doesnt exist
Mike Bayer [Mon, 16 Jan 2006 04:46:37 +0000 (04:46 +0000)] 
assign_mapper will create a default __init__ method if one doesnt exist

19 years agofullname for table used when generating REFERENCES
Mike Bayer [Mon, 16 Jan 2006 03:57:29 +0000 (03:57 +0000)] 
fullname for table used when generating REFERENCES

19 years agocolumn arguments converted to integer
Mike Bayer [Fri, 13 Jan 2006 01:43:23 +0000 (01:43 +0000)] 
column arguments converted to integer