def get_repository_by_name_and_owner(name, owner_username):
owner = get_user_by_name(owner_username)
repository = sa_session.query( model.Repository ) \
.filter( and_( model.Repository.table.c.name == name,
model.Repository.table.c.user_id == owner.id ) ) \
.first()
return repository
def get_repository_metadata_by_repository_id_changeset_revision(
repository_id, changeset_revision):
repository_metadata = sa_session.query( model.RepositoryMetadata ) \
.filter( and_( model.RepositoryMetadata.table.c.repository_id == repository_id,
model.RepositoryMetadata.table.c.changeset_revision == changeset_revision ) ) \
.first()
return repository_metadata
def get_repository_review_by_user_id_changeset_revision( user_id, repository_id, changeset_revision ):
review = sa_session.query( model.RepositoryReview ) \
.filter( and_( model.RepositoryReview.table.c.user_id == user_id,
model.RepositoryReview.table.c.repository_id == repository_id,
model.RepositoryReview.table.c.changeset_revision == changeset_revision ) ) \
.first()
return review
def get_repository_by_name_and_owner( name, owner_username ):
owner = get_user_by_name( owner_username )
repository = sa_session.query( model.Repository ) \
.filter( and_( model.Repository.table.c.name == name,
model.Repository.table.c.user_id == owner.id ) ) \
.first()
return repository
def get_repository_review_by_user_id_changeset_revision(
user_id, repository_id, changeset_revision):
review = sa_session.query( model.RepositoryReview ) \
.filter( and_( model.RepositoryReview.table.c.user_id == user_id,
model.RepositoryReview.table.c.repository_id == repository_id,
model.RepositoryReview.table.c.changeset_revision == changeset_revision ) ) \
.first()
return review
def get_role_by_name( role_name ):
return sa_session.query( model.Role ) \
.filter( model.Role.table.c.name == role_name ) \
.first()
def get_user( email ):
return sa_session.query( model.User ) \
.filter( model.User.table.c.email==email ) \
.first()
def get_repository_by_id( repository_id ):
return sa_session.query( model.Repository ) \
.filter( model.Repository.table.c.id == repository_id ) \
.first()
def get_user_by_name(username):
return sa_session.query( model.User ) \
.filter( model.User.table.c.username==username ) \
.first()
def get_default_user_permissions_by_role( role ):
return sa_session.query( model.DefaultUserPermissions ) \
.filter( model.DefaultUserPermissions.table.c.role_id == role.id ) \
.all()
def get_default_user_permissions_by_user( user ):
return sa_session.query( model.DefaultUserPermissions ) \
.filter( model.DefaultUserPermissions.table.c.user_id==user.id ) \
.all()
def get_all_repositories():
return sa_session.query( model.Repository ).all()
def get_category_by_name( name ):
return sa_session.query( model.Category ) \
.filter( model.Category.table.c.name == name ) \
.first()
def get_user_by_name( username ):
return sa_session.query( model.User ) \
.filter( model.User.table.c.username==username ) \
.first()
def get_user(email):
return sa_session.query( model.User ) \
.filter( model.User.table.c.email==email ) \
.first()
def get_repository_by_id(repository_id):
return sa_session.query( model.Repository ) \
.filter( model.Repository.table.c.id == repository_id ) \
.first()
def get_default_user_permissions_by_user(user):
return sa_session.query( model.DefaultUserPermissions ) \
.filter( model.DefaultUserPermissions.table.c.user_id==user.id ) \
.all()
def get_default_user_permissions_by_role(role):
return sa_session.query( model.DefaultUserPermissions ) \
.filter( model.DefaultUserPermissions.table.c.role_id == role.id ) \
.all()
def get_category_by_name(name):
return sa_session.query( model.Category ) \
.filter( model.Category.table.c.name == name ) \
.first()
def get_all_repositories():
return sa_session.query(model.Repository).all()
def get_repository_metadata_by_repository_id_changeset_revision( repository_id, changeset_revision ):
repository_metadata = sa_session.query( model.RepositoryMetadata ) \
.filter( and_( model.RepositoryMetadata.table.c.repository_id == repository_id,
model.RepositoryMetadata.table.c.changeset_revision == changeset_revision ) ) \
.first()
return repository_metadata
def get_role_by_name(role_name):
return sa_session.query( model.Role ) \
.filter( model.Role.table.c.name == role_name ) \
.first()
