import praw
import datetime
import time
import sqlite3
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support.ui import Select


#create the database that will store information regarding which posts have already been parsed
data = sqlite3.connect('checked.db')
cur = data.cursor()
cur.execute('CREATE TABLE IF NOT EXISTS checked (id)')
data.commit()
reddit = ''

#create a class that will handle submissions on the subreddit
class redditSubmission(object):

    def __init__(self, submission):
        self.driver = webdriver.Chrome()
        self.submission = submission
        self.url = submission.url
        self.author = submission.author.name
        self.id = submission.id
        self.run()

    def check_database(self):
        cur.execute('SELECT * FROM checked WHERE id=?',[self.id])
        if not cur.fetchone():
            return True
        else:
            return False

    def submit_to_database(self):
        cur.execute('INSERT INTO checked VALUES(?)',[self.id])
        data.commit()

    def upload_url(self):
        self.driver.get('https://streamable.com/clipper')
        self.driver.find_element_by_xpath('//*[@id="root"]/div/div[2]/div[2]/div/div[1]/div/form/input').send_keys(self.url)
        time.sleep(.5)
        self.driver.find_element_by_xpath('//*[@id="root"]/div/div[2]/div[2]/div/div[1]/div/form/button').click()
        time.sleep(.5)
        self.driver.find_element_by_xpath('//*[@id="clip-controls-footer"]/button').click()
        time.sleep(.5)
        self.driver.find_element_by_xpath('//*[@id="video-url"]').click()
        switch = self.driver.switch_to_window(self.driver.window_handles[-1])
        time.sleep(.5)
        url = self.driver.current_url
        return url

    def response(self):
        if self.check_database() is True:
            print('Beginning process...')
            url = self.upload_url()
            disclaimer = '\n\n------------\n\n^(I am a bot created by /u/iNeverQuiteWas, and this was done automatically. If you have any questions or concerns, or would like a bot of your own, please contact him) '
            self.submission.reply('[Rehosted link in case original is lost]({})'.format(url)+disclaimer)
            self.submit_to_database()
            print('Reply was successful to /u/{}'.format(self.author))

    def run(self):
        print('Beginning moderation...')
        self.response()
        print('Finished moderation...')

def main():
    global reddit
    reddit = praw.Reddit(username='RehostBOT',password='rehost1234',client_id='ehgHk7Y_al2vNw',client_secret='hbaBYxsk3t_IlcHf2Pi5smh9XwY',user_agent='Rehosting moderator for /r/StreetFights')
    while True:
        for submission in reddit.subreddit('StreetFights').new(limit=100):
            redditSubmission(submission)
        time.sleep(100)

if __name__ == '__main__':
    main()