Re: [Sqlalchemy-users] transaction uber-commit

hey, just confirmed this.  to fix right now:   make sure you create_engine('url', strategy='plain') .On Jun 22, 2006, at 10:29 AM, Tim Van Steenburgh wrote:Sorry, shoulda mentioned that I'm using SA 0.2.3.On 6/22/06, Tim Van Steenburgh [EMAIL PROTECTED] wrote:Mike, did Nick ever follow up with an

[Sqlalchemy-users] duplicate inserts of many-to-many keys

Not sure if this is a bug or something wrong with the way I'm assigning the role in Admin.__init__(). Test script and engine output below.import sqlalchemy.mods.threadlocalfrom sqlalchemy import *sqlite = 'sqlite:///:memory:' db = create_engine(sqlite, strategy='plain', echo=True)metadata =

Re: [Sqlalchemy-users] duplicate inserts of many-to-many keys

the 'roles' attribute on the "User" and "Admin" mappers (inheriting properties copy across a hierarchy) were both trying to insert a row...added some more uniqueness + unittest to fix, revision 1653.On Jun 22, 2006, at 5:04 PM, Tim Van Steenburgh wrote:import sqlalchemy.mods.threadlocalfrom

Re: [Sqlalchemy-users] Error creating Table while try simpe test

Mike, if you've got some time, you may want to review the discussion regarding a TypePolicy scheme a few weeks ago (IIRC the thread was titled something about Decimal/Numeric). If you're digging into type conversion and don't mind a bit more work, this might be a good time to start some work on

Re: [Sqlalchemy-users] Specifying order (and perhaps other keyword arguments) when using ActiveMapper

Jonathan LaCour wrote: Thanks to Mike's latest changes in the SQLAlchemy core to allow for deferred mapper compilation, a lot of the checking in ActiveMapper is no longer necessary (basically, the second loop inside the process_relationships() function). You should be able to remove this

[Sqlalchemy-users] strange initialization problem with latest trunk

I have code that's been working with an earlier version of 0.2 after svn up tonight I find this odd behaviour, that is table.c is busted until the first query is executed. Then that table starts working, but other tables are broken too until I perform a select on them. Revision: 1654 --

Re: [Sqlalchemy-users] Specifying order (and perhaps other keyword arguments) when using ActiveMapper

Michael Bayer wrote: you can stick order_by into the ManyToMany, OneToMany, etcnone of it should be processed until the tables exist in the MetaData and are therefore locatable via string Yah -- this was easy. A quick first cut doing this only (no generalization yet at all) is

[Sqlalchemy-users] RowProxy methods

I just had an interesting failure in some tests with rev 1652, although its a fundamentally a v0.2 difference, but this is the first time I've been in a position to run this test on 0.2. The RowProxy class now has a 'close' method which, when using the attribute notation to access columns

Re: [Sqlalchemy-users] RowProxy methods

at what point did we even have a __getattr__ on RowProxy ? the close () method on there is not very important, more important on ResultProxy. but you do have items, keys, values, etc. also somewhat generic names. without SVN annotating to see if it was my idea originally, id say why not

Re: [Sqlalchemy-users] strange initialization problem with latest trunk

a lot has changed with mapper initialization (and plenty of bugs), but not tables. can you send a test example ? heres a session with tables: from sqlalchemy import * meta = MetaData() t = Table('sometable', meta, Column('col1', Integer, primary_key=True), Column ('col2',

Re: [Sqlalchemy-users] RowProxy methods

Michael Bayer wrote: at what point did we even have a __getattr__ on RowProxy ? the close () method on there is not very important, more important on ResultProxy. but you do have items, keys, values, etc. also somewhat generic names. without SVN annotating to see if it was my idea

Re: [Sqlalchemy-users] Error creating Table while try simpe test

the thing that worries me about TypePolicy is that its a whole new object and concept to learn just to do something simple, i.e. i want the string "enum" to give me back MSEnumType, or "decimal" to give me back a FloatType or DecimalType.  for that, i still see the plain dictionary of

Re: [Sqlalchemy-users] RowProxy methods

usually with this kind of thing the row['literal'] method is used when theres a keyword conflict. im not sure what system im thinking of but ive def. seen that idea before (although one way to do it would just say, row[something] and thats it). i *have* become slightly more pythonic in

Re: [Sqlalchemy-users] duplicate inserts of many-to-many keys

Not sure what's goin on, but I checked out 1653 and get the exact same error. ? :(On 6/22/06, Michael Bayer [EMAIL PROTECTED] wrote:the 'roles' attribute on the User and Admin mappers (inheriting properties copy across a hierarchy) were both trying to insert a row...added some more uniqueness +

[Sqlalchemy-users] SQLAlchemy and locking up.

Ok, so I've upgraded mydrawings.com to use SQLAlchemy 0.2.3 a few days ago w/ the hopes that any database locking up problems on 0.1.x were alleviated. I'm still having lockups though. I installed httprepl into cherrypy(See this thread for details: