Re: [sqlalchemy] TypeError: argument of type 'NoneType' is not iterable

2012-02-27 Thread Jakob D.
Sure, I thought that might be something obvious. Here's runnable test which gives the above error: import elixir from elixir import * from elixir.events import * from sqlalchemy.orm import scoped_session, sessionmaker from smisk.config import config class Project(Entity):

Re: [sqlalchemy] TypeError: argument of type 'NoneType' is not iterable

2012-02-27 Thread Michael Bayer
To make this script run, I had to remove from smisk.config since I don't have access to that, and also replace get_db_url() with a plain SQLite URL. The script also doesn't include any data so I added a row that matches the particular delete you're doing. The line that redefines the elixir

[sqlalchemy] Re: deleting a sqlite database

2012-02-27 Thread lars van gemerden
Thank you for the extensive reply. It makes things a lot clearer; still i am not sure about how to continue. Conceptually i would like to create 2 sets of tables/classes in a database (as part of a prototype): 1) one set of tables/classes with the parameters to generate other classes/tables

Re: [sqlalchemy] Re: Something in Pyramid is preventing gc on SQLAlchemy objects

2012-02-27 Thread Vlad K.
Thanks for the info, I've commented on that separate issue as well. .oO V Oo. On 02/25/2012 04:14 AM, Yap Sok Ann wrote: I too encountered the same problem that wasted me days, until I caught pdtb_sqla_queries with my very limited memory profiling skill. I have actually filed a bug here:

Re: [sqlalchemy] Re: deleting a sqlite database

2012-02-27 Thread Michael Bayer
On Feb 27, 2012, at 9:55 AM, lars van gemerden wrote: Thank you for the extensive reply. It makes things a lot clearer; still i am not sure about how to continue. Conceptually i would like to create 2 sets of tables/classes in a database (as part of a prototype): 1) one set of

Re: [sqlalchemy] Re: deleting a sqlite database

2012-02-27 Thread Michael Bayer
The only database link between these two sets is the 'polymorphic on' column in the root base table in set 2, which is a foreign key to a Type table in set 1. also, I'd set up this foreign key using a literal Column so you don't have to worry about string lookups:

Re: [sqlalchemy] TypeError: argument of type 'NoneType' is not iterable

2012-02-27 Thread Jakob D.
Yes, the error was reproduced. I'm using 0.4.7. I couldn't import Session, any particular reason you imported it? Here's the output, it seems to get the entry just fine: (I only get one entry by id to minimize the output) 2012-02-27 16:19:37,080 INFO sqlalchemy.engine.base.Engine.0x..cL SHOW

Re: [sqlalchemy] TypeError: argument of type 'NoneType' is not iterable

2012-02-27 Thread Michael Bayer
On Feb 27, 2012, at 10:42 AM, Jakob D. wrote: Yes, the error was reproduced. I'm using 0.4.7. ouch ! I couldn't import Session, any particular reason you imported it? i was trying to play with how to get elixir.session to mean something. It's not something that would work in 0.4.