The new data upgrade functionality is available in revision 826. This adds sqlalchemy-migrate as a dependency.
Sqlalchemy-migrate uses a version table in the DB to keep track of the schema version. Each time Pytrainer starts, the upgrade mechanism will check this version number, adding it if missing, and run any upgrade scripts that have been added to the upgrade repository. >From now on, any database schema change should be accompanied with an sqlalchemy-migrate upgrade script. Data or configuration modifications can also be achieved with upgrade scripts. Upgrade scripts can be written as SQL or as Python. They can be targeted at a specific RDBMS or be generic. Upgrade scripts are located in the migrate repository at pytrainer/upgrade/versions. The new upgrade mechanism provides an alternative to the data cleanup logic in DDBB#checkDBIntegrity. This method still can be invoked by providing the "--check" startup parameter but in time this logic should be entirely replaced with upgrade scripts. - Nathan ------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Pytrainer-devel mailing list Pytrainer-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pytrainer-devel
