Joost Moesker wrote:
1) Create the current sql schema using tg-admin sql record 2) See what tables need to be altered using tg-admin sql status 3) Use the generated schema as basis for youre alter script. It's 'documented' at: http://www.sqlobject.org/sqlobject-admin.html.
Is this linked from the Turbogears project anywhere? I know the philosophy is to have a loosely-coupled set of tools, but we can't keep chasing around the internet across 5 or 6 sites to find out how to do something integral to using the system. What does (1) actually do? I ran the command, it seemed to work, and I have no idea what its created. (2) tells me which columns are missing, but says nothing about their type, which I will presumably have to translate from my model.py myself, hoping everything matches up. (3) assumes I know how to write and use an alter script. Why am I expected to know how to write SQL statements to alter a database, which is somewhat esoteric compared to creating a table, which is quite standard (yet which is done for me)? Isn't this sort of thing supposed to be isolating me from database-specific solutions?
I don't see why you are bashing SQLObject. Honestly, I have been working with it for over a year now and haven't found one single usecase which it could not solve.
Probably because you have more time and/or patience than myself. I am quite confident that SQLObject can probably do everything I need - it's just a case of how much source code I have to trawl through, how much performance I have to sacrifice, and how much searching of Google and mailing lists I have to do in order to find the equivalent of an obvious 1 line SQL statement.
The SQLObject api is much more than just the *Column and *Join classes. You can do almost any query through the SQLBuilder syntax.
You mean the SQLBuilder syntax which has barely a single page of documentation? It's lacking several crucial things, such as any example whatsoever of its usage, never mind an example addressing a multi-table join like the one I described earlier in this thread. -- Ben Sizer --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
