sqlalchemy.testing.suite.test_select.FetchLimitOffsetTest

class documentation

class FetchLimitOffsetTest(fixtures.TablesTest):

Undocumented

Class Method	`define_tables`	Undocumented
Class Method	`insert_data`	Undocumented
Method	`_assert_result`	Undocumented
Method	`_assert_result_str`	Undocumented
Method	`test_bound_fetch_offset`	Undocumented
Method	`test_bound_limit`	Undocumented
Method	`test_bound_limit_offset`	Undocumented
Method	`test_bound_offset`	Undocumented
Method	`test_expr_fetch_offset`	Undocumented
Method	`test_expr_limit`	Undocumented
Method	`test_expr_limit_offset`	Undocumented
Method	`test_expr_limit_simple_offset`	Undocumented
Method	`test_expr_offset`	Undocumented
Method	`test_fetch_offset_no_order`	Undocumented
Method	`test_fetch_offset_nobinds`	test that 'literal binds' mode works - no bound params.
Method	`test_fetch_offset_percent`	Undocumented
Method	`test_fetch_offset_percent_ties`	Undocumented
Method	`test_fetch_offset_ties`	Undocumented
Method	`test_fetch_offset_ties_exact_number`	Undocumented
Method	`test_limit_offset_nobinds`	test that 'literal binds' mode works - no bound params.
Method	`test_limit_render_multiple_times`	Undocumented
Method	`test_simple_fetch`	Undocumented
Method	`test_simple_fetch_offset`	Undocumented
Method	`test_simple_fetch_percent`	Undocumented
Method	`test_simple_fetch_percent_ties`	Undocumented
Method	`test_simple_fetch_ties`	Undocumented
Method	`test_simple_limit`	Undocumented
Method	`test_simple_limit_expr_offset`	Undocumented
Method	`test_simple_limit_offset`	Undocumented
Method	`test_simple_offset`	Undocumented
Method	`test_simple_offset_zero`	Undocumented
Class Variable	`__backend__`	Undocumented

Inherited from TablesTest:

Class Method	`dispose_bind`	Undocumented
Class Method	`fixtures`	Undocumented
Class Method	`setup_bind`	Undocumented
Class Method	`_init_class`	Undocumented
Class Method	`_load_fixtures`	Insert rows as represented by the fixtures() method.
Class Method	`_setup_once_inserts`	Undocumented
Class Method	`_setup_once_tables`	Undocumented
Class Method	`_teardown_once_metadata_bind`	Undocumented
Method	`_setup_each_inserts`	Undocumented
Method	`_setup_each_tables`	Undocumented
Method	`_setup_tables_test_class`	Undocumented
Method	`_setup_tables_test_instance`	Undocumented
Method	`_teardown_each_tables`	Undocumented
Method	`sql_count_`	Undocumented
Method	`sql_eq_`	Undocumented
Class Variable	`_tables_metadata`	Undocumented
Class Variable	`bind`	Undocumented
Class Variable	`other`	Undocumented
Class Variable	`run_create_tables`	Undocumented
Class Variable	`run_define_tables`	Undocumented
Class Variable	`run_deletes`	Undocumented
Class Variable	`run_dispose_bind`	Undocumented
Class Variable	`run_inserts`	Undocumented
Class Variable	`run_setup_bind`	Undocumented
Class Variable	`sequences`	Undocumented
Class Variable	`tables`	Undocumented
Property	`tables_test_metadata`	Undocumented

Inherited from TestBase (via TablesTest):

Method	`assert_`	Undocumented
Method	`async_testing_engine`	Undocumented
Method	`connection`	Undocumented
Method	`connection_no_trans`	Undocumented
Method	`future_connection`	Undocumented
Method	`future_engine`	Undocumented
Method	`metadata`	Provide bound MetaData for a single test, dropping afterwards.
Method	`registry`	Undocumented
Method	`testing_engine`	Undocumented
Method	`trans_ctx_manager_fixture`	Undocumented
Class Variable	`__leave_connections_for_teardown__`	Undocumented
Class Variable	`__only_on__`	Undocumented
Class Variable	`__requires__`	Undocumented
Class Variable	`__skip_if__`	Undocumented
Class Variable	`__unsupported_on__`	Undocumented

