# coding=utf-8

import dbConn
import time

list = dbConn.MY_SQL().calcYanZheng1Code()
print(list)
for i in list:
    dbConn.MY_SQL().saveYanZheng1Code(i[0])

# day = (time.strftime('%Y-%m-%d', time.localtime()))
# day = '2020-10-14'
#
# list = dbConn.MY_SQL().getYanZheng1Code()
# result = []
# for code in list:
#     print(code[1])
#     tlist = dbConn.MY_SQL().getLastZiJinGeGu(code[1], day)
#     print(tlist)
#     if  tlist is not None and tlist[4] != '-' and float(tlist[4])>10:
#         result.append(tlist)
#         dbConn.MY_SQL().updateYanZheng1Code(code[0])
#
# print(result)