U ĆĻ aTć@svddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd lm Z Gd d „d ej ƒZ d S) é)Śfixtures)Śeq_)ŚColumn)ŚTableé)ŚInteger)Śselect)Śtesting)Śunionc@szeZdZdZedd„ƒZedd„ƒZddd„Zd d „Zd d „Z e j j e j j d d„ƒƒZe j jdd„ƒZdd„Zdd„ZdS)ŚDeprecatedCompoundSelectTestTcCs*td|tdtddtdtƒtdtƒƒdS)NŚ some_tableŚidT)Z primary_keyŚxŚy)rrr)ŚclsŚmetadata©rśkC:\Users\vtejo\AppData\Local\Temp\pip-unpacked-wheel-nyjtotrf\sqlalchemy\testing\suite\test_deprecations.pyŚ define_tabless ūz*DeprecatedCompoundSelectTest.define_tablesc Cs@| |jj ”ddddœddddœddddœddddœg”dS)Nér)r rrréé)ŚexecuteŚtablesr Śinsert)rŚ connectionrrrŚ insert_datas     üžz(DeprecatedCompoundSelectTest.insert_datarcCst| ||” ”|ƒdS)N)rrZfetchall)ŚselfŚconnrŚresultŚparamsrrrŚ_assert_result$sz+DeprecatedCompoundSelectTest._assert_resultc Cst|jj}t|ƒ |jjdk”}t|ƒ |jjdk”}t||ƒ}t d”"|  ||  |jj”ddg”W5QRXdS©NrrśAThe SelectBase.c and SelectBase.columns attributes are deprecated©rrr©rrr) rr rŚwhereŚcr r r Śexpect_deprecatedr!Śorder_by©rrŚtableŚs1Śs2Śu1rrrŚtest_plain_union's ’ ’z-DeprecatedCompoundSelectTest.test_plain_unionc Cs||jj}t|ƒ |jjdk”}t|ƒ |jjdk”}t||ƒ ” ”}t  d”"|  ||  |jj”ddg”W5QRXdSr") rr rr&r'r r Śaliasr r(r!r)r*rrrŚ"_dont_test_select_from_plain_union<s’ ’z?DeprecatedCompoundSelectTest._dont_test_select_from_plain_unionc Csš|jj}t|ƒ |jjdk” d” |jj”}t|ƒ |jjdk” d” |jj”}t||ƒ d”}t   d”"|  || |jj”ddg”W5QRXdS©Nrrrr#r$r%) rr rr&r'r Ślimitr)r r r(r!r*rrrŚ&test_limit_offset_selectable_in_unionsJs&&’ ’zCDeprecatedCompoundSelectTest.test_limit_offset_selectable_in_unionsc CsŽ|jj}t|ƒ |jjdk” |jj”}t|ƒ |jjdk” |jj”}t||ƒ d”}t   d”"|  || |jj”ddg”W5QRXdSr") rr rr&r'r r)r r3r r(r!r*rrrŚ"test_order_by_selectable_in_unionsZs  ’ ’z?DeprecatedCompoundSelectTest.test_order_by_selectable_in_unionsc Cs‚|jj}t|ƒ |jjdk” ”}t|ƒ |jjdk” ”}t||ƒ d”}t   d”"|  ||  |jj”ddg”W5QRXdSr") rr rr&r'r Zdistinctr r3r r(r!r)r*rrrŚ"test_distinct_selectable_in_unionsis’ ’z?DeprecatedCompoundSelectTest.test_distinct_selectable_in_unionsc CsŖ|jj}t|ƒ |jjdk” d” |jj” ” ”}t|ƒ |jjdk” d” |jj” ” ”}t ||ƒ d”}t   d”"|  || |jj”ddg”W5QRXdSr2) rr rr&r'r r3r)r0r r r(r!r*rrrŚ.test_limit_offset_aliased_selectable_in_unionsws4 ’žż ’  ’žż ’ ’ ’zKDeprecatedCompoundSelectTest.test_limit_offset_aliased_selectable_in_unionsN)r)Ś__name__Ś __module__Ś __qualname__Z __backend__Ś classmethodrrr!r/r1r ŚrequiresZorder_by_col_from_unionZ/parens_in_union_contained_select_w_limit_offsetr4Z0parens_in_union_contained_select_wo_limit_offsetr5r6r7rrrrr s    r N) ŚrZ assertionsrZschemarrrrr r Z TablesTestr rrrrŚs