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))
