import pypyodbc as pyodbc
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText


def msgfunc(msgcnt):
   fromaddr = "Smoot178@gmail.com"
   toaddr = "Smoot178@gmail.com"
   msg = MIMEMultipart()
   msg['From'] = fromaddr
   msg['To'] = toaddr
   msg['Subject'] = "Messages over 8!"

   body = "Number of messages: " + msgcnt
   msg.attach(MIMEText(body, 'plain'))

   server = smtplib.SMTP('smtp.gmail.com', 587)
   server.starttls()
   server.login(fromaddr, "xx")
   text = msg.as_string()
   server.sendmail(fromaddr, toaddr, text)
   server.quit()

   return;




server = 'localhost'
database = 'LDSD'
username = 'sa'
password = '.faj1tas'
driver= '{ODBC Driver 13 for SQL Server}'
cnxn = pyodbc.connect('DRIVER='+driver+';PORT=1433;SERVER='+server+';PORT=1443;DATABASE='+database+';UID='+username+';PWD='+ password)
cursor = cnxn.cursor()
cursor.execute("SELECT COUNT(tps_is_email_sent) FROM tps_user_message_recipient where tps_is_email_sent = 0")

msgcti = int(cursor.fetchone()[0])
msgcts = str(msgcti)




if msgcti > 7:
    msgfunc(msgcts)