#!/usr/bin/python
import smtplib
import mimetypes
import email
import email.mime.application
import time
import glob
import os
import sys
import MySQLdb

path = '/opt/sensiplicity'




try:
	sys.argv[1]

except:
	print "You need to send in command line arguments"

else:
	smtp_server = sys.argv[1]
	smtp_port = sys.argv[2]
	smtp_login = sys.argv[3]
	smtp_pass = sys.argv[4]
	send_address = sys.argv[5]
	recv_address = sys.argv[6]

	db = MySQLdb.connect(data.servername,data.username,data.password,data.dbname)
	cursor = db.cursor()

        server_hostname = "Sensiplicity (SS-L1)"
        # SQL for name
        cursor.execute("SELECT value FROM sensors_system WHERE name = 'server_hostname'")
        #data = cursor.fetchall()
        #print "data = "+str(data[1])
        row = cursor.fetchone()
        if row:
               	server_hostname = row[0]


	# Create a text/plain message
	print "Testing email by sending for "+str(server_hostname)+":\n\tto "+str(recv_address)+"\n\tfrom "+str(send_address)+"\n\tusing "+str(smtp_server)+"\n\ton port "+str(smtp_port)+"\n\twith login "+str(smtp_login)+"\n"
	msg = email.mime.Multipart.MIMEMultipart()
	msg['Subject'] = ''+str(server_hostname)+' Logger Test!'
	msg['From'] = send_address
	msg['To'] = recv_address

	# The main body
	body_text = "Your Email Test from the "+str(server_hostname)+" Logger was successful."
	body = email.mime.Text.MIMEText(body_text)
	msg.attach(body)
 
	# send via mail server
	s = smtplib.SMTP(smtp_server + ':' + smtp_port)
	s.starttls()
	s.login(smtp_login,smtp_pass)
	s.sendmail(recv_address,[recv_address], msg.as_string())
	s.quit()