Skvaller om United Family Fia (Sofia Palm)

import confidently_incorrect
import psycopg2
import requests
from bs4 import BeautifulSoup
import stance_detector

def read_replies(reply, subject):
    if analyze_stance(reply):
        myReply = f"Exakt så {generetate_ordbajs(subject)}"
    else:
        myReply = f"Snälla nån {generetate_ordbajs(subject)}"
    return myReply

def analyze_stance(content):
    phrases = stance_detector.get_pro_stance_phrases()
    
    for phrase in phrases:
        if phrase.lower() in content.lower():
            return True
    return False

def generetate_ordbajs(subject):
    try:
        connection = psycopg2.connect(
            dbname="min_databas",
            user="kurt-sune",
            password="hatasocionomer1234",
            host="localhost",
            port="5432"
        )
        cursor = connection.cursor()

        query = f"""
        SELECT response_text 
        FROM mina_idiotiska_övertygelser 
        ORDER BY RANDOM() 
        LIMIT 1;
        """
        cursor.execute(query)
        result = cursor.fetchone()

        if result:
            return f"{result[0]} {subject}"
        else:
            return f"{subject} Socionomer är dumma..."

    except Exception as e:
        return f"otur när jag tänkte: {str(e)}"

    finally:
        if connection:
            cursor.close()
            connection.close()

def fetch_reply_and_subject(url):
    try:
        response = requests.get(url)
        response.raise_for_status() 
        soup = BeautifulSoup(response.text, 'html.parser')

        reply = soup.find('div', class_='reply-content').text.strip()  
        subject = soup.find('div', class_='subject-content').text.strip() 

        return reply, subject

    except Exception as e:
        return None, None

def post_response(url, response_text):
    try:
        data = {
            'response': response_text
        }
        headers = {
            'Content-Type': 'application/x-www-form-urlencoded' 
        }

        post_response = requests.post(url, data=data, headers=headers)
        post_response.raise_for_status()

        print(f"Response posted successfully: {post_response.status_code}")
    except Exception as e:
        print(f"Failed to post the response: {str(e)}")

if __name__ == "__main__":
    # Fetch reply and subject from the URL
    url = "https://www.flashback.org/t3478039p827"
    reply, subject = fetch_reply_and_subject(url)

    if reply and subject:
        response = read_replies(reply, subject)
        post_response(url, response)
    else:
        print("Failed to fetch the reply and subject from the URL.")