提取loid所对应的光猫厂商信息，并提取loid下所有非路由器的信息

#!/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":"机顶盒",