cdao = Company_dao()
hdao = History_dao()

data = {}

if filter_flag == "ALL":
    t = hdao.select_all(username)
    l = tdao.get_user_stock_list(username)
elif filter_flag == "ALGOS":
    t = hdao.select_all_algo_trades(username)
    l = tdao.get_all_algo_stock_list(username)
elif filter_flag == "USER":
    t = hdao.select_all_user_trades(username)
    l = tdao.get_only_user_stock_list(username)
else:
    t = hdao.select_algo_trades(username, filter_flag)
    l = tdao.get_algo_stock_list(username, filter_flag)

# HISTORY
if t:
    data['transactions'] = {}

    for i in range(len(t)):
        data['transactions'][i] = {}

        #start date formatting
        from_zone = tz.tzutc()
        to_zone = tz.tzlocal()
        date_time = t[i].get_trans_date()
        date_time = date_time.strftime('%Y-%m-%d %H:%M:%S')
        date_time = datetime.strptime(date_time, '%Y-%m-%d %H:%M:%S')
cdao = Company_dao()
hdao = History_dao()

data={}

if filter_flag == "ALL":
    t = hdao.select_all(username)
    l = tdao.get_user_stock_list(username)
elif filter_flag == "ALGOS":
    t = hdao.select_all_algo_trades(username)
    l = tdao.get_all_algo_stock_list(username)
elif filter_flag == "USER":
    t = hdao.select_all_user_trades(username)
    l = tdao.get_only_user_stock_list(username)
else:
    t = hdao.select_algo_trades(username, filter_flag)
    l = tdao.get_algo_stock_list(username, filter_flag)


# HISTORY
if t:
    data['transactions']={}
    
    for i in range(len(t)):
        data['transactions'][i]={}
	
	    #start date formatting
        from_zone = tz.tzutc()
        to_zone = tz.tzlocal()
        date_time = t[i].get_trans_date()
        date_time = date_time.strftime('%Y-%m-%d %H:%M:%S')