RE: [sqlalchemy] sql hashed tables

2012-01-09 Thread Jackson, Cameron
Woah, 100 tables of users? That doesn't seem right. How come you don't just have 1 table, 'users', with an id column, and then each user is a row in the table? Likewise for your events. Is there a reason you don't have a single 'events' table, with date as a column, and then each row in the

Re: [sqlalchemy] sql hashed tables

2012-01-09 Thread Michael Bayer
On Jan 9, 2012, at 9:07 PM, Mason wrote: Hi I have 100 tables that go from user_00 to user_99 (based on the last 2 digits of user id). In sql, I can create a view (say 'user') and query 'user' directly. With sqlalchemy, can I do something similar? I would like to query the 'user' class