[sqlalchemy] Problem in relation()

2008-11-13 Thread ershadul.hoque
Suppose I have two tables in mysql, there is no referential constraint defined. Tables: banks, locations Schema for banks: id, name, country_id Schema for locations: id, name banks.country_id will be foreign key of locations.id, but banks.country_id can be null too. Two tables are reflected as

[sqlalchemy] Re: Problem in relation()

2008-11-13 Thread ershadul.hoque
Thanks Michael Bayer, I have got the cause of the problem. I had set a attibute in the model as 'country' and assign a value = 0 Because it first the column name was country On Nov 13, 10:29 am, Michael Bayer [EMAIL PROTECTED] wrote: On Nov 13, 2008, at 8:44 AM, ershadul.hoque wrote

[sqlalchemy] Re: joins with limit offset

2008-10-25 Thread ershadul.hoque
PROTECTED] wrote: On Oct 23, 2008, at 8:58 AM, ershadul.hoque wrote: journals table has id column ledgers table has journal_id column consider that: journals table is mapped in Class Journal(object):    pass and similarly ledgers as : Class Ledger(object):   pass Now i want

[sqlalchemy] joins with limit offset

2008-10-23 Thread ershadul.hoque
journals table has id column ledgers table has journal_id column consider that: journals table is mapped in Class Journal(object): pass and similarly ledgers as : Class Ledger(object): pass Now i want to run this query ( it runs successfully in mysql): select * from (select * from