def test_023_login(self): """ Time :2019-04-03 author : 罗林 desc : 运营人员登录 """ ManageSql.activate_manage_user(linkman) rs1 = m.test_login(email, '12345678') ass.verity(json.loads(rs1)['message'], '请求成功') ass.verity(json.loads(rs1)['data']['email'], email)
def test_010_cuser_lock(self): """ Time :2019-04-02 author : 罗林 desc :锁定管理员 """ ManageSql.activate_user(email) user_id = ManageSql.get_user_id(email) rs6 = m.test_cuser_lock(user_id) ass.verity(json.loads(rs6)['message'], '请求成功')
def test_009_cuser_update(self): """ Time :2019-04-02 author : 罗林 desc :编辑管理员 """ user_id = ManageSql.get_user_id(email) com_id = ManageSql.get_company_id(comp_name) rs5 = m.test_cuser_update(id=user_id, companyid=com_id, username=linkman, userphone=linkphone, useremail=email) ass.verity(json.loads(rs5)['message'], '请求成功')
def test_006_company_update(self): """ Time :2019-04-02 author : 罗林 desc :编辑企业 """ com_id = ManageSql.get_company_id(comp_name) licence_id = ManageSql.get_licence_file_id(comp_name) rs5 = m.test_company_update(id=com_id, name=comp_name, description='apitest-company', linkman=linkman, linkphone=linkphone, licencecode=licence_id, licencefileid=38) ass.verity(json.loads(rs5)['message'], '请求成功')
def activate_user(user_id): # 激活用户 fk_user = {"password": "******", "status": 11, "uuid": "0539a37d2e3048b69ef6ec3a00147b19", "is_active": "Y"} MysqlClent.update_dict(DB_CONN, 'fk_user', fk_user, 'id={}'.format(user_id)) manage_user = {"user_status": 11, "available": 1} MysqlClent.update_dict(ManageSql.DB_CONN, 'biz_company_user', manage_user, 'user_id={0} AND company_id={1}'.format(user_id, ManageSql.get_company_id()))
def test_011_cuser_unlock(self): """ Time :2019-04-02 author : 罗林 desc :解锁管理员 """ user_id = ManageSql.get_user_id(email) rs7 = m.test_cuser_unlock(user_id) ass.verity(json.loads(rs7)['message'], '请求成功')
def test_004_company_lock(self): """ Time :2019-04-02 author : 罗林 desc :停用企业 """ com_id = ManageSql.get_company_id(comp_name) rs3 = ManageAction.test_company_lock(com_id) Assertion.verity(json.loads(rs3)['message'], '请求成功')
def test_019_manage_lock(self): """ Time :2019-04-03 author : 罗林 desc : 锁定运营人员 """ manage_user_id = ManageSql.get_manage_user_id(linkman) rs6 = ManageAction.test_manage_lock(manage_user_id) Assertion.verity(json.loads(rs6)['message'], '请求成功')
def test_012_cuser_detail(self): """ Time :2019-04-02 author : 罗林 desc :获取管理员详情 """ user_id = ManageSql.get_user_id(email) rs8 = m.test_cuser_detail(user_id) ass.verity(json.loads(rs8)['message'], '请求成功')
def test_005_company_unlock(self): """ Time :2019-04-02 author : 罗林 desc :启用企业 """ com_id = ManageSql.get_company_id(comp_name) rs4 = m.test_company_unlock(com_id) ass.verity(json.loads(rs4)['message'], '请求成功')
def test_015_manage_sendActiveEmail(self): """ Time :2019-04-03 author : 罗林 desc :给运营人员发送激活邮件 """ manage_user_id = ManageSql.get_manage_user_id(linkman) rs2 = m.test_manage_sendActiveEmail(manage_user_id) ass.verity(json.loads((rs2))['message'], '请求成功')
def test_025_updatePassword(self): """ Time :2019-04-03 author : 罗林 desc : 运营人员修改密码 """ manage_user_id = ManageSql.get_manage_user_id(linkman) rs2 = m.test_updatePassword(manage_user_id, '12345678') ass.verity(json.loads(rs2)['message'], '请求成功')
def test_021_manage_detail(self): """ Time :2019-04-03 author : 罗林 desc : 获取运营人员详情 """ manage_user_id = ManageSql.get_manage_user_id(linkman) rs8 = m.test_manage_detail(manage_user_id) ass.verity(json.loads(rs8)['message'], '请求成功')
def test_024_manage_delete(self): """ Time :2019-04-03 author : 罗林 desc : 删除运营人员 """ manage_user_id = ManageSql.get_manage_user_id(linkman) rs9 = m.test_manage_delete(manage_user_id) ass.verity(json.loads(rs9)['message'], '请求成功')
def test_020_manage_unlock(self): """ Time :2019-04-03 author : 罗林 desc : 解锁运营人员 """ manage_user_id = ManageSql.get_manage_user_id(linkman) rs7 = m.test_manage_unlock(manage_user_id) ass.verity(json.loads(rs7)['message'], '请求成功')
def test_003_company_detail(self): """ Time :2019-04-02 author : 罗林 desc :获取企业详情 """ com_id = ManageSql.get_company_id(comp_name) rs2 = m.test_company_detail(com_id) ass.verity(json.loads(rs2)['message'], '请求成功') ass.verity(json.loads(rs2)['data']['companyName'], comp_name)
def test_022_manage_detail(self): """ Time :2019-04-03 author : 罗林 desc : 获取运营人员详情 """ manage_user_id = ManageSql.get_manage_user_id(linkman) rs8 = ManageAction.test_manage_detail(manage_user_id) Assertion.verity(json.loads(rs8)['message'], '请求成功') Assertion.verity(json.loads(rs8)['data']['email'], email)
def del_user(): # 删除角色 user_ids = MysqlClent.select_col(DB_CONN, 'fk_user', 'id', 'POSITION("{}" IN name)'.format(loginAction.sign)) MysqlClent.delete(DB_CONN, 'fk_user', 'POSITION("{}" IN name)'.format(loginAction.sign)) for user_id in user_ids: MysqlClent.delete(DB_CONN, 'fk_user_jurisdiction', 'user_id={}'.format(user_id)) condition = 'user_id={0} AND company_id={1}'.format(user_id, ManageSql.get_company_id()) company_user_id = MysqlClent.select_col(ManageSql.DB_CONN, 'biz_company_user', 'id', condition) MysqlClent.delete(ManageSql.DB_CONN, 'biz_company_user', condition) MysqlClent.delete(ManageSql.DB_CONN, 'biz_company_user_device', 'company_user_id IN ({})'.format(tuple(company_user_id)))
def test_013_cuser_delete(self): """ Time :2019-04-02 author : 罗林 desc :删除管理员 """ user_id = ManageSql.get_user_id(email) rs9 = m.test_cuser_delete(id=user_id, state='', pagesize=10, currentpage=1) ass.verity(json.loads(rs9)['message'], '请求成功')
def test_018_manage_update(self): """ Time :2019-04-03 author : 罗林 desc : 编辑运营人员 """ manage_user_id = ManageSql.get_manage_user_id(linkman) rs5 = m.test_manage_update(id=manage_user_id, managename=linkman, managephone=linkphone, manageemail=email, roleid=2) ass.verity(json.loads(rs5)['message'], '请求成功')
def test_008_cuser_save(self): """ Time :2019-04-02 author : 罗林 desc :添加管理员 """ com_id = ManageSql.get_company_id(comp_name) rs3 = m.test_cuser_save(id='', companyid=com_id, username=linkman, userphone=linkphone, useremail=email) ass.verity(json.loads(rs3)['message'], '请求成功')
def test_027_teamdown(self): # 删除新增的公司和账号 ManageSql.del_user() ManageSql.del_manage_user() ManageSql.drop_db()
""" import json import time import datetime from common.myCommon import Assertion as a from common.myCommon.TestBaseCase import TestBaseCase from finance.mysqlQuery import FinanceSql as fs from finance.mysqlQuery import ManageSql as ms from finance.testAction import FinanceAction as f from common.myCommon import TimeFormat as tf from finance.testSource import Api_Const as c orgCode = ms.get_finance_db_id() class test_005_Finance_devices(TestBaseCase): # 设备管理 def test_001_getDeviceType(self): # 获取设备类型信息 r1 = json.loads(f.test_device_getDeviceType()) a.verity(r1['data'][0]['dictCode'], '1', '断言dictCode') a.verity(r1['data'][0]['dictName'], '有线', '断言dictName') a.verity(r1['data'][0]['id'], 20, '断言id') a.verity(r1['data'][1]['dictCode'], '0', '断言dictCode') a.verity(r1['data'][1]['dictName'], '无线', '断言dictName') a.verity(r1['data'][1]['id'], 21, '断言id')
# -*- coding: utf-8 -*- """ @Time :2018-07-16 下午 5:27 @Author : 罗林 @File : FinanceSql.py @desc : """ import math from common.mydb import MysqlClent from finance.mysqlQuery import ManageSql from finance.testAction import loginAction db_info = ManageSql.db_info db_info['dbname'] = ManageSql.get_finance_db_name() DB_CONN = MysqlClent.get_conn(**db_info) def get_device_id(deviceCode): # 获取设备ID return MysqlClent.select_one(DB_CONN, 'fk_gps', 'id', 'code = "{}" and is_active = "Y" GROUP BY id DESC'.format(deviceCode)) def get_gps(install_status=0): # 根据安装状态查GPS 设备安装状态 0 未安装,1 已安装,2 已拆机 return MysqlClent.select(DB_CONN, table='fk_gps', column='id, code', condition='install_status = "{}" and is_active = "Y" GROUP BY id DESC LIMIT 1' .format(install_status))