#! /usr/bin/env python
import sys

from datetime import datetime


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


# 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.

def main():

    # try:
    #     print("Starting import")
    #     from tracker.sheet import Sheet
    #     print("Instantiating Sheet")
    #     sheet = Sheet()
    #     print("Opening workbook")
    #     ss = sheet.client.open('INTEGRATION TESTING')  # Setup already
    #     ws = ss.add_worksheet('Testing 123', 10, 10)
    #     print("Worksheet added")
    #     ws.update_cell(1, 1, 10)
    #     c = ws.cell(1, 1)
    #     assert c.numeric_value == 10
    #
    #     ss.del_worksheet(ws)
    #     print("All must be OK!")
    # except Exception as e:
    #     print("Something went wrong.", e)
    #     raise e

    from tracker.bangers import query_to_sheet, get_or_create_google_sheet

    worksheet = get_or_create_google_sheet(existing_sheet_url='https://docs.google.com/spreadsheets/d/1STgTnhov7jt-IgxNItH1VzVRHhFMo2B1QUf2RZxZpgk')
    sample1 = [
        ['ColA', 'ColB', 'ColC'],
        [1, 'Two', 3],
        [10, 'Twenty', 30],
        [100, 'Two Hundy', 300],
    ]

    sample2 = [
        ['ColA', 'ColB'],
        [1, 'Two'],
        [10, 'Twenty'],
        [100, 'Two Hundy'],
        [1000, '2K'],
    ]

    query_to_sheet.csv_to_sheet(csv=sample2, spreadsheet=worksheet, sheet_name='Sheet1', overwrite_sheet_if_exists=True)

    query_to_sheet.csv_to_sheet(csv=sample2, spreadsheet=worksheet, sheet_name='Sheet1', overwrite_sheet_if_exists=True)


if __name__ == '__main__':
    main()