Pyquibase
Pyquibase is a Python wrapper for liquibase. There are other liquibase wrapper for python but they all require change log files to be in YAML format. Since I want to use xml file for liquibase, I built my own liquibase wrapper for python. Athough I use Pyquibase with xml files only, it should also work with other file types.
Installation
pip install pyquibaseUsage
Currently it supports Sqlite, MySql, and Postgresql
Update
sqlite
from pyquibase.pyquibase import Pyquibase
if __name__ == '__main__':
pyquibase = Pyquibase.sqlite('test.sqlite', 'db-changelog-1.xml')
pyquibase.update()MySQL
from pyquibase.pyquibase import Pyquibase
if __name__ == '__main__':
pyquibase = Pyquibase.mysql(
host = 'localhost',
port = 3306,
db_name = 'pyquibase',
username = 'root',
password = 'test',
change_log_file = 'db-changelog-1.xml'
)
pyquibase.update()Postgresql
from pyquibase.pyquibase import Pyquibase
if __name__ == '__main__':
pyquibase = Pyquibase.postgresql(
host = 'localhost',
port = 3306,
db_name = 'pyquibase',
username = 'root',
password = 'test',
change_log_file = 'db-changelog-1.xml'
)
pyquibase.update()Rollback
pyquibase.rollback('tag')