@classmethod
def define_tables(cls, metadata):

overrides sqlalchemy.testing.fixtures.TablesTest.define_tables

Undocumented

@classmethod
def insert_data(cls, connection):

overrides sqlalchemy.testing.fixtures.TablesTest.insert_data

Undocumented

def _assert_result(self, connection, select, result, params=(), set_=False):

Undocumented

def _assert_result_str(self, select, result, params=()):

Undocumented

@testing.requires.fetch_first
def test_bound_fetch_offset(self, connection):

Undocumented

@testing.requires.bound_limit_offset
def test_bound_limit(self, connection):

Undocumented

@testing.requires.bound_limit_offset
def test_bound_limit_offset(self, connection):

Undocumented

@testing.requires.bound_limit_offset
def test_bound_offset(self, connection):

Undocumented

@testing.requires.fetch_first
@testing.requires.fetch_expression
def test_expr_fetch_offset(self, connection):

Undocumented

@testing.requires.sql_expression_limit_offset
def test_expr_limit(self, connection):

Undocumented

@testing.requires.sql_expression_limit_offset
def test_expr_limit_offset(self, connection):

Undocumented

@testing.requires.sql_expression_limit_offset
def test_expr_limit_simple_offset(self, connection):

Undocumented

@testing.requires.sql_expression_limit_offset
def test_expr_offset(self, connection):

Undocumented

@testing.requires.fetch_no_order_by
def test_fetch_offset_no_order(self, connection):

Undocumented

@testing.requires.fetch_first
def test_fetch_offset_nobinds(self):

test that 'literal binds' mode works - no bound params.

@testing.requires.fetch_percent
@testing.requires.fetch_offset_with_options
def test_fetch_offset_percent(self, connection):

Undocumented

@testing.requires.fetch_ties
@testing.requires.fetch_percent
@testing.requires.fetch_offset_with_options
def test_fetch_offset_percent_ties(self, connection):

Undocumented

@testing.requires.fetch_ties
@testing.requires.fetch_offset_with_options
def test_fetch_offset_ties(self, connection):

Undocumented

@testing.requires.fetch_ties
@testing.requires.fetch_offset_with_options
def test_fetch_offset_ties_exact_number(self, connection):

Undocumented

@testing.requires.offset
def test_limit_offset_nobinds(self):

test that 'literal binds' mode works - no bound params.

def test_limit_render_multiple_times(self, connection):

Undocumented

@testing.requires.fetch_first
def test_simple_fetch(self, connection):

Undocumented

@testing.requires.fetch_first
def test_simple_fetch_offset(self, connection):

Undocumented

@testing.requires.fetch_percent
def test_simple_fetch_percent(self, connection):

Undocumented

@testing.requires.fetch_ties
@testing.requires.fetch_percent
def test_simple_fetch_percent_ties(self, connection):

Undocumented

@testing.requires.fetch_ties
def test_simple_fetch_ties(self, connection):

Undocumented

def test_simple_limit(self, connection):

Undocumented

@testing.requires.sql_expression_limit_offset
def test_simple_limit_expr_offset(self, connection):

Undocumented

@testing.combinations([(2, 0), (2, 1), (3, 2)], [(2, 1), (2, 0), (3, 2)], [(3, 1), (2, 1), (3, 1)], argnames='cases')
@testing.requires.offset
def test_simple_limit_offset(self, connection, cases):

Undocumented

@testing.requires.offset
def test_simple_offset(self, connection):

Undocumented

@testing.requires.offset
def test_simple_offset_zero(self, connection):

Undocumented

__backend__: bool =

Undocumented