import pandas as pd
from sqlalchemy import Column, Integer, String

class Order(Base):
  __tablename__ = 'orders'

  id = Column(Integer, primary_key=True)
  buy_price = Column(String)
  buy_currency = Column(String)
  sell_price = Column(String)
  sell_currency = Column(String)

def load_orders(filename):
  orders_df = pd.read_csv(filename)
  # add to database
  session = Session()
  for order in orders_df:
    order = Order(buy_price=order["buy_price"], buy_currency=order["buy_currency"], sell_price=order["sell_price"], sell_currency=order["sell_currency"])
    session.add(order)
  session.commit()