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:
>
>
>
>
>
>
>
>
>
> > 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 follows:
>
> > Class Bank(object):
> > pass
> > class Location(object):
> > pass
>
> > there were load as follows:
>
> > bank_table = Table('banks',metadata, autoload = True)
> > location_table = Table('locations',metadata, autoload = True)
>
> > mapper(Location, location_table)
> > mapper(Bank, bank_table, properties =
> > {'country': relation(Location,
> > primaryjoin =
> > bank_table.c.country_id == location_table.c.id,
> > foreign_keys =
> > [bank_table.c.country_id],
> > lazy = False,
> > uselist = False
> > )
> > }
> > )
> > Now i was going to add a bank object , using the following data
> > {'name': 'Bank A', 'country_id': '1'}
> > I was called by the following error:
> > exception = 'int' object has no attribute '_sa_instance_state'
>
> this usually suggests you are assigning an integer value to an
> attribute which is mapped as an object reference. In this case I'd
> ensure that "country_id" is actually the key you used, and that it's
> not mapped as a relation().
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
