def do_init(): create_all() project1 = model.session.query(RowProject).first() if project1 is None: print "No projects found. Creating a 'llampex' project" project1 = RowProject() project1.code = "llampex" project1.description = "Llampex main project" project1.db = "llampex" project1.path = os.path.realpath(filedir("../")) project1.active = True model.session.add(project1) model.session.commit() user1 = model.session.query(RowUser).first() if user1 is None: print "No users found. Creating a 'llampex' user with password 'llampex'" user1 = RowUser() user1.username = "******" user1.password = compute_password("llampex") model.session.add(user1) model.session.commit() for project in model.session.query(RowProject): nn = RowProjectUser() nn.user = user1 nn.project = project model.session.add(nn) user1.projects.append(nn) model.session.commit()
def do_addprojectuser(username = None, project = None): if username is None: username = raw_input("Please give an username: "******"No user found with that name. Giving up." return if project is None: do_lsproject() project = raw_input("Give a project code: ") if not project: return project1 = model.session.query(RowProject).filter(RowProject.code == project).first() if project1 is None: print "No project found with that name. Giving up." return projectuser1 = model.session.query(RowProjectUser).filter(RowProjectUser.user == user1).filter(RowProjectUser.project == project1).first() if projectuser1 is not None: print "User is already granted on that project." return projectuser1 = RowProjectUser() projectuser1.project = project1 projectuser1.user = user1 model.session.add(projectuser1) model.session.commit() print "User %s added to the project %s" % (username,project)
def addUserToProject(self, user, project): userProj = RowProjectUser() userProj.project = model.session.query(RowProject).filter( RowProject.code == project).one() userProj.user = model.session.query(RowUser).filter( RowUser.username == user).one() model.session.add(userProj) return self.do_Commit()
def addUserToProject(self,user,project): userProj = RowProjectUser() userProj.project = model.session.query(RowProject).filter(RowProject.code == project).one() userProj.user = model.session.query(RowUser).filter(RowUser.username == user).one() model.session.add(userProj) return self.do_Commit()