For SQLite on Win32, I find the following tool very helpful: http://sqlitebrowser.sourceforge.net/
Kevin Horn On 2/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > There are many ways to do this. > > One is to use slobject's addColumn feature by adding it to your code, > and then delete it from your code > http://www.sqlobject.org/SQLObject.html#runtime-column-changes > > You'd then just add the appropriate line to your model and continue as > normal. This won't unfortunately work with sqlite---this is the > reason I switched from sqlite to mysql. > > But for sqlite you can do this: http://www.sqlite.org/faq.html#q13 > (then add the appropriate line to your model). > > You can also use your favorite gui administrative front end to your > database. I use mysql-navigator, but there's probably one for > whatever database and platform you are using. Just drill down until > you find an option to create a field. Create said field, add the > appropriate line to your model and your done. > > Another option is to just issue the sql directly to add a field... > Use "alter table tablename" > and then "add fieldname datatype". Like the other examples add the > appropriate line to your model, and proceed. > > > On Feb 19, 5:29 pm, "kbochert" <[EMAIL PROTECTED]> wrote: > > If I have a database (class) > > > > 4 class Person(SQLObject): > > 5 > > 6 firstName = StringCol(length=100) > > 7 middleInitial = StringCol(length=1, default=None) > > 8 lastName = StringCol(length=100) > > 9 lastContact = DateTimeCol(default=datetime.now) > > > > with a few thousand entries, and I wish to add a new field to the > > table > > age = Integer() #(or whatever) > > > > how do I proceed? > > > > thanx > > Karl > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
