I can not get my ahead around sqlalchemy. I have worked the sqlalchemy tutorial on the sqlalchemey site but it was for .2. I have been using tg for awhile but this is my first attempt with using sqlalchemy over sqlobject. Can someone point me to a tutorial that explains in detail how to go about setting up your modules? There seems to me much more that needs to be done upfront (which is ok) but i keep getting twisted around the axel.
I was looking at the auth model and it has joins predefined outside of the normal "foreign key" definition on a column? WHY? Do I have to do this for all of my joins in the model? I want to extend "User" and have it joined to some other tables most those tables reside in the auth model or can they be in a separate file (which seems to be the way the quickstart wants you to do it). Lets say I have a user table that is the normal stuff but has a company and supervisor column added to it. I then have a tasks and projects table. A task can be part of a project but doesn't need to be a task is owned by a user and can be delegated to another user. How would I go about setting up these tables? Also we need to setup a config script that builds our databases and adds date and it too is in another file? Do i need to rerun this everytime that I add or mod a table or is there a "better" way to do that. Confused, Paul Kraus --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
