10

            return oErrorBase.base_failed,[];
        for symbol_id in cou.fetchall():
            int_parent_id = symbol_id;
            sql = "SELECT [phy_id] FROM [config_db].[imc_config].[tbl_symbol] WHERE  parent_symbol_id = %d"%(int_parent_id);
            try:
                cou.execute(sql);
            except Exception, e:
                log_manager.GetInstance().CoutLog('database error:' + str(e),Com_db_tools);
                log_manager.GetInstance().CoutLog('datebase error:ip = ' + self.__str_db_ip + ' user = ' + self.__str_db_user + ' pw= ' + self.__str_db_pw + 'datebase = config_db',Com_db_tools);
                log_manager.GetInstance().CoutLog('sql = ' + sql,Com_db_tools);
                return oErrorBase.base_failed,[];
            for phy_id in cou.fetchall():
                int_phy_id = phy_id;
                sql = "SELECT [dev_ip] FROM [config_db].[imc_config].[tbl_dev] WHERE dev_id = %d"%(int_phy_id);
                try:
                    cou.execute(sql);
                except Exception, e:
                    log_manager.GetInstance().CoutLog('database error:' + str(e),Com_db_tools);
                    log_manager.GetInstance().CoutLog('datebase error:ip = ' + self.__str_db_ip + ' user = ' + self.__str_db_user + ' pw= ' + self.__str_db_pw + 'datebase = config_db',Com_db_tools);
                    log_manager.GetInstance().CoutLog('sql = ' + sql,Com_db_tools);
                    return oErrorBase.base_failed,[];
                for dev_ip in cou.fetchall():
                    str_dev_ip = dev_ip[0];
                    t_list_devip.append(str_dev_ip);
                    break;
        log_manager.GetInstance().CoutLog('end to exec GetDevIPListByTopoName',Com_db_tools);
        return oErrorBase.base_succeed,t_list_devip;


    def GetDevIPIDDicByTopoName(self,p_str_topo_name):
        log_manager.GetInstance().CoutLog('begin to exec GetDevIPIDDicByTopoName',Com_db_tools);
        t_dic_devip_id = {};
        cou = None;
        sql = "SELECT [symbol_id] FROM [config_db].[imc_config].[tbl_symbol] WHERE symbol_name = '%s'"%(p_str_topo_name);
        try:
            cou = self.conn.cursor();
            cou.execute(sql.decode('GBK'));
        except Exception, e:
            log_manager.GetInstance().CoutLog('database error:' + str(e),Com_db_tools);
            log_manager.GetInstance().CoutLog('datebase error:ip = ' + self.__str_db_ip + ' user = ' + self.__str_db_user + ' pw= ' + self.__str_db_pw + 'datebase = config_db',Com_db_tools);
            log_manager.GetInstance().CoutLog('sql = ' + sql,Com_db_tools);
            return oErrorBase.base_failed,{};
        for symbol_id in cou.fetchall():
            int_parent_id = symbol_id[0];
            sql = "SELECT [phy_id] FROM [config_db].[imc_config].[tbl_symbol] WHERE  parent_symbol_id = %d"%(int_parent_id);
            try:
                cou.execute(sql);
            except Exception, e:
                log_manager.GetInstance().CoutLog('database error:' + str(e),Com_db_tools);
                log_manager.GetInstance().CoutLog('datebase error:ip = ' + self.__str_db_ip + ' user = ' + self.__str_db_user + ' pw= ' + self.__str_db_pw + 'datebase = config_db',Com_db_tools);
                log_manager.GetInstance().CoutLog('sql = ' + sql,Com_db_tools);
                return oErrorBase.base_failed,{};
            for phy_id in cou.fetchall():
                int_phy_id = common_tools.GetInstance().DecimalToInt(phy_id);
                sql = "SELECT [dev_ip] FROM [config_db].[imc_config].[tbl_dev] WHERE dev_id = %d"%(int_phy_id);
                try:
                    cou.execute(sql);
                except Exception, e:
                    log_manager.GetInstance().CoutLog('database error:' + str(e),Com_db_tools);
                    log_manager.GetInstance().CoutLog('datebase error:ip = ' + self.__str_db_ip + ' user = ' + self.__str_db_user + ' pw= ' + self.__str_db_pw + 'datebase = config_db',Com_db_tools);
                    log_manager.GetInstance().CoutLog('sql = ' + sql,Com_db_tools);
                    return oErrorBase.base_failed,{};
                for dev_ip in cou.fetchall():
                    str_dev_ip = dev_ip[0];
                    t_dic_devip_id[int_phy_id] = str_dev_ip;
                    break;
        log_manager.GetInstance().CoutLog('db_tools:end to exec GetDevIPIDDicByTopoName',Com_db_tools);
        return oErrorBase.base_succeed,t_dic_devip_id;


    def GetDevIP(self,obj_dev_sync_info):
        log_manager.GetInstance().CoutLog('db_tools:begin to exec GetDevIPByDevID',Com_db_tools);
        cou = None;
        sql = "SELECT [dev_ip] FROM [config_db].[imc_config].[tbl_dev] WHERE dev_id = %d"%(obj_dev_sync_info.int_dev_id);
        try:
            cou = self.conn.cursor();
            cou.execute(sql);
        except Exception, e:
            log_manager.GetInstance().CoutLog('database error:' + str(e),Com_db_tools);
            log_manager.GetInstance().CoutLog('datebase error:ip = ' + self.__str_db_ip + ' user = ' + self.__str_db_user + ' pw= ' + self.__str_db_pw + 'datebase = config_db',Com_db_tools);
            log_manager.GetInstance().CoutLog('sql = ' + sql,Com_db_tools);
            return oErrorBase.base_failed;
        for dev_ip in cou.fetchall():
            str_dev_ip = dev_ip[0];
            obj_dev_sync_info.str_dev_ip = str_dev_ip;
            log_manager.GetInstance().CoutLog('end to exec GetDevIPByDevID',Com_db_tools);
            return oErrorBase.base_succeed;
        log_manager.GetInstance().CoutLog('fail to exec GetDevIPByDevID',Com_db_tools);
        log_manager.GetInstance().CoutLog('select no data error:' + sql,Com_db_tools);
        log_manager.GetInstance().CoutLog('ip = ' + self.__str_db_ip + ' user = ' + self.__str_db_user + ' pw= ' + self.__str_db_pw + 'datebase = config_db',Com_db_tools);
        return oErrorBase.base_failed;


