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

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 = "四口"