Module ImportFrom alias alias ImportFrom alias ImportFrom alias alias ImportFrom alias ImportFrom alias ImportFrom alias alias ImportFrom alias ImportFrom alias alias alias alias alias alias alias alias alias alias alias alias alias alias alias alias alias ClassDef bases AttributeLoad NameLoad attr NameLoad body Assign NameStore Call AttributeLoad NameLoad attr FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad NameLoad attr attr NameLoad Str Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad keyword Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad NameLoad attr attr NameLoad Str Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr NameLoad CompareEq AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr attr attr NameLoad Str Expr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Str Call NameLoad keyword Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str For NameStore TupleLoad NameLoad NameLoad body For NameStore TupleLoad Str Str body Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword Str attr Str keyword NameLoad keyword NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str For NameStore TupleLoad NameLoad NameLoad body For NameStore TupleLoad Str Str body Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Str attr keyword Str attr Str keyword NameLoad keyword NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Str attr keyword Str attr Str Str Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str For NameStore TupleLoad NameLoad NameLoad body For NameStore TupleLoad Str Str body Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Str attr Str keyword NameLoad keyword NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Str attr Str keyword Str Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Assign NameStore Call NameLoad Str Call NameLoad Str For NameStore TupleLoad Str Str body Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr attr keyword Str attr Str keyword NameLoad keyword NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad keyword Str Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad AttributeLoad AttributeLoad NameLoad attr attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr attr Expr Call AttributeLoad NameLoad attr NameLoad Str Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr keyword AttributeLoad AttributeLoad NameLoad attr attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Expr Str ImportFrom alias Assign NameStore Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad Assign NameStore Call NameLoad Str Call NameLoad Str For TupleStore NameStore NameStore ListLoad TupleLoad Call NameLoad ListLoad Call NameLoad Str Call NameLoad Str Str TupleLoad Call AttributeLoad Call NameLoad ListLoad NameLoad attr Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr ListLoad Str Str Str Str TupleLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr ListLoad NameLoad Str body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad keyword NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call NameLoad Str Call NameLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad NameLoad attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad NameLoad attr attr CompareNotEq AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad NameLoad attr Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Str decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad Call NameLoad ListLoad AttributeLoad AttributeLoad NameLoad attr attr keyword ListLoad AttributeLoad AttributeLoad NameLoad attr attr attr Str Assign NameStore CompareEq AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr Call NameLoad ListLoad Str NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad keyword NameLoad keyword Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Str Assign NameStore Call AttributeLoad Call NameLoad ListLoad AttributeLoad AttributeLoad NameLoad attr attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad NameLoad attr attr Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad keyword NameLoad keyword Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Str Assign NameStore Call AttributeLoad Call NameLoad ListLoad AttributeLoad AttributeLoad NameLoad attr attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad NameLoad attr attr Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad keyword NameLoad keyword Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Str Assign NameStore Call AttributeLoad Call NameLoad ListLoad AttributeLoad AttributeLoad NameLoad attr attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad NameLoad attr attr Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad keyword NameLoad keyword Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Str Assign NameStore Call AttributeLoad Call NameLoad ListLoad AttributeLoad AttributeLoad NameLoad attr attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad NameLoad attr attr Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str Call NameLoad Str Call NameLoad Str Call NameLoad Str Assign NameStore Call NameLoad Str Call NameLoad Str Call NameLoad Str Call NameLoad Str Call NameLoad Str Assign TupleStore NameStore NameStore TupleLoad Call NameLoad ListLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Str Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Str Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr ListLoad Str Str Call NameLoad ListLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Str Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Str Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr ListLoad Str Str Assign NameStore Call NameLoad NameLoad NameLoad keyword ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad Call AttributeLoad NameLoad attr Str attr Str decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Num Num Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad ListLoad Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Str decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Num Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str For NameStore TupleLoad Str Str Str body Expr Call AttributeLoad NameLoad attr Call NameLoad ListLoad Call NameLoad NameLoad AttributeLoad AttributeLoad NameLoad attr attr BinOpMod Str NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str Call NameLoad Num Call NameLoad Str Call NameLoad Num Assign NameStore Call AttributeLoad Call NameLoad NameLoad keyword Call NameLoad keyword Str attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Str Assign NameStore Call AttributeLoad Call NameLoad NameLoad keyword Call NameLoad keyword Str attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Str Assign NameStore Call AttributeLoad Call AttributeLoad Call NameLoad NameLoad keyword Call NameLoad keyword Str attr NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Str Expr Call AttributeLoad NameLoad attr NameLoad Str Assign NameStore Call AttributeLoad Call NameLoad NameLoad keyword Call NameLoad keyword Str attr Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str Call NameLoad Num Call NameLoad Str Call NameLoad Num Assign NameStore Call AttributeLoad Call NameLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Str Assign NameStore Call AttributeLoad Call AttributeLoad Call NameLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Str attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str Call NameLoad Num Call NameLoad Str Call NameLoad Num Assign NameStore Call AttributeLoad Call NameLoad NameLoad keyword Call NameLoad keyword Str attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Str Assign NameStore Call AttributeLoad Call NameLoad NameLoad keyword Call NameLoad keyword Str attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Str Assign NameStore Call AttributeLoad Call NameLoad NameLoad keyword Call NameLoad keyword Str attr Call AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr AttributeLoad AttributeLoad NameLoad attr attr attr Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr AttributeLoad AttributeLoad NameLoad attr attr attr Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Num Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr Expr Call NameLoad Call NameLoad AttributeLoad NameLoad attr Num Assert CompareIn AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr AttributeLoad AttributeLoad NameLoad attr attr attr Num For NameStore Call NameLoad Num body Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Str Num Num Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr Expr Call NameLoad Call NameLoad AttributeLoad NameLoad attr Num Assert CompareIn AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr AttributeLoad AttributeLoad NameLoad attr attr attr Num attr Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Str Str Num Num Num Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr Expr Call NameLoad Call NameLoad AttributeLoad NameLoad attr Num Assert CompareIn AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num Assert CompareIn AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore ListLoad AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Str Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Str AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad Call AttributeLoad Call NameLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr AttributeLoad AttributeLoad NameLoad attr attr attr Num attr Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Str Str Num Num Num Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr Expr Call NameLoad Call NameLoad AttributeLoad NameLoad attr Num Assign NameStore Call AttributeLoad NameLoad attr For NameStore NameLoad body Expr Call NameLoad SubscriptLoad SubscriptLoad SubscriptLoad NameLoad Index AttributeLoad NameLoad attr Index Num Index Num NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad AttributeLoad AttributeLoad NameLoad attr attr attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr attr Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr NameLoad attr Num attr Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Str Str Num Num Num Assign NameStore Call AttributeLoad NameLoad attr keyword Call AttributeLoad NameLoad attr Expr Call NameLoad Call NameLoad AttributeLoad NameLoad attr Num Assert CompareIn AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num Assert CompareIn AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Str Index Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call AttributeLoad Call AttributeLoad Call AttributeLoad Call AttributeLoad Call NameLoad ListLoad NameLoad attr CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num attr AttributeLoad AttributeLoad NameLoad attr attr attr Num attr Num Expr Call AttributeLoad NameLoad attr NameLoad Str keyword Dict Str Num decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str Num keyword NameLoad Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad keyword NameLoad Call NameLoad Str NameLoad keyword NameLoad Call NameLoad Str Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad keyword NameLoad Call NameLoad Str NameLoad keyword NameLoad Call NameLoad Str Call NameLoad Str keyword NameLoad Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad Str 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 NameLoad Str AttributeLoad AttributeLoad NameLoad attr attr keyword NameLoad Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call NameLoad Str Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad Str 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 Call AttributeLoad NameLoad attr Call NameLoad Str CompareGt AttributeLoad AttributeLoad NameLoad attr attr Num Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad keyword Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Call NameLoad Str AttributeLoad AttributeLoad NameLoad attr attr Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call NameLoad Str AttributeLoad AttributeLoad NameLoad attr attr keyword ListLoad Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad Str decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign NameStore Call NameLoad Str AttributeLoad AttributeLoad NameLoad attr attr keyword ListLoad AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad Str decorator_list decorator_list ClassDef bases AttributeLoad NameLoad attr body FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad Str Call NameLoad Call NameLoad Str NameLoad Call NameLoad Str NameLoad Assign AttributeStore NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Call NameLoad Str Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad Expr Call NameLoad Str Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad Expr Call NameLoad Str Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad Expr Call NameLoad Str Call AttributeLoad NameLoad attr decorator_list decorator_list
N/A sqlalchemy.testing eq_ is_ sqlalchemy schema sqlalchemy.sql table column sqlalchemy.databases mssql sqlalchemy.dialects.mssql mxodbc sqlalchemy.testing fixtures AssertsCompiledSQL sqlalchemy sql sqlalchemy Integer String Table Column select MetaData update delete insert extract union func PrimaryKeyConstraint UniqueConstraint Index Sequence literal CompileTest N/A N/A fixtures TestBase AssertsCompiledSQL N/A N/A __dialect__ N/A N/A mssql dialect test_true_false N/A N/A self N/A N/A N/A N/A N/A self assert_compile N/A N/A sql false 0 N/A N/A N/A self assert_compile N/A N/A sql true 1 N/A test_select N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A N/A N/A self assert_compile N/A N/A t select SELECT sometable.somecolumn FROM sometable N/A test_select_with_nolock N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A N/A N/A self assert_compile N/A N/A N/A N/A t select with_hint t WITH (NOLOCK) SELECT sometable.somecolumn FROM sometable WITH (NOLOCK) N/A test_select_with_nolock_schema N/A N/A self N/A N/A N/A m N/A MetaData N/A t N/A Table sometable m N/A Column somecolumn Integer schema test_schema N/A N/A N/A self assert_compile N/A N/A N/A N/A t select with_hint t WITH (NOLOCK) SELECT test_schema.sometable.somecolumn FROM test_schema.sometable WITH (NOLOCK) N/A test_join_with_hint N/A N/A self N/A N/A N/A t1 N/A table t1 N/A column a Integer N/A column b String N/A column c String N/A t2 N/A table t2 N/A column a Integer N/A column b Integer N/A column c Integer N/A join N/A N/A N/A N/A N/A N/A t1 join t2 N/A N/A N/A t1 c a N/A N/A t2 c a select with_hint t1 WITH (NOLOCK) N/A N/A N/A self assert_compile join SELECT t1.a, t1.b, t1.c, t2.a, t2.b, t2.c FROM t1 WITH (NOLOCK) JOIN t2 ON t1.a = t2.a N/A test_insert N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A N/A N/A self assert_compile N/A N/A t insert INSERT INTO sometable (somecolumn) VALUES (:somecolumn) N/A test_update N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A N/A N/A self assert_compile N/A N/A t update N/A N/A N/A t c somecolumn 7 UPDATE sometable SET somecolumn=:somecolumn WHERE sometable.somecolumn = :somecolumn_1 N/A dict somecolumn 10 N/A test_insert_hint N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A targ N/A None t N/A N/A darg N/A * mssql N/A N/A N/A N/A self assert_compile N/A N/A N/A N/A N/A N/A t insert values somecolumn x with_hint WITH (PAGLOCK) selectable targ dialect_name darg INSERT INTO sometable WITH (PAGLOCK) (somecolumn) VALUES (:somecolumn) N/A test_update_hint N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A targ N/A None t N/A N/A darg N/A * mssql N/A N/A N/A N/A self assert_compile N/A N/A N/A N/A N/A N/A N/A N/A t update where N/A N/A N/A t c somecolumn q values somecolumn x with_hint WITH (PAGLOCK) selectable targ dialect_name darg UPDATE sometable WITH (PAGLOCK) SET somecolumn=:somecolumn WHERE sometable.somecolumn = :somecolumn_1 N/A test_update_exclude_hint N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A N/A N/A self assert_compile N/A N/A N/A N/A N/A N/A N/A N/A t update where N/A N/A N/A t c somecolumn q values somecolumn x with_hint XYZ mysql UPDATE sometable SET somecolumn=:somecolumn WHERE sometable.somecolumn = :somecolumn_1 N/A test_delete_hint N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A targ N/A None t N/A N/A darg N/A * mssql N/A N/A N/A N/A self assert_compile N/A N/A N/A N/A N/A N/A t delete where N/A N/A N/A t c somecolumn q with_hint WITH (PAGLOCK) selectable targ dialect_name darg DELETE FROM sometable WITH (PAGLOCK) WHERE sometable.somecolumn = :somecolumn_1 N/A test_delete_exclude_hint N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A N/A N/A self assert_compile N/A N/A N/A N/A N/A N/A t delete where N/A N/A N/A t c somecolumn q with_hint XYZ dialect_name mysql DELETE FROM sometable WHERE sometable.somecolumn = :somecolumn_1 N/A test_update_from_hint N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A t2 N/A table othertable N/A column somecolumn N/A darg N/A * mssql N/A N/A N/A N/A self assert_compile N/A N/A N/A N/A N/A N/A N/A N/A t update where N/A N/A N/A t c somecolumn N/A N/A t2 c somecolumn values somecolumn x with_hint WITH (PAGLOCK) selectable t2 dialect_name darg UPDATE sometable SET somecolumn=:somecolumn FROM sometable, othertable WITH (PAGLOCK) WHERE sometable.somecolumn = othertable.somecolumn N/A test_update_to_select_schema N/A N/A self N/A N/A N/A meta N/A MetaData N/A table N/A Table sometable meta N/A Column sym String N/A Column val Integer schema schema N/A other N/A Table #other meta N/A Column sym String N/A Column newval Integer N/A stmt N/A N/A N/A N/A table update values val N/A N/A N/A N/A N/A select N/A N/A N/A other c newval where N/A N/A N/A table c sym N/A N/A other c sym as_scalar N/A N/A N/A self assert_compile stmt UPDATE [schema].sometable SET val=(SELECT [#other].newval FROM [#other] WHERE [schema].sometable.sym = [#other].sym) N/A stmt N/A N/A N/A N/A N/A N/A table update values val N/A N/A other c newval where N/A N/A N/A table c sym N/A N/A other c sym N/A N/A N/A self assert_compile stmt UPDATE [schema].sometable SET val=[#other].newval FROM [schema].sometable, [#other] WHERE [schema].sometable.sym = [#other].sym N/A test_strict_binds N/A N/A self N/A N/A N/A test the 'strict' compiler binds. sqlalchemy.dialects.mssql.base MSSQLStrictCompiler N/A mxodbc_dialect N/A N/A mxodbc dialect N/A N/A mxodbc_dialect statement_compiler MSSQLStrictCompiler N/A t N/A table sometable N/A column foo N/A N/A expr compile N/A N/A N/A select N/A N/A literal x N/A literal y SELECT 'x' AS anon_1, 'y' AS anon_2 N/A N/A N/A N/A select N/A t where N/A N/A N/A N/A t c foo in_ N/A x y z SELECT sometable.foo FROM sometable WHERE sometable.foo IN ('x', 'y', 'z') N/A N/A N/A N/A N/A t c foo in_ N/A None sometable.foo IN (NULL) N/A N/A N/A N/A self assert_compile expr compile dialect mxodbc_dialect N/A test_in_with_subqueries N/A N/A self N/A N/A N/A Test removal of legacy behavior that converted "x==subquery"
        to use IN.

         N/A t N/A table sometable N/A column somecolumn N/A N/A N/A self assert_compile N/A N/A N/A N/A t select where N/A N/A N/A t c somecolumn N/A N/A t select SELECT sometable.somecolumn FROM sometable WHERE sometable.somecolumn = (SELECT sometable.somecolumn FROM sometable) N/A N/A N/A self assert_compile N/A N/A N/A N/A t select where N/A N/A N/A t c somecolumn N/A N/A t select SELECT sometable.somecolumn FROM sometable WHERE sometable.somecolumn != (SELECT sometable.somecolumn FROM sometable) N/A test_count N/A N/A self N/A N/A N/A t N/A table sometable N/A column somecolumn N/A N/A N/A self assert_compile N/A N/A t count SELECT count(sometable.somecolumn) AS tbl_row_count FROM sometable N/A test_noorderby_insubquery N/A N/A self N/A N/A N/A test that the ms-sql dialect removes ORDER BY clauses from
        subqueries N/A table1 N/A table mytable N/A column myid Integer N/A column name String N/A column description String N/A q N/A N/A N/A select N/A N/A N/A table1 c myid order_by N/A N/A N/A table1 c myid alias foo N/A crit N/A N/A N/A q c myid N/A N/A table1 c myid N/A N/A N/A self assert_compile N/A select N/A * crit SELECT * FROM (SELECT mytable.myid AS myid FROM mytable) AS foo, mytable WHERE foo.myid = mytable.myid N/A test_delete_schema N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column id Integer primary_key True schema paj N/A N/A N/A self assert_compile N/A N/A tbl delete N/A N/A N/A tbl c id 1 DELETE FROM paj.test WHERE paj.test.id = :id_1 N/A s N/A N/A N/A select N/A N/A N/A tbl c id where N/A N/A N/A tbl c id 1 N/A N/A N/A self assert_compile N/A N/A N/A N/A tbl delete where N/A N/A N/A N/A tbl c id in_ s DELETE FROM paj.test WHERE paj.test.id IN (SELECT paj.test.id FROM paj.test WHERE paj.test.id = :id_1) N/A test_delete_schema_multipart N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column id Integer primary_key True schema banana.paj N/A N/A N/A self assert_compile N/A N/A tbl delete N/A N/A N/A tbl c id 1 DELETE FROM banana.paj.test WHERE banana.paj.test.id = :id_1 N/A s N/A N/A N/A select N/A N/A N/A tbl c id where N/A N/A N/A tbl c id 1 N/A N/A N/A self assert_compile N/A N/A N/A N/A tbl delete where N/A N/A N/A N/A tbl c id in_ s DELETE FROM banana.paj.test WHERE banana.paj.test.id IN (SELECT banana.paj.test.id FROM banana.paj.test WHERE banana.paj.test.id = :id_1) N/A test_delete_schema_multipart_needs_quoting N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column id Integer primary_key True schema banana split.paj N/A N/A N/A self assert_compile N/A N/A tbl delete N/A N/A N/A tbl c id 1 DELETE FROM [banana split].paj.test WHERE [banana split].paj.test.id = :id_1 N/A s N/A N/A N/A select N/A N/A N/A tbl c id where N/A N/A N/A tbl c id 1 N/A N/A N/A self assert_compile N/A N/A N/A N/A tbl delete where N/A N/A N/A N/A tbl c id in_ s DELETE FROM [banana split].paj.test WHERE [banana split].paj.test.id IN (SELECT [banana split].paj.test.id FROM [banana split].paj.test WHERE [banana split].paj.test.id = :id_1) N/A test_delete_schema_multipart_both_need_quoting N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column id Integer primary_key True schema banana split.paj with a space N/A N/A N/A self assert_compile N/A N/A tbl delete N/A N/A N/A tbl c id 1 DELETE FROM [banana split].[paj with a space].test WHERE [banana split].[paj with a space].test.id = :id_1 N/A s N/A N/A N/A select N/A N/A N/A tbl c id where N/A N/A N/A tbl c id 1 N/A N/A N/A self assert_compile N/A N/A N/A N/A tbl delete where N/A N/A N/A N/A tbl c id in_ s DELETE FROM [banana split].[paj with a space].test WHERE [banana split].[paj with a space].test.id IN (SELECT [banana split].[paj with a space].test.id FROM [banana split].[paj with a space].test WHERE [banana split].[paj with a space].test.id = :id_1) N/A test_union N/A N/A self N/A N/A N/A t1 N/A table t1 N/A column col1 N/A column col2 N/A column col3 N/A column col4 N/A t2 N/A table t2 N/A column col1 N/A column col2 N/A column col3 N/A column col4 N/A N/A s1 s2 N/A N/A select N/A N/A N/A N/A N/A t1 c col3 label col3 N/A N/A N/A N/A t1 c col4 label col4 N/A N/A N/A N/A t1 c col2 in_ N/A t1col2r1 t1col2r2 N/A select N/A N/A N/A N/A N/A t2 c col3 label col3 N/A N/A N/A N/A t2 c col4 label col4 N/A N/A N/A N/A t2 c col2 in_ N/A t2col2r2 t2col2r3 N/A u N/A union s1 s2 order_by N/A col3 col4 N/A N/A N/A self assert_compile u SELECT t1.col3 AS col3, t1.col4 AS col4 FROM t1 WHERE t1.col2 IN (:col2_1, :col2_2) UNION SELECT t2.col3 AS col3, t2.col4 AS col4 FROM t2 WHERE t2.col2 IN (:col2_3, :col2_4) ORDER BY col3, col4 N/A N/A N/A self assert_compile N/A N/A N/A N/A u alias bar select SELECT bar.col3, bar.col4 FROM (SELECT t1.col3 AS col3, t1.col4 AS col4 FROM t1 WHERE t1.col2 IN (:col2_1, :col2_2) UNION SELECT t2.col3 AS col3, t2.col4 AS col4 FROM t2 WHERE t2.col2 IN (:col2_3, :col2_4)) AS bar N/A test_function N/A N/A self N/A N/A N/A N/A N/A self assert_compile N/A N/A func foo 1 2 foo(:foo_1, :foo_2) N/A N/A N/A self assert_compile N/A N/A func current_time CURRENT_TIME N/A N/A N/A self assert_compile N/A N/A func foo foo() N/A m N/A MetaData N/A t N/A Table sometable m N/A Column col1 Integer N/A Column col2 Integer N/A N/A N/A self assert_compile N/A select N/A N/A N/A func max N/A N/A t c col1 SELECT max(sometable.col1) AS max_1 FROM sometable N/A test_function_overrides N/A N/A self N/A N/A N/A N/A N/A self assert_compile N/A N/A func current_date GETDATE() N/A N/A N/A self assert_compile N/A N/A func length 3 LEN(:length_1) N/A test_extract N/A N/A self N/A N/A N/A t N/A table t N/A column col1 N/A field N/A day month year N/A N/A N/A N/A self assert_compile N/A select N/A N/A extract field N/A N/A t c col1 N/A SELECT DATEPART(%s, t.col1) AS anon_1 FROM t field N/A test_update_returning N/A N/A self N/A N/A N/A table1 N/A table mytable N/A column myid Integer N/A column name N/A String 128 N/A column description N/A String 128 N/A u N/A N/A N/A update table1 values N/A dict name foo returning N/A N/A table1 c myid N/A N/A table1 c name N/A N/A N/A self assert_compile u UPDATE mytable SET name=:name OUTPUT inserted.myid, inserted.name N/A u N/A N/A N/A update table1 values N/A dict name foo returning table1 N/A N/A N/A self assert_compile u UPDATE mytable SET name=:name OUTPUT inserted.myid, inserted.name, inserted.description N/A u N/A N/A N/A N/A N/A update table1 values N/A dict name foo returning table1 where N/A N/A N/A table1 c name bar N/A N/A N/A self assert_compile u UPDATE mytable SET name=:name OUTPUT inserted.myid, inserted.name, inserted.description WHERE mytable.name = :name_1 N/A u N/A N/A N/A update table1 values N/A dict name foo returning N/A N/A func length N/A N/A table1 c name N/A N/A N/A self assert_compile u UPDATE mytable SET name=:name OUTPUT LEN(inserted.name) AS length_1 N/A test_delete_returning N/A N/A self N/A N/A N/A table1 N/A table mytable N/A column myid Integer N/A column name N/A String 128 N/A column description N/A String 128 N/A d N/A N/A N/A delete table1 returning N/A N/A table1 c myid N/A N/A table1 c name N/A N/A N/A self assert_compile d DELETE FROM mytable OUTPUT deleted.myid, deleted.name N/A d N/A N/A N/A N/A N/A delete table1 where N/A N/A N/A table1 c name bar returning N/A N/A table1 c myid N/A N/A table1 c name N/A N/A N/A self assert_compile d DELETE FROM mytable OUTPUT deleted.myid, deleted.name WHERE mytable.name = :name_1 N/A test_insert_returning N/A N/A self N/A N/A N/A table1 N/A table mytable N/A column myid Integer N/A column name N/A String 128 N/A column description N/A String 128 N/A i N/A N/A N/A insert table1 values N/A dict name foo returning N/A N/A table1 c myid N/A N/A table1 c name N/A N/A N/A self assert_compile i INSERT INTO mytable (name) OUTPUT inserted.myid, inserted.name VALUES (:name) N/A i N/A N/A N/A insert table1 values N/A dict name foo returning table1 N/A N/A N/A self assert_compile i INSERT INTO mytable (name) OUTPUT inserted.myid, inserted.name, inserted.description VALUES (:name) N/A i N/A N/A N/A insert table1 values N/A dict name foo returning N/A N/A func length N/A N/A table1 c name N/A N/A N/A self assert_compile i INSERT INTO mytable (name) OUTPUT LEN(inserted.name) AS length_1 VALUES (:name) N/A test_limit_using_top N/A N/A self N/A N/A N/A t N/A table t N/A column x Integer N/A column y Integer N/A s N/A N/A N/A N/A N/A N/A N/A select N/A t where N/A N/A N/A t c x 5 order_by N/A N/A t c y limit 10 N/A N/A N/A self assert_compile s SELECT TOP 10 t.x, t.y FROM t WHERE t.x = :x_1 ORDER BY t.y checkparams N/A x_1 5 N/A test_limit_zero_using_top N/A N/A self N/A N/A N/A t N/A table t N/A column x Integer N/A column y Integer N/A s N/A N/A N/A N/A N/A N/A N/A select N/A t where N/A N/A N/A t c x 5 order_by N/A N/A t c y limit 0 N/A N/A N/A self assert_compile s SELECT TOP 0 t.x, t.y FROM t WHERE t.x = :x_1 ORDER BY t.y checkparams N/A x_1 5 N/A c N/A N/A s compile dialect N/A N/A mssql MSDialect N/A N/A eq_ N/A len N/A c _result_columns 2 N/A N/A N/A N/A t c x N/A set N/A N/A N/A N/A c _create_result_map N/A x N/A 1 N/A test_offset_using_window N/A N/A self N/A N/A N/A t N/A table t N/A column x Integer N/A column y Integer N/A s N/A N/A N/A N/A N/A N/A N/A select N/A t where N/A N/A N/A t c x 5 order_by N/A N/A t c y offset 20 N/A i N/A range 2 N/A N/A N/A N/A self assert_compile s SELECT anon_1.x, anon_1.y FROM (SELECT t.x AS x, t.y AS y, ROW_NUMBER() OVER (ORDER BY t.y) AS mssql_rn FROM t WHERE t.x = :x_1) AS anon_1 WHERE mssql_rn > :param_1 checkparams N/A param_1 x_1 20 5 N/A c N/A N/A s compile dialect N/A N/A mssql MSDialect N/A N/A eq_ N/A len N/A c _result_columns 2 N/A N/A N/A N/A t c x N/A set N/A N/A N/A N/A c _create_result_map N/A x N/A 1 N/A test_limit_offset_using_window N/A N/A self N/A N/A N/A t N/A table t N/A column x Integer N/A column y Integer N/A s N/A N/A N/A N/A N/A N/A N/A N/A N/A select N/A t where N/A N/A N/A t c x 5 order_by N/A N/A t c y limit 10 offset 20 N/A N/A N/A self assert_compile s SELECT anon_1.x, anon_1.y FROM (SELECT t.x AS x, t.y AS y, ROW_NUMBER() OVER (ORDER BY t.y) AS mssql_rn FROM t WHERE t.x = :x_1) AS anon_1 WHERE mssql_rn > :param_1 AND mssql_rn <= :param_2 + :param_1 checkparams N/A param_1 param_2 x_1 20 10 5 N/A c N/A N/A s compile dialect N/A N/A mssql MSDialect N/A N/A eq_ N/A len N/A c _result_columns 2 N/A N/A N/A N/A t c x N/A set N/A N/A N/A N/A c _create_result_map N/A x N/A 1 N/A N/A N/A N/A t c y N/A set N/A N/A N/A N/A c _create_result_map N/A y N/A 1 N/A test_limit_offset_w_ambiguous_cols N/A N/A self N/A N/A N/A t N/A table t N/A column x Integer N/A column y Integer N/A cols N/A N/A N/A t c x N/A N/A N/A N/A t c x label q N/A N/A N/A N/A t c x label p N/A N/A t c y N/A s N/A N/A N/A N/A N/A N/A N/A N/A N/A select cols where N/A N/A N/A t c x 5 order_by N/A N/A t c y limit 10 offset 20 N/A N/A N/A self assert_compile s SELECT anon_1.x, anon_1.q, anon_1.p, anon_1.y FROM (SELECT t.x AS x, t.x AS q, t.x AS p, t.y AS y, ROW_NUMBER() OVER (ORDER BY t.y) AS mssql_rn FROM t WHERE t.x = :x_1) AS anon_1 WHERE mssql_rn > :param_1 AND mssql_rn <= :param_2 + :param_1 checkparams N/A param_1 param_2 x_1 20 10 5 N/A c N/A N/A s compile dialect N/A N/A mssql MSDialect N/A N/A eq_ N/A len N/A c _result_columns 4 N/A result_map N/A N/A c _create_result_map N/A col cols N/A N/A N/A is_ N/A N/A N/A result_map N/A N/A col key N/A 1 N/A 0 col N/A test_limit_offset_with_correlated_order_by N/A N/A self N/A N/A N/A t1 N/A table t1 N/A column x Integer N/A column y Integer N/A t2 N/A table t2 N/A column x Integer N/A column y Integer N/A order_by N/A N/A N/A N/A N/A select N/A N/A N/A t2 c y where N/A N/A N/A t1 c x N/A N/A t2 c x as_scalar N/A s N/A N/A N/A N/A N/A N/A N/A N/A N/A select N/A t1 where N/A N/A N/A t1 c x 5 order_by order_by limit 10 offset 20 N/A N/A N/A self assert_compile s SELECT anon_1.x, anon_1.y FROM (SELECT t1.x AS x, t1.y AS y, ROW_NUMBER() OVER (ORDER BY (SELECT t2.y FROM t2 WHERE t1.x = t2.x)) AS mssql_rn FROM t1 WHERE t1.x = :x_1) AS anon_1 WHERE mssql_rn > :param_1 AND mssql_rn <= :param_2 + :param_1 checkparams N/A param_1 param_2 x_1 20 10 5 N/A c N/A N/A s compile dialect N/A N/A mssql MSDialect N/A N/A eq_ N/A len N/A c _result_columns 2 N/A N/A N/A N/A t1 c x N/A set N/A N/A N/A N/A c _create_result_map N/A x N/A 1 N/A N/A N/A N/A t1 c y N/A set N/A N/A N/A N/A c _create_result_map N/A y N/A 1 N/A test_limit_zero_offset_using_window N/A N/A self N/A N/A N/A t N/A table t N/A column x Integer N/A column y Integer N/A s N/A N/A N/A N/A N/A N/A N/A N/A N/A select N/A t where N/A N/A N/A t c x 5 order_by N/A N/A t c y limit 0 offset 0 N/A N/A N/A self assert_compile s SELECT TOP 0 t.x, t.y FROM t WHERE t.x = :x_1 ORDER BY t.y checkparams N/A x_1 5 N/A test_sequence_start_0 N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column id Integer N/A Sequence 0 primary_key True N/A N/A N/A self assert_compile N/A N/A schema CreateTable tbl CREATE TABLE test (id INTEGER NOT NULL IDENTITY(0,1), PRIMARY KEY (id)) N/A test_sequence_non_primary_key N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column id Integer N/A Sequence primary_key False N/A N/A N/A self assert_compile N/A N/A schema CreateTable tbl CREATE TABLE test (id INTEGER NOT NULL IDENTITY(1,1)) N/A test_sequence_ignore_nullability N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column id Integer N/A Sequence nullable True N/A N/A N/A self assert_compile N/A N/A schema CreateTable tbl CREATE TABLE test (id INTEGER NOT NULL IDENTITY(1,1)) N/A test_table_pkc_clustering N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column x Integer autoincrement False N/A Column y Integer autoincrement False N/A PrimaryKeyConstraint x y mssql_clustered True N/A N/A N/A self assert_compile N/A N/A schema CreateTable tbl CREATE TABLE test (x INTEGER NOT NULL, y INTEGER NOT NULL, PRIMARY KEY CLUSTERED (x, y)) N/A test_table_uc_clustering N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column x Integer autoincrement False N/A Column y Integer autoincrement False N/A PrimaryKeyConstraint x N/A UniqueConstraint y mssql_clustered True N/A N/A N/A self assert_compile N/A N/A schema CreateTable tbl CREATE TABLE test (x INTEGER NOT NULL, y INTEGER NULL, PRIMARY KEY (x), UNIQUE CLUSTERED (y)) N/A test_index_clustering N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column id Integer N/A idx N/A Index foo N/A N/A tbl c id mssql_clustered True N/A N/A N/A self assert_compile N/A N/A schema CreateIndex idx CREATE CLUSTERED INDEX foo ON test (id) N/A test_index_ordering N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column x Integer N/A Column y Integer N/A Column z Integer N/A idx N/A Index foo N/A N/A N/A N/A tbl c x desc y N/A N/A N/A self assert_compile N/A N/A schema CreateIndex idx CREATE INDEX foo ON test (x DESC, y) N/A test_create_index_expr N/A N/A self N/A N/A N/A m N/A MetaData N/A t1 N/A Table foo m N/A Column x Integer N/A N/A N/A self assert_compile N/A N/A schema CreateIndex N/A Index bar N/A N/A N/A t1 c x 5 CREATE INDEX bar ON foo (x > 5) N/A test_drop_index_w_schema N/A N/A self N/A N/A N/A m N/A MetaData N/A t1 N/A Table foo m N/A Column x Integer schema bar N/A N/A N/A self assert_compile N/A N/A schema DropIndex N/A Index idx_foo N/A N/A t1 c x DROP INDEX idx_foo ON bar.foo N/A test_index_extra_include_1 N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column x Integer N/A Column y Integer N/A Column z Integer N/A idx N/A Index foo N/A N/A tbl c x mssql_include N/A y N/A N/A N/A self assert_compile N/A N/A schema CreateIndex idx CREATE INDEX foo ON test (x) INCLUDE (y) N/A test_index_extra_include_2 N/A N/A self N/A N/A N/A metadata N/A MetaData N/A tbl N/A Table test metadata N/A Column x Integer N/A Column y Integer N/A Column z Integer N/A idx N/A Index foo N/A N/A tbl c x mssql_include N/A N/A N/A tbl c y N/A N/A N/A self assert_compile N/A N/A schema CreateIndex idx CREATE INDEX foo ON test (x) INCLUDE (y) N/A N/A SchemaTest N/A N/A fixtures TestBase N/A setup N/A N/A self N/A N/A N/A t N/A Table sometable N/A MetaData N/A Column pk_column Integer N/A Column test_column String N/A N/A self column N/A N/A t c test_column N/A dialect N/A N/A mssql dialect N/A N/A self ddl_compiler N/A N/A dialect ddl_compiler dialect N/A N/A schema CreateTable t N/A _column_spec N/A N/A self N/A N/A N/A N/A N/A N/A self ddl_compiler get_column_specification N/A self column N/A test_that_mssql_default_nullability_emits_null N/A N/A self N/A N/A N/A N/A eq_ test_column VARCHAR(max) NULL N/A N/A self _column_spec N/A test_that_mssql_none_nullability_does_not_emit_nullability N/A N/A self N/A N/A N/A N/A N/A self column nullable None N/A N/A eq_ test_column VARCHAR(max) N/A N/A self _column_spec N/A test_that_mssql_specified_nullable_emits_null N/A N/A self N/A N/A N/A N/A N/A self column nullable True N/A N/A eq_ test_column VARCHAR(max) NULL N/A N/A self _column_spec N/A test_that_mssql_specified_not_nullable_emits_not_null N/A N/A self N/A N/A N/A N/A N/A self column nullable False N/A N/A eq_ test_column VARCHAR(max) NOT NULL N/A N/A self _column_spec N/A N/A