#!/usr/bin/env python
import os
import time
import MySQLdb
import sys

SENDMAIL = "/usr/sbin/sendmail" # sendmail location

username = "backupuser"
password = "backuppass"
hostname = "localhost"

filestamp = time.strftime('%d-%m-%Y')

# Get a list of databases on the mysql server
database_list_command="mysql -u %s -p%s -h %s --silent -N -e 'show databases'" % (username, password, hostname)
for database in os.popen(database_list_command).readlines():
    database = database.strip()
    
    # Check if the auto backup module is enabled and get the notification data
    notify_db = MySQLdb.connect( user=username,passwd=password,db=database)
    c = notify_db.cursor()
    
    try:
        c.execute("SELECT `notify_email`,`enabled` FROM `backup_config` WHERE 1 LIMIT 1")
        result = c.fetchone()
        notify_to = result[0]
        enabled = result[1]
    except MySQLdb.Error, e:
        continue
    
    if enabled == 1:
        filename = "/backups/mysql/%s-%s.sql" % (database, filestamp)
        os.popen("mysqldump -u %s -p%s -h %s -e --opt -c %s | gzip -c > %s.gz" % (username, password, hostname, database, filename))
        
        FROM = "backup@mydomainhere.com.au"
        
        if notify_to == "":
            notify_to = "backup@mydomainhere.com.au"
            
        TO = [notify_to]    # using a list to make it easier to support multiple addresses
        SUBJECT = "Backup Complete Notification"
        TEXT = "The latest database backup has been complete."

        # Prepare actual message
        message = """From: %s\nTo: %s\nSubject: %s\n\n%s""" % (FROM, ", ".join(TO), SUBJECT, TEXT)

        # Send the mail
        p = os.popen("%s -t -i" % SENDMAIL, "w")
        p.write(message)
        status = p.close()
        if status:
            print "Sendmail exit status", status