document.open();document.writeln('
');document.writeln('
def update():');document.writeln('    "Update development MySQL database with production clone."');document.writeln('');document.writeln('    require(');document.writeln('        'prod_mysql_host', 'prod_mysql_user', 'prod_mysql_pass', 'prod_mysql_db',');document.writeln('        'local_mysql_host', 'local_mysql_user', 'local_mysql_pass', 'local_mysql_db'');document.writeln('    )');document.writeln('');document.writeln('    # Run the database dump on the server and store as file.');document.writeln('    run("mysqldump --user=$(prod_mysql_user) --password=$(prod_mysql_pass) --host $(prod_mysql_host) $(prod_mysql_db) > $(prod_mysql_db).dump")');document.writeln('');document.writeln('    # Download the database dump from the server and store as file.  Will be stored as $(prod_mysql_db).dump.$(fab_host).');document.writeln('    download('$(prod_mysql_db).dump', '$(prod_mysql_db).dump')');document.writeln('');document.writeln('    # On our local workstation, create a fresh instance of the database and import the production dump into it.');document.writeln('    local("""');document.writeln('        `mysql -u$(local_mysql_user) -p$(local_mysql_pass) -h$(local_mysql_host) << EOF');document.writeln('        DROP DATABASE IF EXISTS $(local_mysql_db);');document.writeln('        CREATE DATABASE $(local_mysql_db);');document.writeln('        exit`');document.writeln('');document.writeln('        `mysql -u$(local_mysql_user) -p$(local_mysql_pass) -h$(local_mysql_host) $(local_mysql_db) < $(prod_mysql_db).dump.$(fab_host)`');document.writeln('    """)');document.writeln('');document.writeln('def deploy(**kwargs):');document.writeln('    "Deploy code changes to the production server."');document.writeln('');document.writeln('    # If a message is provided (fab deploy:m='a message'), run an SVN commit, first.');document.writeln('    if 'm' in kwargs:');document.writeln('        set(message = kwargs['m'])');document.writeln('        local("svn ci -m '$(message)'")');document.writeln('    else:');document.writeln('        local("echo 'WARNING: running deploy without SVN commit.\\n##########'")');document.writeln('    run("svn update $(prod_dir)")');document.writeln('
');document.writeln('');document.writeln('');document.writeln('
');document.close();