def save_group_details(self, login, groupid, groupname, userids, desc): dupGrp = None group = Group() db = DBHelper() session = DBHelper().get_session() dupGrp = session.query(Group).filter( Group.group_name == groupname).first() if dupGrp is None: result = [] group.group_name = groupname group.created_by = (login) group.modified_by = (login) group.created_date = datetime.now() group.description = desc L = (userids).split(',') if userids != "": for i in L: user = session.query(User).filter( User.user_id == int(i)).first() group.users.append(user) db.add(group) return result else: result = "False" return result
def edit_group_details(self, groupid): result = [] group = Group() session = DBHelper().get_session() group = session.query(Group).filter(Group.group_id == groupid).first() result.append( dict(groupid=group.group_id, groupname=group.group_name, createdby=group.created_by, modifiedby=group.modified_by, createddate=group.created_date, modifieddate=group.modified_date, desc=group.description)) return result
def updatesave_group_details(self, login, groupid, groupname, userids, desc): result = [] group = Group() session = DBHelper().get_session() if groupname in constants.DEFAULT_GROUPS: user = session.query(User).filter( User.user_name == constants.DEFAULT_USERS[0]).first() new_ids = [] if userids != "": new_ids = (userids).split(',') new_ids = [int(id) for id in new_ids] if user.user_id not in new_ids: raise Exception("Can not remove user " + user.user_name + " from " + groupname) group = session.query(Group).filter(Group.group_id == groupid).first() group.group_name = groupname group.description = desc group.modified_date = datetime.now() group.modified_by = (login) for user in group.users: group.users.remove(user) if userids != "": L = (userids).split(',') for i in L: user = session.query(User).filter( User.user_id == int(i)).first() group.users.append(user) DBHelper().update(group) return result