8

            sql = "SELECT [ifindex],[ifadminstatus],[ifoptstatus] FROM [config_db].[imc_config].[tbl_if_info] WHERE dev_id = %d"%(int_dev_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,None;
            for (ifindex,ifadminstatus,ifoptstatus) in cou.fetchall():
                if (p_int_if_index == ifindex):
                    t_ip_if_status_info.m_dict_if_status[ifindex] = self.CalculateIfStatus(ifadminstatus,ifoptstatus);
        conn.close();
        log_manager.GetInstance().CoutLog('end to exec QueryIfInfoByDevIP',Com_db_tools);
        return oErrorBase.base_succeed,t_ip_if_status_info;


    def QueryDevIDByDevIP(self,p_str_dev_ip):
        log_manager.GetInstance().CoutLog('begin to exec QueryDevIDByDevIP',Com_db_tools);
        conn = None;
        cou = None;
        sql = "SELECT [dev_id] FROM [config_db].[imc_config].[tbl_dev] WHERE dev_ip = '%s'"%(p_str_dev_ip);
        try:
            conn = pymssql.connect(host=self.__str_db_ip, user=self.__str_db_user, password=self.__str_db_pw, database='config_db',charset='utf8');
            cou = 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];
            conn.close();
            log_manager.GetInstance().CoutLog('end to exec QueryDevIDByDevIP',Com_db_tools);
            return oErrorBase.base_succeed,int_dev_id;
        conn.close();
        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);
        log_manager.GetInstance().CoutLog('end to exec QueryDevIDByDevIP',Com_db_tools);
        return oErrorBase.base_failed,-1;


    def QueryInterfaceName(self,p_int_dev_id,p_int_if_index):
        log_manager.GetInstance().CoutLog('db_tools:begin to exec QueryInterfaceName',Com_db_tools);
        conn = None;
        cou = None;
        sql = "SELECT [ifdesc] FROM config_db].[imc_config].[tbl_if_info] WHERE dev_id = %d AND ifindex = %d"%(p_int_dev_id,p_int_if_index);
        try:
            conn = pymssql.connect(host=self.__str_db_ip, user=self.__str_db_user, password=self.__str_db_pw, database='config_db',charset='utf8');
            cou = 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 ifdesc in cou.fetchall():
            str_ifdesc = ifdesc[0];
            conn.close();
            log_manager.GetInstance().CoutLog('end to exec QueryInterfaceName',Com_db_tools);
            return oErrorBase.base_succeed,str_ifdesc;
        log_manager.GetInstance().CoutLog('fail to exec QueryInterfaceName',Com_db_tools);
        conn.close();
        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,'';


    def QueryIfIndex(self,p_int_dev_id,p_str_if_name):
        log_manager.GetInstance().CoutLog('begin to exec QueryIfIndex',Com_db_tools);
        conn = None;
        cou = None;
        sql = "SELECT [ifindex] FROM [config_db].[imc_config].[tbl_if_info] WHERE dev_id = %d AND ifdesc = '%s'"%(p_int_dev_id,p_str_if_name);
        try:
            conn = pymssql.connect(host=self.__str_db_ip, user=self.__str_db_user, password=self.__str_db_pw, database='config_db',charset='utf8');
            cou = 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 ifindex in cou.fetchall():
            int_ifindex = ifindex[0];
            conn.close();
            log_manager.GetInstance().CoutLog('end to exec QueryIfIndex',Com_db_tools);
            return oErrorBase.base_succeed,int_ifindex;
        conn.close();
        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);
        log_manager.GetInstance().CoutLog('fail to exec QueryIfIndex',Com_db_tools);
        return oErrorBase.base_failed,-1;


    def QueryIfSpeed(self,p_int_dev_id,p_str_if_name):
        log_manager.GetInstance().CoutLog('begin to exec QueryIfSpeed',Com_db_tools);
        conn = None;
        cou = None;
        sql = "SELECT [ifspeed] FROM [config_db].[imc_config].[tbl_if_info] WHERE dev_id = %d AND ifdesc = '%s'"%(p_int_dev_id,p_str_if_name);
        try:
            conn = pymssql.connect(host=self.__str_db_ip, user=self.__str_db_user, password=self.__str_db_pw, database='config_db',charset='utf8');
            cou = 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 ifspeed in cou.fetchall():
            int_ifspeed = ifspeed[0];
            conn.close();
            log_manager.GetInstance().CoutLog('end to exec QueryIfSpeed',Com_db_tools);
            return oErrorBase.base_succeed,int_ifspeed;
        conn.close();