def querydatabase(testbed, layer2mode, tag): """ # Column Type Collation Attributes Null Default Extra Action 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 PORT varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 4 MODE varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 5 TAG varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 6 PVC varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 7 ETHNo varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 8 VLAN varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 9 LineProfile varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 10 LineTemplate varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 11 BondGroupIndex varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 12 BondGroupMainPort varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 13 BondGrouplinkPort varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 14 DiscoverCode varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions (1L, (('at_sh1', 'HuaWei', 'NA', 'VDSL_B_8B', '101', 'NA', '300', '405', '112', '120', '5', '0/1/17', '0/1/18', '0000-0000-0001'),)) """ mytuple = [] mytuple = db_helper.queryTBDSLAM({'TBNAME': testbed, 'MODE': layer2mode, 'TAG': tag}) print mytuple num = str(mytuple[0]) if num == '1': print 'AT_INFO : Find 1 data!' elif num == '0': print 'AT_ERROR : Can\'t find data!' return False else: print 'AT_ERROR : Find ' + num + ' data!' return False return mytuple
def get_info_from_database(self): """ # Column Type Collation Attributes Null Default Extra Action 1 TBNAME varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 2 DSLAMTYPE varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 3 PORT varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 4 MODE varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 5 TAG varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 6 PVC varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 7 ETHNo varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 8 VLAN varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 9 LineProfile varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 10 LineTemplate varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 11 BondGroupIndex varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 12 BondGroupMainPort varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 13 BondGrouplinkPort varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions 14 DiscoverCode varchar(255) utf8_general_ci No None Change Change Drop Drop More Show more actions (1L, (('at_sh1', 'Adtran', 'NA', 'VDSL_B_8B', '101', 'NA', '300', '405', '112', '120', '5', '0/1/17', '0/1/18', '0000-0000-0001'),)) """ print '\n' + '#' * 50 + 'Enter function get_info_from_database' profile_name = ''; fsp = []; fs = ''; mfsp = ''; sfsp = ''; port = []; mport = ''; vlan = ''; bond_group = ''; pvc = ''; eth = ''; tag = ''; query_dict = {'TBNAME': self._testbed, 'DSLAMTYPE': self._dslam_type, 'MODE': self._layer2mode, 'TAG': self._tag} if self._linemode == 'ADSL': query_dict = {'TBNAME': self._testbed, 'DSLAMTYPE': self._dslam_type, 'MODE': self._layer2mode} mytuple = db_helper.queryTBDSLAM(query_dict) print mytuple num = str(mytuple[0]) if num == '1': print 'AT_INFO : Find 1 data!' elif num == '0': print 'AT_ERROR : Can\'t find data!' exit(1) else: print 'AT_ERROR : Find ' + num + ' data!' exit(1) profilename = mytuple[1][0][8] tag = mytuple[1][0][4] pvc = mytuple[1][0][5] eth = mytuple[1][0][6] vlan = mytuple[1][0][7] # profile_index = mytuple[1][0][8] # template_index = mytuple[1][0][9] bond_group = mytuple[1][0][10] # discovercode = mytuple[1][0][13] # template_name = profile_index + '_' + profilename # refsp = '[0-9]/[0-9]+/[0-9]+' #if self._bonding: mfsp = mytuple[1][0][11] 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 profilename, fsp, fs, mfsp, sfsp, port, mport, sport, vlan, bond_group, eth, tag