1 В избранное 0 Ответвления 0

OSCHINA-MIRROR/percyc-sjsdata

В этом репозитории не указан файл с открытой лицензией (LICENSE). При использовании обратитесь к конкретному описанию проекта и его зависимостям в коде.
Клонировать/Скачать
get_wangyi.py 2.6 КБ
Копировать Редактировать Web IDE Исходные данные Просмотреть построчно История
percyc Отправлено 18.10.2019 05:22 22ba827
#!/usr/bin/env python3
from mymodules import wangyi
from mymodules import mylog
from mymodules import mysql_oper
import time
data_time = time.strftime('%Y%m%d%H',time.localtime(time.time()))
db_result = mysql_oper.operate('select * from nat_used where DATE="%s"'%(data_time),None)
if not db_result:
result_data = wangyi.download_wangyi()
if result_data:
result_data = [data_time,result_data[2],result_data[4]]
mysql_oper.operate("insert into nat_used (DATE,nat,device) value (%s,%s,%s)",result_data)
data_time = time.strftime('%Y%m%d%H',time.localtime(time.time()-4200))
year,month,day,hour = time.strftime('%Y,%m,%d,%H',time.localtime(time.time()-4200)).split(',')
db_result = mysql_oper.operate('select * from wangyiUser where DATE="%s"'%(data_time),None)
if not db_result:
# network user
data0 = mysql_oper.wangyi_operate('''select sum(used) as used,ryear,Rmonth,rday,rhour from (SELECT deviceip,max(used) as used,ryear,Rmonth,rday,rhour FROM poolr where ryear = %s and rmonth = %s and rday = %s and rhour = %s and (poolname not like '%%tr069%%' and poolname not like '%%ims%%') and (poolname like '%%pppoe%%' or poolname like '%%Private-Address-Pool%%' or poolname like '%%dhcp-private-pool%%' or poolname like '139.gd') group by deviceip,poolname,ryear,Rmonth,rday,rhour ) t group by ryear,Rmonth,rday,rhour;'''%(year,month,day,hour),None)
if data0:
data0 = data0[0][0]
# iptv user
data1 = mysql_oper.wangyi_operate('''select sum(used) as used,ryear,Rmonth,rday,rhour from (SELECT deviceip,max(used) as used,ryear,Rmonth,rday,rhour FROM poolr where ryear = %s and rmonth = %s and rday = %s and rhour = %s and poolname like 'otv-%%' group by deviceip,poolname,ryear,Rmonth,rday,rhour ) t group by ryear,Rmonth,rday,rhour;'''%(year,month,day,hour),None)
if data1:
data1 = data1[0][0]
# max user of single bng
data2 = mysql_oper.wangyi_operate('''select max(used) as used,ryear,Rmonth,rday,rhour from (SELECT deviceip, used,ryear,Rmonth,rday,rhour FROM poolr where ryear = %s and rmonth = %s and rday = %s and rhour = %s and (poolname not like '%%tr069%%' and poolname not like '%%ims%%') and (poolname like '%%pppoe%%' or poolname like '%%Private-Address-Pool%%' or poolname like '%%dhcp-private-pool%%' or poolname like '139.gd')) t;'''%(year,month,day,hour),None)
if data2:
data2 = data2[0][0]
if data0 and data1 and data2:
result_data = [data_time,data0,data1,data2]
mysql_oper.operate("insert into wangyiUser (DATE,net_user,tv_user,bng_user_max) value (%s,%s,%s,%s)",result_data)

Опубликовать ( 0 )

Вы можете оставить комментарий после Вход в систему

1
https://api.gitlife.ru/oschina-mirror/percyc-sjsdata.git
git@api.gitlife.ru:oschina-mirror/percyc-sjsdata.git
oschina-mirror
percyc-sjsdata
percyc-sjsdata
master