Python query示例

示例#1

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

示例#2

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

示例#3

文件： 96d68c1af09e919e2f94107ee72c27232234fef6test_db_util.py 项目： hidelab/galaxy-central-hpc

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

示例#4

def get_repository_reviews( repository_id, reviewer_user_id=None, changeset_revision=None ):
    if reviewer_user_id and changeset_revision:
        reviews = sa_session.query( model.RepositoryReview ) \
                            .filter( and_( model.RepositoryReview.table.c.repository_id == repository_id,
                                           model.RepositoryReview.table.c.deleted == False,
                                           model.RepositoryReview.table.c.changeset_revision == changeset_revision,
                                           model.RepositoryReview.table.c.user_id == reviewer_user_id ) ) \
                            .all()
    elif reviewer_user_id:
        reviews = sa_session.query( model.RepositoryReview ) \
                            .filter( and_( model.RepositoryReview.table.c.repository_id == repository_id,
                                           model.RepositoryReview.table.c.deleted == False,
                                           model.RepositoryReview.table.c.user_id == reviewer_user_id ) ) \
                            .all()
    else:
        reviews = sa_session.query( model.RepositoryReview ) \
                            .filter( and_( model.RepositoryReview.table.c.repository_id == repository_id,
                                           model.RepositoryReview.table.c.deleted == False ) ) \
                            .all()
    return reviews

示例#5

def get_default_user_permissions_by_user( user ):
    return sa_session.query( model.DefaultUserPermissions ) \
                     .filter( model.DefaultUserPermissions.table.c.user_id==user.id ) \
                     .all()

示例#6

def get_default_user_permissions_by_role( role ):
    return sa_session.query( model.DefaultUserPermissions ) \
                     .filter( model.DefaultUserPermissions.table.c.role_id == role.id ) \
                     .all()

示例#7

def get_category_by_name( name ):
    return sa_session.query( model.Category ) \
                     .filter( model.Category.table.c.name == name ) \
                     .first()

示例#8

def get_all_repositories():
    return sa_session.query( model.Repository ).all()

示例#9

文件： test_db_util.py 项目： Pelonza/Learn2Mine-Main

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

示例#10

def get_user_by_name( username ):
    return sa_session.query( model.User ) \
                     .filter( model.User.table.c.username==username ) \
                     .first()

示例#11

def get_user( email ):
    return sa_session.query( model.User ) \
                     .filter( model.User.table.c.email==email ) \
                     .first()

示例#12

def get_role_by_name( role_name ):
    return sa_session.query( model.Role ) \
                     .filter( model.Role.table.c.name == role_name ) \
                     .first()

示例#13

def get_repository_downloadable_revisions( repository_id ):
    revisions = sa_session.query( model.RepositoryMetadata ) \
                          .filter( and_( model.RepositoryMetadata.table.c.repository_id == repository_id,
                                         model.RepositoryMetadata.table.c.downloadable == True ) ) \
                          .all()
    return revisions

示例#14

def get_repository_by_id( repository_id ):
    return sa_session.query( model.Repository ) \
                     .filter( model.Repository.table.c.id == repository_id ) \
                     .first()

示例#15

文件： test_db_util.py 项目： galaxyguardians/galaxy

def get_repository_role_association( repository_id, role_id ):
    rra = sa_session.query( model.RepositoryRoleAssociation ) \
                    .filter( and_( model.RepositoryRoleAssociation.table.c.role_id == role_id,
                                   model.RepositoryRoleAssociation.table.c.repository_id == repository_id ) ) \
                    .first()
    return rra

示例#16

文件： 96d68c1af09e919e2f94107ee72c27232234fef6test_db_util.py 项目： hidelab/galaxy-central-hpc

def get_repository_role_association(repository_id, role_id):
    rra = sa_session.query( model.RepositoryRoleAssociation ) \
                    .filter( and_( model.RepositoryRoleAssociation.table.c.role_id == role_id,
                                   model.RepositoryRoleAssociation.table.c.repository_id == repository_id ) ) \
                    .first()
    return rra