Code: Alles auswählen
if __name__ == "__main__":
mail = poplib.POP3_SSL('pop.googlemail.com', 995)
mail.user("meine_email")
mail.pass_("mein_passwort")
messages = len(mail.list()[1])
for i in range(messages):
raw_mail = mail.retr (i+1)
str = string.join(raw_mail[1], "\n")
my_mail = email.message_from_string(str)
conn = dbtools.opendb ()
cursor = conn.cursor()
cursor.execute("""INSERT INTO mail_incomming
(mail_from, mail_to, mail_subject, mail_date)
VALUES
(%s, %s, %s, %s)""", [
my_mail["From"],
my_mail["To"],
my_mail["Subject"],
my_mail["Date"]
])
conn.close ()
for part in my_mail.walk():
if (part.get_filename()):
print (part.get_filename())
conn = dbtools.opendb ()
cursor = conn.cursor()
cursor.execute("""INSERT INTO mail_incomming_append
(append_id,append, filename)
VALUES
((SELECT MAX(id) from mail_incomming), %s, %s)""", [
part.get_payload(decode=True),
part.get_filename()])
conn.close ()
Kann da jemand helfen?