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)