#coding:utf-8
import Site
import at
import utils
import hisq
import tags
#链接 历史库
dbSQL=tags.dataDBPort()
hisq=hisq.Hisq(dbSQL["hisq"]["host"],dbSQL["hisq"]["port"])
devices = Site.findDevices()
groups,_ = Site.getWtgGroups()
#总风场信息缓存
farmCache={"farmName":"DBZDT:DBZDT:DBZDT_TT","devices":devices}
#统计风场数据信息
def writeGroupRtdb():
global devCache
tm = utils.today()
monTm = utils.toMonth(tm)
monTm = utils.stringToTime(monTm)
yearTm = utils.toYear(tm)
yearTm = utils.stringToTime(yearTm)
#print utils.now()
for dev in devices:
hisq.writeArchive(dev["devName"],monTm,0,"CALC_ProductionMonth",1)
hisq.writeArchive(dev["devName"],yearTm,0,"CALC_ProductionYear",1)
for group in groups:
hisq.writeArchive(group["farmName"],monTm,0,"CALC_ProductionMonth",1)
hisq.writeArchive(group["farmName"],yearTm,0,"CALC_ProductionYear",1)
if farmCache["farmName"]:
hisq.writeArchive(farmCache["farmName"],monTm,0,"CALC_ProductionMonth",1)
hisq.writeArchive(farmCache["farmName"],yearTm,0,"CALC_ProductionYear",1)
writeGroupRtdb()
at.every().day.at("03:00").do(writeGroupRtdb)
at.start()
import Site
import at
import utils
import hisq
import tags
#链接 历史库
dbSQL=tags.dataDBPort()
hisq=hisq.Hisq(dbSQL["hisq"]["host"],dbSQL["hisq"]["port"])
devices = Site.findDevices()
groups,_ = Site.getWtgGroups()
#总风场信息缓存
farmCache={"farmName":"DBZDT:DBZDT:DBZDT_TT","devices":devices}
#统计风场数据信息
def writeGroupRtdb():
global devCache
tm = utils.today()
monTm = utils.toMonth(tm)
monTm = utils.stringToTime(monTm)
yearTm = utils.toYear(tm)
yearTm = utils.stringToTime(yearTm)
#print utils.now()
for dev in devices:
hisq.writeArchive(dev["devName"],monTm,0,"CALC_ProductionMonth",1)
hisq.writeArchive(dev["devName"],yearTm,0,"CALC_ProductionYear",1)
for group in groups:
hisq.writeArchive(group["farmName"],monTm,0,"CALC_ProductionMonth",1)
hisq.writeArchive(group["farmName"],yearTm,0,"CALC_ProductionYear",1)
if farmCache["farmName"]:
hisq.writeArchive(farmCache["farmName"],monTm,0,"CALC_ProductionMonth",1)
hisq.writeArchive(farmCache["farmName"],yearTm,0,"CALC_ProductionYear",1)
writeGroupRtdb()
at.every().day.at("03:00").do(writeGroupRtdb)
at.start()