from __future__ import print_function

import os
import sqlite3
import urllib  # URL functions
from time import strftime

import urllib2  # URL functions

# Script Name	: python_sms.py
# Author	: Craig Richards
# Created	: 16th February 2017
# Last Modified	:
# Version	: 1.0
# Modifications	:
# Description	: This will text all the students Karate Club

dropbox = os.getenv("dropbox")
scripts = os.getenv("scripts")
dbfile = ("database/maindatabase.db")
master_db = os.path.join(dropbox, dbfile)

f = open(scripts + '/output/student.txt', 'a')

tdate = strftime("%d-%m")

conn = sqlite3.connect(master_db)
cursor = conn.cursor()
loc_stmt = 'SELECT name, number from table'
cursor.execute(loc_stmt)
while True:
    row = cursor.fetchone()
    if row == None:
        break
    sname = row[0]
    snumber = row[1]

    message = (
                sname + ' There will be NO training tonight on the ' + tdate + ' Sorry for the late notice, I have sent a mail as well, just trying to reach everyone, please do not reply to this message as this is automated')

    username = 'YOUR_USERNAME'
    sender = 'WHO_IS_SENDING_THE_MAIL'

    hash = 'YOUR HASH YOU GET FROM YOUR ACCOUNT'

    numbers = (snumber)

    # Set flag to 1 to simulate sending, this saves your credits while you are testing your code. # To send real message set this flag to 0
    test_flag = 0

    # -----------------------------------
    # No need to edit anything below this line
    # -----------------------------------

    values = {'test': test_flag,
              'uname': username,
              'hash': hash,
              'message': message,
              'from': sender,
              'selectednums': numbers}

    url = 'http://www.txtlocal.com/sendsmspost.php'

    postdata = urllib.urlencode(values)
    req = urllib2.Request(url, postdata)

    print('Attempting to send SMS to ' + sname + ' at ' + snumber + ' on ' + tdate)
    f.write('Attempting to send SMS to ' + sname + ' at ' + snumber + ' on ' + tdate + '\n')

    try:
        response = urllib2.urlopen(req)
        response_url = response.geturl()
        if response_url == url:
            print('SMS sent!')
    except urllib2.URLError as e:
        print('Send failed!')
        print(e.reason)