import time
import argparse

from databasesync import createDatabase
from sheetloader import downloadGamesCSV, downloadCharactersCSV

parser = argparse.ArgumentParser()
parser.add_argument("-r", "--replay_time", type=int)
args = parser.parse_args()

CHARACTER_DATA_OUT_FILE = "CharacterData.csv"
GAME_DATA_OUT_FILE = "GameData.csv"
DATABASE_NAME = "data/testdb.db"

def execute():
  downloadCharactersCSV(CHARACTER_DATA_OUT_FILE)
  downloadGamesCSV(GAME_DATA_OUT_FILE)
  createDatabase(DATABASE_NAME, GAME_DATA_OUT_FILE, CHARACTER_DATA_OUT_FILE)

if __name__ == "__main__":
  print("starting up loader.")
  print("replay time: ", args.replay_time)
  execute()
  while args.replay_time and args.replay_time > 0:
    print("re-run in ", args.replay_time, "seconds", flush=True)
    time.sleep(args.replay_time)
    execute()