Kashif wrote: > > Tried that already, I get an error: > > InterfaceError: (InterfaceError) Error binding parameter 1 - probably > unsupported type. u 'INSERT INTO emails (address, user) VALUES > (?, ?)' ['e...@ped.com', <__main__.User object at 0x92edcec>] > > or I get a ProgrammingError that says something like 'cant adapt...' > > PS: I am interested in the non-declarative style
if you'd like to store a User object on an attribute named "user", then you can't map that attribute to a column named "user". you need to construct a foreign key on your table. please read: http://www.sqlalchemy.org/docs/05/mappers.html#many-to-one > > > On Apr 6, 7:44 pm, "Michael Bayer" <mike...@zzzcomputing.com> wrote: >> Kashif wrote: >> >> > Hi, >> > I have tried all kinds of tutorials, but I cant get two simple tables >> > mapped. >> >> pretty much this exact example is present in *the* tutorial which is the >> ORM tutorial athttp://www.sqlalchemy.org/docs/. >> >> >> >> > Here are the tables: >> >> > class User(object): >> > def __init__(self,username,password): >> > self.username = username >> > self.password = password >> >> > class Email(object): >> > def __init__(self, address, user): >> > self.address = address >> > self.user = user >> >> > All I wish to accomplish is the following: >> >> > tom_user = User("tom","passy") >> > tom_email = Email("t...@someemail.com", tom_user) >> > session.add(tom_user) >> > session.add(tom_email) >> > session.commit() >> >> > But this doesnt work, can someone flesh out the tables and the mapping >> > for me so I know what I am doing wrong. >> >> > Thanks >> > Kashif > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
