I've been through the tutorial and I'm attempting to construct a 1-
Many relationship between Customers.custnmbr ~ Addresses.custnmbr

Here is some sample code(no relations).

class Addresses(Entity):
    using_options(tablename='addresses')

    custnmbr = Field(Unicode, primary_key=True)
    adrscode = Field(Unicode, primary_key=True)
    address1 = Field(Unicode)
    ...

class Customers(Entity):
    using_options(tablename='customers')

    custnmbr = Field(Unicode, primary_key=True)
    custname = Field(Unicode)
    ...


The 1-Many forward relation would seem to be:
class Addresses(Entity):
    using_options(tablename='addresses')

    custnmbr = Field(Unicode, primary_key=True)
    adrscode = Field(Unicode, primary_key=True)
    address1 = Field(Unicode)


class Customers(Entity):
    using_options(tablename='customers')

    custnmbr = Field(Unicode, primary_key=True)
    custname = Field(Unicode)
    addresses = OneToMany(Addresses)

but I can't seem to figure out the back relationship that would be
needed.  I apologize if this is already answered on the list but I
couldn't seem to find it -- probably wasn't searching for the correct
term.  It's my first crack at ORM

Jeff
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"SQLElixir" 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/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to