from tracker.bangers import run_frunches, get_or_create_google_sheet, share_and_email
from tracker.logger import get_logger
import os

from pycommon.database import db as cdb

logger = get_logger(__name__)

logger.info("Starting gen_frunchspace")

cdb.setup_randh_session()

template_url = "https://docs.google.com/spreadsheets/d/1_zKqJPlsMmp-5n2uJgb0etpW63V1XwucgGw2SLPDloM"

logger.info(f"Creating copy of template sheet")

ss = get_or_create_google_sheet(
    template_url, title_prefix="Bangers", make_copy_of_existing_sheet=True
)

created_sheet_url = ss.url

logger.info("Sharing to the team")

share_and_email(ss)

frunch_list = [
    "sc25k",
    ## "instaFollowers",
    ## "tiktokGrowing",
    ## "spotifyFollowers",
    "kworb5DayGrowth",
    "kworbAppleMusicClimbers",
    "kworbAppleMusicNew",
    "kworbNewChart",
    "scSlope7",
    "ytSlope7",
    "spotifyMilosList",
    "chartMetricFollowers1",
    "chartMetricTikTok7gt28",
]

if os.environ.get("WL_FRUNCH_LIST"):
    frunch_list = [f.strip() for f in os.environ.get("WL_FRUNCH_LIST").split(",")]

logger.info(f"frunch_list: {frunch_list}")

run_frunches(
    frunch_list,
    include_previous=True,
    store_chart_in_db=True,
    share_sheet=False,  # shared already above
    existing_sheet_url=created_sheet_url,
    make_copy_of_existing_sheet=False,
)