import json
import gspread as gs
from oauth2client.client import SignedJwtAssertionCredentials
from calendar import month_name
def upload_to_spread_sheet(p_name, spreadsheet, month, cells_time):  # cells_time= {cells_row: time}
    print("Syncing: \n" + str(cells_time) + "...")
    json_key = json.load(open('cred-ptc.json'))
    credentials = SignedJwtAssertionCredentials(json_key['client_email'],
                                                bytes(json_key['private_key'], 'utf-8'),
                                                json_key['scope'])
    print('Authenticating....')
    gc = gs.authorize(credentials)
    print('opening your sheet...')
    sheet = gc.open(spreadsheet)
    month_sheet = sheet.worksheet(month_name[month])
    rows_left = len(cells_time)
    for (row, value) in cells_time.items():
        print("Writing value in row number: " + row)
        print(str(rows_left) + " items left.")
        rows_left -= 1
        # update start
        month_sheet.update_acell('B' + row, '00:00:00')
        # update end
        month_sheet.update_acell('c' + row, value)
    print('finished writing')

            print("inside if")

from spread import upload_to_spread_sheet

    return str(total_time)

    return str(total_time)
def sync(p_name='supermarket', spreadsheet='WorkSheet', month=Time.date()):
    all_logs = FileManager.read('logs/{}'.format(p_name))
    month_days = set([log['date'] for log in all_logs if log.get('date', None) != None and
                      int(log.get('date').split('-')[1]) == 6])
    cells_time = {}
    for day_date in month_days:
        cell_row = str(int(day_date.split('-')[2]) + 1)  # we start from 2 not 1
        cells_time.update(
            {cell_row: get_time_for_certain_day(p_name, date=day_date)})
    month = int(month.split('-')[1])
    return upload_to_spread_sheet(p_name=p_name, spreadsheet=spreadsheet, month=month, cells_time=cells_time)

    elif commands[0] == "sync":
        return sync()