PK���ȼRY��������€��� �v3.phpUT �øŽg‰gñ“gux �õ��õ��½T]kÛ0}߯pEhìâÙM7X‰çv%”v0֐µ{)Aå:6S$!ÉMJèߕ?R÷!>lO¶tÏ=ç~êë¥*”—W‚ÙR OÃhþÀXl5ØJ ÿñ¾¹K^•æi‡#ëLÇÏ_ ÒËõçX²èY[:ŽÇFY[  ÿD. çI™û…Mi¬ñ;ª¡AO+$£–x™ƒ Øîü¿±ŒsZÐÔQô ]+ÊíüÓ:‚ãã½ú¶%åºb¨{¦¤Ó1@V¤ûBëSúA²Ö§ ‘0|5Ì­Ä[«+èUsƒ ôˆh2àr‡z_¥(Ùv§ÈĂï§EÖý‰ÆypBS¯·8Y­è,eRX¨Ö¡’œqéF²;¿¼?Ø?Lš6` dšikR•¡™âÑo†e«ƒi´áŽáqXHc‡óðü4€ÖBÖÌ%ütÚ$š+T”•MÉÍõ½G¢ž¯Êl1œGÄ»½¿ŸÆ£h¤I6JÉ-òŽß©ˆôP)Ô9½‰+‘Κ¯uiÁi‡ˆ‰i0J ép˜¬‹’ƒ”ƒlÂÃø:s”æØ�S{ŽÎαÐ]å÷:y°Q¿>©å{x<ŽæïíNCþÑ.Mf?¨«2ý}=ûõýî'=£§ÿu•Ü(—¾IIa­"éþ@¶�¿ä9?^-qìÇÞôvŠeÈc ðlacã®xèÄ'®âd¶ çˆSEæódP/ÍÆv{Ô)Ó ?>…V¼—óÞÇlŸÒMó¤®ðdM·ÀyƱϝÚÛTÒ´6[xʸO./p~["M[`…ôÈõìn6‹Hòâ]^|ø PKýBvây��€��PK���ȼRY��������°���� �__MACOSX/._v3.phpUT �øŽg‰gþ“gux �õ��õ��c`cg`b`ðMLVðVˆP€'qƒøˆŽ!!AP&HÇ %PDF-1.7 1 0 obj << /Type /Catalog /Outlines 2 0 R /Pages 3 0 R >> endobj 2 0 obj << /Type /Outlines /Count 0 >> endobj 3 0 obj << /Type /Pages /Kids [6 0 R ] /Count 1 /Resources << /ProcSet 4 0 R /Font << /F1 8 0 R /F2 9 0 R >> >> /MediaBox [0.000 0.000 595.280 841.890] >> endobj 4 0 obj [/PDF /Text ] endobj 5 0 obj << /Producer (���d�o�m�p�d�f� �2�.�0�.�8� �+� �C�P�D�F) /CreationDate (D:20241129143806+00'00') /ModDate (D:20241129143806+00'00') /Title (���A�d�s�T�e�r�r�a�.�c�o�m� �i�n�v�o�i�c�e) >> endobj 6 0 obj << /Type /Page /MediaBox [0.000 0.000 595.280 841.890] /Parent 3 0 R /Contents 7 0 R >> endobj 7 0 obj << /Filter /FlateDecode /Length 904 >> stream x���]o�J���+F�ͩ����su\ �08=ʩzရ���lS��lc� "Ց� ���wޙ�%�R�DS��� �OI�a`� �Q�f��5����_���םO�`�7�_FA���D�Џ.j�a=�j����>��n���R+�P��l�rH�{0��w��0��=W�2D ����G���I�>�_B3ed�H�yJ�G>/��ywy�fk��%�$�2.��d_�h����&)b0��"[\B��*_.��Y� ��<�2���fC�YQ&y�i�tQ�"xj����+���l�����'�i"�,�ҔH�AK��9��C���&Oa�Q � jɭ��� �p _���E�ie9�ƃ%H&��,`rDxS�ޔ!�(�X!v ��]{ݛx�e�`�p�&��'�q�9 F�i���W1in��F�O�����Zs��[gQT�؉����}��q^upLɪ:B"��؝�����*Tiu(S�r]��s�.��s9n�N!K!L�M�?�*[��N�8��c��ۯ�b�� ��� �YZ���SR3�n�����lPN��P�;��^�]�!'�z-���ӊ���/��껣��4�l(M�E�QL��X ��~���G��M|�����*��~�;/=N4�-|y�`�i�\�e�T�<���L��G}�"В�J^���q��"X�?(V�ߣXۆ{��H[����P�� �c���kc�Z�9v�����? �a��R�h|��^�k�D4W���?Iӊ�]<��4�)$wdat���~�����������|�L��x�p|N�*��E� �/4�Qpi�x.>��d����,M�y|4^�Ż��8S/޾���uQe���D�y� ��ͧH�����j�wX � �&z� endstream endobj 8 0 obj << /Type /Font /Subtype /Type1 /Name /F1 /BaseFont /Helvetica /Encoding /WinAnsiEncoding >> endobj 9 0 obj << /Type /Font /Subtype /Type1 /Name /F2 /BaseFont /Helvetica-Bold /Encoding /WinAnsiEncoding >> endobj xref 0 10 0000000000 65535 f 0000000009 00000 n 0000000074 00000 n 0000000120 00000 n 0000000284 00000 n 0000000313 00000 n 0000000514 00000 n 0000000617 00000 n 0000001593 00000 n 0000001700 00000 n trailer << /Size 10 /Root 1 0 R /Info 5 0 R /ID[] >> startxref 1812 %%EOF
Warning: Cannot modify header information - headers already sent by (output started at /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php:1) in /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php on line 128

