#!/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'


def getVarFromFile(filename):
    import imp
    f = open(filename)
    global data
    data = imp.load_source('data', '', f)
    f.close()

getVarFromFile(path + '/etc/SS-L1.conf')

def getColorFromFile(filename):
    import imp
    f = open(filename)
    global color
    color = f.readlines()
    f.close()



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]
	sms_address = sys.argv[6]

        db = MySQLdb.connect(data.servername,data.username,data.password,data.dbname)
        cursor = db.cursor()
        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 sms by sending for "+str(server_hostname)+":\n\tto "+str(sms_address)+"\n\tfrom "+str(send_address)+"\n\tusing "+str(smtp_server)+"\n\ton port "+str(smtp_port)+"\n\twith login "+str(smtp_login)+"\n"

	# Create a text/plain message
	msg = email.mime.Multipart.MIMEMultipart()
	msg['Subject'] = ''+str(server_hostname)+' Test!'
	msg['From'] = send_address
	msg['To'] = sms_address

	# The main body
	body_text = "SMS Test from "+str(server_hostname)+" 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(sms_address,[sms_address], msg.as_string())
	s.quit()