def restore_database():
"""
restore a database backup file, please use backup_database command first
"""
require('database_host', provided_by=[staging_server])
from lib.database_restore import DatabaseRestore
database_restore = DatabaseRestore(env.database_user,
env.database_password,
env.database_name,
env.database_host)
utils.make_dir_if_not_exists(database_restore.get_remote_restore_dir())
database_restore.list_backup_file()
database_restore.select_restore_file()
put(database_restore.get_local_restore_file(),
database_restore.get_remote_restore_file())
is_uploadad_sucessed = utils.is_same_content(
database_restore.get_local_restore_file(),
database_restore.get_remote_restore_file())
if is_uploadad_sucessed:
run(database_restore.get_restore_database_cmd())
else:
print "upload failed, you need upload again"
def backup_database():
"""
backup your database
"""
require('database_host', provided_by=[staging_server, production_server])
from lib.database_backup import DatabaseBackup
database_backup = DatabaseBackup(env.database_user,
env.database_password,
env.database_name,
env.database_host,
env.server_type)
utils.make_dir_if_not_exists(database_backup.get_remote_backup_dir())
database_backup.make_local_backup_file_path()
run('uptime')
run(database_backup.get_backup_cmd())
run(database_backup.get_show_remote_backup_file_cmd())
#run('md5sum %s' % database_backup.get_remote_backup_file_path())
get(database_backup.get_remote_backup_file_path(),
database_backup.get_local_backup_file_path())
is_download_sucessed = utils.is_same_content(
database_backup.get_local_backup_file_path(),
database_backup.get_remote_backup_file_path())
if is_download_sucessed:
print "Backup database sucess"
else:
print "backup database faile"
run(database_backup.get_remove_remote_backup_file_cmd())
return database_backup.get_local_backup_file_path()