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 -~----------~----~----~----~------~----~------~--~---
