]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/log
thirdparty/sqlalchemy/sqlalchemy.git
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

19 years agocrazy postgres and its foreign key constraints
Mike Bayer [Sat, 11 Feb 2006 19:43:06 +0000 (19:43 +0000)] 
crazy postgres and its foreign key constraints

19 years agofixes to TypeDecorator, including A. Houghton's patch
Mike Bayer [Sat, 11 Feb 2006 19:35:50 +0000 (19:35 +0000)] 
fixes to TypeDecorator, including A. Houghton's patch

19 years agobeefed up type adaptation methodology, got Unicode to do encode/decode + test case
Mike Bayer [Sat, 11 Feb 2006 18:54:51 +0000 (18:54 +0000)] 
beefed up type adaptation methodology, got Unicode to do encode/decode + test case

19 years agofix to manytomany
Mike Bayer [Sat, 11 Feb 2006 16:33:09 +0000 (16:33 +0000)] 
fix to manytomany

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