On Mon, Nov 24, 2008 at 3:15 PM, Antony Joseph <[EMAIL PROTECTED]> wrote: > Hi, > > In turbogears application, i want to know that how can i update the > devdata.sqlite, if there is any modification or new tables added in database > schema. > currently i am using tg-admin sql create to create a new devdata.sqlite and > replace the existing devdata.sqlite, Every time i am losing my data when > database has changes. > > Can anyone help me how to update my existing devdata.sqlite.
If you are using SQLAlchemy, sqlalchemy-migrate is what you need. It will work better with postgresql or mysql because sqlite misses some table delete commands (but basic migration will work with sqlite too, you just won't be able to downgrade your database schema). If you use SQLObject you're on you own, I don't have an answer. Florent. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
