dash_app.py

from dash import Dash
from helpers.execute_query_postgresql import execute_query_postgresql
from helpers.layout_dash import get_layout
import os
import json

PATH_TO_SECRET = f"{os.path.dirname(os.path.abspath(__file__))}/secret.json"

with open(PATH_TO_SECRET, "r") as f:
    secret = json.load(f)
    table_name = secret["postgresql"]["tablename"]

aggregated_sentiment_stats = f"""
    SELECT sentiment, COUNT(*) as count
    FROM {table_name}
    WHERE company_request_id = 'ZDFSDF'
    GROUP BY sentiment
"""

aggregated_sentiment_stats = dict(execute_query_postgresql(PATH_TO_SECRET, aggregated_sentiment_stats))

sentiment_trend = f"""
    SELECT date_extracted, sentiment, COUNT(*) as count
    FROM {table_name}
    WHERE company_request_id = 'ZDFSDF'
    GROUP BY date_extracted, sentiment
    ORDER BY date_extracted
"""

sentiment_trend = execute_query_postgresql(PATH_TO_SECRET, sentiment_trend)

sentiment_trend = [
    {
        "sentiment": "positive",
        "date": [line[0] for line in sentiment_trend if line[1] == "positive"],
        "count": [line[2] for line in sentiment_trend if line[1] == "positive"]
    },
    {
        "sentiment": "negative",
        "date": [line[0] for line in sentiment_trend if line[1] == "negative"],
        "count": [line[2] for line in sentiment_trend if line[1] == "negative"]
    },
    {
        "sentiment": "neutral",
        "date": [line[0] for line in sentiment_trend if line[1] == "neutral"],
        "count": [line[2] for line in sentiment_trend if line[1] == "neutral"]
    }
]

reviews = f"""
    SELECT text, sentiment
    FROM {table_name}
    WHERE company_request_id = 'ZDFSDF'
    LIMIT 100
"""

reviews = execute_query_postgresql(PATH_TO_SECRET, reviews)

reviews = [
    {
        "text": review[0],
        "sentiment": review[1]
    }
    for review in reviews
]

app = Dash(__name__)

app.layout = get_layout(sentiment_trend, aggregated_sentiment_stats, reviews)

if __name__ == "__main__":
    app.run_server(debug=True)