run.py

import datetime
import time
import gspread
import function
from __init__ import credentials, max_orders, threshold


def main_search(sheet, query):
    last_row = function.next_available_row(sheet)
    if last_row < 2:
        print("New item to search: {item_name}".format(item_name=query))
        header = sheet.range("A1:H1")
        header[0].value = "ID"
        header[1].value = "Name"
        header[2].value = "Price"
        header[3].value = "Link"
        header[4].value = "Orders"
        header[5].value = "Previous Orders"
        header[6].value = "Delta"
        header[7].value = "Interesting"
        sheet.update_cells(header)
        prev_items_orders = {}
    else:
        prev_items_list = sheet.range("A2:H{last_row}".format(last_row=last_row))
        prev_items_orders = function.range_to_items(prev_items_list)

    items = function.get_items(query)
    interesting = {}

    for id in items:
        prev_orders = prev_items_orders.get(id)
        if prev_orders is not None:
            items[id]["prev_orders"] = prev_orders
            items[id]["delta"] = items[id]["orders"] - items[id]["prev_orders"]

            if (
                items[id]["delta"] >= threshold
                and items[id]["prev_orders"] <= max_orders
            ):
                interesting[id] = items[id]
                items[id]["interesting"] = True
            else:
                items[id]["interesting"] = False
        else:
            items[id]["prev_orders"] = None
            items[id]["delta"] = None
            items[id]["interesting"] = None  # new item!

    if interesting:
        function.send_msg(interesting, item_name=query)
    else:
        print("Nothing of interest [or new item added], mail not sent.")

    file = gspread.authorize(credentials)
    sheet_file = file.open("Ali_Express")
    sheet = sheet_file.worksheet(query)
    product_num_difference = len(prev_items_orders) - len(items)

    function.put_items(sheet, items, product_num_difference)
    print("Done for sheet {name}".format(name=sheet.title))


sleep_time = 0
while True:
    for i in range(sleep_time):  # chunks of 10 minutes
        time.sleep(600)
        print("Waiting...")

    start = datetime.datetime.now()

    file = gspread.authorize(credentials)
    sheet_file = file.open("Ali_Express")
    sheet_names = [sheet.title for sheet in sheet_file.worksheets()]
    for query in sheet_names:
        sheet = sheet_file.worksheet(query)  # query is the sheet name
        print("Product: {query}".format(query=query))

        main_search(sheet, query)

        file = gspread.authorize(credentials)
        sheet_file = file.open("Ali_Express")

    end = datetime.datetime.now()
    seconds = (end - start).seconds
    hours_ran = seconds / 3600
    if hours_ran > 24:
        sleep_time = 0
    else:
        sleep_time = (24 - hours_ran) * 6