提取光猫_下挂设备_路由器性能

最新推荐文章于 2023-12-18 23:45:00 发布

sxf_0123

最新推荐文章于 2023-12-18 23:45:00 发布

阅读量1.4k

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/sxf_123456/article/details/80289703

版权

本文主要介绍了如何提取光猫信息，并根据loid详细提取下挂的设备，特别是针对路由器进行性能分析。

摘要由CSDN通过智能技术生成

1、提取光猫信息

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time    : 2018/5/11 0011 12:50
# @Author  : Sxf
# @QQ      : 
# @File    : distinct_loid.py
# @Software: PyCharm Community Edition

"""
在终端使用mysql -u root -p test  -e 'SELECT loid FROM ana_customer WHERE localnet_id='101000';' > loid.txt
将表中数据导出到本地
"""

import pymysql
# read_path = "C:\\Users\\Administrator\\Desktop\\loid.txt"
# write_path = "C:\\Users\\Administrator\\Desktop\\new_customer.txt"
read_path = "/home/data/mysql/test/data/loid.txt"
write_path = "/home/data/mysql/test/data/new_customer.txt"
read_file = open(read_path, "r")
write_file = open(write_path, "w")

connect = pymysql.connect(host="", port=3306, user="", passwd="", db="test", charset="utf8")

for line in read_file:
    line_ = line.strip()
    sql = """select loid,factory_name,model_name,wifi_count,port_count,hard_version from ana_customer where loid='%s'"""%(line_)
    with connect.cursor() as cursor:
        cursor.execute(sql)
        result = cursor.fetchone()
        # anid = result[0]
        try:
            loid = result[0]
            factory = str(result[1]).replace(',','')
            model = result[2]
            wifi_count = result[3]
            if wifi_count == 0:
                wifi = "否"
            else:
                wifi = "是"
            port = result[4]
            if port == 2:
                _port = "两口"
            elif port == 4:
                _port = "四口"