python 提取光猫下挂设备路由器信息

最新推荐文章于 2023-06-28 01:50:10 发布

sxf_0123

最新推荐文章于 2023-06-28 01:50:10 发布

阅读量1.5k

点赞数 1

分类专栏：数据提取文章标签： python提取数据

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

版权

该Python脚本从光猫数据中提取设备信息，包括LOID、光猫型号、设备类型、MAC地址等，并将结果写入文件。通过查询数据库获取详细设备属性如类型、厂商、型号和端口配置。

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

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time    : 2018/5/11 0011 20:33
# @Author  : Sxf
# @QQ      :
# @File    : get_dev.py
# @Software: PyCharm Community Edition
import pymysql
import  re

read_path = "F:\\data_mac\\data\\mysql\\test.txt"
write_path = "F:\\data_mac\\data\\mysql\\data_2.txt"
# read_path = "/home/data/mysql/test/data/new_customer.txt"
# write_path = "/home/data/mysql/test/data/data.txt"
read_file = open(read_path, "r", encoding='utf-8')
write_file = open(write_path, "w")

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

type_dict = {
    "-1":"未知",
    "0":"光猫",
    "1":"机顶盒",
    "2":"路由器",
    "3":"手机",
    "4":"平板",
    "5":"电脑",
    "6"<