#*****************for public lib use**********************
    def GetDevIDByDevIP(self,p_str_dev_ip):
        print "************";
        print p_str_dev_ip;
        log_manager.GetInstance().CoutLog('begin to exec GetDevIDByDevIP',Com_db_tools);
        cou = None;
        sql = "SELECT [dev_id] FROM [config_db].[imc_config].[tbl_dev] WHERE dev_ip = '%s'"%(p_str_dev_ip);
        try:
            cou = self.conn.cursor();
            cou.execute(sql);
        except Exception, e:
            log_manager.GetInstance().CoutLog('database error:' + str(e),Com_db_tools);
            log_manager.GetInstance().CoutLog('datebase error:ip = ' + self.__str_db_ip + ' user = ' + self.__str_db_user + ' pw= ' + self.__str_db_pw + 'datebase = config_db',Com_db_tools);
            log_manager.GetInstance().CoutLog('sql = ' + sql,Com_db_tools);
            return oErrorBase.base_failed,-1;
        for dev_id in cou.fetchall():
            int_dev_id = dev_id[0];
            log_manager.GetInstance().CoutLog('begin to exec GetDevIDByDevIP',Com_db_tools);
            return oErrorBase.base_succeed,int_dev_id;
        log_manager.GetInstance().CoutLog('fail to exec GetDevIDByDevIP',Com_db_tools);
        log_manager.GetInstance().CoutLog('select no data error:' + sql,Com_db_tools);