order.append(
1000) #These are hardcoded values for trader id and algorithm id.
order.append(
1000) #I may have more traders/algorithms but not for a while.
order.append(random.choice(tickers))
order.append(random.choice(order_type))
order.append(randrange(100, 400)) # Price targets will be off
order.append(random.choice(size))
order.append(random.choice(date_range))
order.append(random.choice(time_range))
data.append(order)
return data
if __name__ == "__main__":
crud = CRUD()
n = len(sys.argv)
if n >= 3:
file_name = sys.argv[1]
total = sys.argv[2]
else:
print("PASS IN ARGUMENTS!")
exit(0)
data = generateOrders(int(total))
df = pd.DataFrame.from_records(data, columns=columns) # CONVERT TO DF
#df.to_csv(file_name, index=False) # I'm leaving this in to show I can do it
crud.insertTrade(df) #I export straight to my db
