def getSourceFarEvaluations(sesSource):
"""
Isolate the imports for the ORM records into this file
Returns the set of records from the FarEvaluations table of the source database.
"""
srcFilters = AsuPsBioFilters(sesSource)
srcEmplidsSubQry = srcFilters.getAllBiodesignEmplidList(True)
return sesSource.query(AsuDwPsFarEvaluations).join(
srcEmplidsSubQry,
AsuDwPsFarEvaluations.emplid == srcEmplidsSubQry.c.emplid).order_by(
AsuDwPsFarEvaluations.emplid).all()
def getSourceFarRefereedarticles(sesSource):
"""
Isolate the imports for the ORM records into this file
Returns the set of records from the FarRefereedarticles table of the source database.
"""
srcFilters = AsuPsBioFilters(sesSource)
srcEmplidsSubQry = srcFilters.getAllBiodesignEmplidList(True)
farEvals = sesSource.query(AsuDwPsFarEvaluations.evaluationid).join(
srcEmplidsSubQry,
AsuDwPsFarEvaluations.emplid == srcEmplidsSubQry.c.emplid).subquery()
return sesSource.query(AsuDwPsFarRefereedarticles).join(
farEvals, AsuDwPsFarRefereedarticles.evaluationid == farEvals.c.
evaluationid).filter(AsuDwPsFarRefereedarticles.ispublic != 'N').all()