Fabfile with support for sqlalchemy-migrate deployments?

Posted by Chris Reid on Stack Overflow See other posts from Stack Overflow or by Chris Reid
Published on 2010-05-06T02:12:25Z Indexed on 2010/05/06 2:18 UTC
Read the original article Hit count: 321

Filed under:

best-practices

I have database migrations (with sqlalchemy-migrate) working well in my dev environment. However, I'm a little stumped about how to integrate this into my deployment process.

I'm using fabric for deployment but having some trouble scripting the migrations part. The path to the to migrations directory in site-packages is dynamic (due to changing egg version number) and I'd rather not hard code my db password into the fabfile.

Does anyone have a fabfile that plays nicely with sqlalchemy-migrate?

Related posts about fabric

Windows Azure Learning Plan - Application Fabric

as seen on SQL Blog - Search for 'SQL Blog'
This is one in a series of posts on a Windows Azure Learning Plan. You can find the main post here. This one deals with the Application Fabric for Windows Azure. It serves three main purposes - Access Control, Caching, and as a Service Bus. Overview and Training Overview… >>> More
fabric and svn password

as seen on Stack Overflow - Search for 'Stack Overflow'
Assuming that I cannot run something like this with Fabric: run("svn update --password 'password' .") how's the proper way to pass to Fabric the password for the remote interactive command line? I am not sure, but the svn server we're using might have some restrictions to not allow --non-interactive… >>> More
Python Fabric error

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm running fabric (Django deployment to apache) and everything seems to work fine until I get to the task for installing the site: def install_site(): "Add the virtualhost file to apache" require('release', provided_by=[deploy, setup]) sudo('cd %(path)/releases/%(release)/%(release);… >>> More
How to set target hosts in Fabric file

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to use Fabric to deploy my web app code to development, staging and production servers. My fabfile: def deploy_2_dev(): deploy('dev') def deploy_2_staging(): deploy('staging') def deploy_2_prod(): deploy('prod') def deploy(server): print 'env.hosts:', env.hosts env.hosts = [server] … >>> More
fabric deploy problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to deploy a django app with fabric and get the following error: Alexs-MacBook:fabric alex$ fab config:instance=peergw deploy -H <ip> - u <username> -p <password> [192.168.2.93] run: cat /etc/issue Traceback (most recent call last): File "build/bdist.macosx-10… >>> More

Developer IT