Hi. My latest patch to bug 57 [1] solves this problem partially by adding the db.check_column() method. It can add columns without recreating table. You would need to call this in db.__check_schema() and add new fields to the list in db.load_channnels().
But if you can wait few days, maybe I will come up with a better solution and update that patch. I'll post here. 1. http://bugs.gpodder.org/show_bug.cgi?id=57#c11 On 7/17/08, jerome. chabod @ ifrance. com <[EMAIL PROTECTED]> wrote: > Hello, > > I need for solving bug 90 to add a "xsl_file" property to channels. > Unfortunaltely, since whe use sqlite, it seems there is no mechanism to > transparently add a field. The only way I see is to force the user to > remove its database in order to run the setup again (table creation), and > doing so losing its channels configurations and episode's history. Not very > elegant. > > Has somebody already plan to solve this problem or have indication on how it > could be done? > From my point of vue, I would maintain a hard coded list of fields, and have > a function which would check at each start if the fields are already in the > table and add it if not (alter table). But I'm afraid it could be a very > expensive task. What do you think? > > Jérôme > > ________________________________ > My...où ? You...quoi ? Face...qui ?... Vous ne savez plus comment être > vous-même ? > Pour Créer, Partager et enfin Gagner ... Découvrez iDOO en vidéo > _______________________________________________ > gpodder-devel mailing list > [email protected] > https://lists.berlios.de/mailman/listinfo/gpodder-devel > > _______________________________________________ gpodder-devel mailing list [email protected] https://lists.berlios.de/mailman/listinfo/gpodder-devel
