python代码

zjgxwx

已于 2024-09-27 17:05:45 修改

阅读量42

点赞数 1

文章标签： python android 开发语言

于 2024-09-27 17:04:08 首次发布

本文链接：https://blog.csdn.net/zjgxwx/article/details/142598079

版权

    def get_onu_info(self, thread_id):
        sql = f"""select OLTID, MgmtIP, OLTModel from DMS_OLT 
            where State = 3 and OLTModel in (2, 4) and OLTCode not like '%-GA-%' and OLTID % 10 = {thread_id}"""
        db_link = Mysql("DMS")
        rs = db_link.query_all(sql)
        add_sql = """insert into DMS_ConfiguredONU (OLTID, OltPort, OnuID, OnuType, isLoid, OnuSn) 
            values (%s, %s, %s, %s, %s, %s)"""
        for row in rs:
            cfg_file_name = row[1] + ".dat"
            cfg_file_path = os.path.join(self.local_dir, cfg_file_name)
            if os.path.exists(cfg_file_path):
                with open(cfg_file_path, errors="ignore") as file:
                    lines = file.readlines()
                found_onus = self.handle_c300(row[0], lines) if row[2] == 2 else self.handle_c600(row[0], lines)
                if found_onus:
                    db_link.execute_many_cud(add_sql, found_onus)
            else:
                print(row[1] + " cfg file not found!")