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

Reply via email to