def add_file(self, file_data):
file_seq = pg_update.getSeq('file')
file_data['id'] = int(file_seq)
file_data['exist'] = 1
file_data['path'] = file_data['path'] + str(file_seq) + '_' + file_data['file_name']
pg_update.insertOne("file", file_data)
return file_data
def add_role(data_map):
'''
新增角色
'''
try:
pg_update.insertOne("role", data_map)
except Exception, e:
raise Exception("角色代码已存在", data_map)
def add_file(self, file_data):
file_seq = pg_update.getSeq('file')
file_data['id'] = int(file_seq)
file_data['exist'] = 1
file_data['path'] = file_data['path'] + str(
file_seq) + '_' + file_data['file_name']
pg_update.insertOne("file", file_data)
return file_data
def add_role_business(self, role_code, business_code):
'''
添加角色拥有业务
'''
pg_update.insertOne("role_business", {
'role_code': role_code,
'business_code': business_code
})
def add_user(data_map):
'''
新增用户
'''
try:
pg_update.insertOne("user_info", data_map)
except Exception, e:
raise Exception("用户已存在", data_map)
def add_business_api(self, business_code, api):
'''
添加业务拥有api
'''
pg_update.insertOne("business_api", {
'api': api,
'business_code': business_code
})
def add_message(self, message, message_type, send_type, send_value, receive_type, receive_value):
message_data = {}
message_data['id'] = int(pg_update.getSeq('message'))
message_data['message'] = message
message_data['message_type'] = message_type
message_data['send_type'] = send_type
message_data['send_value'] = send_value
message_data['receive_type'] = receive_type
message_data['receive_value'] = receive_value
pg_update.insertOne("message", message_data)
MessageSendRecord.add_message_send_record(message_data)
def add_role(data_map):
'''
新增角色
'''
try:
pg_update.insertOne("role", data_map)
except Exception, e:
if str(e).find('unique') != -1:
raise CooError(text='角色代码已存在:' + data_map['role_code'])
else:
raise CooError(text='未知错误')
def add_role(data_map):
'''
新增角色
'''
try:
pg_update.insertOne("role", data_map)
except Exception, e:
if str(e).find('unique') != -1:
raise CooError(text='角色代码已存在:' + data_map['role_code'])
else:
raise CooError(text='未知错误')
def add_user(self):
'''
新增用户
'''
try:
pg_update.insertOne("user_info", self.user_map)
except Exception, e:
if str(e).find('unique') != -1:
raise CooError(text='用户已存在:' + self.user_map['account'])
else:
print e
raise CooError(text='未知错误')
def add_user(self):
'''
新增用户
'''
try:
pg_update.insertOne("user_info", self.user_map)
except Exception, e:
if str(e).find('unique') != -1:
raise CooError(text='用户已存在:' + self.user_map['account'])
else:
print e
raise CooError(text='未知错误')
def add_message(self, message, message_type, send_type, send_value,
receive_type, receive_value):
message_data = {}
message_data['id'] = int(pg_update.getSeq('message'))
message_data['message'] = message
message_data['message_type'] = message_type
message_data['send_type'] = send_type
message_data['send_value'] = send_value
message_data['receive_type'] = receive_type
message_data['receive_value'] = receive_value
pg_update.insertOne("message", message_data)
MessageSendRecord.add_message_send_record(message_data)
def __addBusinessApi(api, business):
'''
传入api及business
添加到business_code表中
'''
sql = '''
select * from business_api
where api = '%s' and business_code = '%s'
''' % (api, business)
business_apis = pg_update.selectBySql(sql)
if len(business_apis) == 0:
data_map['api'] = api
data_map['business_code'] = business
pg_update.insertOne("business_api", data_map)
def __addRoleBusiness(role, business):
'''
传入role及business
添加到role_business表中
'''
sql = '''
select * from role_business
where role = '%s' and business_code = '%s'
''' % (role, business)
role_business = pg_update.selectBySql(sql)
if len(business_apis) == 0:
data_map['role_code'] = api
data_map['business_code'] = business
pg_update.insertOne("role_business", data_map)
def add_message_send_record(self, message_data):
if message_data['receive_type'] == 'user':
message_record_data = {}
message_record_data['message_id'] = message_data['id']
message_record_data['send_status'] = 0
message_record_data['receive_account'] = message_data['receive_value']
pg_update.insertOne("message_send_record", message_record_data)
if message_data['receive_type'] == 'role':
message_record_datas = []
users = User.get_users_by_role(message_data['receive_value'])
for user in users:
message_record_data = {}
message_record_data['message_id'] = message_data['id']
message_record_data['send_status'] = 0
message_record_data['receive_account'] = user['account']
message_record_datas.append(message_record_data)
pg_update.insert("message_send_record", message_record_datas)
def add_message_send_record(self, message_data):
if message_data['receive_type'] == 'user':
message_record_data = {}
message_record_data['message_id'] = message_data['id']
message_record_data['send_status'] = 0
message_record_data['receive_account'] = message_data[
'receive_value']
pg_update.insertOne("message_send_record", message_record_data)
if message_data['receive_type'] == 'role':
message_record_datas = []
users = User.get_users_by_role(message_data['receive_value'])
for user in users:
message_record_data = {}
message_record_data['message_id'] = message_data['id']
message_record_data['send_status'] = 0
message_record_data['receive_account'] = user['account']
message_record_datas.append(message_record_data)
pg_update.insert("message_send_record", message_record_datas)
def __addApi():
'''
将其api接口函数信息添加到api表中
'''
funs = __getFuns()
for fun in funs:
if pg_update.select("api", where=" api = '%s' " % fun.__name__):
# 已存在则跳过
continue
data_map = {}
data_map['api'] = fun.__name__
data_map['api_explain'] = fun.__doc__.strip('\n').split('\n')[0].strip(
' ').strip('\n') if fun.__doc__ else ''
data_map['path'] = fun.__module__
data_map['disable'] = 0
data_map['error'] = 0
data_map['session'] = 1
data_map['restrict'] = (0 if fun.__module__
== 'model.businessLayer.base_business' else 1)
pg_update.insertOne("api", data_map)
def add_session_by_account(self, account):
'''
session注册
'''
where = "account = '%s' and status = 0 and invalid_time > now() " % account
session = pg_update.select("session", where=where)
if session:
raise CooError(text='该帐号已被登陆！')
data = {}
data['account'] = account
data['session'] = str(uuid.uuid4())
# 60秒后失效
data['invalid_time'] = str(datetime.datetime.now() + datetime.timedelta(seconds=600))[:19]
try:
pg_update.insertOne("session", data)
return data['session']
except Exception, e:
if str(e).find('unique') != -1:
return add_session_by_account(account)
else:
print e
raise CooError(text='未知错误')
def add_session_by_account(self, account):
'''
session注册
'''
where = "account = '%s' and status = 0 and invalid_time > now() " % account
session = pg_update.select("session", where=where)
if session:
raise CooError(text='该帐号已被登陆！')
data = {}
data['account'] = account
data['session'] = str(uuid.uuid4())
# 60秒后失效
data['invalid_time'] = str(datetime.datetime.now() +
datetime.timedelta(seconds=600))[:19]
try:
pg_update.insertOne("session", data)
return data['session']
except Exception, e:
if str(e).find('unique') != -1:
return add_session_by_account(account)
else:
print e
raise CooError(text='未知错误')
def add_business_api(self, business_code, api):
'''
添加业务拥有api
'''
pg_update.insertOne("business_api", {'api': api, 'business_code': business_code})
def add_role_business(self, role_code, business_code):
'''
添加角色拥有业务
'''
pg_update.insertOne("role_business", {'role_code': role_code, 'business_code': business_code})
def add_business(self, data_map):
'''
新增业务
'''
pg_update.insertOne("business", data_map)
def add_business(self, data_map):
'''
新增业务
'''
pg_update.insertOne("business", data_map)
def initializeDb():
forciblyCreateAllTable()
data = pg_update.insertOne("user_info", {'name': '陈力', "account": 'chenli', 'password': "******"})
data = pg_update.insertOne("role", {'role_code': 'root', "role_name": 'root', 'role_explain': "超级用户，拥有系统中所有的模块和权限",
'role_type': 'root', 'seq_code': 'root', 'parent_role_code': 'None'})
data = pg_update.insertOne("role", {'role_code': 'user_root', "role_name": '超级用户', 'role_explain': "超级用户，拥有系统中所有用户相关的模块和权限",
'role_type': 'root', 'seq_code': 'root.user_root', 'parent_role_code': 'root'})
data = pg_update.insertOne("role", {'role_code': 'sys_root', "role_name": '超级管理员', 'role_explain': "超级管理员，拥有系统中所有系统相关的模块和权限",
'role_type': 'root', 'seq_code': 'root.sys_root', 'parent_role_code': 'root'})
data = pg_update.insertOne("role", {'role_code': 'sys_manage', "role_name": '系统管理员', 'role_explain': "管理系统系统业务",
'role_type': 'norm', 'seq_code': 'root.sys_root.sys_manage', 'parent_role_code': 'sys_root'})
data = pg_update.insertOne("user_role", {'role_code': 'sys_manage', "account": 'chenli'})
data = pg_update.insertOne("business", {'business_code': 'top', "business_name": '顶层业务', 'business_explain': "系统顶层业务，其它业务都是其子孙业务",
'parent_business_code': 'None', 'is_leaf': 0, 'seq_code': 'top'})
data = pg_update.insertOne("business", {'business_code': 'sys', "business_name": '系统业务', 'business_explain': "包括所有系统管理的业务",
'parent_business_code': 'top', 'is_leaf': 0, 'seq_code': 'top.sys'})
data = pg_update.insertOne("business", {'business_code': 'sys_base_deploy', "business_name": '基础配置', 'business_explain': "系统基础数据的更新（单表）",
'parent_business_code': 'sys', 'is_leaf': 0, 'seq_code': 'top.sys.sys_base_deploy'})
data = pg_update.insertOne("business", {'business_code': 'user_management', "business_name": '用户管理', 'business_explain': "用户管理",
'parent_business_code': 'sys_base_deploy', 'is_leaf': 1, 'component': 'user_management', 'icon': 'users', 'seq_code': 'top.sys.sys_base_deploy.user_management'})
data = pg_update.insertOne("business", {'business_code': 'role_management', "business_name": '角色管理', 'business_explain': "角色管理",
'parent_business_code': 'sys_base_deploy', 'is_leaf': 1, 'component': 'role_management', 'icon': 'spy', 'seq_code': 'top.sys.sys_base_deploy.role_management'})
data = pg_update.insertOne("business", {'business_code': 'business_management', "business_name": '业务管理', 'business_explain': "业务管理",
'parent_business_code': 'sys_base_deploy', 'is_leaf': 1, 'component': 'business_management', 'icon': 'users', 'seq_code': 'top.sys.sys_base_deploy.business_management'})
data = pg_update.insertOne("business", {'business_code': 'api_management', "business_name": 'API管理', 'business_explain': "API管理",
'parent_business_code': 'sys_base_deploy', 'is_leaf': 1, 'component': 'api_management', 'icon': 'users', 'seq_code': 'top.sys.sys_base_deploy.api_management'})
data = pg_update.insertOne("role_business", {'role_code': 'root', "business_code": 'top'})
data = pg_update.insertOne("role_business", {'role_code': 'sys_root', "business_code": 'sys'})
data = pg_update.insertOne("role_business", {'role_code': 'sys_manage', "business_code": 'sys_base_deploy'})
data = pg_update.insertOne("business_api", {'api': 'get_businesses_tree', 'business_code': 'business_management'})
data = pg_update.insertOne("business_api", {'api': 'save_business', 'business_code': 'business_management'})
data = pg_update.insertOne("business_api", {'api': 'get_roles', 'business_code': 'role_management'})
data = pg_update.insertOne("business_api", {'api': 'get_roles_tree', 'business_code': 'role_management'})
data = pg_update.insertOne("business_api", {'api': 'save_role', 'business_code': 'role_management'})
data = pg_update.insertOne("business_api", {'api': 'change_user_role', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'edit_user', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'new_user', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'get_users', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'edit_api', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'get_apis', 'business_code': 'user_management'})
def initializeDb():
forciblyCreateAllTable()
data = pg_update.insertOne("user_info", {'name': '陈力', "account": 'chenli', 'password': "******"})
data = pg_update.insertOne("role", {'role_code': 'root', "role_name": 'root', 'role_explain': "超级用户，拥有系统中所有的模块和权限",
'role_type': 'root', 'seq_code': 'root', 'parent_role_code': 'None'})
data = pg_update.insertOne("role", {'role_code': 'user_root', "role_name": '超级用户', 'role_explain': "超级用户，拥有系统中所有用户相关的模块和权限",
'role_type': 'root', 'seq_code': 'root.user_root', 'parent_role_code': 'root'})
data = pg_update.insertOne("role", {'role_code': 'sys_root', "role_name": '超级管理员', 'role_explain': "超级管理员，拥有系统中所有系统相关的模块和权限",
'role_type': 'root', 'seq_code': 'root.sys_root', 'parent_role_code': 'root'})
data = pg_update.insertOne("role", {'role_code': 'sys_manage', "role_name": '系统管理员', 'role_explain': "管理系统系统业务",
'role_type': 'norm', 'seq_code': 'root.sys_root.sys_manage', 'parent_role_code': 'sys_root'})
data = pg_update.insertOne("user_role", {'role_code': 'sys_manage', "account": 'chenli'})
data = pg_update.insertOne("business", {'business_code': 'top', "business_name": '顶层业务', 'business_explain': "系统顶层业务，其它业务都是其子孙业务",
'parent_business_code': 'None', 'is_leaf': 0, 'seq_code': 'top'})
data = pg_update.insertOne("business", {'business_code': 'sys', "business_name": '系统业务', 'business_explain': "包括所有系统管理的业务",
'parent_business_code': 'top', 'is_leaf': 0, 'seq_code': 'top.sys'})
data = pg_update.insertOne("business", {'business_code': 'sys_base_deploy', "business_name": '基础配置', 'business_explain': "系统基础数据的更新（单表）",
'parent_business_code': 'sys', 'is_leaf': 0, 'seq_code': 'top.sys.sys_base_deploy'})
data = pg_update.insertOne("business", {'business_code': 'user_management', "business_name": '用户管理', 'business_explain': "用户管理",
'parent_business_code': 'sys_base_deploy', 'is_leaf': 1, 'component': 'user_management', 'icon': 'users', 'seq_code': 'top.sys.sys_base_deploy.user_management'})
data = pg_update.insertOne("business", {'business_code': 'role_management', "business_name": '角色管理', 'business_explain': "角色管理",
'parent_business_code': 'sys_base_deploy', 'is_leaf': 1, 'component': 'role_management', 'icon': 'spy', 'seq_code': 'top.sys.sys_base_deploy.role_management'})
data = pg_update.insertOne("business", {'business_code': 'business_management', "business_name": '业务管理', 'business_explain': "业务管理",
'parent_business_code': 'sys_base_deploy', 'is_leaf': 1, 'component': 'business_management', 'icon': 'users', 'seq_code': 'top.sys.sys_base_deploy.business_management'})
data = pg_update.insertOne("business", {'business_code': 'api_management', "business_name": 'API管理', 'business_explain': "API管理",
'parent_business_code': 'sys_base_deploy', 'is_leaf': 1, 'component': 'api_management', 'icon': 'users', 'seq_code': 'top.sys.sys_base_deploy.api_management'})
data = pg_update.insertOne("role_business", {'role_code': 'root', "business_code": 'top'})
data = pg_update.insertOne("role_business", {'role_code': 'sys_root', "business_code": 'sys'})
data = pg_update.insertOne("role_business", {'role_code': 'sys_manage', "business_code": 'sys_base_deploy'})
data = pg_update.insertOne("business_api", {'api': 'get_businesses_tree', 'business_code': 'business_management'})
data = pg_update.insertOne("business_api", {'api': 'save_business', 'business_code': 'business_management'})
data = pg_update.insertOne("business_api", {'api': 'get_roles', 'business_code': 'role_management'})
data = pg_update.insertOne("business_api", {'api': 'get_roles_tree', 'business_code': 'role_management'})
data = pg_update.insertOne("business_api", {'api': 'save_role', 'business_code': 'role_management'})
data = pg_update.insertOne("business_api", {'api': 'change_user_role', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'edit_user', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'new_user', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'get_users', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'edit_api', 'business_code': 'user_management'})
data = pg_update.insertOne("business_api", {'api': 'get_apis', 'business_code': 'user_management'})
