def save_trades(element_list, stock_code, insider_code): for element in element_list: trade = Trade() trade.stock = stock_code trade.insider = insider_code trade.relation = element[2] trade_last_date = datetime.date( datetime.strptime(element[3], '%m/%d/%Y')) trade.last_date = trade_last_date trade.transaction_type = element[4] trade.owner_type = element[5] shares_traded = element[6].replace(',', '') if shares_traded == '': shares_traded = 0 trade.shares_traded = shares_traded last_price = element[7] if last_price == '': last_price = 0.0 trade.last_price = last_price shares_held = element[8].replace(',', '') if shares_held == '': shares_held = 0 trade.shares_held = shares_held try: trade.save() logger.info( f'Trade object of {stock_code} on last date {element[2]} saved in db' ) except Exception as exception: logger.error(f'{stock_code} is allready exist: {exception}') db.rollback()