#/u/GoldenSights
import praw # simple interface to the reddit API, also handles rate limiting of requests
import time
import sqlite3
import random

'''USER CONFIGURATION'''

USERNAME  = "Flip-The-Coin"
#This is the bot's Username. In order to send mail, he must have some amount of Karma.
PASSWORD  = "*********"
#This is the bot's Password.
USERAGENT = "/u/inanegs' First bot"
#This is a short description of what the bot does. For example "/u/GoldenSights' Newsletter bot"
SUBREDDIT = "inaneg"
#This is the sub or list of subs to scan for new posts. For a single sub, use "sub1". For multiple subreddits, use "sub1+sub2+sub3+..."
PARENTSTRING = ["!flip"]
#These are the words you are looking for
#REPLYSTRING = "Hi hungry, I'm dad"
#This is the word you want to put in reply
MAXPOSTS = 100
#This is how many posts you want to retrieve all at once. PRAW can download 100 at a time.
WAIT = 1
#This is how many seconds you will wait between cycles. The bot is completely inactive during this time.


'''All done!'''




WAITS = str(WAIT)
try:
    import bot #This is a file in my python library which contains my Bot's username and password. I can push code to Git without showing credentials
    USERNAME = bot.getu()
    PASSWORD = bot.getp()
    USERAGENT = bot.geta()
except ImportError:
    pass

sql = sqlite3.connect('sql.db')
print('Loaded SQL Database')
cur = sql.cursor()

cur.execute('CREATE TABLE IF NOT EXISTS oldposts(ID TEXT)')
print('Loaded Completed table')

sql.commit()

r = praw.Reddit(USERAGENT)
r.login(USERNAME, PASSWORD)

def scanSub():
    print('Searching '+ SUBREDDIT + '.')
    subreddit = r.get_subreddit(SUBREDDIT)

#Trying to make this to loop
    RAND = random.randint(0,1)
    if RAND == 0:
        REPLYSTRING = "I fliped a coin and it became heads"
    else:
        REPLYSTRING = "I fliped a coin and it became tails"





    posts = subreddit.get_comments(limit=MAXPOSTS)
    for post in posts:
        pid = post.id
        try:
            pauthor = post.author.name
            cur.execute('SELECT * FROM oldposts WHERE ID=?', [pid])
            if not cur.fetchone():
                cur.execute('INSERT INTO oldposts VALUES(?)', [pid])
                pbody = post.body.lower()
                if any(key.lower() in pbody for key in PARENTSTRING):
                    if pauthor.lower() != USERNAME.lower():

                        print('Replying to ' + pid + ' by ' + pauthor)
                        post.reply(REPLYSTRING)
                    else:
                        print('Will not reply to self')
        except AttributeError:
            pauthor = '[DELETED]'
    sql.commit()


while True:
    try:
        scanSub()
    except Exception as e:
        print('An error has occured:', e)
    print('Running again in ' + WAITS + ' seconds \n')
    sql.commit()
    time.sleep(WAIT)