def get_child_businesses(self, parent_business_code):
'''
通过父业务编码获取子业务
'''
child_business = pg_update.select("business", order_by='id',
where=" parent_business_code = '%s' " % parent_business_code)
for business in child_business:
if business['is_leaf'] == 0:
business['child'] = pg_update.select("business", order_by='id',
where=" parent_business_code = '%s' " % parent_business_code)
return child_business
def get_child_businesses(parent_business_code):
'''
通过父业务编码获取子业务
'''
child_business = pg_update.select("business", order_by='id',
where=" parent_business_code = '%s' " % parent_business_code)
for business in child_business:
if business['is_leaf'] == 0:
business['child'] = pg_update.select("business", order_by='id',
where=" parent_business_code = '%s' " % parent_business_code)
return child_business
def get_user_by_ap(self, user):
'''
通过用户名密码获取用户
'''
where = " account = '%s' and password = '******' " % (user['account'],
user['password'])
return pg_update.select("user_info", where=where, columns='id,account')
def get_role_parent_role_code(slef, role_code):
'''
获取所有角色
create by chenli at 16/01/07 11:37
'''
parent_role_code = pg_update.select("role", where="role_code = '%s' " % role_code)[0]['parent_role_code']
return 'root' if parent_role_code == 'None' else parent_role_code
def get_user_by_account(self, account):
'''
通过帐号获取用户
'''
return pg_update.select("user_info",
where=" account = '%s' " % account,
columns='id,account')
def get_component_businesses(self):
'''
获取所有业务
'''
return pg_update.select("business",
order_by="id",
where="component is not null",
limit=-1)
def get_role_parent_role_code(slef, role_code):
'''
获取所有角色
create by chenli at 16/01/07 11:37
'''
parent_role_code = pg_update.select("role",
where="role_code = '%s' " %
role_code)[0]['parent_role_code']
return 'root' if parent_role_code == 'None' else parent_role_code
def get_user_by_id(user_id):
sql = '''
select * from role
where role_code in (
select r.role_code
from user_info u,user_role r
where u.id = %s and u.account = r.account
and r.status=0)
''' % user_id
roles = pg_update.selectBySql(sql)
user = pg_update.select("user_info", where=' id = %s ' % user_id, columns='id,account')[0]
user['roles'] = roles
return user
def get_businesses_by_role_code(self, role_code):
'''
获取某角色拥有的所有业务
'''
business_codes = pg_update.select("role_business", where="role_code = '%s'" % role_code)
where = ''
for business_code in business_codes:
where += "or seq_code like '%%%s%%'" % business_code['business_code']
sql = '''
select * from (
select * from business where status = 0
) b where %s
''' % where[2:]
return pg_update.selectBySql(sql)
def get_businesses_by_role_code(self, role_code):
'''
获取某角色拥有的所有业务
'''
business_codes = pg_update.select("role_business",
where="role_code = '%s'" % role_code)
where = ''
for business_code in business_codes:
where += "or seq_code like '%%%s%%'" % business_code[
'business_code']
sql = '''
select * from (
select * from business where status = 0
) b where %s
''' % where[2:]
return pg_update.selectBySql(sql)
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 get_businesses():
'''
获取所有业务
'''
datas = pg_update.select("business", order_by="id", limit=-1)
return datas
def get_user_by_ap(self, user):
'''
通过用户名密码获取用户
'''
where = " account = '%s' and password = '******' " % (user['account'], user['password'])
return pg_update.select("user_info", where=where, columns='id,account')
def get_businesses_by_api(self, api):
'''
通过api获取业务api数据
'''
return pg_update.select("business_api", where=" api = '%s' " % api)
def get_session_by_session(self, session):
where = "session = '%s' and status = 0 and invalid_time > now() " % session
return pg_update.select("session", where=where)
def get_component_businesses(self):
'''
获取所有业务
'''
return pg_update.select("business", order_by="id", where="component is not null", limit=-1)
def get_businesses(self):
'''
获取所有业务
'''
return pg_update.select("business", order_by="id", limit=-1)
def get_user_head_file_name_by_account(self, account):
return pg_update.select("user_detail",
where=" account = '%s' and status = 0 " %
account)
def get_roles(slef):
'''
获取所有角色
create by chenli at 16/01/07 11:37
'''
return pg_update.select("role", order_by="id", limit=-1)
def get_user_head_file_name_by_account(self, account):
return pg_update.select("user_detail", where=" account = '%s' and status = 0 " % account)
def get_user_by_account(self, account):
'''
通过帐号获取用户
'''
return pg_update.select("user_info", where=" account = '%s' " % account, columns='id,account')
def get_session_by_session(self, session):
where = "session = '%s' and status = 0 and invalid_time > now() " % session
return pg_update.select("session", where=where)
def get_roles(slef):
'''
获取所有角色
create by chenli at 16/01/07 11:37
'''
return pg_update.select("role", order_by="id", limit=-1)
def get_businesses(self):
'''
获取所有业务
'''
return pg_update.select("business", order_by="id", limit=-1)
def get_businesses_by_api(self, api):
'''
通过api获取业务api数据
'''
return pg_update.select("business_api", where=" api = '%s' " % api)