def __repo_update(user): db_template.update('update T_USER set USERNAME = ?, PASSWORD = ?, NAME = ? where ID = ?', (user.username, user.password, user.name, user.id)) db_template.update('delete from T_USER_GROUP where USER_ID = ?', (user.id,)) if user.groups: [db_template.insert('insert into T_USER_GROUP (USER_ID, GROUP_ID) values (?, ?)', (user.id, group.id)) for group in user.groups] db_template.update('delete from T_USER_ROLE where USER_ID = ?', (user.id,)) if user.roles: [db_template.insert('insert into T_USER_ROLE (USER_ID, ROLE_ID) values (?, ?)', (user.id, role.id)) for role in user.roles]
def __repo_delete_befor(time): db_template.update("delete from T_LOG where TIME <= ?", (time,))
def __repo_delete(log): db_template.update('delete from T_LOG where ID = ?', (log.id,))
def __repo_delete(user): db_template.update('delete from T_USER_ROLE where USER_ID = ?', (user.id,)) db_template.update('delete from T_USER_GROUP where USER_ID = ?', (user.id,)) db_template.update('delete from T_USER where ID = ?', (user.id,))
def __repo_delete(group): db_template.update('delete from T_GROUP_ROLE where GROUP_ID = ?', (group.id,)) db_template.update('delete from T_GROUP where ID = ?', (group.id,))
def __repo_update(group): db_template.update('update T_GROUP set NAME = ?, PARENT_ID = ?, DESCRIPTION = ? where ID = ?', (group.name, group.parent.id if group.parent else None, group.description, group.id)) db_template.update('delete from T_GROUP_ROLE where GROUP_ID = ?', (group.id,)) if group.roles: [db_template.insert('insert into T_GROUP_ROLE (GROUP_ID, ROLE_ID) values (?, ?)', (group.id, role.id)) for role in group.roles]