#-*- coding:utf-8 -*-
"""
Purpose:Send Http Request to Web and get Response
Author:ChenMin
Version:1.0
Modify log:
(1) 20180805 Creat by ChenMin
"""
__version__ = '0.1'
from robot.api import logger
import os
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
class RunDW(object):
def db_init(self,excel_fn):
'''
Purpose:gen python file from excel file
Author:ChenMin
Version:1.0
Modify log:
(1) 20180805 Creat func by ChenMin
:param http_excel_fn: excel file name
:return: nil
'''
command_info = 'ruby ' + r'C:\RF\share\DataWareLibrary\tools\gen_py.rb ' + excel_fn.encode('GBK')
print command_info
os.system(command_info)
command_info = 'python ' + r'C:\RF\share\DataWareLibrary\python\init\init.py'
os.system(command_info)
return "db init"
def db_clear(self):
'''
Purpose:del tmp python files
Author:ChenMin
Version:1.0
Modify log:
(1) 20180805 Creat func by ChenMin
:return: nil
'''
command_info = 'del ' + r'C:\RF\share\DataWareLibrary\python\expect\* /q'
os.system(command_info)
command_info = 'del ' + r'C:\RF\share\DataWareLibrary\python\actual\* /q'
os.system(command_info)
command_info = 'del ' + r'C:\RF\share\DataWareLibrary\python\init\* /q'
os.system(command_info)
return "db_clear"
def db_clearall(self):
'''
Purpose:del all tmp files
Author:ChenMin
Version:1.0
Modify log:
(1) 20180805 Creat func by ChenMin
:return: nil
'''
command_info = 'del ' + r'C:\RF\share\DataWareLibrary\python\expect\* /q'
os.system(command_info)
command_info = 'del ' + r'C:\RF\share\DataWareLibrary\python\actual\* /q'
os.system(command_info)
command_info = 'del ' + r'C:\RF\share\DataWareLibrary\python\init\* /q'
os.system(command_info)
command_info = 'del ' + r'C:\RF\share\DataWareLibrary\result\expect\* /q'
os.system(command_info)
command_info = 'del ' + r'C:\RF\share\DataWareLibrary\result\actual\* /q'
os.system(command_info)
return "db_clearall"
def db_expect_call(self,python_fn):
'''
Purpose:exec python file
Author:ChenMin
Version:1.0
Modify log:
(1) 20180805 Creat func by ChenMin
:param python_fn: python filename
:return: nil
'''
command_info = 'python ' + r'C:\RF\share\DataWareLibrary\python\expect' + '\\' + python_fn + ".py"
os.system(command_info)
file_object = open('C:\\RF\\share\\DataWareLibrary\\result\\expect\\' + python_fn)
try:
result = file_object.read()
finally:
file_object.close()
print result
return result
def db_actual_call(self,python_fn):
'''
Purpose:exec python file
Author:ChenMin
Version:1.0
Modify log:
(1) 20180805 Creat func by ChenMin
:param python_fn: python filename
:return: nil
'''
command_info = 'python ' + r'C:\RF\share\DataWareLibrary\python\actual' + '\\' + python_fn + ".py"
os.system(command_info)
file_object = open('C:\\RF\\share\\DataWareLibrary\\result\\actual\\' + python_fn)
try:
result = file_object.read()
finally:
file_object.close()
print result
return result
if __name__ == "__main__":
run = RunDW()
run.db_init("C:\Users\HO174996\Desktop\dwtest\demo配置.xlsx")
res = run.db_expect_call('test001')
#print res
print "************"
res = run.db_actual_call('test001')
#print res
print "************"