agoStr = ago.strftime('%Y-%m-%d')
date_start = agoStr
date_end = tomorrowStr
print("update: %s - %s" % (date_start, date_end) )
sdb = Stocks();
for stock in StockCommon.getAllSymbols2():
#for stock in ['600008']:
#if(stock < '600008'): continue
#if(re.search('318$',stock)): continue
symbol,symbol_y = StockCommon.symbolFormat(stock)
print('-------------------------------------')
print(symbol_y)
#has = sdb.findStocksBySymbol(symbol)
#if(len(has)):
# print("existed:" + symbol_y)
# continue
s = sdb.findStockBySymbolAndDate(symbol,todayStr)
if s is not None:
print("existed: %s-%s" % (symbol, todayStr))
continue
all = ystockquote.get_historical_prices(symbol_y,date_start, date_end)
sdb.insertStocks(symbol,all)
sdb.close()
nowStrFull = datetime.now().strftime('%Y-%m-%d %H:%M:%S')
print("End:" + nowStrFull)
