Hi! I'm trying to use the sqlobject-admin command to track the evolution of my database schema but I couldn't find the right way to use it.
I couldn't find any documentation on the subject, except for the brief description when using sqlobject-admin help record/upgrade or in the sqlobject-admin command web documentation, but they are not enough. As I understand the steps to use this is: 1) Create a project using sqlobject. For example (model.py): from sqlobject import * from os.path import dirname, realpath __connection__ = 'sqlite://%s/db' % dirname(realpath(__file__)) class Person(SQLObject): name = UnicodeCol() 2) Create the database: PYTHONPATH=. sqlobject-admin --module=model create 3) Record the database version: PYTHONPATH=. sqlobject-admin --module=model \ --output-dir=sqlobject-history record 4) Edit model.py to add a column age = IntCol() to Person 5) Record the new version of the database schema: PYTHONPATH=. sqlobject-admin --module=model \ --output-dir=sqlobject-history record --edit (sqlobject-history/2007-08-21/upgrade_sqlite_2007-08-21a.sql is filled with 'ALTER TABLE person ADD COLUMN age INT;' in the editor) 6) Upgrade the database: PYTHONPATH=. sqlobject-admin --connection=sqlite://$PWD/db \ --output-dir=sqlobject-history upgrade But this last step says "Database up to date" because step 5) added a row to sqlobject_db_version table which says version='2007-08-21a'. If I manually change version to '2007-08-21' in the database, the 'upgrade' command works fine. The 'record' command has a switch to avoid updating the version row (--no-db-record), but when I use it the status presented in the editor when making the record --edit is empty, so it's a little annoying. This is not the way to use this record/upgrade stuff or I'm hitting a bug? Is there any other documentation/examples on this? TIA. -- LUCA - Leandro Lucarella - Usando Debian GNU/Linux Sid - GNU Generation ------------------------------------------------------------------------ E-Mail / JID: [EMAIL PROTECTED] GPG Fingerprint: D9E1 4545 0F4B 7928 E82C 375D 4B02 0FE0 B08B 4FB2 GPG Key: gpg --keyserver pks.lugmen.org.ar --recv-keys B08B4FB2 ------------------------------------------------------------------------ El poco sol que entra, me deja ciego Pero ni siquiera entibia mis baldozas frías Aquí donde todo es frío y casi muerto ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss