lsst.dax.ppdb.ap_verify_queries Namespace Reference

Functions
def	countUnassociatedObjects (ppdb)
def	isVisitProcessed (ppdb, visitInfo)

Function Documentation

countUnassociatedObjects()

def lsst.dax.ppdb.ap_verify_queries.countUnassociatedObjects

(

ppdb

)

Return the number of DiaObjects that have only one DiaSource associated
with them.

Parameters
----------
ppdb : `lsst.dax.ppdb.Ppdb`
    Ppdb object connected to an instantiated database.

Returns
-------
count : `int`
    Number of DiaObjects with exactly one associated DiaSource.

Definition at line 31 of file ap_verify_queries.py.

def countUnassociatedObjects(ppdb):
    """Return the number of DiaObjects that have only one DiaSource associated
    with them.

    Parameters
    ----------
    ppdb : `lsst.dax.ppdb.Ppdb`
        Ppdb object connected to an instantiated database.

    Returns
    -------
    count : `int`
        Number of DiaObjects with exactly one associated DiaSource.
    """
    # Retrieve the DiaObject table.
    table = ppdb._schema.objects

    # Construct the sql statement.
    stmt = sql.select([func.count()]).select_from(table).where(table.c.nDiaSources == 1)
    stmt = stmt.where(table.c.validityEnd == None)  # noqa: E711

    # Return the count.
    count = ppdb._engine.scalar(stmt)

    return count

isVisitProcessed()

def lsst.dax.ppdb.ap_verify_queries.isVisitProcessed	(		ppdb,
			visitInfo
	)

Test whether data from an image has been loaded into the database.

Parameters
----------
ppdb : `lsst.dax.ppdb.Ppdb`
    Ppdb object connected to an instantiated database.
visitInfo : `lsst.afw.image.VisitInfo`
    The metadata for the image of interest.

Returns
-------
isProcessed : `bool`
    `True` if the data are present, `False` otherwise.

Definition at line 58 of file ap_verify_queries.py.

def isVisitProcessed(ppdb, visitInfo):
    """Test whether data from an image has been loaded into the database.

    Parameters
    ----------
    ppdb : `lsst.dax.ppdb.Ppdb`
        Ppdb object connected to an instantiated database.
    visitInfo : `lsst.afw.image.VisitInfo`
        The metadata for the image of interest.

    Returns
    -------
    isProcessed : `bool`
        `True` if the data are present, `False` otherwise.
    """
    id = visitInfo.getExposureId()
    table = ppdb._schema.sources
    idField = table.c.ccdVisitId

    # Hopefully faster than SELECT DISTINCT
    query = sql.select([idField]).select_from(table) \
        .where(idField == id).limit(1)

    return ppdb._engine.scalar(query) is not None

---

Generated on Sat Jun 8 2019 08:10:02 for LSSTApplications by   1.8.13