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]
