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

2008-05-06 Thread Michael Bayer
On May 6, 2008, at 11:17 AM, [EMAIL PROTECTED] wrote: 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

[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 Michael Bayer
On May 6, 2008, at 11:42 AM, [EMAIL PROTECTED] wrote: No, I do implement a __str__ so that I can format up the composite primary key. I didnt implement __repr__ at all. Ok you'd have to work up an example script that can illustrate this happening, I can't see any codepath that would

[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

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

2008-05-06 Thread Michael Bayer
that doesnt help much. We really need a standalone script which reproduces the behavior on its own. You'll probably find the issue yourself as you go through this process. On May 6, 2008, at 12:28 PM, [EMAIL PROTECTED] wrote: #From the Model jobs_table = Table('jobs', metadata,

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

2008-05-06 Thread Michael Bayer
On May 6, 2008, at 12:28 PM, [EMAIL PROTECTED] wrote: #Interactive debugger is stuff I executed print Session.query(Job).all() [None] print Session.query(Job).first() None heres other things to try. 1. you are on SQLAlchemy 0.4.5. 2. do not use any 3rd party Python REPL tools like