Exemplo n.º 1
0
def delete_request_type_permissions( id ):
    rtps = sa_session.query( galaxy.model.RequestTypePermissions ) \
                     .filter( and_( galaxy.model.RequestTypePermissions.table.c.request_type_id==id ) ) \
                     .order_by( desc( galaxy.model.RequestTypePermissions.table.c.create_time ) )
    for rtp in rtps:
        sa_session.delete( rtp )
    sa_session.flush()
Exemplo n.º 2
0
def get_user_address( user, short_desc ):
    return sa_session.query( galaxy.model.UserAddress ) \
                     .filter( and_( galaxy.model.UserAddress.table.c.user_id==user.id,
                                    galaxy.model.UserAddress.table.c.desc==short_desc,
                                    galaxy.model.UserAddress.table.c.deleted==False ) ) \
                     .order_by( desc( galaxy.model.UserAddress.table.c.create_time ) ) \
                     .first()   
Exemplo n.º 3
0
def get_library( name, description, synopsis ):
    return sa_session.query( galaxy.model.Library ) \
                     .filter( and_( galaxy.model.Library.table.c.name==name,
                                    galaxy.model.Library.table.c.description==description,
                                    galaxy.model.Library.table.c.synopsis==synopsis,
                                    galaxy.model.Library.table.c.deleted==False ) ) \
                     .first()
Exemplo n.º 4
0
def get_form( name ):
    fdc_list = sa_session.query( galaxy.model.FormDefinitionCurrent ) \
                         .filter( galaxy.model.FormDefinitionCurrent.table.c.deleted == False ) \
                         .order_by( galaxy.model.FormDefinitionCurrent.table.c.create_time.desc() )
    for fdc in fdc_list:
        sa_session.refresh( fdc )
        sa_session.refresh( fdc.latest_form )
        if fdc.latest_form.name == name:
            return fdc.latest_form
    return None
Exemplo n.º 5
0
def get_group_by_name( name ):
    return sa_session.query( galaxy.model.Group ).filter( galaxy.model.Group.table.c.name==name ).first()
Exemplo n.º 6
0
def get_folder( parent_id, name, description ):
    return sa_session.query( galaxy.model.LibraryFolder ) \
                     .filter( and_( galaxy.model.LibraryFolder.table.c.parent_id==parent_id,
                                    galaxy.model.LibraryFolder.table.c.name==name,
                                    galaxy.model.LibraryFolder.table.c.description==description ) ) \
                     .first()
Exemplo n.º 7
0
def get_request_by_name( name ):
    return sa_session.query( galaxy.model.Request ) \
                     .filter( and_( galaxy.model.Request.table.c.name==name,
                                    galaxy.model.Request.table.c.deleted==False ) ) \
                     .first()   
Exemplo n.º 8
0
def get_latest_lddas( limit ):
    return sa_session.query( galaxy.model.LibraryDatasetDatasetAssociation ) \
                     .order_by( desc( galaxy.model.LibraryDatasetDatasetAssociation.table.c.update_time ) ) \
                     .limit( limit )
Exemplo n.º 9
0
def get_latest_hda():
    return sa_session.query( galaxy.model.HistoryDatasetAssociation ) \
                     .order_by( desc( galaxy.model.HistoryDatasetAssociation.table.c.create_time ) ) \
                     .first()
Exemplo n.º 10
0
def get_dataset_permissions_by_dataset( dataset ):
    return sa_session.query( galaxy.model.DatasetPermissions ) \
                     .filter( galaxy.model.DatasetPermissions.table.c.dataset_id==dataset.id ) \
                     .all()
Exemplo n.º 11
0
def get_all_histories_for_user( user ):
    return sa_session.query( galaxy.model.History ) \
                     .filter( and_( galaxy.model.History.table.c.user_id==user.id,
                                    galaxy.model.History.table.c.deleted==False ) ) \
                     .all()
Exemplo n.º 12
0
def get_user_group_associations_by_group( group ):
    return sa_session.query( galaxy.model.UserGroupAssociation ) \
                     .filter( galaxy.model.UserGroupAssociation.table.c.group_id == group.id ) \
                     .all()
Exemplo n.º 13
0
def get_role_by_name( name ):
    return sa_session.query( galaxy.model.Role ).filter( galaxy.model.Role.table.c.name==name ).first()
Exemplo n.º 14
0
def get_request_type_by_name( name ):
    return sa_session.query( galaxy.model.RequestType ) \
                     .filter( and_( galaxy.model.RequestType.table.c.name==name ) ) \
                     .order_by( desc( galaxy.model.RequestType.table.c.create_time ) ) \
                     .first()
Exemplo n.º 15
0
def get_group_role_associations_by_role( role ):
    return sa_session.query( galaxy.model.GroupRoleAssociation ) \
                     .filter( galaxy.model.GroupRoleAssociation.table.c.role_id == role.id ) \
                     .all()
Exemplo n.º 16
0
def get_latest_dataset():
    return sa_session.query( galaxy.model.Dataset ) \
                     .order_by( desc( galaxy.model.Dataset.table.c.create_time ) ) \
                     .first()
Exemplo n.º 17
0
def get_dataset_permissions_by_role( role ):
    return sa_session.query( galaxy.model.DatasetPermissions ) \
                     .filter( galaxy.model.DatasetPermissions.table.c.role_id == role.id ) \
                     .first()
Exemplo n.º 18
0
def get_latest_history_for_user( user ):
    return sa_session.query( galaxy.model.History ) \
                     .filter( and_( galaxy.model.History.table.c.deleted==False,
                                    galaxy.model.History.table.c.user_id==user.id ) ) \
                     .order_by( desc( galaxy.model.History.table.c.create_time ) ) \
                     .first()
Exemplo n.º 19
0
def get_default_history_permissions_by_history( history ):
    return sa_session.query( galaxy.model.DefaultHistoryPermissions ) \
                     .filter( galaxy.model.DefaultHistoryPermissions.table.c.history_id==history.id ) \
                     .all()
Exemplo n.º 20
0
def get_latest_ldda_by_name( name ):
    return sa_session.query( galaxy.model.LibraryDatasetDatasetAssociation ) \
                     .filter( and_( galaxy.model.LibraryDatasetDatasetAssociation.table.c.name==name,
                                    galaxy.model.LibraryDatasetDatasetAssociation.table.c.deleted == False ) ) \
                     .order_by( desc( galaxy.model.LibraryDatasetDatasetAssociation.table.c.create_time ) ) \
                     .first()
Exemplo n.º 21
0
def get_default_user_permissions_by_role( role ):
    return sa_session.query( galaxy.model.DefaultUserPermissions ) \
                     .filter( galaxy.model.DefaultUserPermissions.table.c.role_id == role.id ) \
                     .all()
Exemplo n.º 22
0
def get_galaxy_user( email ):
    return ga_session.query( galaxy.model.User ) \
                     .filter( galaxy.model.User.table.c.email==email ) \
                     .first()
Exemplo n.º 23
0
def get_default_user_permissions_by_user( user ):
    return sa_session.query( galaxy.model.DefaultUserPermissions ) \
                     .filter( galaxy.model.DefaultUserPermissions.table.c.user_id==user.id ) \
                     .all()