import praw
import sys
from datetime import datetime

from config import *
from functions import get_connection, get_prompt, update_reddit_status

with open('/home/pknemyay/adnansiddiqi.me/promptbazar/redditapp/debug_log.txt', 'a') as file:
    file.write(f'Script ran at {datetime.now()}\n')

if __name__ == '__main__':
    CLIENT_ID = 'YW2PdBBlsZnW2haLagNOHg'
    CLIENT_SECRET = '-goLzhck_TAIBMTUS0V9Yp7Zx1jA-Q'
    connection = get_connection(host=HOST, db=DB, user=USER, password=PASSWORD)
    # Get the Prompt
    record = get_prompt(connection, status=1)
    if record is None:
        print('No Record was found')
        exit()
    record_id = record['id']
    title = record['title']
    tweet_id = record['tweet_id']
    tweet_url = 'https://twitter.com/promptbazar/status/{}'.format(tweet_id)
    print(tweet_url)
    with open('/home/pknemyay/adnansiddiqi.me/promptbazar/redditapp/debug_log.txt', 'a') as file:
        file.write(f'TWEET URL Script ran at {datetime.now()}\n')

    reddit = praw.Reddit(
        client_id=CLIENT_ID,
        client_secret=CLIENT_SECRET,
        password=".Redhat.11.0",
        user_agent="agent/promptbazar",
        username="pknerd",
    )
    # print(reddit.read_only)
    subreddit = reddit.subreddit("promptbazar")
    subreddit.submit(title=title, url=tweet_url)
    update_reddit_status(connection=connection, id=record_id)
    print("Post successfully submitted.")

    # # subreddit = reddit.subreddit("u_pknerd")
    # submission = subreddit.submit(title="Hola", selftext=body)
    # submission.mod.approve()