Example #1
0
    def getNumberOfRows(self, where=None, **kwargs):
        if not where:
            where = self.sqlBuildConditional(**kwargs)

        query = self.table.select(sqla.Count(sql.Literal(1)), where=where)

        query, params = tuple(query)

        self.log.debug("Query = '%s'", query)
        self.log.debug("Args = '%s'", params)

        with self.transaction() as cur:
            cur.execute(query, params)
            ret = cur.fetchone()

        return ret[0]
Example #2
0
 def test_reduce_ids_empty(self):
     'Test reduce_ids empty list'
     self.assertEqual(reduce_ids(self.table.id, []), sql.Literal(False))