def run() -> None:
multiverse.init()
oracle.init()
fetch()
price.cache()
high MEDIUMINT UNSIGNED,
low MEDIUMINT UNSIGNED,
price MEDIUMINT UNSIGNED,
week FLOAT,
month FLOAT,
season FLOAT
)"""
execute(sql)
sql = """CREATE TABLE IF NOT EXISTS low_price (
`time` INTEGER,
name VARCHAR(150),
price MEDIUMINT UNSIGNED,
INDEX idx_name_time_price (name, `time`, price)
)"""
execute(sql)
def name_lookup(name):
if not CARDS:
rs = database.DATABASE.execute(oracle.base_query())
for row in rs:
CARDS[card.canonicalize(row['name'])] = row['name']
canonical = card.canonicalize(name)
if canonical not in CARDS:
print("Bogus name {name} ({canonical}) found.".format(name=name, canonical=canonical))
return name
return CARDS[canonical]
if __name__ == "__main__":
fetch()
price.cache()