wizard.sql

Functions

wizard.sql.connect(url)

Convenience method for connecting to a MySQL database.

wizard.sql.auth(url)

If the URL has a database name but no other values, it will use the global configuration, and then try the database name.

This function implements a plugin interface named wizard.sql.auth.

wizard.sql.backup(outdir, deployment)

Generic database backup function.

wizard.sql.restore(backup_dir, deployment)

Generic database restoration function.

wizard.sql.drop(url)

Generic drop database function. Attempts to run DROP DATABASE on the database if no plugins succeed.

This function implements the plugin interface named wizard.sql.drop.

MySQL functions

wizard.sql.backup_mysql(outdir, deployment)

Database backups for MySQL using the mysqldump utility.

wizard.sql.restore_mysql(backup_dir, deployment)

Database restoration for MySQL by piping SQL commands into mysql.

wizard.sql.get_mysql_args(dsn)

Extracts arguments that would be passed to the command line mysql utility from a deployment.

Exceptions

exception wizard.sql.Error

Generic error class for this module.

exception wizard.sql.RemoveDatabaseError(details)

Removing the database failed.

exception wizard.sql.RestoreDatabaseError(details)

Restore script failed.

exception wizard.sql.BackupDatabaseError(details)

Backup script failed.