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
