def sqladdressbookquery(filter, addressbookid=None):
"""
Convert the supplied addressbook-query into a partial SQL statement.
@param filter: the L{Filter} for the addressbook-query to convert.
@return: a C{tuple} of (C{str}, C{list}), where the C{str} is the partial SQL statement,
and the C{list} is the list of argument substitutions to use with the SQL API execute method.
Or return C{None} if it is not possible to create an SQL query to fully match the addressbook-query.
"""
try:
expression = buildExpression(filter, sqllitegenerator.FIELDS)
sql = sqllitegenerator(expression, addressbookid, None)
return sql.generate()
except ValueError:
return None
def sqlcalendarquery(filter, calendarid=None, userid=None, freebusy=False):
"""
Convert the supplied calendar-query into a partial SQL statement.
@param filter: the L{Filter} for the calendar-query to convert.
@return: a C{tuple} of (C{str}, C{list}), where the C{str} is the partial SQL statement,
and the C{list} is the list of argument substitutions to use with the SQL API execute method.
Or return C{None} if it is not possible to create an SQL query to fully match the calendar-query.
"""
try:
expression = buildExpression(filter, sqllitegenerator.FIELDS)
sql = sqllitegenerator(expression, calendarid, userid, freebusy)
return sql.generate()
except ValueError:
return None