Untitled

import smtplib
import sqlite3
from email.message import EmailMessage
from email.utils import make_msgid
# from PIL import Image

conn = sqlite3.connect('employees.sqlite')
cursor = conn.cursor()
cursor.execute(
    "SELECT id, LastName, FirstName, Photo from employees WHERE strftime('%m',DOB) = strftime('%m','now') AND  strftime('%d','now') = strftime('%d', DOB)")

results = cursor.fetchall()
pic_sql = results[0][3]
print(pic_sql)
conn.close()

# Create the base text message.
msg = EmailMessage()
msg['Subject'] = "happy birthday"
msg['From'] = ("zard.41@gmail.com")
msg['To'] = ('s41.blizzard@mail.ru')
msg.set_content("""\
test test
""")

# Add the html version.  This converts the message into a multipart/alternative
# container, with the original text message as the first part and the new html
# message as the second part.
asparagus_cid = make_msgid()
msg.add_alternative("""\
<html>
  <head></head>
  <body>

    <img src="cid:{asparagus_cid}" />
  </body>
</html>
""".format(asparagus_cid=asparagus_cid[1:-1]), subtype='html')
# note that we needed to peel the <> off the msgid for use in the html.

# Now add the related image to the html part.
with open(pic_sql, 'rb') as img:
    msg.get_payload()[1].add_related(img.read(), 'dimaseg_frbulldog.jpg', 'jpeg',
                                     cid=asparagus_cid)
# Send the message via local SMTP server.
smtpObj = smtplib.SMTP('smtp.gmail.com', 587)
smtpObj.starttls()
smtpObj.login('zard.41@gmail.com', 'bi31V3Iu4J')
with smtpObj as s:
    s.send_message(msg)