def getvlanid(self): """ """ print 'AT_INFO : get VLAN' if not self.layer2mode: print 'AT_ERROR : linemode is Null!' return False mytuple = SetDSLAM.querydatabase(self.testbed, self.layer2mode, self.tag) if not mytuple: return False self.vlan = mytuple[1][0][4] print 'vlan=' + self.vlan return True
def gettagid(self): """ """ print 'AT_INFO : get Tag' retag = '^([0-9]+|[Aa][Uu][Tt][Oo])$' rc = re.findall(retag, self.tag) if len(rc) > 0: return True, str(self.tag).upper() else: self.tag = 'TAG' if not self.layer2mode: print 'AT_ERROR : linemode is Null!' return False, 'NA' mytuple = SetDSLAM.querydatabase(self.testbed, self.layer2mode, self.tag) if not mytuple: return False, 'NA' rc = re.findall(retag, str(mytuple[1][0][3])) if len(rc) > 0: return True, str(mytuple[1][0][3]) else: return False, 'NA'
def get_info_from_database(self): """ 1 TBNAME varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 2 DslamName varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 3 MODE varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 4 TAG varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 5 VLAN varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 6 LineTemplate varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 7 BondGroupIndex varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 8 BondGroupMainPort varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 9 BondGrouplinkPort varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 10 DiscoverCode varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions """ print '\n' + '#' * 50 + 'Enter function get_info_from_database' profile_name = ''; port = []; mport = ''; sport = ''; vlan = ''; bond_group = ''; pvc = ''; eth = ''; tag = ''; mytuple = SetDSLAM.querydatabase(self._testbed, self._layer2mode, self._tag) if not mytuple: return False if self._tag: if self._tag == 'TAG': tag = mytuple[1][0][3] retag = '^[0-9]+$' rc = re.findall(retag, tag) if len(rc) > 0: pass else: print 'AT_ERROR : tag ' + tag + 'format error!' return False else: tag = self._tag else: tag = '' # profilename = mytuple[1][0][8] #pvc = mytuple[1][0][5] #eth = mytuple[1][0][6] vlan = mytuple[1][0][4] # profile_index = mytuple[1][0][8] # template_index = mytuple[1][0][9] bond_group = mytuple[1][0][6] # discovercode = mytuple[1][0][13] # template_name = profile_index + '_' + profilename # refsp = '[0-9]/[0-9]+/[0-9]+' #if self._bonding: mport = mytuple[1][0][7] sport = mytuple[1][0][8] # rc = re.findall(refsp, mfsp) # if not rc: # print 'AT_ERROR : frameid/slotid/portid ' + mfsp + ' format Error!' # exit(1) # sfsp = mytuple[1][0][12] # rc = re.findall(refsp, sfsp) # if not rc: # print 'AT_ERROR : frameid/slotid/portid ' + sfsp + ' format Error!' # exit(1) # fsp = [mfsp, sfsp] # mport = mfsp.split('/')[2] # sport = sfsp.split('/')[2] port = [mport, sport] # else: # mfsp = mytuple[1][0][2] # rc = re.findall(refsp, mfsp) # if not rc: # print 'AT_ERROR : frameid/slotid/portid ' + mfsp + ' format Error!' # exit(1) # fsp = [mfsp] # mport = mfsp.split('/')[2] # port = [mport] # fs = mfsp.split('/')[0] + '/' + mfsp.split('/')[1] return port, mport, sport, vlan, bond_group, tag