If SQLAlchemy seems a bit overwhelming, you can always try using Elixir (or
one of the other declarative wrappers fro SA) to "get your feet wet" and get
fully up to speed on SQLAlchemy itself as you go.
Kevin Horn
On 5/18/07, Lee McFadden <[EMAIL PROTECTED]> wrote:
>
>
> On 5/18/07, Greg Lindstrom <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I am attempting to create tables for an application I am writing to help
> my
> > wife track her home business. I want a a table to hold some client
> > information (Client), with multiple joins to a table holding phones,
> emails,
> > and addresses (allowing multiple associations for each back to the
> client).
> > Here are the classes out of model.py (some field removed for clarity)
> >
> --8<-- snip --8<--
> >
> > When I run tg-admin sql create I get the address, client, email, and
> phone
> > tables, as well as a address_client table. I am expecting an
> email_client
> > and phone_client but I don't see them. Am I correct to assume I should
> get
> > a join tables for the other two? And, if so, am I doing something wrong
> in
> > my class definitions? I've looked at this for a couple days now and
> just
> > don't see it.
>
> My SQLObject is a little rusty, but I believe that if you have a
> RelatedJoin, it should be defined as RelatedJoin in both classes. So
> where you have `phones = MultipleJoin('Phones')` in your Client class
> it should be `phones = RelatedJoin('Phones')` and the same goes for
> the other many-to-many joins you have.
>
> >
> > Related to this, since I am just learning this, should I make the effort
> to
> > use SQLAlchemy in place of SQLObject?
> >
>
> In my opinion, yes. SA will be the future default ORM for TG so you
> should probably start using it now if you want to learn the defaults.
> SO will still be supported though, so if you really prefer it to SA
> you can use it instead. SA is a little more verbose when defining
> your tables and objects, but the flexibility and power that you get is
> definitely worth the extra typing :)
>
> Lee
>
>
> --
> Lee McFadden
>
> blog: http://www.splee.co.uk
> work: http://fireflisystems.com
> skype: fireflisystems
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