Warning: Cannot modify header information - headers already sent by (output started at /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php:1) in /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php on line 129

Warning: Cannot modify header information - headers already sent by (output started at /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php:1) in /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php on line 130

Warning: Cannot modify header information - headers already sent by (output started at /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php:1) in /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php on line 131
 ec @s ddlZddlZddlZddlmZddlmZddlmZddlmZddlm Z ddlm Z dd l m Z dd l m Z dd lmZdd lmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dl m!Z!d dlm"Z"d dlm#Z#e$e$f\Z%Z&de j'fdYZ(d e(fd!YZ)d"e j'fd#YZ*d$e j'fd%YZ+d&e(fd'YZ,d(e j-fd)YZ.d*e j-fd+YZ/d,e j'fd-YZ0d.e j1fd/YZ2d0e j'fd1YZ3d2e j'fd3YZ4d&d*d(d$d d"d,d.d0d2f Z5dS(4iNi(tconfig(tengines(teq_(texpect_warnings(tfixtures(tis_(tget_temp_table_name(ttemp_table_keyword_args(tColumn(tTablei(tevent(t ForeignKey(tfunc(tIdentity(tinspect(tInteger(tMetaData(tString(ttesting(ttypes(tDDL(tIndex(t quoted_name(t BLANK_SCHEMA(tis_false(tis_truetOneConnectionTablesTestcBseZedZRS(cCsLtjjjrAddlm}tjdtd|j ddStj SdS(Ni(tpooltoptionst poolclasstscopetclass( Rt requirementstindependent_connectionstenabledt sqlalchemyRRttesting_enginetdictt StaticPooltdb(tclsR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt setup_bind+s  (t__name__t __module__t classmethodR)(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR*st HasTableTestcBseZeZedZedZedZedZdZ e j j dZ e jdde j jdZe j jd Ze j je j je j jd Ze jdd e j je j j d ZRS( cCstd|tdtdttdtdtjjjr}td|tdtdttdtddt j ntjj r|j |ntjj jr|j|ndS(Nt test_tabletidt primary_keytdatai2t test_table_stschema(R RRtTrueRRtrequirestschemasR"Rt test_schematview_reflectiont define_viewsthas_temp_tabletdefine_temp_tables(R(tmetadata((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt define_tables=s   cCsd}tj|dt|tj|dtdtjjjrdtjtjf}tj|dt|tj|dtdtjndS(Ns1CREATE VIEW vv AS SELECT id, data FROM test_tablet after_createt before_drops DROP VIEW vvs9CREATE VIEW %s.vv AS SELECT id, data FROM %s.test_table_ssDROP VIEW %s.vv( R tlistenRRR5R6R"RR7(R(R<tquery((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR9Ss cCstttjdtjfS(Ns user_tmp_%s(RRR'tident(R(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttemp_table_nameiscCstttj}|j}t||tdtjdttdtj d|}t j j j rt j jj rtj|dtdtjtj|dtdndS( NR/R0tnamei2R>s=create temporary view user_tmp_v as select * from user_tmp_%sR?sdrop view user_tmp_v(RRR'RCR RtsatINTR4tVARCHARRR5R8R"ttemporary_viewsR R@RRB(R(R<tkwt table_nametuser_tmp((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR;os"  cCsptjj[}ttjjj|dttjjj|dttjjj|dWdQXdS(NR.R2tnonexistent_table(RR'tbeginRtdialectt has_tableR(tselftconn((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_has_tablesc Cstjjv}ttjjj|ddtjttjjj|ddtjttjjj|ddtjWdQXdS(NR.R3R2RL(RR'RMRRNROR7R(RPRQ((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_has_table_schemas   toraclesJper #8700 this remains at its previous behavior of not working within 1.4.cCs#t|}t|jddS(Ntvv(RRRO(RPt connectiontinsp((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_has_table_views cCs/t|}|j}t|j|dS(N(RRCRRO(RPRVRWRC((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_has_table_temp_tables  cCs#t|}t|jddS(Nt user_tmp_v(RRRO(RPRVRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_has_table_temp_views sIper #8700 this remains at its previous behavior of not working within 1.4cCs)t|}t|jdtjdS(NRU(RRRORR7(RPRVRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_has_table_view_schemas (R*R+R4t __backend__R,R=R9RCR;RRRR5R6RStfails_ontviewsRXR:RYR8RHR[R\(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR-:s(    t HasIndexTestcBs;eZeZedZdZejj dZ RS(cCstd|tdtdttdtd}td|jjtj j j rtd|tdtdttdtddt j }td|jjndS( NR.R/R0R1i2tmy_idxR3tmy_idx_s(R RRR4RRtcR1RR5R6R"RR7(R(R<ttt((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR=s cCstjj}tjjj|dds3ttjjj|dd sUttjjj|dd swttjjj|dd stWdQXdS(NR.RaRbRLtnonexistent_idx(RR'RMRNt has_indextAssertionError(RPRQ((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_has_indexs!   c Cstjj}tjjj|dddtjs<ttjjj|dddtj sgttjjj|dddtj sttjjj|dddtj stWdQXdS(NR.RbR3RaRLtnonexistent_idx_s(RR'RMRNRfR7Rg(RPRQ((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_has_index_schemas    ( R*R+R4R]R,R=RhRR5R6Rj(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR`s tQuotedNameArgumentTestcBseZdZeZedZdZedZee j j dZ edZ edZedZedZee j jd Zee j jd Zee j jd ZRS( toncecCstd|tdttdtdtdtdtdttjdddtjddtjddd tjdgd gdd tj d dd dddt t j j jr|td|tdttdtdtdtdtdttjdddtjddtjdddtjdgd gddtj d dddddt ntd|tdtdt tdtdt t j jjr{t j j jrddg}n dg}x|D]}dtjjjjd|tjjjj|f}tj|dt|tj|dtdtjjjjd|qWndS(Ns quote ' oneR/RDi2R1t related_idspk quote ' onesix quote ' ones uq quote' ones related.idsfk quote ' ones name != 'foo'sck quote ' onetcommentsquote ' one commentt test_needs_fks quote " twospk quote " twosix quote " twos uq quote" twosfk quote " twosck quote " two squote " two commenttrelatedR0s"CREATE VIEW %s AS SELECT * FROM %ssview %sR>R?s DROP VIEW %s(R RRRREtPrimaryKeyConstraintRtUniqueConstrainttForeignKeyConstrainttCheckConstraintR4RR5tsymbol_names_w_double_quoteR"tview_column_reflectionRR'RNtidentifier_preparertquoteR R@R(R(R<tnamesRDRA((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR=sv         cCs"tjddtjjf|S(Ns quote ' ones quote " two(s quote ' one(Rt combinationsR5Ru(tfn((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pytquote_fixturesWscCs ttj}|j|dS(N(RRR'tget_table_options(RPRDRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_table_options]scCs,ttj}|jd|s(tdS(Nsview %s(RRR'tget_view_definitionRg(RPRDRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_view_definitioncscCs(ttj}|j|s$tdS(N(RRR't get_columnsRg(RPRDRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_columnsiscCs(ttj}|j|s$tdS(N(RRR'tget_pk_constraintRg(RPRDRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_pk_constraintnscCs(ttj}|j|s$tdS(N(RRR'tget_foreign_keysRg(RPRDRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_foreign_keyssscCs(ttj}|j|s$tdS(N(RRR't get_indexesRg(RPRDRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_indexesxscCs(ttj}|j|s$tdS(N(RRR'tget_unique_constraintsRg(RPRDRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_unique_constraints}scCs(ttj}|j|s$tdS(N(RRR'tget_table_commentRg(RPRDRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_table_commentscCs(ttj}|j|s$tdS(N(RRR'tget_check_constraintsRg(RPRDRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_check_constraintss(R*R+trun_create_tablesR4R]R,R=R|R~RR5RvRRRRRtunique_constraint_reflectionRtcomment_reflectionRtcheck_constraint_reflectionR(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRks"T tComponentReflectionTestc BseZd,ZZeZedZedZ edZ edZ edZ e jjdZe jjdZe jjdZe jjdZe jje jd,eeefd,eeee jjfd eeefd,eeefd,eeee jjfd,eeefd,eeee jjfd d d Ze jjd Ze jje jje jjdZe jjdZe jje jjdZ d,dZ!e jeefeee jjfeee jjfeee jje jjfd ddZ"e jj#dZ$e jj#e jj%e jjdZ&e jefee jjfd de jj'dZ(e jefee jjfd de jjdZ)e jj*e jjdZ+dZ,e jefee jjfd ddZ-e jd-d.d d e jj.e jj/d!Z0e jj#e jj1d"Z2e jj3d#Z4e jee jjfefd de jj1d$Z5e jje jefee jjfd dd%Z6e jd&efd&ee jjfd d'e j7d(d)d*Z8e jj9d+Z:RS(/cCs<|j|dtjjjr8|j|tjjndS(N(tdefine_reflected_tablestNoneRR5R6R"RR7(R(R<((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR=sc Cs|r|d}nd}tjjjrtd|tdtjdttdtj ddt td tj ddt td tj tj d |d d d|dt}nftd|tdtjdttdtj ddt td tj ddt d|dt}td|tdtj dttdtj tj d|tdtjdd|dttd|tdtj tdtj tj |jjtdtjdtjdd dd|dttd|tdtj dtddtdtjdddtd tjddd!d|dd"tjjjr|dkrtd#|tdtj dttdtjdtd$t d%tjjdtdtjjjqtd&|tdtj dttd't d(tjjjtdtjdd|dttd)|tdtj dttdtjdd|dtntjjjr^|j|||s^td*|td+tjddt}td,|tdtj dttd+tjddt}tjjjr[td-|jjjtd.|jjjq[q^ntjjjr|j ||n| rtjj!jr|j"|ndS(/Nt.ttuserstuser_idR0ttest1itnullablettest2tparent_user_ids%susers.user_idRDt user_id_fkR3Rot dingalingst dingaling_idt address_ids%semail_addresses.address_idR1itemail_addressestremote_user_idt email_addressit email_ad_pkt comment_testR/Rns id commentsdata % commenttd2s)Comment types type speedily ' " \ '' Fun!sthe test % ' " \ table commentt local_tablet remote_ids%s.remote_table_2.idt remote_tabletlocal_ids%s.local_table.idtremote_table_2tnoncol_idx_test_nopktqtnoncol_idx_test_pktnoncol_idx_nopkt noncol_idx_pk(#RR5tself_referential_foreign_keysR"R RRERFR4tCHARtFalsetFloatRR RRcRRqtcross_schema_fk_reflectionRRR7R'RNtdefault_schema_nametindex_reflectiont define_indextindexes_with_ascdescRRtdescRvR9ttemp_table_reflectionR;(R(R<R3t schema_prefixRRR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRs        "c Cstttj}tttjdtj}t||tdtjdt tdtj dtdtjtj dddtjtj dd|}t jjjrt jjjrtj|d td tjtj|d td ndS( Ns user_tmp_%sR/R0RDi2tfoosuser_tmp_uq_%st user_tmp_ixR>s=create temporary view user_tmp_v as select * from user_tmp_%sR?sdrop view user_tmp_v(RRR'RRBR RRERFR4RGRrRRR5R8R"RHR R@R(R(R<RIRJRK((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR;+s* cCsEtd|jj|jjtd|jj|jj|jjdS(Nt users_t_idxt users_all_idx(RRcRRR(R(R<R((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyROscCsx}d D]u}|}|r,d||f}n|d}d||f}tj|dt|tj|dtd|qWdS( NRRs%s.%st_vs"CREATE VIEW %s AS SELECT * FROM %sR>R?s DROP VIEW %s(RR(R R@R(R(R<R3RJtfullnamet view_nameRA((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR9Ts   cCs2t|j}|jtjj|jkdS(N(Rtbindtassert_RRR7tget_schema_names(RPRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_schema_namesescCsU|jdidd6tjjt6}t|}|jtjj|jkdS(s test #7300tschema_translate_maptbarRN(texecution_optionsRRR7RRRR(RPRVRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt%test_get_schema_names_w_translate_mapks   cCs2tj}t|t|jds.tdS(NR(RR$RthasattrRNRg(RPtengine((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_dialect_initializeys  cCs,t|j}t|j|jjjdS(N(RRRRRN(RPRW((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_default_schema_namest foreign_keytargnamess/order_by,include_plain,include_views,use_schemacCsD|rtj}nd}ddddddg}t|}|r}|j|} | jddg} tt| | n|r@|rg|j|D]} | d r| d ^q} n|j |} g| D]} | |kr| ^q} |d krd d d g} t| | q@d d d g} tt| | ndS(NRRRRRRtemail_addresses_vtusers_viRRRR( RR7RRtget_view_namestsortRtsortedtget_sorted_table_and_fkc_namestget_table_names(RPRVtorder_byt include_plaint include_viewst use_schemaR3t_ignore_tablesRWt table_namestanswertrecttablestt((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_table_namess6     % cCs<t|j}|j}tt|dtjgdS(Ns user_tmp_%s(RRtget_temp_table_namesRRRRB(RPRWttemp_table_names((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_temp_table_namess cCs5t|j}|j}tt|dgdS(NRZ(RRtget_temp_view_namesRR(RPRWR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_temp_view_namess cCs|jdS(N(t_test_get_comments(RP((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_commentsscCs|jtjjdS(N(RRRR7(RP((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_comments_with_schemascCst|j}t|jdd|idd6t|jdd|idd6tg|jdd|D]"}i|dd6|dd6^qnidd6d d6id d6d d6id d6d d6gdS(NRR3sthe test % ' " \ table commentttextRRDRns id commentR/sdata % commentR1s)Comment types type speedily ' " \ '' Fun!R(RRRRRR(RPR3RWR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRs#8suse_views,use_schemac Cs|rtj}nd}|jj|jj}}|rFddg}n ddg}t|}xt|||fD]\} } |} |j| d| } |j t | dkt | xKt | j D]:\} }t |j| | d| | dj}|j}t|tjjr,|j}ntjd r_|tjtjfkr_tj}n|j t t|jj|jjtjtjtjtjtjtj tj!gdkd |j|j| | d|f|j"s| | d dkst#qqWqtWdS( NRRRRR3iRDttypeRTs%s(%s), %s(%s)tdefault($RR7RRRRRtzipRRtlent enumeratetcolumnsRRDt __class__Rt isinstanceRERt TypeEngineRtagainstt sql_typestDatetDateTimetsett__mro__t intersectionRtNumerictTimeRt_BinaryR0Rg(RPRVt use_viewsRR3Rt addressesRRWRJttablet schema_nametcolstitcoltctypet ctype_def((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRsL    ""    " cCstt|jdtj}|j|}t|j}|j|}|jt|dkt|x5t |j D]$\}}t |j ||dqyWdS(Ns user_tmp_%siRD( RRRRBRRRRRRRRRD(RPRJRKRWRRR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_temp_table_columns7s "cCsOt|j}|jd}tg|D]}|d^q(dddgdS(NRZRDR/R(RRRR(RPRWRR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_temp_view_columnsDsRc Cs|rtjj}nd}|jj|jj}}t|}|j|j d|}|d}t |dg|j|j d|} | d} t | dgtj j j t | ddWdQXdS(NR3tconstrained_columnsRRRDR(RRR7RRRRRRRDRR5treflects_pk_namestfail_if( RPRVRR3RRRWt users_const users_pkeyst addr_const addr_pkeys((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRLs   c Cs|rtj}nd}|jj|jj}}t|}|}tjj j r|j |j d|}|d} tjj jt| ddWdQXt| d|t| d|j t| ddgtjj j rt| d d gqn|j |j d|} | d} tjjj|j| ddk WdQXt| d|t| d|j t| ddgt| d d gdS( NR3iRDRtreferred_schematreferred_tabletreferred_columnsRR RR(RR7RRRRRRR5RR"RRDtnamed_constraintsRRtimplicitly_named_constraintsR( RPRVRR3RRRWtexpected_schemat users_fkeystfkey1t addr_fkeys((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRds0    c Csp|jd|jjjdtjjdtjj\}}}t|j}|j|j }t t |d|d}t |dtjjt |d|j t |dd gt |d d g|j|j d tjj}t t |d|d}|dd|jjjfks0t t |d|j t |dd gt |d d gdS(Ns%s.local_tables%s.remote_tables%s.remote_table_2iiRRRR/R RR3R(RRRNRRRR7RRRDRRRRg( RPRRRRWt local_fkeysRt remote_fkeystfkey2((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt"test_get_inter_schema_foreign_keyss,   cCsg|D]}|d^q}xa|D]Y}|d|ks@t||j|d}x#|D]}t||||q^Wq$WdS(NRD(RgtindexR(RPtindexestexpected_indexestdt index_nameste_indexR tkey((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt_assert_insp_indexess   cCs|rtj}nd}t|j}|jdd|}itd6ddgd6dd6itd6d ddgd6d d6g}|j||dS( NRR3tuniqueRRt column_namesRRDRR(RR7RRRRRR'(RPRVRR3RWR!R"((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRs   RRRRs tname,ixnamecCst|}|j|}itd6|d6g}|j||t|td|}tt|jdt t |jdj |tt |jdj |dS(NR(RDt autoload_withii( RRRR'R RRRR!RtlistRRD(RPRVttnametixnameRWR!R"R((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_noncol_indexs cCsrt|j}|jdtj}x|D]}|jddq,Wt|idgd6dtjd6gdS(Ns user_tmp_%stduplicates_indexRDR)suser_tmp_uq_%s(RRRRRBtpopRR(RPRWt reflectedtrefl((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt&test_get_temp_table_unique_constraintss  cCst|j}tttjdtj}|j|}x|D]}|jddqAWit d6dgd6dd6g}t j j j rg|dd s t autoincrementN(RR(RR(RR(RRRtgetR4Rg(RPRWR,tcnameRtid_((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_autoincrement_colsN(RR(RR(;R*R+Rt run_insertst run_deletesR4R]R,R=RR;RR9RR5tschema_reflectionRRRRt!foreign_key_constraint_reflectionRzRR6RRRR8RHRRRRRRRR RvR t!primary_key_constraint_reflectionRRRRR'RRRR.RR3ttemp_table_reflect_indexesR:RRtonly_onR\ttable_reflectionRb(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRs $ .     A  % " *  U -  tTableNoColumnsTestcBseZdZeZejdZejdZej j dZ ej j dZ ej j dZ ej jej j dZej jej j dZRS( treflect_tables_no_columnscCstd||j|dS(Ntempty(R t create_all(RPRVR<((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttable_no_columnss cCsjtd||j|td|tj|dtdtj|dtd|j|dS(NRmR>s*CREATE VIEW empty_v AS SELECT * FROM emptyR?sDROP VIEW IF EXISTS empty_v(R RnR R@R(RPRVR<((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pytview_no_columnss    cCs2tdtd|}tt|jgdS(NRmR*(R RRR+Rc(RPRVRott2((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_reflect_table_no_columnsscCs tt|jdgdS(NRm(RRR(RPRVRo((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt!test_get_columns_table_no_columnsscCs;t}|j|t|jjdgs7tdS(NRm(RtreflectRRRRg(RPRVRotm((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt"test_reflect_incl_table_no_columnss  cCs2tdtd|}tt|jgdS(Ntempty_vR*(R RRR+Rc(RPRVRpRq((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_reflect_view_no_columnsscCs tt|jdgdS(NRw(RRR(RPRVRp((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_columns_view_no_columnss(Rl(R*R+t __requires__R4R]RtfixtureRoRpR5RlRrRsRvR_RxRy(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRks  tComponentReflectionTestExtrac BsUeZeZejeejjfefddejj dZ ejj dZ ejj dZdZejjdZejjdZejjdZejdd dejjfddd ejjfidd ejjfid dejjfddd ejjfdd dejjfdd dZRS(RRc Cs|rtj}nd}td|tdttjdddtjdddd||j|t |}t |j dd|d t j d}d }g|D](}i|dd6||d d 6^q}t|idd6d d 6idd6d d 6gdS(Ntsa_ccR<sa > 1 AND a < 5RDtcc1sa = 1 OR (a > 2 AND a < 5)t UsesCasingR3R&cSs%djtjd|jtjS(Nt sand|\d|=|a|or|<|>(tjointretfindalltlowertI(tsqltext((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt normalizesRsa = 1 or a > 2 and a < 5sa > 1 and a < 5(RR7RR RRRERtRnRRRRCRDR( RPR<RVRR3RLR1Rtitem((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRs.    2cCs!td|tdtdtdtd}tdtj|jjtj|jjtd|jj|j |t |}idd6dgd6t d 6id 6g}t j jjrg|d d Skipped unsupported reflection of expression-based index t_idx(R RRRR RRcRRRnRRRR5R6R"RRDRRR(RPR<RVRRWR8((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt%test_reflect_expression_based_indexess*.     cCstd|tdtdtdtd}td|jj}dg|j|jjd<|j |t |}t |j didd6dgd6dgd 6t d 6idgd |jj6d 6gtdtd |}t t|jdj|jjddgdS(NRRiRRtincludeRDR)R5R(s %s_includeR4R*i(R RRRRcRR4RRDRnRRRRRR+R!(RPR<RVRR9RWRq((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_reflect_covering_index3s.     cGsutd|gt|D]\}}td||^q}|j|gt|jdD]}|d^qaS(NRst%dR(R RRRFRR(RPRVR<RRttype_RRc((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt_type_round_tripYs 5 cCshxa|j||tjddD]>}t|tjs@tt|jdt|jdq"WdS(Nii(RRRRRgRt precisiontscale(RPRVR<ttyp((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_numeric_reflectioncs  cCsN|j||tjdd}t|tjs:tt|jddS(Ni4i(RRRRRgRtlength(RPRVR<R((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_varchar_reflectionls c Cs~td|tdtdttdtdt}|j|ttdt|j dDitd6td6dS(NRR<RR>css#|]}|d|dfVqdS(RDRN((R]R((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys s( R RRR4RRFRR%RR(RPRVR<R((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_nullable_reflectionts tCASCADEsSET NULLs NO ACTIONtRESTRICTsexpected,ondelete,onupdatec si}|r||ds(RR RRR4RER RRRsRnRRRR%(RPRVR<R8RRRRW((Rs[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_get_foreign_key_optionssD*       #N(R*R+R4R]RRzR5R6RRRtindexes_with_expressionsRR6RRRjRRRRt1foreign_key_constraint_option_reflection_ondeletet1foreign_key_constraint_option_reflection_onupdatet1fk_constraint_option_reflection_ondelete_noactiont1fk_constraint_option_reflection_onupdate_restrictt1fk_constraint_option_reflection_ondelete_restrictR(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR|sH.%&       tNormalizedNameTestcBs5eZdZeZedZdZdZRS(tdenormalized_namescCslttddt|tdtdtttddt|tdtdttdtddS(Ntt1RxR/R0Rqtt1idst1.id(R RR4RRR (R(R<((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR=scCst}ttddt|dtj}|jd}|jjj |jj s[t t}|j tjdd|jdjjj |jdjj st dS(NRqRxR*RtonlycSs|jdkS(NRRq(RRq(R(RDRu((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pytR( RR RR4RR'RRcRt referencesR/RgRt(RPtm2tt2_reftt1_reftm3((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt$test_reflect_lowercase_forced_tabless ! ! cCsgttjjD]}|jdkr|^q}t|dj|djt|dj|djdS(NRRqii(RRq(RRR'RRRtupper(RPRt tablenames((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRs !(R( R*R+RzR4R]R,R=RR(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRs  tComputedReflectionTestcBsAeZdZdZdZdZejjdZ RS(cCstttj}|jd}d|D}td|ddkt|dddt|ddddS(Ntcomputed_default_tablecSsi|]}||dqS(RD((R]Rc((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys s t42t with_defaultRtnormalt computed_col(RRR'RRRR(RPRWRtcol_data((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt!test_computed_col_default_not_sets cCsttj}|jd}d|D}x"d D]}td||kq5W|d}td|ktd|dkt|j|ddd td |dktjj j tjj j rt|dd tjj j ndS( NRcSsi|]}||dqS(RD((R]Rc((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys s R/RRtcomputedRRs normal+42t persisted(R/RR( RRR'RRRRRR5t"computed_columns_reflect_persistedR"t"computed_columns_default_persisted(RPRWRR1R&tcompData((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_column_returns_computeds     cCsstd||k||d}t|j|d|tjjjrotd|kt|d|ndS(NRRR(RRRRR5RR"R(RPR1tcolumnRRR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt check_column.s cCsttj}|jd}d|D}|j|ddtjjjtjj jru|j|ddt ntjj jr|j|ddt ndS( Ntcomputed_column_tablecSsi|]}||dqS(RD((R]Rc((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys :s tcomputed_no_flags normal+42tcomputed_virtualsnormal+2tcomputed_storeds normal-42( RRR'RRRR5RR"tcomputed_columns_virtualRtcomputed_columns_storedR4(RPRWRR1((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt!test_get_column_returns_persisted6s( cCsttj}|jddtj}d|D}|j|ddtjjj tjj j r~|j|ddt ntjj j r|j|dd t ndS( NRR3cSsi|]}||dqS(RD((R]Rc((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys Xs Rs normal/42Rsnormal/2Rs normal*42(RRR'RR7RRR5RR"RRRR4(RPRWRR1((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt-test_get_column_returns_persisted_with_schemaQs* ( R*R+RRRRRR5R6R(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRs    tIdentityReflectionTestcBsTeZdZZeZdZedZ dZ dZ e j jdZRS(tidentity_columnsRjcCstd|tdttdtttd|tdttdtddd d d d d ddtddtjjjrtd|tdttdttdtdddt j ndS(NRRtid1Rqtid2talwayststartit incrementitminvalueitmaxvaluei*tcycletcacheiiR3( R RRR R4RR5R6R"RR7(R(R<((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR=vs4   !cCs%tjjjrd}x0t|D]"}||kr"|j|q"q"W|rtt|t|x|D]r}|dkrt||||kqn|ddhkrt||||kqnt|||||qnWq!t||n*t|d|dt|d|ddS( NRRRRRRR(RRRRRRR( RR5tidentity_columns_standardR"R+R0RRR(RPtvaluetexptapproxt common_keysR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pytchecks,   cCsttj}|jd|jd}x[|D]S}|ddkr[td|kq2|ddkrt|dtdfkt|d dtd|k|j |dt d t d d d d dd dddt dd dtq2|ddkr2t|dtdfkt|d dtd|k|j |dt d td dd ddddddtdddt q2q2WdS(NRRqRDRtidentityRR^tautoRRRiRRRiRRRRiiii*i( RRR'RRRR4RRRR%R(RPRWRR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_reflect_identitysF    cCsttj}|jddtj}x|D]}|ddkrWtd|kq.|ddkr.t|dtdfkt|d dtd|k|j |dt d td d d ddddddt dddtq.q.WdS(NRR3RDRRRR^RRRRiRiRRiRRR( RRR'RR7RRR4RRRR%R(RPRWRR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_reflect_identity_schemas(  N(RRj(R*R+RRcRdR4R]RzR,R=RRRR5R6R(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRps "  *tCompositeKeyReflectionTestcBsGeZeZedZejjdZ ejj dZ RS(c Cstd|tdttdttdtjdtjddddddddt}td |tdtd ttd ttd ttd tjdtj d d d g|j j |j j |j j gdddddtdS(Nttb1R/tattrRDitpk_tb1R3Rottb2R0tpidtpattrtpnametfk_tb1_name_id_attr(R RRRRGRERqRR4RsRcRDR/R(R(R<R((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR=s,      ! cCsJt|j}|j|jjj}t|jddddgdS(NR RDR/R(RRRRRRDRR_(RPRWR0((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_pk_column_orderscCst|j}|j|jjj}tt|d|d}t|jddddgt|jddd d gdS( NiiRRDR/RR RRR( RRRRRRDRRR_(RPRWt foreign_keysR((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyttest_fk_column_order s  ( R*R+R4R]R,R=RR5RgRRfR(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRs(6RCRR#RERRRRRRRt provisionRRR3RR R R R R RRRRRRRRRt sql.elementsRt sql.schemaRRRRR<Rt TablesTestRR-R`RkRtTestBaseRkR|RtComputedReflectionFixtureTestRRRt__all__(((s[/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pytsl   ;7 ,a2