def sendClientMailsOficinasArriendo():
mariadb_connection = mysql.connect(user='******',
password='******',
host='127.0.0.1',
database='bullestate')
cur = mariadb_connection.cursor()
cur.execute(sqlOficinasArriendo)
lista = cur.fetchall()
mariadb_connection.close()
print("[" + str(datetime.now()) +
"]Sending mails (oficinas arriendo) to " + str(len(lista)) +
" clients:")
for i, l in enumerate(lista):
to = str(l[0])
nombreProp = str(l[1])
linkProp = str(l[2])
mailer.sendMailGratis(to, nombreProp, linkProp)
checkClient(to, "1")
time.sleep(sleepTime)
def threadSendMails():
t = threading.currentThread()
mariadb_connection = mysql.connect(user='******',
password='******',
host='127.0.0.1',
database='bullestate')
cur = mariadb_connection.cursor()
cur.execute(sqlDeptos)
listaDeptos = cur.fetchall()
cur.execute(sqlCasas)
listaCasas = cur.fetchall()
cur.execute(sqlOficinas)
listaOficinas = cur.fetchall()
mariadb_connection.close()
print("[mailbotPahola][" + str(datetime.now()) +
"]Sending mails (dptos) to " + str(len(listaDeptos)) + " clients:")
for i, l in enumerate(listaDeptos):
if not getattr(t, "do_run", True):
print("[mailbotPahola] Deteniendo mailer")
return
to = str(l[0])
nombreProp = str(l[1])
linkProp = str(l[2])
#gratis
mailer.sendMailGratis(to, nombreProp, linkProp)
checkClient(to, "1")
time.sleep(sleepTime)
def sendClientMailsTerrenos():
mariadb_connection = mysql.connect(user='******', password='******', host='127.0.0.1', database='bullestate')
cur = mariadb_connection.cursor()
cur.execute(sqlTerrenos)
lista = cur.fetchall()
mariadb_connection.close()
print("[" + str(datetime.now()) +"]Sending mails (terrenos) to "+str(len(lista))+ " clients:")
carolina=True
for i,l in enumerate(lista):
to = str(l[0])
nombreProp = str(l[1])
linkProp=str(l[2])
gratis=True
if carolina:
mailer.sendMailGratis(to,nombreProp,linkProp,gratis)
carolina=False
else:
mailerDaniela.sendMailGratis(to,nombreProp,linkProp)
carolina=True
checkClient(to,"1")
time.sleep(sleepTime)