async def V_MN_JOIN_SYS_PERMISSION_JOIN_SYS_ACTION_Query_Detail(request):
"""
Description end-point
---
description: V_MN_JOIN_SYS_PERMISSION_JOIN_SYS_ACTION明细查询
tags:
- select detail
produces:
- application/json
parameters:
- name: id
in: query
type: string
required: true
description: id 唯一标示符
"""
id = request.query.get('id')
try:
if not id:
tablelist = await V_MN_JOIN_SYS_PERMISSION_JOIN_SYS_ACTION.findAll(
selectField='*')
else:
tablelist = await V_MN_JOIN_SYS_PERMISSION_JOIN_SYS_ACTION.findAll(
selectField='*', where=f'id = "{id}"')
data = dict(success=True, data=tablelist)
return render_json(data)
except Exception as e:
data = dict(failure=True, data=e)
return render_json(data)
async def SYS_PERMISSION_InsOrUp(request):
"""
Description end-point
---
description: SYS_PERMISSION插入/更新 没有id表示插入 有id表示更新
tags:
- insert update
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_PERMISSION插入/更新
required: True
schema:
type: object
properties:
id:
type: string
createuserid:
type: string
updateuserid:
type: string
type:
type: string
remark:
type: string
"""
form = await request.json()
id = form.get('id')
createuserid = form.get('createuserid')
updateuserid = form.get('updateuserid')
type = form.get('type')
remark = form.get('remark')
try:
if id: # update
effectrows = await SYS_PERMISSION(id=id).upd2(
createuserid=createuserid,
updateuserid=updateuserid,
type=type,
remark=remark,
)
elif not id: # create
id = next_id()
effectrows = await SYS_PERMISSION().save2(
id=id,
createuserid=createuserid,
updateuserid=updateuserid,
type=type,
remark=remark,
)
data = dict(success=True, data=(effectrows, id))
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_PERMISSION_BatchIns(request):
"""
Description end-point
---
description: SYS_PERMISSION批量插入
tags:
- insert batch
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_PERMISSION插入/更新
required: True
schema:
type: object
properties:
batch_data:
type: array
items:
type: object
properties:
id:
type: string
createuserid:
type: string
createtime:
type: string
updateuserid:
type: string
updatetime:
type: string
type:
type: string
remark:
type: string
"""
form = await request.json()
data_list = form.get('batch_data')
try:
for n in data_list:
effectrows = await SYS_PERMISSION(
id=next_id(),
createuserid=n.get('createuserid'),
createtime=n.get('createtime'),
updateuserid=n.get('updateuserid'),
updatetime=n.get('updatetime'),
type=n.get('type'),
remark=n.get('remark'),
).save()
data = dict(success=True, data=effectrows)
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def V_MULTIJOIN_USERS_ROLES_PERMISSION_MENU_ELEMENT_ACTION_Query_Page(
request):
"""
Description end-point
---
description: V_MULTIJOIN_USERS_ROLES_PERMISSION_MENU_ELEMENT_ACTION分页查询
tags:
- select page
produces:
- application/json
parameters:
- name: CurrentPage
in: query
type: string
required: true
description: 当前页
- name: PageSize
in: query
type: string
required: true
description: 每一页条数
- name: Where
in: query
type: string
description: where条件
- name: OrderBy
in: query
type: string
description: 排序
"""
CurrentPage = request.query.get('CurrentPage')
PageSize = request.query.get('PageSize')
Where = request.query.get('Where')
OrderBy = request.query.get('OrderBy')
if (not CurrentPage or not PageSize):
data = dict(failure=True,
data="find no parameters CurrentPage or PageSize !")
return render_json(data)
try:
num = await V_MULTIJOIN_USERS_ROLES_PERMISSION_MENU_ELEMENT_ACTION.findNumber(
selectField='count(*)', where=Where)
p = Page(num, int(CurrentPage),
int(PageSize)) # totalcount # currentpage # pagesize
if num == 0:
data1 = dict(page=p.GetDict, res=[])
else:
list = await V_MULTIJOIN_USERS_ROLES_PERMISSION_MENU_ELEMENT_ACTION.findAll(
selectField='*',
where=Where,
orderBy=OrderBy,
limit=(p.offset, p.limit))
data1 = dict(page=p.GetDict, res=list)
data = dict(success=True, data=data1)
return render_json(data)
except Exception as e:
data = dict(failure=True, data=e)
return render_json(data)
async def SYS_USER_GROUP_HAS_SYS_ROLES_InsOrUp(request):
"""
Description end-point
---
description: SYS_USER_GROUP_HAS_SYS_ROLES插入/更新 没有id表示插入 有id表示更新
tags:
- insert update
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_USER_GROUP_HAS_SYS_ROLES插入/更新
required: True
schema:
type: object
properties:
id:
type: string
sys_user_group_id:
type: string
sys_roles_id:
type: string
"""
form = await request.json()
id = form.get('id')
sys_user_group_id = form.get('sys_user_group_id')
sys_roles_id = form.get('sys_roles_id')
try:
if id: # update
effectrows = await SYS_USER_GROUP_HAS_SYS_ROLES(id=id).upd2(
sys_user_group_id=sys_user_group_id,
sys_roles_id=sys_roles_id,
)
elif not id: # create
id = next_id()
effectrows = await SYS_USER_GROUP_HAS_SYS_ROLES().save2(
id=id,
sys_user_group_id=sys_user_group_id,
sys_roles_id=sys_roles_id,
)
data = dict(success=True, data=(effectrows, id))
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_USERS_HAS_SYS_ORGANIZATION_BatchIns(request):
"""
Description end-point
---
description: SYS_USERS_HAS_SYS_ORGANIZATION批量插入
tags:
- insert batch
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_USERS_HAS_SYS_ORGANIZATION插入/更新
required: True
schema:
type: object
properties:
batch_data:
type: array
items:
type: object
properties:
id:
type: string
sys_users_id:
type: string
sys_organization_id:
type: string
"""
form = await request.json()
data_list = form.get('batch_data')
try:
for n in data_list:
effectrows = await SYS_USERS_HAS_SYS_ORGANIZATION(
id=next_id(),
sys_users_id=n.get('sys_users_id'),
sys_organization_id=n.get('sys_organization_id'),
).save()
data = dict(success=True, data=effectrows)
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_ACTION_BatchDel(request):
"""
Description end-point
---
description: SYS_ACTION批量删除
tags:
- batch delete
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_ACTION批量删除
required: True
schema:
type: object
properties:
batchid:
type: string
description: ['xxx','xxx','xxx',...]
"""
form = await request.json()
batchid = form.get('batchid')
x = re.search(r'^\[(.*?)\]$', str(batchid))
try:
sql = f'delete from sys_action where id in ({x.group(1)})'
print(sql)
effectrows = await orm.execute(sql=sql, args=())
logging.info(effectrows)
data = dict(success=True, data=effectrows)
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_USERS_InsOrUp(request):
"""
Description end-point
---
description: SYS_USERS插入/更新 没有id表示插入 有id表示更新
tags:
- insert update
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_USERS插入/更新
required: True
schema:
type: object
properties:
id:
type: string
createuserid:
type: string
updateuserid:
type: string
name:
type: string
sex:
type: string
job:
type: string
tel:
type: string
account:
type: string
expiredtime:
type: string
oauth2_id:
type: string
"""
form = await request.json()
id = form.get('id')
createuserid = form.get('createuserid')
updateuserid = form.get('updateuserid')
name = form.get('name')
sex = form.get('sex')
job = form.get('job')
tel = form.get('tel')
account = form.get('account')
expiredtime = form.get('expiredtime')
oauth2_id = form.get('oauth2_id')
try:
if id: # update
effectrows = await SYS_USERS(id=id).upd2(
createuserid=createuserid,
updateuserid=updateuserid,
name=name,
sex=sex,
job=job,
tel=tel,
account=account,
expiredtime=expiredtime,
oauth2_id=oauth2_id,
)
elif not id: # create
id = next_id()
effectrows = await SYS_USERS().save2(
id=id,
createuserid=createuserid,
updateuserid=updateuserid,
name=name,
sex=sex,
job=job,
tel=tel,
account=account,
expiredtime=expiredtime,
oauth2_id=oauth2_id,
)
data = dict(success=True, data=(effectrows, id))
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_DICT_InsOrUp(request):
"""
Description end-point
---
description: SYS_DICT插入/更新 没有id表示插入 有id表示更新
tags:
- insert update
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_DICT插入/更新
required: True
schema:
type: object
properties:
id:
type: string
createuserid:
type: string
updateuserid:
type: string
code:
type: string
name:
type: string
level:
type: string
remark:
type: string
sort:
type: string
pid:
type: string
"""
form = await request.json()
id = form.get('id')
createuserid = form.get('createuserid')
updateuserid = form.get('updateuserid')
code = form.get('code')
name = form.get('name')
level = form.get('level')
remark = form.get('remark')
sort = form.get('sort')
pid = form.get('pid')
try:
if id: # update
effectrows = await SYS_DICT(id=id).upd2(
createuserid=createuserid,
updateuserid=updateuserid,
code=code,
name=name,
level=level,
remark=remark,
sort=sort,
pid=pid,
)
elif not id: # create
id = next_id()
effectrows = await SYS_DICT().save2(
id=id,
createuserid=createuserid,
updateuserid=updateuserid,
code=code,
name=name,
level=level,
remark=remark,
sort=sort,
pid=pid,
)
data = dict(success=True, data=(effectrows, id))
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_ORGANIZATION_InsOrUp(request):
"""
Description end-point
---
description: SYS_ORGANIZATION插入/更新 没有id表示插入 有id表示更新
tags:
- insert update
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_ORGANIZATION插入/更新
required: True
schema:
type: object
properties:
id:
type: string
createuserid:
type: string
updateuserid:
type: string
code:
type: string
name:
type: string
fullname:
type: string
location:
type: string
x:
type: string
y:
type: string
remark:
type: string
isvalid:
type: string
pid:
type: string
"""
form = await request.json()
id = form.get('id')
createuserid = form.get('createuserid')
updateuserid = form.get('updateuserid')
code = form.get('code')
name = form.get('name')
fullname = form.get('fullname')
location = form.get('location')
x = form.get('x')
y = form.get('y')
remark = form.get('remark')
isvalid = form.get('isvalid')
pid = form.get('pid')
try:
if id: # update
effectrows = await SYS_ORGANIZATION(id=id).upd2(
createuserid=createuserid,
updateuserid=updateuserid,
code=code,
name=name,
fullname=fullname,
location=location,
x=x,
y=y,
remark=remark,
isvalid=isvalid,
pid=pid,
)
elif not id: # create
id = next_id()
effectrows = await SYS_ORGANIZATION().save2(
id=id,
createuserid=createuserid,
updateuserid=updateuserid,
code=code,
name=name,
fullname=fullname,
location=location,
x=x,
y=y,
remark=remark,
isvalid=isvalid,
pid=pid,
)
data = dict(success=True, data=(effectrows, id))
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_MENU_InsOrUp(request):
"""
Description end-point
---
description: SYS_MENU插入/更新 没有id表示插入 有id表示更新
tags:
- insert update
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_MENU插入/更新
required: True
schema:
type: object
properties:
id:
type: string
createuserid:
type: string
updateuserid:
type: string
namezh:
type: string
name:
type: string
path:
type: string
component:
type: string
title:
type: string
icon:
type: string
level:
type: string
pid:
type: string
"""
form = await request.json()
id = form.get('id')
createuserid = form.get('createuserid')
updateuserid = form.get('updateuserid')
namezh = form.get('namezh')
name = form.get('name')
path = form.get('path')
component = form.get('component')
title = form.get('title')
icon = form.get('icon')
level = form.get('level')
pid = form.get('pid')
try:
if id: # update
effectrows = await SYS_MENU(id=id).upd2(
createuserid=createuserid,
updateuserid=updateuserid,
namezh=namezh,
name=name,
path=path,
component=component,
title=title,
icon=icon,
level=level,
pid=pid,
)
elif not id: # create
id = next_id()
effectrows = await SYS_MENU().save2(
id=id,
createuserid=createuserid,
updateuserid=updateuserid,
namezh=namezh,
name=name,
path=path,
component=component,
title=title,
icon=icon,
level=level,
pid=pid,
)
data = dict(success=True, data=(effectrows, id))
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_ELEMENT_InsOrUp(request):
"""
Description end-point
---
description: SYS_ELEMENT插入/更新 没有id表示插入 有id表示更新
tags:
- insert update
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_ELEMENT插入/更新
required: True
schema:
type: object
properties:
id:
type: string
createuserid:
type: string
updateuserid:
type: string
name:
type: string
value:
type: string
menu_id:
type: string
"""
form = await request.json()
id = form.get('id')
createuserid = form.get('createuserid')
updateuserid = form.get('updateuserid')
name = form.get('name')
value = form.get('value')
menu_id = form.get('menu_id')
try:
if id: # update
effectrows = await SYS_ELEMENT(id=id).upd2(
createuserid=createuserid,
updateuserid=updateuserid,
name=name,
value=value,
menu_id=menu_id,
)
elif not id: # create
id = next_id()
effectrows = await SYS_ELEMENT().save2(
id=id,
createuserid=createuserid,
updateuserid=updateuserid,
name=name,
value=value,
menu_id=menu_id,
)
data = dict(success=True, data=(effectrows, id))
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_USERS_BatchIns(request):
"""
Description end-point
---
description: SYS_USERS批量插入
tags:
- insert batch
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_USERS插入/更新
required: True
schema:
type: object
properties:
batch_data:
type: array
items:
type: object
properties:
id:
type: string
createuserid:
type: string
createtime:
type: string
updateuserid:
type: string
updatetime:
type: string
name:
type: string
sex:
type: string
job:
type: string
tel:
type: string
account:
type: string
expiredtime:
type: string
oauth2_id:
type: string
"""
form = await request.json()
data_list = form.get('batch_data')
try:
for n in data_list:
effectrows = await SYS_USERS(
id=next_id(),
createuserid=n.get('createuserid'),
createtime=n.get('createtime'),
updateuserid=n.get('updateuserid'),
updatetime=n.get('updatetime'),
name=n.get('name'),
sex=n.get('sex'),
job=n.get('job'),
tel=n.get('tel'),
account=n.get('account'),
expiredtime=n.get('expiredtime'),
oauth2_id=n.get('oauth2_id'),
).save()
data = dict(success=True, data=effectrows)
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
async def SYS_MENU_BatchIns(request):
"""
Description end-point
---
description: SYS_MENU批量插入
tags:
- insert batch
produces:
- application/json
parameters:
- in: body
name: body
description: SYS_MENU插入/更新
required: True
schema:
type: object
properties:
batch_data:
type: array
items:
type: object
properties:
id:
type: string
createuserid:
type: string
createtime:
type: string
updateuserid:
type: string
updatetime:
type: string
namezh:
type: string
name:
type: string
path:
type: string
component:
type: string
title:
type: string
icon:
type: string
level:
type: string
pid:
type: string
"""
form = await request.json()
data_list = form.get('batch_data')
try:
for n in data_list:
effectrows = await SYS_MENU(
id=next_id(),
createuserid=n.get('createuserid'),
createtime=n.get('createtime'),
updateuserid=n.get('updateuserid'),
updatetime=n.get('updatetime'),
namezh=n.get('namezh'),
name=n.get('name'),
path=n.get('path'),
component=n.get('component'),
title=n.get('title'),
icon=n.get('icon'),
level=n.get('level'),
pid=n.get('pid'),
).save()
data = dict(success=True, data=effectrows)
return render_json(data)
except Exception as e:
logging.error(e)
data = dict(failure=True, data=str(e))
return render_json(data)
