def get(self,id):
jie=Shebei.get_by_id(id)
if jie and jie.she_sta==1:
jie.she_sta=0
db_session.commit()
self.redirect('/shebei')
self.render('shebei.html')
def get(self,id):
dongjie=Shebei.get_by_id(id)
if dongjie and dongjie.she_sta==0:
dongjie.she_sta=1
db_session.commit()
self.redirect('/shebei')
self.render('shebei.html')
def get(self,id):
banben=BanbenWrite.get_by_id(id)
if banben and banben.status==1:
banben.status=0
db_session.commit()
self.redirect('/banben')
self.redirect('/banben')
def post(self, id):
testcase = TestCase.get_by_id(id)
porject = self.get_argument('porject')
testcasename = self.get_argument('casename')
testcaseqianzhi = self.get_argument('qianzhitiaojian')
testcasebuzhou = self.get_argument('buzhou')
testcaseyuqi = self.get_argument('yuqi')
logurl = self.get_current_user()
if not (porject and testcasename and testcasebuzhou and testcaseyuqi):
self.render('editcase.html',
porjects=self.project,
case=testcase,
error_message='请准确填写用例信息')
testcase.porject_id = int(porject)
testcase.casename = testcasename
testcase.case_qianzhi = testcaseqianzhi
testcase.case_buzhou = testcasebuzhou
testcase.case_yuqi = testcaseyuqi
testcase.user_id = logurl.id
try:
db_session.commit()
self.redirect('/testcase')
except Exception as e:
raise e
self.render('editcase.html',
porjects=self.porjects,
case=testcase,
error_message='编辑用例信息失败')
def get(self, id):
testcase = TestCase.get_by_id(id)
if testcase and testcase.status == 1:
testcase.status = 0
db_session.commit()
self.redirect('/testcase')
self.redirect('/testcase', error_message='恢复失败')
def post(self):
porject = self.get_argument('porject')
banbenhao = self.get_argument('banbenhao')
new = BanbenWrite.get_by_name(banbenhao)
if new:
self.render('addbanben.html',
error_message='版本号不能重复',
porjects=self.porjects)
shangxian = self.get_argument('shangxian')
test = self.get_argument('test')
login_user = self.get_current_user()
if not banbenhao:
self.render('addbanben.html',
error_message='版本号不能为空',
porjects=self.porjects)
new_ban = BanbenWrite(porject_id=int(porject),
banbenhao=banbenhao,
is_xian=shangxian,
is_test=test,
user_id=login_user.id)
db_session.add(new_ban)
try:
db_session.commit()
self.redirect('/banben')
except Exception as e:
db_session.rollback()
self.render('addbanben.html',
error_message='添加失败',
porjects=self.porjects)
def post(self):
file = self.request.files.get('file', None)
if not file:
self.render('daorutestcase.html', error_message='请选择上传文件')
upload_path = os.path.join(os.path.dirname(__file__), 'tease')
for meta in file:
filename = meta['filename']
file_path = os.path.join(upload_path, filename)
with open(file_path, 'wb') as up:
up.write(meta['body'])
porject_id_list, casename_list, case_qianzhi_list, case_buzhou_list, case_yuqi_list = datacel(
file_path)
if len(porject_id_list) < 0:
self.render('daorutestcase.html', error_message='上传失败')
try:
for i in range(len(porject_id_list)):
project = Project.get_by_name(porject_id_list[i]).first().id
new_case = TestCase(porject_id=project,
casename=casename_list[i],
case_qianzhi=case_qianzhi_list[i],
case_buzhou=case_buzhou_list[i],
case_yuqi=case_yuqi_list[i],
user_id=self.get_current_user().id)
db_session.add(new_case)
db_session.commit()
self.redirect('/testcase')
except Exception as e:
raise e
self.render('daorutestcase.html', error_message='上传失败')
def post(self):
porject = self.get_argument('porject')
testcasename = self.get_argument('casename')
testcaseqianzhi = self.get_argument('qianzhitiaojian')
testcasebuzhou = self.get_argument('buzhou')
testcaseyuqi = self.get_argument('yuqi')
logurl = self.get_current_user()
if not (porject and testcasename and testcasebuzhou and testcaseyuqi):
self.render('addtestcase.html',
porjects=self.project,
error_message='请确认用例必要信息填写是否完整')
new_testcas = TestCase(porject_id=int(porject),
casename=testcasename,
case_qianzhi=testcaseqianzhi,
case_buzhou=testcasebuzhou,
case_yuqi=testcaseyuqi,
user_id=logurl.id)
db_session.add(new_testcas)
try:
db_session.commit()
self.redirect('/testcase')
except Exception as e:
raise e
self.render('addtestcase.html',
porjects=self.porjects,
error_message='添加用例失败！')
def get(self, id):
filepan = FilePan.get_by_id(id)
if filepan and filepan.status == 1:
filepan.status = 0
db_session.commit()
self.redirect('/filepan')
self.redirect('/filepan')
def post(self):
user_list=db_session.query(User).all()
bianhao=self.get_argument('shebeibianhao')
fapiao=self.get_argument('fapiao')
shebeiname=self.get_argument('shebeiname')
new=Shebei.get_by_name(shebeiname)
if new:
self.render('addshebei.html',user_list=user_list,error_message='设备名不能重复')
xitong=self.get_argument('xitong')
shebeixinghao=self.get_argument('shebeixinghao')
quanxian=self.get_argument('quanxian')
goumaidate=self.get_argument('goumai')
jiage=self.get_argument('jiage')
shebeizhuangtai=self.get_argument('shebeizhuangtai')
tianjia=self.get_argument('tianjia')
goumaidate=datetime.datetime.strptime(goumaidate,"%Y-%m-%d")
if not (shebeiname and bianhao and shebeixinghao and fapiao):
self.render('addshebei.html',user_list=user_list,error_message='请准确填写信息')
try:
jiage=int(jiage)
except Exception as e:
self.render('addshebei.html',user_list=user_list,error_message='价格只能是数字')
new_shebei=Shebei(shebei_id=bianhao,shebei_name=shebeiname,shebei_xitong=xitong,shebei_xinghao=shebeixinghao,
shebei_jiage=jiage,shebei_fapiaobianhao=fapiao,shebei_quanxian=quanxian,gou_date=goumaidate,shebei_status=shebeizhuangtai,ruku_user=int(tianjia))
db_session.add(new_shebei)
try:
db_session.commit()
self.redirect('/shebei')
except Exception as e:
db_session.rollback()
self.render('addshebei.html',user_list=user_list,error_message='添加失败')
def post(self):
file = self.request.files.get('file', None)
fenlei = self.get_body_argument('fenlei')
if not file:
self.render('addfile.html', error_message='请选择上传测试文件')
upload_path = os.path.join(os.path.dirname(__file__), 'testfile')
for meta in file:
filename = meta['filename']
file_path = os.path.join(upload_path, filename)
with open(file_path, 'wb') as up:
up.write(meta['body'])
m = sendfile(filename, file_path)
if m == False:
self.render('addtestresult.html',
user_list=self.user_list,
porjects=self.porjects,
error_message='上传失败')
file_url = 'http://owd1oye3g.bkt.clouddn.com/%s' % filename
new_file = FilePan(file_name=filename,
down_url=file_url,
user_id=self.get_current_user().id,
file_fenlei=fenlei)
try:
db_session.add(new_file)
db_session.commit()
self.redirect('/filepan')
except Exception as e:
# raise e
self.render('daorutestcase.html', error_message='上传失败')
def post(self):
porject = self.get_argument('porject')
banbenhao = self.get_argument('banbenhao')
bug_send = self.get_argument('user')
bug_tile = self.get_argument('title')
miaoshu = self.get_argument('miaoshu')
dengji = self.get_argument('dengji')
if not (porject and banbenhao and bug_send and bug_tile and miaoshu
and dengji):
self.render('addbug.html',
banbenhaos=self.banbenhaos,
porjects=self.porjects,
users=self.users,
error_message='请准确填写bug信息')
new_bug = BugAdmin(porject_id=int(porject),
ban_id=banbenhao,
bugname=bug_tile,
bugdengji=dengji,
bug_miaoshu=miaoshu,
bug_send=bug_send,
user_id=self.get_current_user().id)
db_session.add(new_bug)
try:
db_session.commit()
self.redirect('/bug')
except Exception as e:
db_session.rollback()
self.render('addbug.html',
banbenhaos=self.banbenhaos,
porjects=self.porjects,
users=self.users,
error_message='添加失败')
def get(self, id):
file = FilePan.get_by_id(id)
doempath = os.path.join(os.path.expanduser("~"), 'Desktop')
local = os.path.join(doempath, file.down_url[-10:])
urllib.request.urlretrieve(file.down_url, local)
file.down_count += 1
db_session.commit()
self.redirect('/filepan')
def post(self,id):
user_list=db_session.query(User).all()
shebei=Shebei.get_by_id(id)
if not shebei:
self.redirect('/shebei',error_message='设备找不到')
bianhao=self.get_argument('shebeibianhao')
fapiao=self.get_argument('fapiao')
shebeiname=self.get_argument('shebeiname')
xitong=self.get_argument('xitong')
shebeixinghao=self.get_argument('shebeixinghao')
quanxian=self.get_argument('quanxian')
goumaidate=self.get_argument('goumai')
jiage=self.get_argument('jiage')
shebeizhuangtai=self.get_argument('shebeizhuangtai')
tianjia=self.get_argument('tianjia')
try:
goumaidate=datetime.datetime.strptime(goumaidate,"%Y-%m-%d")
except Exception as e:
self.render('edit.html',user_list=user_list,error_message='日期格式不对，请填写例如2017-1-19',shebei=shebei)
waijietime=self.get_argument('waijietime')
try:
waijietime=datetime.datetime.strptime(waijietime,"%Y-%m-%d")
except Exception as e:
self.render('edit.html',user_list=user_list,error_message='日期格式不对，请填写例如2017-1-19',shebei=shebei)
waijie_user=self.get_argument('waijie')
waijie_s=self.get_argument('waijie_s')
if not (shebeiname and bianhao and shebeixinghao and fapiao and quanxian):
self.render('edit.html',user_list=user_list,error_message='请准确填写信息',shebei=shebei)
try:
jiage=int(jiage)
except Exception as e:
self.render('edit.html',user_list=user_list,error_message='价格只能是数字',shebei=shebei)
shebei.shebei_id=bianhao
shebei.shebei_name=shebeiname
shebei.shebei_xitong=xitong
shebei.shebei_xinghao=shebeixinghao
shebei.shebei_jiage=jiage
shebei.shebei_fapiaobianhao=fapiao
shebei.shebei_quanxian=quanxian
shebei.shebei_jie=waijie_s
shebei.shebei_date=waijietime
shebei.shebei_user=waijie_user
shebei.gou_date=goumaidate
shebei.shebei_status=shebeizhuangtai
shebei.ruku_user=tianjia
try:
db_session.commit()
self.redirect('/shebei')
except Exception as e:
db_session.rollback()
self.render('edit.html',shebei=shebei,user_list=user_list,error_message='编辑失败')
def get(self,id):
user=User.get_by_id(id)
if not user:
self.redirect('/user')
login_user=self.get_current_user()
if login_user.leves!=1:
self.redirect('/user')
if login_user ==user:
self.redirect('/user')
user.status=1
try:
db_session.commit()
self.redirect('/user')
except:
db_session.rollback()
self.redirect('/user')
def post(self):
porject=self.get_argument('project')
new=Project.get_by_name(porject)
if new:
self.render('addporject.html',error_message='项目名不能重复！')
login_user=self.get_current_user()
if not porject:
self.render('addporject.html',error_message='项目名不能为空')
new_pro=Project(name=porject,user_id=login_user.id)
db_session.add(new_pro)
try:
db_session.commit()
self.redirect('/banben')
except Exception as e:
db_session.rollback()
self.render('addporject.html',error_message='添加项目失败')
def post(self,id):
banben=BanbenWrite.get_by_id(id)
porject=self.get_argument('porject')
banbenhao=self.get_argument('banbenhao')
shangxian=self.get_argument('shangxian')
test=self.get_argument('test')
if not banbenhao:
self.render('editbanben.html',banben=banben,porjects=self.porjects,error_message='请准确填写版本信息')
banben.banbenhao=banbenhao
banben.is_xian=shangxian
banben.is_test=test
banben.porject_id=int(porject)
try:
db_session.commit()
self.redirect('/banben')
except Exception as e:
#raise e
self.render('editbanben.html',banben=banben,porjects=self.porjects,error_message='编辑失败')
def post(self, id):
self.user = User.get_by_id(id)
password = self.get_body_argument('yuanmima')
xinmima = self.get_body_argument('newpass')
querenmima = self.get_body_argument('newpass_que')
if not (xinmima and querenmima):
self.render('person.html',
user=self.user,
error_message='请输入修改密码!')
if encrypt(password) != self.user.password:
self.render('person.html', user=self.user, error_message='原密码有误!')
if xinmima != querenmima:
self.render('person.html',
user=self.user,
error_message='新密码输入不一致!')
self.user.password = encrypt(xinmima)
db_session.commit()
self.redirect('/logout')
def get(self, id):
bug = BugAdmin.get_by_id(id)
if bug and bug.status == 1:
bug.status = 0
db_session.commit()
self.redirect('/bug')
