[sqlalchemy] query.all() returns None?

2008-05-06 Thread dgriff1
Hi, I have been using SQLAlchemy with Pylons. I map a table to a class and use ORM(reflection) to work with it. I am using MySQL for the backend. The class is Job and the table is jobs. I can create and insert new Jobs but whenever I try to get any back I get None. This used to work just fine

[sqlalchemy] Re: query.all() returns None?

2008-05-06 Thread dgriff1
No, I do implement a __str__ so that I can format up the composite primary key. I didnt implement __repr__ at all. Dan On May 6, 10:25 am, Michael Bayer [EMAIL PROTECTED] wrote: On May 6, 2008, at 11:17 AM, [EMAIL PROTECTED] wrote: Hi, I have been using SQLAlchemy with Pylons. I map

[sqlalchemy] Re: query.all() returns None?

2008-05-06 Thread dgriff1
Ok, its pretty hard to really put an example script up, but heres the relelvant parts. #From the Model jobs_table = Table('jobs', metadata, autoload=True) mapper(Job, jobs_table ) #The Job Class is pretty generic so I wont include it #The method that does the display with a debug print def