def test_check_order_by_raises_no_exception_when_given_colum_name_as_string_with_quotes( self, app): # When try: check_order_by('"venueId"') except ApiErrors: # Then assert pytest.fail("Should not fail with valid params")
def test_check_order_by_raises_no_exception_when_given_sqlalchemy_func_random_expression( self, app): # When try: check_order_by(func.random()) except ApiErrors: # Then assert pytest.fail("Should not fail with valid params")
def test_check_order_by_raises_no_exception_when_given_sqlalchemy_column_list( self, app): # When try: check_order_by([Offer.id, Offer.venueId]) except ApiErrors: # Then assert pytest.fail("Should not fail with valid params")
def test_check_order_by_raises_an_exception_when_given_select_statement( self, app): # When with pytest.raises(ApiErrors) as e: check_order_by('select plop from offer') # Then assert 'order_by' in e.value.errors
def test_check_order_by_raises_an_exception_when_given_list_containing_invalid_part( self, app): # When with pytest.raises(ApiErrors) as e: check_order_by([Offer.id, func.random(), 'select * from toto']) # Then assert 'order_by' in e.value.errors
def test_check_order_by_raises_no_exception_when_given_coalesce_expression_in_string( self, app): # When try: check_order_by('COALESCE("Offer"."venueId" , id) ASC') except ApiErrors: # Then assert pytest.fail("Should not fail with valid params")
def test_check_order_by_raises_no_exception_when_given_comma_separated_list_in_string( self, app): # When try: check_order_by('"Offer"."venueId" DESC, id ASC') except ApiErrors: # Then assert pytest.fail("Should not fail with valid params")
def test_check_order_by_raises_no_exception_when_given_mixed_list( self, app): # When try: check_order_by( [Offer.id, Offer.venueId.desc(), func.random(), 'id']) except ApiErrors: # Then assert pytest.fail("Should not fail with valid params")
def find_offerer_bookings_paginated(offerer_id, search=None, order_by=None, page=1): query = _filter_bookings_by_offerer_id(offerer_id) if search: query = _filter_bookings_with_keywords_string(query, search) if order_by: check_order_by(order_by) query = query_with_order_by(query, order_by) bookings = query.paginate(int(page), per_page=10, error_out=False) \ .items return bookings