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)