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