#!/usr/bin/env python3

from mymodules import mylog
from mymodules import mysql_oper
from mymodules import wangguan
import time,math

data_time = time.strftime('%Y%m%d%H',time.localtime(time.time()-3600))

db_result = mysql_oper.operate('select * from wangguan where DATE="%s"'%(data_time),None)
if not db_result:
    data=wangguan.download_wangguan(data_time)
    GB=math.pow(2,30)
    wg_in = float('%.2f'%(int(data[0])/GB*5))
    wg_out = float('%.2f'%(int(data[1])/GB*5))
    zd_in = float('%.2f'%(int(data[2])/GB*100))
    zd_out = float('%.2f'%(int(data[3])/GB*100))
    result_data = (data_time,wg_in,wg_out,zd_in,zd_out)
    mysql_oper.operate("insert into wangguan (date,wg_in,wg_out,zd_in,zd_out) value (%s,%s,%s,%s,%s);",result_data)