#! /usr/bin/env python
import sys

sys.path.insert(0, ".")

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

logger = get_logger(__name__)

logger.info("Starting gen_frunchspace")

from tracker import db

db.setup_session()

from pycommon.database import db as cdb

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="R+H", make_copy_of_existing_sheet=True
)

created_sheet_url = ss.url

logger.info("Sharing to the team")
# share_and_email(ss)

from tracker.bangers import randh, sc_charts, query_to_sheet
from pycommon.genius.sc_charts import genres

for genre in genres:
    print(genre)
    csv = sc_charts.get_chart(genre)
    query_to_sheet.csv_to_sheet(csv, spreadsheet=ss, sheet_name="Top 100 " + genre)

move_settings_tab_to_end(ss)