Пример #1
0
import configServer as xCS
import dbFunction as fD
import pandas as pd
import time
import matplotlib.pyplot as plt

start_time = time.time()

fD.setConnection(typeConn='source',
                 modeConnOnOff='on',
                 connectionUse=xCS.connServ52_coreReport)
res = fD.querySelect(
    typeConn='source',
    querySource='select msc, pool from do_msc group by msc, pool')
dfDoMsc = pd.DataFrame()
for rx in res:
    datax = {'msc': rx[0], 'pool': rx[1]}
    dfDoMsc = dfDoMsc.append(datax, ignore_index=True)
fD.setConnection(typeConn='source', modeConnOnOff='off')

#------------------------
dfUseKpi = pd.DataFrame()

fD.setConnection(typeConn='source',
                 modeConnOnOff='on',
                 connectionUse=xCS.connServ52_neHuawei)
res = fD.querySelect(typeConn='source',
                     querySource=""" SELECT    
										XDATE 
										,POOL 
                                        ,NE
Пример #2
0
import configServer as xCS
import dbFunction as fD
import pandas as pd
import time
import matplotlib.pyplot as plt

start_time = time.time()

fD.setConnection(typeConn='source',
                 modeConnOnOff='on',
                 connectionUse=xCS.connServ52_coreReport)
res = fD.querySelect(
    typeConn='source',
    querySource='select msc, pool from do_msc group by msc, pool')
dfDoMsc = pd.DataFrame()
for rx in res:
    datax = {'msc': rx[0], 'pool': rx[1]}
    dfDoMsc = dfDoMsc.append(datax, ignore_index=True)
fD.setConnection(typeConn='source', modeConnOnOff='off')

#------------------------
dfUseKpi = pd.DataFrame()

# fD.setConnection(typeConn='source',modeConnOnOff='on',connectionUse= xCS.connServ52_neHuawei)
# res =  fD.querySelect(typeConn='source',querySource="select time, ne, attach,  total from V_Kpi_HW_HR_RT where total > 0 and time >='2020-02-16'" )
# for rx in res:
# 	datax = {'time': rx[0],'msc':rx[1], 'attach': rx[2], 'total': rx[3], 'system':'huawei'}
# 	dfUseKpi = dfUseKpi.append(datax, ignore_index=True)
# fD.setConnection(typeConn='source',modeConnOnOff='off')

fD.setConnection(typeConn='target',
Пример #3
0
import configServer as xCS
import dbFunction as fD
import csv

fD.setConnection(typeConn='source',
                 modeConnOnOff='on',
                 connectionUse=xCS.connServ103_neHuawei)

for i in range(0, 2):
    for j in range(4, 7):
        StrQuery = "select * from tbl_Result_8388830" + str(
            i
        ) + " where ( [Result time] >='2020-0" + str(
            j
        ) + "-01' and [Result time] <'2020-0" + str(
            j + 1
        ) + "-01' ) and ([object name] like '%818%' or [object name] like '%817%' or [object name] like '%838%')"
        # print(StrQuery)
        res = fD.querySelect(typeConn='source', querySource=StrQuery)
        with open('pm8388830' + str(i) + '_0' + str(j) + '.csv',
                  'w',
                  newline='') as f_handle:
            fileOut = csv.writer(f_handle)
            fileOut.writerow("POOL,NE,DATE,ATTACH,DETECH,TOTAL".split(","))
            for rx in res:
                fileOut.writerow(rx)

fD.setConnection(typeConn='source', modeConnOnOff='off')