#!/usr/bin/python

import sqlite3
import os
import time
import re
import base64
import sys

text=sys.argv[2]
numcell=sys.argv[1]

fileout="""Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64
To: """ + numcell + """ 
Cc:
Bcc:
Subject: """ + text + """
Date:
MIME-Version: 1.0

""" + base64.b64encode(text) + "\n"
newfileout = re.sub("\r?\n", "\r\n", fileout)

os.system("rm /home/root/Applications/qtmail/mail/sms.tmp")
f = open("/home/root/Applications/qtmail/mail/sms.tmp", "w")
f.write (newfileout)
f.close()

con = sqlite3.connect("/home/root/Applications/qtmail/qtopia_db.sqlite")
cur = con.cursor()

query="insert into mailmessages values(null,'4','5',null,'" + numcell + "','<3',null,'194',null,null,'sms.tmp',null,'0');"

cur.execute(query)
con.commit()
#cur.close()
time.sleep(1)
os.system("qtmail &")
time.sleep(15)
os.system("killall qtmail")
cur.close()