[sqlalchemy] SQLAlchemy-0.4.0beta3, pylons-0.9.6rc2: 'MetaData' object has no attribute 'name'

2007-08-21 Thread Goodrone
I follow instructions in http://wiki.pylonshq.com/display/pylonscookbook/SQLAlchemy+0.4+for+people+in+a+hurry a piece of my model/__init__.py file: # ... Session = scoped_session(sessionmaker(autoflush=True, transactional=True, bind=config['pylons.g'].sa_engine)) metadata = MetaData() table1

[sqlalchemy] Re: Ascii codec instead of unicode ?

2007-08-21 Thread Arun Kumar PG
Sounds good. Thanks Jason! On 8/20/07, jason kirtland [EMAIL PROTECTED] wrote: Arun wrote: So in short if I specify use_unicode=True at the SA engine level then I can skip specifying use_unicode and specify only charset=utf8 at mysqldb level ? If you configure this DB-API driver for

[sqlalchemy] Re: SQLAlchemy-0.4.0beta3, pylons-0.9.6rc2: 'MetaData' object has no attribute 'name'

2007-08-21 Thread Michael Bayer
you need to use the Table constructor, with an uppercase T. the lowercase table name is removed from the main sqlalchlemy namespace in the next release so that people don't trip over this one. On Aug 21, 2007, at 3:15 AM, Goodrone wrote: I follow instructions in

[sqlalchemy] dbcook updated for SA 0.4

2007-08-21 Thread svilen
hi The automatic DB-declaration layer, dbcook.sf.net/, is now working with either sqlalchemy 0.3 and 0.4. Other changes: - All DB_* parametrisation class attributes become DBCOOK_*. - DB-recreate works for postgress/msqql - misc/metadata/: autoload, diff, copydata are ok - Some work has

[sqlalchemy] polymorphic inheritance with multiple foreign keys

2007-08-21 Thread Patrick Wagstrom
Howdy, I'm trying to create a fairly generic graph structure in a database using SQLAlchemy. Basically, I'd like to create a root object of class Element, and have everything inherit from Element. Connections between Elements are done through a generic class Link, which is an Element itself,

[sqlalchemy] Re: adding non-persisted attributes to sqlalchemy objects - python newbie question

2007-08-21 Thread Michael Bayer
On Aug 21, 2007, at 2:14 PM, Brendan Arnold wrote: hi there, i'd like to add an array of 'tag' attributes for use on my orm objects while my scripts are running (i.e. a flag to delete etc.). recently i found that, class Foo(object): tags = [] caused problems with object instances

[sqlalchemy] Re: polymorphic inheritance with multiple foreign keys

2007-08-21 Thread Michael Bayer
On Aug 21, 2007, at 6:10 PM, Patrick Wagstrom wrote: Unfortunately, when creating the mapper, I can't specify an onclause to the mapper. Any help on how I would accomplish this and get my such a structure in SQLAlchemy? the onclause for a joined table inheritance join is specified