예제 #1
0
    def build_query(self, kwargs):
        query = self.model.query.filter(
            self.year_column >= SQL_CONFIG['START_YEAR_ITEMIZED'], )

        query = utils.filter_multi(query, kwargs, self.filter_multi_fields)
        query = utils.filter_range(query, kwargs, self.filter_range_fields)
        query = self.filter_fulltext(query, kwargs)

        return query
예제 #2
0
 def get(self, **kwargs):
     query = models.Filings.query
     query = filter_query(models.Filings, query, fields, kwargs)
     query = utils.filter_range(query, kwargs, range_fields)
     count = counts.count_estimate(query, models.db.session, threshold=5000)
     return utils.fetch_page(query, kwargs, model=models.Filings, count=count)