def get_actions(run_id):
conn = engine_runs.connect()
query = 'select actions, prices from runs where id=:run_id'
row = conn.execute(text(query), run_id=run_id).fetchone()
conn.close()
return jsonify(dict(row))
def get_actions(run_id):
conn = engine_runs.connect()
query = 'select actions, prices from runs where id=:run_id'
row = conn.execute(text(query), run_id=run_id).fetchone()
conn.close()
return jsonify(dict(row))
def get_runs():
rows = []
conn = engine_runs.connect()
# TODO prices/actions in separate route
for row in conn.execute('select id, hypers, advantage_avg, advantages, uniques from runs where advantage_avg > 0').fetchall():
row = dict(row.items())
row['advantage_avg'] = utils.calculate_score(row['advantages'])
rows.append(row)
conn.close()
print(len(rows), 'rows')
return jsonify(rows)
def get_runs():
rows = []
conn = engine_runs.connect()
# TODO prices/actions in separate route
for row in conn.execute(
'select id, hypers, advantage_avg, advantages, uniques from runs'
).fetchall():
row = dict(row.items())
row['advantage_avg'] = utils.calculate_score(row)
rows.append(row)
conn.close()
print(len(rows), 'rows')
return jsonify(rows)