Das deutsche Python-Forum

Code: Alles auswählen

.
.
mailad=()

def abfrage():
    
    
    sql = "SELECT servername, sw_producer, enddate, comment, email FROM software s, notify n, users u WHERE s.rowid=software_id AND users_id=id_users AND enddate < date('now', '+72days')" 
    cur = conn.cursor() 
    cur.execute(sql) 
    data = cur.execute(sql) 

    if (data is not 'NULL'):
        
        item = 0 
        for item in data: 
            print item[4] 
            mailad = item[4] 
            print mailad 
abfrage() 

def versenden(): 
    
    Email( 
        from_address = "auernighp@chello.at", 
        to_address = mailad, 
        subject = "Python_test", 
        message = "Email via Python" 
    ).send() 
versenden() 

Code: Alles auswählen

def abfrage():
    ...
    return mail

def versenden(mail):
    Email(
        ...
        to_address=mail,
    ).send()

mail = abfrage()
versenden(mail)