I am evaluating SQLAlchemy-migrate as a database migration tool. My db_version is 0, and the repository version is 1.
$ python manage.py db_version --url=postgresql://localhost:5432/my_db
0
$ python manage.py version
1
and I only have one unapplied version:
./versions/001_initial_schema_postgres_upgrade.sql
I run the migration tool, but it won't upgrade because it can't find the version:
$ python manage.py upgrade --version 1 --url=postgresql://localhost:5432/my_db
"There is no script for %d version" % self.version
AssertionError: There is no script for 1 version
Am I doing something wrong so that the migrate tool can't find my change script?