#! /usr/bin/env python
import sys

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

import datetime

from tracker.bangers import run_frunches, get_or_create_google_sheet, share_and_email
from tracker.bangers.notifications import send_sheet_emails_to_all_recipients
from tracker.sheet import cleanup_and_share_spreadsheet

from tracker.logger import get_logger

logger = get_logger("test_bangers")

# Google oauth stuff is complicated, and sometimes fails due to libs
# being out of date, this checks, using the docker image, that things are working.
from tracker import db

db.setup_session(echo=True)

from tracker import logger as L

L.setup_logging(for_console=True)

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("Created sheet " + created_sheet_url)

if __name__ == "__main__":

    frunch_list = [
        "scSlope7",
    ]
    print(f"Generating sheet(s) for {frunch_list}")
    print(f"db {db.Session.get_bind()}")

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

    cleanup_and_share_spreadsheet(ss, ["joel@whlst.in"], notify=True)