import panel as pn
import pandas as pd
from datetime import datetime, timedelta
import plotly.express as px
import holoviews as hv
import numpy as np
from sidebar import SideNavBar
import random
import scipy.stats as stats
import hvplot.pandas  # noqa
from sqlalchemy import create_engine
import api
# from backgroundTask import stocks_stream
from functools import partial
import plotly.graph_objects as go
from panel.viewable import Viewer
import processing
import appComponents
import param
import db_operation as db
# import warnings
pn.extension('mathjax')
# warnings.filterwarnings("ignore", category=pd.core.common.SettingWithCopyWarning)
pn.extension('plotly')
pn.extension('tabulator')
db_url = 'sqlite:///instance/local.db'
engine = create_engine(db_url)



analytic_p = db.get_portfolio_analytic_df()
analytic_b = db.get_benchmark_analytic_df()
# load benchmark stock
# with engine.connect() as connection:
#     analytics_df = pd.read
#     calculated_b_stock = pd.read_sql('calculated_b_stock', con=connection)
#     calculated_p_stock = pd.read_sql('calculated_p_stock', con=connection)
#     p_eval_df = pd.read_sql('p_eval_result', con=connection)

stock_overview = appComponents.BestAndWorstStocks(
    analytic_df=analytic_p)
composation_card = appComponents.PortfolioComposationCard(
    analytic_p)
monthly_return_card = appComponents.HistReturnCard(
     calculated_p_stock=analytic_p, calculated_b_stock=analytic_b)
total_return_card = appComponents.TotalReturnCard(name='Range', 
                                                  b_stock_df=analytic_b,
                                                  p_stock_df=analytic_p,
                                                  value=(0, 20))
drawdown_card = appComponents.DrawDownCard(
   calculated_p_stock=analytic_p)

top_header = appComponents.TopHeader(
    eval_df = analytic_p,
)

template = pn.template.FastListTemplate(
    title="Portfolio一览",
    # sidebar=[freq, phase],
)
template.sidebar.append(SideNavBar())
# template.main.extend([drawdown_card, stock_overview, composation_card, monthly_return_card, total_return_card])
template.main.extend(
    [pn.Row(top_header),
     pn.Row(
        pn.Column(monthly_return_card, stock_overview,
                  width=500, margin=(10, 10, 10, 10)),
        pn.Column(total_return_card, drawdown_card, margin=(10, 10, 10, 10)),
        pn.Column(composation_card, margin=(10, 10, 10, 10)),
    )]
)
template.servable()