def __repo_count(conditions):
sql = 'select count(*) from T_LOG L inner join T_USER U on L.OPERATOR = U.ID where 1 = 1'
params = []
if conditions:
operator = conditions.get('operator')
if operator:
sql += ' and L.OPERATOR = ?'
params.append(operator)
operator_name = conditions.get('operator_name')
if operator_name:
sql += ' and (U.USERNAME like ? or U.NAME like ?)'
param = '%' + operator_name + '%'
params.extend((operator_name, operator_name))
start_time = conditions.get('start_time')
if start_time:
sql += " and L.TIME >= ?";
params.append(start_time)
end_time = conditions.get('end_time')
if end_time:
sql += " and L.TIME <= ?";
params.append(end_time)
resource_name = conditions.get('resource_name')
if resource_name:
sql += ' and L.RESOURCE_NAME like ?'
param = '%' + resource_name + '%'
params.append(resource_name)
status = conditions.get('status')
if status:
sql += ' and L.STATUS = ?'
params.append(status)
return db_template.query_object(sql, params)
def __repo_count(keyword):
sql = 'select count(*) from T_USER where 1 = 1'
params = []
if keyword:
sql += ' and (USERNAME like ? or NAME like ?)'
param = '%' + keyword + '%'
params.extend((param, param))
return db_template.query_object(sql, params)
def __repo_get(id):
return db_template.query_object('select L.ID, L.TIME, L.OPERATOR, U.USERNAME, U.NAME, L.RESOURCE_NAME, L.RESOURCE_PATH, L.ARGUMENTS, L.STATUS, L.MESSAGE from T_LOG L inner join T_USER U on L.OPERATOR = U.ID where L.ID = ?', (id,), __map)
def __repo_get(id):
return db_template.query_object('select ID, NAME, DESCRIPTION from T_ROLE where ID = ?', (id,), __map)
def __repo_get_by_username(username):
return db_template.query_object('select ID, USERNAME, PASSWORD, NAME from T_USER where USERNAME = ?', (username,), __map)
def __repo_get(id):
return db_template.query_object('select ID, USERNAME, PASSWORD, NAME from T_USER where ID = ?', (id,), __map)
def __repo_be_using(id):
return db_template.query_object('select count(*) from T_USER_GROUP where GROUP_ID = ?', (id,)) > 0
def __repo_has_child(id):
return db_template.query_object('select count(*) from T_GROUP where PARENT_ID = ?', (id,)) > 0
def __repo_get_by_name(name):
return db_template.query_object('select ID, NAME, PARENT_ID, DESCRIPTION from T_GROUP where NAME = ?', (name,), __map)
def __repo_get_root():
return db_template.query_object('select ID, NAME, PARENT_ID, DESCRIPTION from T_GROUP where PARENT_ID is null', (), __map)
