Пример #1
0
import smtplib
import MySQLdb as mdb
import datetime
import pytz

from etc import Config


smtp_config = Config.smtp()
db_config = Config.db()

db_conn = mdb.connect(db_config["host"],
                      db_config["user"],
                      db_config["password"],
                      db_config["name"])

to_addresses = []

try:
    query = "SELECT DISTINCT(email) from users"
    db_cursor = db_conn.cursor()
    db_cursor.execute(query)

    results = db_cursor.fetchall()

    if len(results) == 0:
        print "No emails to send"
        exit()

    for row in results:
        to_addresses.append(row[0])