def get(self, url, params=''): if self.port != '0': url = self.protocol + '://' + self.host + ':' + str( self.port) + url + params else: url = self.protocol + '://' + self.host + url + params logger.info('Request:%s' % url) logger.info('Header:%s' % self.headers) request = urllib2.Request(url, headers=self.headers) try: response = urllib2.urlopen(request) response_body = response.read() # response_info = response.info() # for key, value in response_info.items(): # if key == 'headers': # response_header = value response_header = '' response_status_code = response.getcode() response = [response_body, response_header, response_status_code] return response except Exception as e: logger.error('Send Request is failed,reasons:%s' % e) return None
def enableModule(config_file, sname): config_file = r'E:\AutoTestDemo\config\htmlconfig.ini' sname = 'STAGECONFIG' htmlObj = html.MyHttp(config_file, sname) url = '/clearapi.do?' # combine all parameters project = 'vlife' version = 'major' t = str(int(time.time()) * 1000) t1 = '1500878198000' component = ['interactive','adcenter'] username = '******' for comp in component: temp = '-'.join([project,comp,'paper',project,t]) md = stropt.get_md5(temp) paras = '&'.join(['component='+comp,'project='+project,'t='+t,'check='+ md, 'from='+username,'user='******'version='+version]) logger.debug('Read for enable module') res = htmlObj.get(url,paras) if json.loads(res[0]).get('result', '') == 'success': logger.info('Enable module is passed for ' + comp) else: logger.error('Enable module is not failed ' + comp)
def enableModule(sname): htmlObj = html.MyHttp(html_config, sname) url = '/clearapi.do?' # combine all parameters project = 'vlife' version = 'major' t = str(int(time.time()) * 1000) t1 = '1500878198000' # first two items for module download.'adcenter, cloud-upgrade for operation module upgrade' component = ['cm', 'adcenter', 'cloud-upgrade'] username = '******' for comp in component: temp = '-'.join([project,comp,'paper',project,t]) md = stropt.get_md5(temp) paras = '&'.join(['component='+comp,'project='+project,'t='+t,'check='+ md, 'from='+username,'user='******'version='+version]) logger.debug('Read for enable module') res = htmlObj.get(url,paras) if json.loads(res[0]).get('result', '') == 'success': logger.info('Enable module is passed for ' + comp) else: logger.error('Enable module is not failed ' + comp) # need wait for 5 minutes and enable validate on side logger.debug('Have to wait for 3 minutes server take effect') time.sleep(180)
def execute_delete(self, query, data=""): logger.info('query:%s data:%s' % (query, data)) try: db_cursor = self.dbconn.cursor() db_cursor.execute(query, data) db_cursor.execute('commit') db_cursor.close() return True except Exception as e: logger.error('Delete database is failed:%s' % e) db_cursor.execute('rollback') db_cursor.close() exit()
def execute_create(self, query): logger.info('query:%s' % query) try: db_cursor = self.dbconn.cursor() db_cursor.execute(query) db_cursor.execute('commit') db_cursor.close() return True except Exception as e: logger.error('Create database is failed:%s' % e) db_cursor.execute('rollback') db_cursor.close() exit()
def execute_update(self, query, data=""): #query = query % data logger.info('query:%s' % query) try: db_cursor = self.dbconn.cursor() db_cursor.execute(query) db_cursor.execute('commit') db_cursor.close() return ('', True) except Exception as e: logger.error('update database is failed:%s' % e) db_cursor.execute('rollback') db_cursor.close() return (e, False)
def select_one_record(self, query, data=""): logger.info('query:%s data:%s' % (query, data)) try: db_cursor = self.dbconn.cursor(dictionary=True) if data: db_cursor.execute(query, data) else: db_cursor.execute(query) query_result = db_cursor.fetchone() db_cursor.close() return (query_result, True) except Exception as e: logger.error('query database is failed:%s' % e) #db_cursor.close() return (e, False)
def post(self, url, data=''): url = self.protocol + '://' + self.host + ':' + str(self.port) + url logger.info('Request:%s' % url) logger.info('parameters:%s' % data) logger.info('Header:%s' % self.headers) request = urllib2.Request(url, headers=self.headers) try: response = urllib2.urlopen(request, data) response_body = response.read() response_header = response.getheaders() response_status_code = response.status response = [response_body, response_header, response_status_code] return response except Exception as e: logger.error('Send Request is failed, reasons:%s' % e) return None