Module ImportFrom alias identifier alias alias alias alias alias ImportFrom alias ImportFrom alias alias ImportFrom alias ImportFrom alias alias alias alias alias ImportFrom alias alias Assign NameStore Num ClassDef bases AttributeLoad NameLoad attr NameLoad body Assign NameStore Str Assign NameStore Call NameLoad Str Call NameLoad Str Call NameLoad Str Assign NameStore Call NameLoad Str Call NameLoad Str Call NameLoad Str FunctionDef arguments args NameParam NameParam NameParam defaults NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad If NameLoad body Assign AttributeStore NameLoad attr Str Assign AttributeStore NameLoad attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body Assign NameStore Call AttributeLoad NameLoad attr Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad AttributeLoad NameLoad attr attr attr Str keyword Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore CompareEq AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad NameLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Str Str keyword Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr For NameStore NameLoad body Expr Call NameLoad AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Str Str AttributeLoad AttributeLoad NameLoad attr attr Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Str Str AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr keyword NameLoad keyword ListLoad AttributeLoad AttributeLoad NameLoad attr attr attr Num Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr Str Assign NameStore Call NameLoad ListLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Str AttributeLoad AttributeLoad NameLoad attr attr Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Str Str AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr Assign NameStore Call AttributeLoad Call NameLoad ListLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad Str keyword NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword NameLoad Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Str Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Str Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Num keyword Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad Str keyword TupleLoad Num keyword Dict Str Num keyword Call AttributeLoad NameLoad attr keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Call NameLoad CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Str Num Num keyword Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Str Num Num keyword TupleLoad Num Num keyword Call AttributeLoad NameLoad attr keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword Call NameLoad Str Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr keyword Num Expr Call NameLoad Call AttributeLoad NameLoad attr keyword Dict Str Num Dict Str Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call NameLoad Call NameLoad Str Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr keyword Num Expr Call NameLoad Call AttributeLoad NameLoad attr keyword Dict Str Num Dict Str Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call NameLoad Call NameLoad Str Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr keyword Num keyword NameLoad Expr Call NameLoad Call AttributeLoad NameLoad attr keyword Dict Str Num Dict Str Num decorator_list decorator_list ClassDef bases AttributeLoad NameLoad attr NameLoad body Assign NameStore Str Assign NameStore Call NameLoad Str Call NameLoad Str Call NameLoad Str Assign NameStore Call NameLoad Str Call NameLoad Str Call NameLoad Str FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr Str Assign NameStore Call NameLoad ListLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr Str Assign NameStore Call NameLoad ListLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr keyword Num Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr Str Assign NameStore Call NameLoad ListLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Str keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr Assign NameStore Call NameLoad ListLoad NameLoad keyword NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr Assign NameStore Call NameLoad ListLoad NameLoad keyword NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr attr Str Assign NameStore Call AttributeLoad NameLoad attr keyword Num Assign NameStore Call AttributeLoad NameLoad attr keyword NameLoad Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad AttributeLoad AttributeLoad NameLoad attr attr Str Str Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad AttributeLoad AttributeLoad NameLoad attr attr Str Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr Str Assign NameStore Call NameLoad ListLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword Num Assign NameStore Call AttributeLoad NameLoad attr keyword NameLoad Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Str Str Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Str Str decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr keyword Num Assign NameStore Call NameLoad Str Call NameLoad Str Assign NameStore Call NameLoad Str Call NameLoad Str Call NameLoad Str Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr NameLoad CompareEq AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad NameLoad NameLoad attr NameLoad attr Str keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr keyword Num Assign NameStore Call AttributeLoad NameLoad attr keyword Str Assign NameStore Call NameLoad ListLoad NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad ListLoad NameLoad Str keyword NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword NameLoad Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Str AttributeLoad AttributeLoad NameLoad attr attr Str Assign NameStore Call AttributeLoad Call NameLoad ListLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad Str keyword NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword NameLoad Assert Call AttributeLoad Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num attr ListLoad Str AttributeLoad AttributeLoad NameLoad attr attr Str decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call NameLoad Str Call NameLoad Str Call NameLoad Str Assign NameStore Call AttributeLoad Call NameLoad ListLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr keyword Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword NameLoad Assign NameStore Call AttributeLoad NameLoad attr keyword NameLoad Expr Call NameLoad Call NameLoad Call AttributeLoad NameLoad attr Call NameLoad ListLoad Str Str decorator_list decorator_list
N/A sqlalchemy exc exceptions select MetaData Integer or_ bindparam sqlalchemy.engine default sqlalchemy.sql table column sqlalchemy.sql.elements _truncated_label sqlalchemy.testing AssertsCompiledSQL assert_raises engines fixtures eq_ sqlalchemy.testing.schema Table Column N/A IDENT_LENGTH 29 MaxIdentTest N/A N/A fixtures TestBase AssertsCompiledSQL N/A N/A __dialect__ DefaultDialect N/A table1 N/A table some_large_named_table N/A column this_is_the_primarykey_column N/A column this_is_the_data_column N/A table2 N/A table table_with_exactly_29_characs N/A column this_is_the_primarykey_column N/A column this_is_the_data_column _length_fixture N/A N/A self length positional N/A IDENT_LENGTH False N/A N/A dialect N/A N/A default DefaultDialect N/A N/A dialect max_identifier_length length N/A positional N/A N/A N/A dialect paramstyle format N/A N/A dialect positional True N/A dialect N/A _engine_fixture N/A N/A self length N/A IDENT_LENGTH N/A N/A eng N/A N/A engines testing_engine N/A N/A N/A eng dialect max_identifier_length length N/A eng N/A test_table_alias_1 N/A N/A self N/A N/A N/A N/A N/A self assert_compile N/A N/A N/A N/A N/A self table2 alias select SELECT table_with_exactly_29_c_1.this_is_the_primarykey_column, table_with_exactly_29_c_1.this_is_the_data_column FROM table_with_exactly_29_characs AS table_with_exactly_29_c_1 dialect N/A N/A self _length_fixture N/A test_table_alias_2 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A table2 N/A self table2 N/A ta N/A N/A table2 alias N/A on N/A N/A N/A table1 c this_is_the_data_column N/A N/A ta c this_is_the_data_column N/A N/A N/A self assert_compile N/A N/A N/A N/A N/A select N/A table1 ta select_from N/A N/A table1 join ta on where N/A N/A N/A ta c this_is_the_data_column data3 SELECT some_large_named_table.this_is_the_primarykey_column, some_large_named_table.this_is_the_data_column, table_with_exactly_29_c_1.this_is_the_primarykey_column, table_with_exactly_29_c_1.this_is_the_data_column FROM some_large_named_table JOIN table_with_exactly_29_characs AS table_with_exactly_29_c_1 ON some_large_named_table.this_is_the_data_column = table_with_exactly_29_c_1.this_is_the_data_column WHERE table_with_exactly_29_c_1.this_is_the_data_column = :this_is_the_data_column_1 dialect N/A N/A self _length_fixture N/A test_too_long_name_disallowed N/A N/A self N/A N/A N/A m N/A MetaData N/A t N/A Table this_name_is_too_long_for_what_were_doing_in_this_test m N/A Column foo Integer N/A eng N/A N/A self _engine_fixture N/A methods N/A N/A t create N/A t drop N/A m create_all N/A m drop_all N/A meth methods N/A N/A N/A assert_raises N/A exceptions IdentifierError meth eng N/A _assert_labeled_table1_select N/A N/A self s N/A N/A N/A table1 N/A self table1 N/A compiled N/A N/A s compile dialect N/A N/A self _length_fixture N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A some_large_named_table__2 N/A 1 issuperset N/A some_large_named_table_this_is_the_data_column some_large_named_table__2 N/A N/A table1 c this_is_the_data_column N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A some_large_named_table__1 N/A 1 issuperset N/A some_large_named_table_this_is_the_primarykey_column some_large_named_table__1 N/A N/A table1 c this_is_the_primarykey_column N/A test_result_map_use_labels N/A N/A self N/A N/A N/A table1 N/A self table1 N/A s N/A N/A N/A N/A N/A N/A table1 select apply_labels order_by N/A N/A table1 c this_is_the_primarykey_column N/A N/A N/A self _assert_labeled_table1_select s N/A test_result_map_limit N/A N/A self N/A N/A N/A table1 N/A self table1 N/A s N/A N/A N/A N/A table1 select use_labels True order_by N/A N/A N/A table1 c this_is_the_primarykey_column limit 2 N/A N/A N/A self _assert_labeled_table1_select s N/A test_result_map_subquery N/A N/A self N/A N/A N/A table1 N/A self table1 N/A s N/A N/A N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 alias foo N/A s2 N/A select N/A s N/A compiled N/A N/A s2 compile dialect N/A N/A self _length_fixture N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A this_is_the_data_column N/A 1 issuperset N/A this_is_the_data_column N/A N/A s c this_is_the_data_column N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A this_is_the_primarykey__1 N/A 1 issuperset N/A this_is_the_primarykey_column this_is_the_primarykey__1 N/A N/A s c this_is_the_primarykey_column N/A test_result_map_anon_alias N/A N/A self N/A N/A N/A table1 N/A self table1 N/A dialect N/A N/A self _length_fixture N/A q N/A N/A N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 alias N/A s N/A N/A N/A select N/A q apply_labels N/A N/A N/A self assert_compile s SELECT anon_1.this_is_the_primarykey__2 AS anon_1_this_is_the_prim_1, anon_1.this_is_the_data_column AS anon_1_this_is_the_data_3 FROM (SELECT some_large_named_table.this_is_the_primarykey_column AS this_is_the_primarykey__2, some_large_named_table.this_is_the_data_column AS this_is_the_data_column FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = :this_is_the_primarykey__1) AS anon_1 dialect dialect N/A compiled N/A N/A s compile dialect dialect N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A anon_1_this_is_the_data_3 N/A 1 issuperset N/A anon_1_this_is_the_data_3 N/A N/A q corresponding_column N/A N/A table1 c this_is_the_data_column N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A anon_1_this_is_the_prim_1 N/A 1 issuperset N/A anon_1_this_is_the_prim_1 N/A N/A q corresponding_column N/A N/A table1 c this_is_the_primarykey_column N/A test_column_bind_labels_1 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A s N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 N/A N/A N/A self assert_compile s SELECT some_large_named_table.this_is_the_primarykey_column, some_large_named_table.this_is_the_data_column FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = :this_is_the_primarykey__1 checkparams N/A this_is_the_primarykey__1 4 dialect N/A N/A self _length_fixture N/A N/A N/A self assert_compile s SELECT some_large_named_table.this_is_the_primarykey_column, some_large_named_table.this_is_the_data_column FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = %s checkpositional N/A 4 checkparams N/A this_is_the_primarykey__1 4 dialect N/A N/A self _length_fixture positional True N/A test_column_bind_labels_2 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A s N/A N/A table1 select N/A or_ N/A N/A N/A table1 c this_is_the_primarykey_column 4 N/A N/A N/A table1 c this_is_the_primarykey_column 2 N/A N/A N/A self assert_compile s SELECT some_large_named_table.this_is_the_primarykey_column, some_large_named_table.this_is_the_data_column FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = :this_is_the_primarykey__1 OR some_large_named_table.this_is_the_primarykey_column = :this_is_the_primarykey__2 checkparams N/A this_is_the_primarykey__1 this_is_the_primarykey__2 4 2 dialect N/A N/A self _length_fixture N/A N/A N/A self assert_compile s SELECT some_large_named_table.this_is_the_primarykey_column, some_large_named_table.this_is_the_data_column FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = %s OR some_large_named_table.this_is_the_primarykey_column = %s checkparams N/A this_is_the_primarykey__1 this_is_the_primarykey__2 4 2 checkpositional N/A 4 2 dialect N/A N/A self _length_fixture positional True N/A test_bind_param_non_truncated N/A N/A self N/A N/A N/A table1 N/A self table1 N/A stmt N/A N/A N/A N/A table1 insert values this_is_the_data_column N/A bindparam this_is_the_long_bindparam_name N/A compiled N/A N/A stmt compile dialect N/A N/A self _length_fixture length 10 N/A N/A eq_ N/A N/A compiled construct_params params N/A this_is_the_long_bindparam_name 5 N/A this_is_the_long_bindparam_name 5 N/A test_bind_param_truncated_named N/A N/A self N/A N/A N/A table1 N/A self table1 N/A bp N/A bindparam N/A _truncated_label this_is_the_long_bindparam_name N/A stmt N/A N/A N/A N/A table1 insert values this_is_the_data_column bp N/A compiled N/A N/A stmt compile dialect N/A N/A self _length_fixture length 10 N/A N/A eq_ N/A N/A compiled construct_params params N/A this_is_the_long_bindparam_name 5 N/A this_1 5 N/A test_bind_param_truncated_positional N/A N/A self N/A N/A N/A table1 N/A self table1 N/A bp N/A bindparam N/A _truncated_label this_is_the_long_bindparam_name N/A stmt N/A N/A N/A N/A table1 insert values this_is_the_data_column bp N/A compiled N/A N/A stmt compile dialect N/A N/A self _length_fixture length 10 positional True N/A N/A eq_ N/A N/A compiled construct_params params N/A this_is_the_long_bindparam_name 5 N/A this_1 5 N/A N/A LabelLengthTest N/A N/A fixtures TestBase AssertsCompiledSQL N/A N/A __dialect__ DefaultDialect N/A table1 N/A table some_large_named_table N/A column this_is_the_primarykey_column N/A column this_is_the_data_column N/A table2 N/A table table_with_exactly_29_characs N/A column this_is_the_primarykey_column N/A column this_is_the_data_column test_adjustable_1 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A q N/A N/A N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 alias foo N/A x N/A select N/A q N/A compile_dialect N/A N/A default DefaultDialect label_length 10 N/A N/A N/A self assert_compile x SELECT foo.this_1, foo.this_2 FROM (SELECT some_large_named_table.this_is_the_primarykey_column AS this_1, some_large_named_table.this_is_the_data_column AS this_2 FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = :this_1) AS foo dialect compile_dialect N/A test_adjustable_2 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A q N/A N/A N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 alias foo N/A x N/A select N/A q N/A compile_dialect N/A N/A default DefaultDialect label_length 10 N/A N/A N/A self assert_compile x SELECT foo.this_1, foo.this_2 FROM (SELECT some_large_named_table.this_is_the_primarykey_column AS this_1, some_large_named_table.this_is_the_data_column AS this_2 FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = :this_1) AS foo dialect compile_dialect N/A test_adjustable_3 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A compile_dialect N/A N/A default DefaultDialect label_length 4 N/A q N/A N/A N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 alias foo N/A x N/A select N/A q N/A N/A N/A self assert_compile x SELECT foo._1, foo._2 FROM (SELECT some_large_named_table.this_is_the_primarykey_column AS _1, some_large_named_table.this_is_the_data_column AS _2 FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = :_1) AS foo dialect compile_dialect N/A test_adjustable_4 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A q N/A N/A N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 alias N/A x N/A select N/A q use_labels True N/A compile_dialect N/A N/A default DefaultDialect label_length 10 N/A N/A N/A self assert_compile x SELECT anon_1.this_2 AS anon_1, anon_1.this_4 AS anon_3 FROM (SELECT some_large_named_table.this_is_the_primarykey_column AS this_2, some_large_named_table.this_is_the_data_column AS this_4 FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = :this_1) AS anon_1 dialect compile_dialect N/A test_adjustable_5 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A q N/A N/A N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 alias N/A x N/A select N/A q use_labels True N/A compile_dialect N/A N/A default DefaultDialect label_length 4 N/A N/A N/A self assert_compile x SELECT _1._2 AS _1, _1._4 AS _3 FROM (SELECT some_large_named_table.this_is_the_primarykey_column AS _2, some_large_named_table.this_is_the_data_column AS _4 FROM some_large_named_table WHERE some_large_named_table.this_is_the_primarykey_column = :_1) AS _1 dialect compile_dialect N/A test_adjustable_result_schema_column_1 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A q N/A N/A N/A N/A N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 apply_labels alias foo N/A dialect N/A N/A default DefaultDialect label_length 10 N/A compiled N/A N/A q compile dialect dialect N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A some_2 N/A 1 issuperset N/A N/A N/A table1 c this_is_the_data_column some_large_named_table_this_is_the_data_column some_2 N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A some_1 N/A 1 issuperset N/A N/A N/A table1 c this_is_the_primarykey_column some_large_named_table_this_is_the_primarykey_column some_1 N/A test_adjustable_result_schema_column_2 N/A N/A self N/A N/A N/A table1 N/A self table1 N/A q N/A N/A N/A N/A table1 select N/A N/A N/A table1 c this_is_the_primarykey_column 4 alias foo N/A x N/A select N/A q N/A dialect N/A N/A default DefaultDialect label_length 10 N/A compiled N/A N/A x compile dialect dialect N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A this_2 N/A 1 issuperset N/A N/A N/A q corresponding_column N/A N/A table1 c this_is_the_data_column this_is_the_data_column this_2 N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A this_1 N/A 1 issuperset N/A N/A N/A q corresponding_column N/A N/A table1 c this_is_the_primarykey_column this_is_the_primarykey_column this_1 N/A test_table_plus_column_exceeds_length N/A N/A self N/A N/A N/A test that the truncation only occurs when tablename + colname are
        concatenated, if they are individually under the label length.

         N/A compile_dialect N/A N/A default DefaultDialect label_length 30 N/A a_table N/A table thirty_characters_table_xxxxxx N/A column id N/A other_table N/A table other_thirty_characters_table_ N/A column id N/A column thirty_characters_table_id N/A anon N/A N/A a_table alias N/A j1 N/A N/A other_table outerjoin anon N/A N/A N/A anon c id N/A N/A other_table c thirty_characters_table_id N/A N/A N/A self assert_compile N/A N/A N/A N/A N/A select N/A other_table anon select_from j1 apply_labels SELECT other_thirty_characters_table_.id AS other_thirty_characters__1, other_thirty_characters_table_.thirty_characters_table_id AS other_thirty_characters__2, thirty_characters_table__1.id AS thirty_characters_table__3 FROM other_thirty_characters_table_ LEFT OUTER JOIN thirty_characters_table_xxxxxx AS thirty_characters_table__1 ON thirty_characters_table__1.id = other_thirty_characters_table_.thirty_characters_table_id dialect compile_dialect N/A test_colnames_longer_than_labels_lowercase N/A N/A self N/A N/A N/A t1 N/A table a N/A column abcde N/A N/A N/A self _test_colnames_longer_than_labels t1 N/A test_colnames_longer_than_labels_uppercase N/A N/A self N/A N/A N/A m N/A MetaData N/A t1 N/A Table a m N/A Column abcde Integer N/A N/A N/A self _test_colnames_longer_than_labels t1 N/A _test_colnames_longer_than_labels N/A N/A self t1 N/A N/A N/A dialect N/A N/A default DefaultDialect label_length 4 N/A a1 N/A N/A t1 alias name asdf N/A s N/A select N/A a1 N/A N/A N/A self assert_compile N/A select N/A a1 SELECT asdf.abcde FROM a AS asdf dialect dialect N/A compiled N/A N/A s compile dialect dialect N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A abcde N/A 1 issuperset N/A abcde N/A N/A a1 c abcde abcde N/A s N/A N/A N/A select N/A a1 apply_labels N/A N/A N/A self assert_compile s SELECT asdf.abcde AS _1 FROM a AS asdf dialect dialect N/A compiled N/A N/A s compile dialect dialect N/A N/A N/A N/A set N/A N/A N/A N/A compiled _create_result_map N/A _1 N/A 1 issuperset N/A asdf_abcde N/A N/A a1 c abcde _1 N/A test_label_overlap_unlabeled N/A N/A self N/A N/A N/A test that an anon col can't overlap with a fixed name, #3396 N/A table1 N/A table tablename N/A column columnname_one N/A column columnn_1 N/A stmt N/A N/A N/A select N/A table1 apply_labels N/A dialect N/A N/A default DefaultDialect label_length 23 N/A N/A N/A self assert_compile stmt SELECT tablename.columnname_one AS tablename_columnn_1, tablename.columnn_1 AS tablename_columnn_2 FROM tablename dialect dialect N/A compiled N/A N/A stmt compile dialect dialect N/A N/A eq_ N/A set N/A N/A compiled _create_result_map N/A set N/A tablename_columnn_1 tablename_columnn_2 N/A N/A