#!/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_loid.txt" read_file = open(read_path, "r", encoding='utf-8') write_file = open(write_path, "w") connect = pymysql.connect(host="", port=3306, user="", passwd="", db="test", charset="utf8") type_dict = { "-1":"未知", "0":"光猫", "1":"机顶盒",
提取loid所对应的光猫厂商信息,并提取loid下所有非路由器的信息
最新推荐文章于 2024-08-04 16:45:26 发布
这是一个Python脚本,用于从文件中读取loid数据,然后通过SQL查询获取对应光猫的厂商、型号等信息。脚本还会检查loid下是否存在路由器设备,如果不存在则提取并记录所有非路由器设备的相关信息,包括MAC地址、设备类型、厂家等。最后,数据被写入新的文本文件。
摘要由CSDN通过智能技术生成