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
