One more issue.... the tables are reflected; meaning that they are
already defined in the database.
Can this syntax still be used in the Account class definition?
person_id = Column(Integer, ForeignKey('people'))
And, your Account class is derived from Base. The example I saw
online used object instead. Is there some inherent advantage to using
Base?
By the way, when I said that I could not find good examples, I was
referring to retrieving the last row ID.
Edgar
On Mar 25, 4:26 pm, Wyatt Baldwin <[email protected]> wrote:
> On Mar 25, 11:12 am, edgarsmolow <[email protected]> wrote:
>
> > I have a set of interdependent tables, including accounts and persons,
> > where this is their relationship (i.e., for certain persons):
>
> > PK: accounts.id INT AUTO_INCREMENT
> > accounts.acct_holder_id = person.id
>
> > PK: person.id INT AUTO_INCREMENT
> > person.account_id = account.id
>
> You probably only want one or the other of these foreign keys. Since
> an account "belongs to" a person (I'm assuming one or many accounts
> per person), you can probably get rid of person.account_id. Then, in
> your person class (assuming you're using the declarative approach):
>
> from sqlalchemy.orm import relation
>
> class Person(Base):
> __tablename__ = 'people'
> # stuff
> accounts = relation('Account')
>
> Over in your Account class:
>
> class Account(Base):
> __tablename__ = 'accounts'
> # stuff
> person_id = Column(Integer, ForeignKey('people'))
>
> Then when you receive the form data, create a new person and append
> the new account:
>
> p = Person(*args, **kwargs)
> p.accounts.append(Account(*args, **kwargs))
> db.add(p)
>
> Of course, I made a bunch of assumptions here, so this might not
> exactly work for you. The basic idea, though, is that you need to set
> up your relations properly and then what you want to do should be
> fairly straightforward.
>
>
>
> > When a new person's contact info is entered in a form, I want to add
> > both the person and the account to the database. The account is added
> > first (including some fields like status):
>
> > account = model.Account()
> > account.status = 'P'
> > db = meta.Session()
> > db.add(account)
> > db.commit()
>
> > The account.id field will be needed to set a field on the person
> > table:
> > person = model.Person()
> > person.first_name = 'Fred'
> > person.last_name = 'Flintstone'
> > person.account_id = account.id
>
> > How do I then determine account.id (i.e., the last row id on the
> > account table)?
>
> In general, you should never need to take this approach.
>
> > I could not seem to find a practical code example.
>
> There are lots of good examples at sqlalchemy.org.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pylons-discuss" 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/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
