def count_daily_trs(rst_ids, date_from, date_end): q = WDBSession().query( func.sum(RstDailyTransaction.order_amt).label('amount')) q = q.filter(RstDailyTransaction.restaurant_id.in_(rst_ids))\ .filter(RstDailyTransaction.order_date >= date_from)\ .filter(RstDailyTransaction.order_date <= date_end) return q.first()
def query_by_points(cls, points): q = DBSession().query(cls) polygon_point_dict = _get_polygon_from_points(points) q = q.filter(and_(cls.latitude <= polygon_point_dict['max_lat'], cls.latitude >= polygon_point_dict['min_lat'], cls.longitude >= polygon_point_dict['min_lng'], cls.longitude <= polygon_point_dict['max_lng'])) buildings = q.all() points = [(point['lat'], point['lng']) for point in points] buildings = [building for building in buildings if is_in_region((float(building.latitude), float(building.longitude)), points)] return buildings
def query_by_points(cls, points): q = DBSession().query(cls) polygon_point_dict = _get_polygon_from_points(points) q = q.filter( and_(cls.latitude <= polygon_point_dict['max_lat'], cls.latitude >= polygon_point_dict['min_lat'], cls.longitude >= polygon_point_dict['min_lng'], cls.longitude <= polygon_point_dict['max_lng'])) buildings = q.all() points = [(point['lat'], point['lng']) for point in points] buildings = [ building for building in buildings if is_in_region((float(building.latitude), float(building.longitude)), points) ] return buildings
def delete_by_region(cls, region_id): q = DBSession().query(cls) q = q.filter(cls.region_id == region_id) buildings = q.all() for building in buildings: building.region_id = None
def query_by_region(cls, region_id): q = DBSession().query(cls) q = q.filter(cls.region_id == region_id) return q.all()
def count_daily_trs(rst_ids, date_from, date_end): q = WDBSession().query(func.sum(RstDailyTransaction.order_amt).label('amount')) q = q.filter(RstDailyTransaction.restaurant_id.in_(rst_ids))\ .filter(RstDailyTransaction.order_date >= date_from)\ .filter(RstDailyTransaction.order_date <= date_end) return q.first()