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
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 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