def save_today_data():
date = time.strftime("%Y-%m-%d", time.localtime())
if Ag.query.filter_by(date=date).first() is None:
data = get_live_data_of_ag(no_cache=True)
ag = Ag(date=data['date'],
time=data['time'],
ag_future_price=data['ag_future_price'],
ag_future_averge_price=data['ag_future_averge_price'],
ag_future_previous_settlement_price=data['ag_future_previous_settlement_price'],
ag_fund_price=data['ag_fund_price'],
ag_fund_previous_net_value=data['ag_fund_previous_net_value'],
)
db.session.add(ag)
db.session.commit()
print('已保存到数据库')
def save_ag_tick_data():
"""
记录每tick的数据
"""
nowtime = time.localtime()
market_open_time = time.strptime('{}-{}-{} 1:30:00'.format(
nowtime.tm_year, nowtime.tm_mon, nowtime.tm_mday), '%Y-%m-%d %H:%M:%S')
middle_close_time = time.strptime('{}-{}-{} 3:30:00'.format(
nowtime.tm_year, nowtime.tm_mon, nowtime.tm_mday), '%Y-%m-%d %H:%M:%S')
middle_open_time = time.strptime('{}-{}-{} 5:00:00'.format(
nowtime.tm_year, nowtime.tm_mon, nowtime.tm_mday), '%Y-%m-%d %H:%M:%S')
market_close_time = time.strptime('{}-{}-{} 7:00:00'.format(
nowtime.tm_year, nowtime.tm_mon, nowtime.tm_mday), '%Y-%m-%d %H:%M:%S')
market_close_time = time.strptime('{}-{}-{} 7:00:00'.format(
nowtime.tm_year, nowtime.tm_mon, nowtime.tm_mday), '%Y-%m-%d %H:%M:%S')
if (nowtime > market_open_time and nowtime < middle_close_time) or (nowtime > middle_open_time and nowtime < market_close_time):
data = get_live_data_of_ag(no_cache=True)
# if data.time != get_tick_data_one().time:
mongo_ag_tick.insert_one(data)
def get(self):
res = get_live_data_of_ag()
return res