Source code for uw.sql.query

"""Tools for generating SQL queries.
"""

def query_and (*items):
    """Join some supplied SQL predicates with AND.

    :param \\*items: Some SQL predicates; any None entries will be ignored.
    :return: The provided predicates, joined by AND; if there no non-None
        predicates, None.
    """
    items = [i for i in items if i is not None]
    if items:
        return "(" + " and ".join (items) + ")"
    else:
        return None

def query_or (*items):
    """Join some supplied SQL predicates with OR.

    :param \\*items: Some SQL predicates; any None entries will be ignored.
    :return: The provided predicates, joined by OR; if there no non-None
        predicates, None.
    """
    items = [i for i in items if i is not None]
    if items:
        return "(" + " or ".join (items) + ")"
    else:
        return None