U
|
¸ý°d$¤ ã @ s¦ d dl Z d dlZd dlZddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm
|
Z
|
dd lm Z dd
|
lm Z dd l mZ dd l mZ dd lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddl m Z ddl m Z dd l m!Z! dd l"m#Z# dd l"m$Z$ dd lm%Z% dd lm&Z& dd!l'm(Z( dd"l)m*Z* dd#lm+Z+ dd$lm,Z, dd%lm-Z- dd&lm.Z. dd'lm/Z/ d(\Z0Z1G d)d* d*e j2Z3G d+d, d,e3Z4G d-d. d.e j2Z5G d/d0 d0e j2Z6d1d2 Z7G d3d4 d4e,e3Z8G d5d6 d6e j9Z:G d7d8 d8e+e j9Z;G d9d: d:e j2Z<G d;d< d<e j=Z>G d=d> d>e j2Z?G d?d@ d@e j2Z@dAZAdS )Bé Né )Úconfig)Úengines)Úeq_)Ú expect_raises)Úexpect_raises_message)Úexpect_warnings)Úfixtures)Úis_)Úget_temp_table_name)Útemp_table_keyword_args©ÚColumn)ÚTableé )Úevent)Ú
|
ForeignKey)Úfunc)ÚIdentity)Úinspect)ÚInteger)ÚMetaData)ÚString)Útesting)Útypes)Ú Inspector)Ú
|
ObjectKind)Ú ObjectScope)ÚNoSuchTableError)ÚUnreflectableTableError)ÚDDL)ÚIndex)Ú quoted_name)Ú BLANK_SCHEMA)ÚComparesIndexes)ÚComparesTables)Úis_false)Úis_true)Úmock)NNc @ s e Zd Zedd ZdS )ÚOneConnectionTablesTestc C s6 t jjjr,ddlm} tjt|j dddS t j
|
S d S )Nr )ÚpoolÚclass)Z poolclassÚscope)Úoptions) r Ú requirementsZindependent_connectionsÚenabledÚ
|
sqlalchemyr* r Útesting_engineÚdictZ
|
StaticPoolÚdb)Úclsr* © r5 ú_d:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/testing/suite/test_reflection.pyÚ
|
setup_bind1 s
|
ÿz"OneConnectionTablesTest.setup_bindN)Ú__name__Ú
|
__module__Ú __qualname__Ú classmethodr7 r5 r5 r5 r6 r) 0 s r) c @ sÈ e Zd ZdZedd Zedd Zedd Zedd Zd
|
d Z d d Z
|
e j j dd Ze j j dd Ze j jdd Ze j jdd Ze j je j je j jdd Ze j je j j dd ZdS )Ú HasTableTestTc C s~ t d|tdtddtdtd tjjjrTt d|tdtddtdtdtj d tjj
|
rf| |¡ tjj jrz| |¡ d S ) NÚ
|
test_tableÚidT©Ú primary_keyÚdataé2 Ú test_table_s©Úschema)r r r r r ÚrequiresÚschemasr/ r Ú test_schemaÚview_reflectionÚ define_viewsÚhas_temp_tableÚdefine_temp_tables©r4 Úmetadatar5 r5 r6 Ú define_tablesC s$ ü
|
û
|
|
zHasTableTest.define_tablesc C sp d}t |dt|¡ t |dtd¡ tjjjrldtjtjf }t |dt|¡ t |dtdtj ¡ d S )Nz1CREATE VIEW vv AS SELECT id, data FROM test_tableÚ after_createÚ before_dropz DROP VIEW vvz9CREATE VIEW %s.vv AS SELECT id, data FROM %s.test_table_szDROP VIEW %s.vv) r Úlistenr r rF rG r/ r rH )r4 rN Úqueryr5 r5 r6 rJ Y s
|
þÿÿ ýzHasTableTest.define_viewsc C s t ttjdtj S ©NZ user_tmp_©r r r3 Úident©r4 r5 r5 r6 Útemp_table_nameo s
|
|
ÿz HasTableTest.temp_table_namec C s t ttj}| ¡ }t||tdtjddtdt d¡f|}t j
|
j j r|t j
|
j j r|t |dtdtj ¡ t |dtd ¡ d S )
|
Nr> Tr? ÚnamerB rP ú=create temporary view user_tmp_v as select * from user_tmp_%srQ údrop view user_tmp_v)r r r3 rX r r ÚsaÚINTÚVARCHARr rF rI r/ Útemporary_viewsr rR r rV ©r4 rN ÚkwÚ
|
table_nameÚuser_tmpr5 r5 r6 rL u s0 üûÿþÿÿýz HasTableTest.define_temp_tablesc C sV t j ¡ B}tt jj |d¡ tt jj |d¡ tt jj |d¡ W 5 Q R X d S )Nr= rC Únonexistent_table)r r3 Úbeginr' ÚdialectÚ has_tabler& ©ÚselfÚconnr5 r5 r6 Útest_has_table s zHasTableTest.test_has_tablec C s t tj}t| d¡ td|tdt}t| d¡ | tj¡ z(t| d¡ | ¡ t| d¡ W 5 |
|
tj¡ X d S )Nr= Z new_tableÚcol) r r r3 r' rg r r r r& ÚcreateÚdropÚ clear_cache)ri rN ÚinspÚntr5 r5 r6 Útest_has_table_cache s
|
z!HasTableTest.test_has_table_cachec C sh t j ¡ T}tt jjj|dt jd tt jjj|dt jd tt jjj|dt jd W 5 Q R X d S )Nr= rD rC rd )r r3 re r& rf rg rH r' rh r5 r5 r6 Útest_has_table_schema¡ s, ÿÿ ÿÿ ÿÿz"HasTableTest.test_has_table_schemac C s2 t j ¡ }tt jjj|ddd W 5 Q R X d S )Nr= Znonexistent_schemarD )r r3 re r& rf rg rh r5 r5 r6 Ú!test_has_table_nonexistent_schema´ s ÿÿz.HasTableTest.test_has_table_nonexistent_schemac C s t |}t| d¡ d S ©NÚvv©r r' rg ©ri Ú
|
connectionrp r5 r5 r6 Útest_has_table_view½ s z HasTableTest.test_has_table_viewc C s" t |}| ¡ }t| |¡ d S ©N)r rX r' rg )ri ry rp rX r5 r5 r6 Útest_has_table_temp_table s z&HasTableTest.test_has_table_temp_tablec C s t |}t| d¡ d S ©NÚ
|
user_tmp_vrw rx r5 r5 r6 Útest_has_table_temp_viewÈ s z%HasTableTest.test_has_table_temp_viewc C s t |}t| dtj¡ d S ru )r r' rg r rH rx r5 r5 r6 Útest_has_table_view_schemaÏ s z'HasTableTest.test_has_table_view_schemaN)r8 r9 r: Ú __backend__r; rO rJ rX rL rk rr r rF rG rs rt Úviewsrz rK r| rI r_ r r r5 r5 r5 r6 r< @ s4
|
|
|
|
|
|
|
|
r< c @ sT e Zd ZdZedd ZejddddZdd Z ed
|
d Z
|
ej j ed d Z dS )Ú HasIndexTestTc C s t d|tdtddtdtdtdtd}td|jj tjj j
|
r|t d|tdtddtdtdt j d }td
|
|jj d S ) Nr= r> Tr? rA rB Údata2Úmy_idxrD Úmy_idx_s) r r r r r! ÚcrA r rF rG r/ r rH )r4 rN Úttr5 r5 r6 rO Ù s" û
|
ûzHasIndexTest.define_tablesrf Ú inspectorÚkind©Úargnamesc s" |dkr fddS t jS d S )Nrf c s t jjj f| |S r{ )r r3 rf Ú has_index)ÚaÚk©rj r5 r6 Ú<lambda>ò ó z)HasIndexTest._has_index.<locals>.<lambda>)r r )ri r rj r5 r r6 Ú
|
_has_indexð s zHasIndexTest._has_indexc C s | ||¡}|ddst|ddr(t|ddr6t|ddrDt|ddrRt|ddr`ttd| jjjj}td|td t tdd }|
|
|¡ |
|
|¡ zV|d
|
krÐ|ddr¸t|ddrÆt|j ¡ |ddd ksât|ddd ksôtW 5 | |¡ | |¡ X d S ) Nr= r
r rd Znonexistent_idxZmy_idx_2Z test_table_2Zmy_idx_3Úfoor T)r ÚAssertionErrorr! Útablesr= r r r r r rm rn Ú__self__ro )ri r ry rN ÚmethÚidxZtblr5 r5 r6 Útest_has_indexö s2 ü
|
|
|
|
zHasIndexTest.test_has_indexc C s` | ||¡}|ddtjds t|ddtjdr4t|ddtjdrHt|ddtjdr\td S )Nr= r rD r
rd Znonexistent_idx_s)r r rH r )ri r ry r r5 r5 r6 Útest_has_index_schema s ÿ
|
ÿz"HasIndexTest.test_has_index_schemaN)r8 r9 r: r r; rO r Ú combinationsr r r rF rG r r5 r5 r5 r6 r Ö s
|
|
r c @ s´ e Zd ZdZdZedd Zdd Zedd Zee j
|
j d d
|
Z ed d Z ed d Zedd Zedd Zee j
|
jdd Zee j
|
jdd Zee j
|
jdd ZdS )ÚQuotedNameArgumentTestÚonceTc C s´ t d|tdttdtdtdtdtdttjdddt d d¡tjdd
|
dtjdgd gd dtj d ddddd t
|
j j j rút d|tdttdtdtdtdtdttjdddt dd¡tjdddtjdgd gddtj d ddddd t d|tdtddtdtdd t
|
j jj r°t
|
j j j r>ddg}ndg}|D ]f}d tjjj d | ¡tjjj |¡f }t |d t|¡ t |d td tjjj d | ¡ ¡ qHd S )!Nú quote ' oner> rY rB rA Z
|
related_idzpk quote ' one©rY zix quote ' onez uq quote' onez
|
related.idzfk quote ' onez name != 'foo'zck quote ' onezquote ' one commentT)ÚcommentÚ test_needs_fkú quote " twozpk quote " twozix quote " twoz uq quote" twozfk quote " twozck quote " two zquote " two commentÚrelatedr? ©r¢ z"CREATE VIEW %s AS SELECT * FROM %súview %srP rQ z DROP VIEW %s)r r r r r\ ÚPrimaryKeyConstraintr! ÚUniqueConstraintÚForeignKeyConstraintÚCheckConstraintr rF Úsymbol_names_w_double_quoter/ Úview_column_reflectionr r3 rf Zidentifier_preparerÚquoter rR r )r4 rN ÚnamesrY rS r5 r5 r6 rO & s
|
þ ÿ î
|
|
þ ÿ î û þÿ
|
ÿü
|
ÿÿÿýz$QuotedNameArgumentTest.define_tablesc C s t ddt jjf¡| S )N)r r£ )r r rF r« )Úfnr5 r5 r6 Úquote_fixturesz s
|
þýz%QuotedNameArgumentTest.quote_fixturesc C sP t tj}tjjjr.| |¡}tt |t
|
n t t | |¡}W 5 Q R X d S r{ ) r r r3 r rF Úreflect_table_optionsr/ Úget_table_optionsr' Ú
|
isinstancer2 r ÚNotImplementedError)ri rY rp Úresr5 r5 r6 Útest_get_table_options s
|
|
|
|
z-QuotedNameArgumentTest.test_get_table_optionsc C s t tj}| d| ¡s td S )Nr¦ )r r r3 Úget_view_definitionr ©ri rY rp r5 r5 r6 Útest_get_view_definition s
|
z/QuotedNameArgumentTest.test_get_view_definitionc C s t tj}| |¡std S r{ )r r r3 Ú get_columnsr r¸ r5 r5 r6 Útest_get_columns s
|
z'QuotedNameArgumentTest.test_get_columnsc C s t tj}| |¡std S r{ )r r r3 Úget_pk_constraintr r¸ r5 r5 r6 Útest_get_pk_constraint s
|
z-QuotedNameArgumentTest.test_get_pk_constraintc C s t tj}| |¡std S r{ )r r r3 Úget_foreign_keysr r¸ r5 r5 r6 Útest_get_foreign_keys s
|
z,QuotedNameArgumentTest.test_get_foreign_keysc C s t tj}| |¡std S r{ )r r r3 Ú get_indexesr r¸ r5 r5 r6 Útest_get_indexes s
|
z'QuotedNameArgumentTest.test_get_indexesc C s t tj}| |¡std S r{ )r r r3 Úget_unique_constraintsr r¸ r5 r5 r6 Útest_get_unique_constraints¥ s
|
z2QuotedNameArgumentTest.test_get_unique_constraintsc C s t tj}| |¡std S r{ )r r r3 Úget_table_commentr r¸ r5 r5 r6 Útest_get_table_comment« s
|
z-QuotedNameArgumentTest.test_get_table_commentc C s t tj}| |¡std S r{ )r r r3 Úget_check_constraintsr r¸ r5 r5 r6 Útest_get_check_constraints± s
|
z1QuotedNameArgumentTest.test_get_check_constraintsN)r8 r9 r: Zrun_create_tablesr r; rO r° r¶ r rF r¬ r¹ r» r½ r¿ rÁ Ú unique_constraint_reflectionrà Úcomment_reflectionrÅ Úcheck_constraint_reflectionrÇ r5 r5 r5 r6 r " s6
|
S
|
|
|
|
|
|
r c
|
C s t jd dd t jjfdd}t jtjtjtjdd}t jtj tj
|
tj tjtj tj tj
|
B tj tj B dd}t jddd d}||||| S )
|
Nc S s t jS r{ )r rH r5 r5 r5 r6 r ¼ r z$_multi_combination.<locals>.<lambda>rE r r, r TFÚ
|
use_filter) r r rF rG r ÚDEFAULTÚ TEMPORARYÚANYr ÚTABLEÚVIEWÚMATERIALIZED_VIEWZANY_VIEW)r¯ rE r, r Ú filter_namesr5 r5 r6 Ú_multi_combination¸ s2 þúü
|
|
ø
|
rÓ c @ s$ e Zd Zd ZZdZedd Zedd Zedd Z ed d
|
Z
|
ed d Z d d Z dd Z dd ZdejejdfddZdejejdfddZdejejdfddZedd Zdejejdfdd Zed d Zdejejdfd d Zed!d" Zdejejdfd#d$Zed%d& Z dejejdd'fd(d)Z ed*d+ Z dejejdfd,d-Z ed.d/ Z e!j"j#d0d1 Z$e!j"j#d2d3 Z%e!j"j#d4d5 Z&e!j"j#d6d7 Z'e!j"j#e!j"j(d8d9 Z)e!j"j#d:d; Z*e!j"j#d<d= Z+e!j,dd>e!j"j-fd?d@e!j,de!j"j.fd'dAd@dBdC Z/e!j,de!j"j.fd'dAd@dDdE Z0e!j"j1dFdG Z2e!j"j3e!j"j4dHdI Z5e!j"j6dJdK Z7e!j"j6e!j"j.dLdM Z8d¦dNdOZ9e!j,dPd'de!j"j.fdd'e!j"j3fdde!j"j.e!j"j3 fdQd@dRdS Z:e!j"j;dTdU Z<e!j"j;dVdW Z=e!j"j;e!j"j>e!j"j4dXdY Z?e!j,dZde!j"j.fdAd@e!j"j@d[d\ ZAe!j,dZde!j"j.fdAd@e!j"j-d]d^ ZBe!j"jCe!j"j.d_d` ZDe!j,dZde!j"j.fdAd@e!j"jEdadb ZFe!j,dcddded@e!j"jEe!j"jGe!j"jHdfdg ZIe!j"j;e!j"jJdhdi ZKe!j"jLdjdk ZMe!j,de!j"j.fdZdAd@e!j"jJdldm ZNe!j"j3e!j,dZde!j"j.fdAd@dndo ZOe!j"j3dpdq ZPe!j"jQdrds ZRe!j,de!j"j.fdZdAd@dtdu ZSe! ,de!j"j.fd'¡dvdw ZTe!jUdxdy ZVe!j"jWeXdzd{ ZYe!j"j6eXd|d} ZZd~d Z[d§ddZ\d¨ddZ]eXdd
Z^e!j"j@eXdd Z_dd Z`e!j"j-eXdd Zae!j"jEeXdd Zbe!j"jJeXdd Zce!j"jdeXdd Zee!j,de!j"jWfdde!j"j@fde!j"j-fde!j"jEfde!j"jJfde!j"jdfde!j"j6fdd@ dd Zfdd Zge!j,dd'dAd@e!j,de!j"jhfd'dd@d d¡ Zie!j"j6d¢d£ Zje!j"jkd¤d¥ ZldS )©ÚComponentReflectionTestNTc C s* | |d ¡ tjjjr&| |tjj¡ d S r{ )Údefine_reflected_tablesr rF rG r/ r rH rM r5 r5 r6 rO Û s
|
z%ComponentReflectionTest.define_tablesc C s |r|d }nd}t jjjr0td| ddf}nd}td|tdtjd d
|
td t d ¡d dtdt
|
¡ d dtdtj f| tj ddddt d¡|d d
|
}td|tdtj d d
|
tdtj td| dd dtd tj td| td t d ¡d d tj d!d"dtjddd#d$d|d d
|
td%|tdtj td&tj t|jjtd't d(¡d d)tjdd*d+d|d d td,|td-tj d d.d/td t d(¡d0d1td2t d(¡d3d1td4t d5¡d6d1|d7d8 td9|td t d(¡|d:d8 t jjjr¢|d kr4td;|td-tj d d
|
td t d(¡td<td=t jj d tjjjd> nntd?|td-tj d d
|
td@tdAtjjj td t d(¡|d d tdB|td-tj d d
|
td t d(¡|d d t jjjrhtdC|jj|jjd d tdD|jj|jj|jj |shtdE|tdFt d ¡d dG}tdH|td-tj d d
|
tdFt d ¡d dG}t jj jrht jj jrhtdI|jj ¡ tdJ|jj ¡ t jj jr| !||¡ |st jj"jr| #|¡ d S )KNÚ.Ú z%susers.user_idÚ
|
user_id_fkr r5 ÚusersÚuser_idTr? Útest1é F©ÚnullableÚtest2Úparent_user_idú test2 > 0Úzz_test2_gt_zeroúusers check constraint©rY r¡ ú test2 <= 1000©rE r¢ Ú
|
dingalingsÚ dingaling_idÚ
|
address_idz %semail_addresses.address_idÚzz_email_add_id_fgú di fk commentÚid_userrA é )Úuniquez$address_id > 0 AND address_id < 1000Úaddress_id_gt_zeroÚzz_dingalings_multipleúdi unique commentÚemail_addressesÚremote_user_idÚ email_addressé )ÚindexÚ email_ad_pkú ea pk commentÚ comment_testr> ú
|
id comment)r@ r¡ údata % comment©r¡ Úd2ú)Comment types type speedily ' " \ '' Fun!Úd3é* úComment
|
with escapesú the test % ' " \ table comment)rE r¡ Úno_constraintsú"no
|
constraints has escaped commentÚ local_tableÚ remote_idz%s.remote_table_2.id)r¢ rE Ú remote_tableÚlocal_idz%s.local_table.idÚremote_table_2Ú users_t_idxÚ users_all_idxÚnoncol_idx_test_nopkÚqr¥ Únoncol_idx_test_pkÚnoncol_idx_nopkÚ noncol_idx_pk)$r rF Ú self_referential_foreign_keysr/ r r r r\ r] ÚCHARZFloatr rª r r¨ r rÚ r§ Úcross_schema_fk_reflectionr rH r3 rf Údefault_schema_nameÚindex_reflectionr! rÛ rß Úindexes_with_ascdescÚ reflect_indexes_with_ascdescr Údescr¬ rJ Útemp_table_reflectionrL )r4 rN rE Z schema_prefixZparent_id_argsrÙ r r r5 r5 r6 rÕ á sJ
|
|
ÿÿýòýý
|
ýþüâ
|
ÿö ýôû
|
|
ÿþôÿÿþóú ÿüû ÿþ z/ComponentReflectionTest.define_reflected_tablesc C s t ttjdtj S rT rU rW r5 r5 r6 rX s
|
|
ÿz'ComponentReflectionTest.temp_table_namec C s¨ t ttj}| ¡ }t||tdtjddtdt d¡tdtjtj ddtj
|
dt d d¡f|}t j jjr¤t j jjr¤t |d
|
td tj
|
¡ t |d td ¡ d S )Nr> Tr? rY rB r Ú user_tmp_uq_r Ú user_tmp_ixrP rZ rQ r[ )r r r3 rX r r r\ r] r^ r¨ rV r! r rF rI r/ r_ r rR r r` r5 r5 r6 rL s6
|
|
óòÿþÿÿýz*ComponentReflectionTest.define_temp_tablesc
|
C sæ t jjjrdh}nt }dD ]Ä}|}|r6| d| }|d }||krJdnd}d| d| d | }t |d
|
t|¡ ||krÂd } |rt d ¡r| d| } d | d| d}
|
t |d
|
t|
|
¡ t |dtd| d| ¡ q d S )Nrç )rÙ rò rç rÖ Z_vz MATERIALIZED r× zCREATE zVIEW z AS SELECT * FROM rP Ú mat_indexÚoraclez CREATE INDEX z ON z(data)rQ zDROP ) r rF Úmaterialized_viewsr/ Úsetr rR r Úagainst) r4 rN rE Ú materializedrb ÚfullnameZ view_nameÚprefixrS Z
|
index_namer r5 r5 r6 rJ · s.
|
ÿ ÿz$ComponentReflectionTest.define_viewsc C sD i }t j|kr| |¡ t j|kr,| |¡ t j|kr@| |¡ |S r{ )r rÏ ÚupdaterÐ rÑ )ri r r r r! rµ r5 r5 r6 Ú _resolve_kindÒ s
|
|
|
|
|
|
z%ComponentReflectionTest._resolve_kindc C s< t jjjs | ¡ | ¡ n t jjjs8| |¡ | ¡ d S r{ )r rF r¬ r/ Úclearr r$ )ri r r! r5 r5 r6 Ú_resolve_viewsÜ s
|
|
|
|
z&ComponentReflectionTest._resolve_viewsc sü dd |t jkrdd |t jkr,dd d ddhtjjddd d
|
| ¡ hitjjj s|d
|
d¡ tjj ddg¡ tjj j sd dd g¡ tjj j r¬tjjj sÂd d
|
| ¡ g¡ tjjj sÜd d
|
g¡ fd d | ¡ D }|S ) Nc S s dS )NTr5 )Ú_r5 r5 r6 r å r z8ComponentReflectionTest._resolve_names.<locals>.<lambda>c S s d| d kS ©NÚtmpé r5 ©r r5 r5 r6 r ç r c S s d| d kS r) r5 r, r5 r5 r6 r é r r r r r r r~ c s> i | ]6\}}|r|d kr r4|d kr||qS )r+ r5 )Ú.0r Úv©rÒ ÚremovedrE Z scope_filterr5 r6 Ú
|
<dictcomp> s ü z:ComponentReflectionTest._resolve_names.<locals>.<dictcomp>)r rÌ rÍ r r rH rX rF r r/ Úaddr$ r r Útemp_table_namesr_ Úitems)ri rE r, rÒ Úvaluesrµ r5 r/ r6 Ú_resolve_namesä sF
|
|
ûþ
|
|
ÿ
|
ÿÿþ
|
þz&ComponentReflectionTest._resolve_namesc C sÖ |dft ji}|dft j|dft j|dft ji}| ||¡ |dft j|dft j|dft j|dft j|d ft j|d
|
ft j|d ft j|d ft j|d ft j|dft j|| ¡ ft ji }| ||||¡}| ||||¡}|S )NÚ dingalings_vÚemail_addresses_vÚusers_vr~ rÙ rç rò rù r r r r r r ©r( rÎ r' rX r% r6 ) ri rE r, r rÒ r! r r rµ r5 r5 r6 Ú exp_options sF ý
|
õ z#ComponentReflectionTest.exp_optionsc
|
C sÈ dd i}|df|i}|df||df||df|i}| ||¡ |df||df||df||d fdd
|
i|d fdd i|d f||df||df||df||df||| ¡ f|i }| ||||¡} | |||| ¡} | S )NÚtextr7 r8 r9 r~ rÙ rç rò rù r r r r r r r r )r' rX r% r6 )
|
ri rE r, r rÒ Úemptyr! r r rµ r5 r5 r6 Ú exp_comments. sP ý ÿ ÿ
|
ñz$ComponentReflectionTest.exp_commentsc
|
s$ dt jd dfdd fdd}|df dd t jd
|
d d d gi}|df d d t jd
|
d dg|df dd t jd
|
dt jd dt jd dg|df dd t jd
|
d dgi}| ||¡ |df|d ddd ddd dg|d f|d d d d g|d f|d d dg|d f|dd d d d!d d"d#d d$d%d g|d&f d g|d'f|d d d(g|d)f|d d* d g|d+f|d d g|d,f d-g|d.f|d d-g|| ¡ f|d d dgi }| ||||¡} | |||| ¡} | S )/NFTc S s* | |t j|||d}|dkr&| d¡ |S )N)rY Ú autoincrementÚtypeÚdefaultr¡ rÞ Úomitr? )r( rÎ Úpop)rY ÚautorA r¡ rÞ rµ r5 r5 r6 rl Y s ú
|
z0ComponentReflectionTest.exp_columns.<locals>.colc s dt jdd|} | f|S )NTF)rD rA rÞ ©r( rÎ )rY ra ©rl r5 r6 Úpkh s z/ComponentReflectionTest.exp_columns.<locals>.pkr7 rè rB )rD rÞ ré rì rA r8 ró rô r9 rÚ rÛ rÝ rß rà r~ r> rY r rÙ rç rò rù rú rü rû rý rþ rÿ r r r r r r r r r r r: )
|
ri rE r, r rÒ rG r! r r rµ r5 rF r6 Ú exp_columnsR s ÿ
|
üÿ ý üýô
|
|
üüý
|
|
þ
|
ù
|
ýß'z#ComponentReflectionTest.exp_columnsc C s ddddhS )NrY r@ rÞ rA r5 ©ri r5 r5 r6 Ú_required_column_keys² s z-ComponentReflectionTest._required_column_keysc C sN t jd ddd}|d d}tjjjr8|df|di}n |df|i}|df||df||d f|i}| ||¡ |d
|
f|d |d f|d|d f|dddd|df|d|df||df|d|df|d|df|d|df||df|d|| ¡ f|di } tjjjs*| ¡ D ] }
|
|
|
d d k r
|
t j|
|
d< q
|
|
|
|| ||¡} | |||| ¡} | S )Nrä c W s t || |dS )N)Úconstrained_columnsrY r¡ )Úlist)rY r¡ Úcolsr5 r5 r6 rG ½ s ýz+ComponentReflectionTest.exp_pks.<locals>.pkr r7 rè r8 r9 r~ rÙ rÚ rç rò ré r÷ rø rù r> r r r r r r rY ) r( rÎ r rF Z materialized_views_reflect_pkr/ r' rX Úreflects_pk_namesr5 r% r6 ) ri rE r, r rÒ rG r= r! r r Úvalrµ r5 r5 r6 Úexp_pks¶ s^
|
|
ý ÿ
|
ó z ComponentReflectionTest.exp_pksc C s ddhS )NrY rK r5 rI r5 r5 r6 Ú_required_pk_keysæ s z)ComponentReflectionTest._required_pk_keysc s¢ G dd d |t jd f fdd }|dfg i}|dfg |dfg |dfg i}| ||¡ |d f|d
|
gd gd d d g|df|dgd gd |dgdgddddg|df|dgd gd g|dfg |dfg |df|dgdgdtjd g|d f|d gdgdd d g|dfg |d fg |d fg || ¡ fg i }tjjj s<||d f
|
¡ tjj j s~| ¡ D ],} | D ] }
|
|
|
d! t jk rXt j|
|
d!< qXqP| ||||¡} | |||| ¡} | S )"Nc @ s e Zd Zdd ZdS )z+ComponentReflectionTest.exp_fks.<locals>.ttc S s |d kpt jjj|kS r{ )r r3 rf r ©ri Úotherr5 r5 r6 Ú__eq__ò s þz2ComponentReflectionTest.exp_fks.<locals>.tt.__eq__N©r8 r9 r: rT r5 r5 r5 r6 r ñ s r c s$ | ||t j|d k r|n ||dS )N)rK Úreferred_columnsrY r- Úreferred_schemaÚreferred_tabler¡ rE )rM Zref_colZ ref_tableÚ
|
ref_schemarY r¡ ©r r5 r6 Úfkø s ÿ÷z+ComponentReflectionTest.exp_fks.<locals>.fkr7 r8 r9 r~ rÙ rà rÚ rØ r rç rì ré rò rê rë rä ró rù r r r r> r )rY r r r r rY )r( rÎ r' r rH rX r rF r r/ r& Únamed_constraintsr5 r% r6 ) ri rE r, r rÒ r[ r! r r ÚvalsrO rµ r5 rZ r6 Úexp_fksê s ú ý ÿûþ
|
ÿ üÿÿ
|
ß# z ComponentReflectionTest.exp_fksc C s dddddhS )NrY rK rW rX rV r5 rI r5 r5 r6 Ú_required_fk_keysB s ûz)ComponentReflectionTest._required_fk_keysc
|
C sî dd ddddd}|dfg i}|dfg |dfg |dfg i}| ||¡ |rf||df |d d
|
d ¡ |d f|d ddd|ddddd |ddddd|df|d tjddd|dtjdd|ddd ddd|d f|d tjd |d tjdd|d fg |d!fg |d"f|d#tjdd|d$f|d%tjdd|d&fg |d'f|d(d)d(d*id+|d,f|d(d-d(d*id+|| ¡ f|d.d/d |d0d1tj ddd2i }tjj j
|
rªtjj j
|
sÊ||d'f ¡ ||d,f ¡ | ||||¡} | |||| ¡} | S )3NF)rî Úcolumn_sortingÚ
|
duplicatesr[ c s t jj}t jj}t jj}|r"|jr,|r0|js0dS |t|| tjg d} r~ | d< |jr~| d | d< }
|
fdd|
|
D | d< |r| | d< | gS ) Nr5 )rî Ú column_namesrY Údialect_optionsÚinclude_columnsr` rb Ú expressionsc s g | ]}| krd n|qS r{ r5 ©r- r ©r` r5 r6 Ú
|
<listcomp>p s zDComponentReflectionTest.exp_indexes.<locals>.idx.<locals>.<listcomp>Zduplicates_constraint) r rF Z foreign_keys_reflect_as_indexZ#unique_constraints_reflect_as_indexZ*reflect_indexes_with_ascdesc_as_expressionr/ rL r( rÎ ) rY rî r` ra r[ rM Zfk_reqZdup_reqZsorting_expressionrµ Úorigr5 rg r6 r S s4 ÿ
|
ÿÿû
|
ÿ
|
z0ComponentReflectionTest.exp_indexes.<locals>.idxr7 r8 r9 r~ rA r r rÙ rà rØ T)rY r[ rÚ rß rÛ r r
|
)rY rî rç )rY rî ra rì ré rè rð rò rô ró rù r r r r r r r r r )r )rY r` r r r r rY r )rY ra rî )r' Úextendr( rÎ rX r rV r rF r r/ r r& r% r6 )
|
ri rE r, r rÒ r r! r r rµ r5 r5 r6 Ú exp_indexesL s¦
|
ú % ý
|
ÿ ýûý þ ÿÿ ýÿ ÿÿ
|
|
|
üþÖ5ÿþz#ComponentReflectionTest.exp_indexesc C s
|
dddhS )NrY rb rî r5 rI r5 r5 r6 Ú_required_index_keysÁ s z,ComponentReflectionTest._required_index_keysFc C s d dd ddd}|dfg i}|dfg |dfg |dfg i}| ||¡ |d f|d
|
d d d d d|df|dtjtjd|dddddd|dfg |dfg |dfg |dfg |dfg |d fg |d fg |d fg || ¡ f|d d tj d!i } |rö||| S | || ||¡}
|
| ||||
|
¡}
|
|
|
S d S )"NF)Úduplicates_indexÚis_indexr¡ c W s8 t jj}|r|jsdS t|| |d}|r2||d< |gS )Nr5 )rb rY r¡ rm )r rF Z*unique_index_reflect_as_unique_constraintsr/ rL )rY rm rn r¡ rM Úreqrµ r5 r5 r6 ÚucÍ s
|
ýz+ComponentReflectionTest.exp_ucs.<locals>.ucr7 r8 r9 r~ rÙ rÛ rß r
|
T)rY rm rn rç rA )rY rm ré rè rð rñ )rY rm r¡ rò rù r r r r r r rY r r )r' r( rÎ rX r rV r% r6 ) ri rE r, r rÒ Úall_rp r! r r rµ r5 r5 r6 Úexp_ucsÅ sr ÿ ý ûÿ ûþ
|
|
ÿä
|
z ComponentReflectionTest.exp_ucsc C s ddhS )NrY rb r5 rI r5 r5 r6 Ú_required_unique_cst_keys
|
s z1ComponentReflectionTest._required_unique_cst_keysc
|
sö G dd dt d fdd }|dfg i}|dfg |dfg |dfg i}| ||¡ |d f|d
|
tj|d d d dg|df|dddg|dfg |dfg |dfg |dfg |dfg |dfg |dfg |dfg || ¡ fg i }| ||||¡} | |||| ¡} | S ) Nc @ s e Zd Zdd ZdS )z+ComponentReflectionTest.exp_ccs.<locals>.ttc S s( | ¡ dd¡ dd¡ dd¡}| |kS )Nú(r× ú)ú`)ÚlowerÚreplace)ri rS rµ r5 r5 r6 rT s ÿ þ ýÿz2ComponentReflectionTest.exp_ccs.<locals>.tt.__eq__NrU r5 r5 r5 r6 r s r c s | ||dS )N)ÚsqltextrY r¡ r5 )r< rY r¡ rZ r5 r6 Úcc s z+ComponentReflectionTest.exp_ccs.<locals>.ccr7 r8 r9 r~ rÙ rå rá râ rã rü rç z$address_id > 0 and address_id < 1000rï r rò rù r r r r r r )N)Ústrr' r( rÎ rX r% r6 )
|
ri rE r, r rÒ rz r! r r rµ r5 rZ r6 Úexp_ccs s^
|
ý
|
ýþþÿ
|
éz ComponentReflectionTest.exp_ccsc C s ddhS )NrY ry r5 rI r5 r5 r6 Ú_required_cc_keysH s z)ComponentReflectionTest._required_cc_keysc C s t |}ttjj| ¡ k d S r{ )r r' r r rH Úget_schema_namesrx r5 r5 r6 Útest_get_schema_namesL s z-ComponentReflectionTest.test_get_schema_namesc C s, t |}t| tjj¡ t| d¡ d S )NÚsa_fake_schema_foo)r r' Ú
|
has_schemar r rH r& rx r5 r5 r6 Útest_has_schemaR s z'ComponentReflectionTest.test_has_schemac C s8 |j ddttjjid}t|}ttjj| ¡ k dS )z
|
test #7300r Úbar©Zschema_translate_mapN)Úexecution_optionsr# r r rH r r' r~ rx r5 r5 r6 Ú%test_get_schema_names_w_translate_mapY s þÿz=ComponentReflectionTest.test_get_schema_names_w_translate_mapc C sD |j ddttjjid}t|}t| tjj¡ t| d¡ d S )Nr r r r ) r
r# r r rH r r' r r& rx r5 r5 r6 Ú test_has_schema_w_translate_mapg s þÿz7ComponentReflectionTest.test_has_schema_w_translate_mapc
|
C s t |}td| ¡ k t| d¡ | td¡ zHtd| ¡ k t| d¡ | ¡ td| ¡ k t| d¡ W 5 | td¡ X d S )NZfoo_barzCREATE SCHEMA foo_barzDROP SCHEMA foo_bar)r r& r~ r Úexecuter ro r' rx r5 r5 r6 Útest_schema_cachet s z)ComponentReflectionTest.test_schema_cachec C s$ t ¡ }t| t|jds td S )Nr )r r1 r Úhasattrrf r )ri Úenginer5 r5 r6 Útest_dialect_initialize
s z/ComponentReflectionTest.test_dialect_initializec C s t |}t|j|jj d S r{ )r r r rf rx r5 r5 r6 Ú test_get_default_schema_name s z4ComponentReflectionTest.test_get_default_schema_nameÚ foreign_keyÚorder_byr Ú
|
use_schemac s |r t j}nd }dddddddh t|}|rDdd | |¡D }n
|
| |¡} fd
|
d |D }|d kr~d d dg}t|| ndd d g}tt|| d S )Nrù r r r r r r c S s g | ]}|d r|d qS )r r5 )r- Zrecr5 r5 r6 rh ¬ s þz@ComponentReflectionTest.test_get_table_names.<locals>.<listcomp>c s g | ]}| kr|qS r5 r5 ©r- Út©Z_ignore_tablesr5 r6 rh ³ s r rÙ rò rç )r rH r Z get_sorted_table_and_fkc_namesÚget_table_namesr Úsorted) ri ry r r rE rp r Ú table_namesÚanswerr5 r r6 Útest_get_table_names s.
|
ù
|
þ
|
|
|
z,ComponentReflectionTest.test_get_table_namesc C sn t |}|rtj}nd }| |¡}tjjjrRtt |ddg t|
|
|¡dg ndddg}tt || d S )Nr8 r9 r7 ) r r rH Úget_view_namesr rF r r/ r r Úget_materialized_view_names)ri ry r rp rE r r r5 r5 r6 Útest_get_view_names¼ s
|
|
|
z+ComponentReflectionTest.test_get_view_namesc C s, t |}| ¡ }tt|dtj g d S rT )r Zget_temp_table_namesr r r rV ©ri ry rp r3 r5 r5 r6 Útest_get_temp_table_namesÍ s z1ComponentReflectionTest.test_get_temp_table_namesc C s$ t |}| ¡ }tt|dg d S r} )r Zget_temp_view_namesr r r r5 r5 r6 Útest_get_temp_view_namesÓ s z0ComponentReflectionTest.test_get_temp_view_namesc C s | |¡ d S r{ )Ú_test_get_comments©ri ry r5 r5 r6 Útest_get_commentsÚ s z)ComponentReflectionTest.test_get_commentsc C s | |tjj¡ d S r{ )r r r rH r r5 r5 r6 Ú test_get_comments_with_schemaÞ s z5ComponentReflectionTest.test_get_comments_with_schemac C s t |}| j|d}t|jd|d||df t|jd|d||df t|jd|d||df | jjj}t|j||d|||f d S )NrD rù rÙ )r r> r rÄ r r rY )ri ry rE rp ÚexpÚno_cstr5 r5 r6 r ã s&
|
þ
|
þ
|
þ
|
|
þz*ComponentReflectionTest._test_get_comments)FFzuse_views,use_schemac C sl |r t j}nd }| jj| jj }}|r2dddg}nddg}t|}t|||fD ]\} }
|
|} |j| | d} tt | dkt | t
|
|
|
j D ]Ø\} }t |j | | d | | d j}|j}t|tjjrÐ|j}t d
|
¡rð|tjtjfkrðtj}tt t|j |j¡ tj tj tjtjtj tj tj g¡dkd |j |j| | d |f |j!s| | d d kst"qqPd S ) Nr9 r8 r7 rÙ rò rD r rY r@ r z%s(%s), %s(%s)rA )#r rH r rÙ rò r Úziprº r' ÚlenÚ enumerateÚcolumnsr rY Ú __class__r@ r³ r\ r Z
|
TypeEnginer r Ú sql_typesÚDateÚDateTimer Ú__mro__Ú intersectionr ÚNumericZTimer Z_Binaryr@ r )ri ry Z use_viewsr rE rÙ Ú addressesr rp rb ÚtableZ schema_namerM Úirl ÚctypeZ ctype_defr5 r5 r6 r» û s\ þ
|
ÿùýÿñÿïz(ComponentReflectionTest.test_get_columnsc C s6 | ¡ }| j| }t|t |d}| j||dd d S )N©Ú autoload_withF)Zstrict_constraints)rX r r r Zassert_tables_equal)ri ry rb rc Zreflected_user_tmpr5 r5 r6 Ú test_reflect_table_temp_tableH s
|
ÿ ÿz5ComponentReflectionTest.test_reflect_table_temp_tablec C sf | ¡ }| j| }t|}| |¡}tt|dkt| t|jD ] \}}t|j || d qDd S )Nr rY )
|
rX r r rº r' r¦ r§ r¨ r rY )ri ry rb rc rp rM r² rl r5 r5 r6 Útest_get_temp_table_columnsU s
|
|
z3ComponentReflectionTest.test_get_temp_table_columnsc C s0 t |}| d¡}tdd |D dddg d S )Nr~ c S s g | ] }|d qS r r5 ©r- rl r5 r5 r6 rh f s zFComponentReflectionTest.test_get_temp_view_columns.<locals>.<listcomp>r> rY r )r rº r )ri ry rp rM r5 r5 r6 Útest_get_temp_view_columns` s
|
z2ComponentReflectionTest.test_get_temp_view_columns©Fc C sð |rt jj}nd }| jj| jj }}t|}| j|d}|j|j |d}|
|
|g|||j f g| j ¡ |j|j |d} |||j f d }
|
t | d |
|
t j j ¡ t | d d W 5 Q R X | jjj } |
|
|j| |dg||| f g| j ¡ d S )NrD rK rY r÷ )r r rH r rÙ rò r rP r¼ rY Ú _check_listrQ r rF rN Úfail_ifr ) ri ry r rE rÙ r° rp r£ Z
|
users_consZ addr_consZexp_colsr¤ r5 r5 r6 r½ h s.
|
ÿ
|
ýz.ComponentReflectionTest.test_get_pk_constraintc C sT |r t j}nd }| jj| jj }}t|}|}tjjj r´|j
|
|j |d}|d } tjj ¡ t| d d W 5 Q R X t| d | t| d |j t| d dg t| d d
|
g |j
|
|j |d}
|
|
|
d } tjj ¡ t| d d k W 5 Q R X t| d | t| d |j t| d dg t| d d g | jjj } t|j
|
| |dg d S ) NrD r rY rØ rW rX rV rÚ rK rà ró )r rH r rÙ rò r r rF r r/ r¾ rY r\ r¼ r Ú implicitly_named_constraintsr' r ) ri ry r rE rÙ r° rp Zexpected_schemaZ users_fkeysÚfkey1Z
|
addr_fkeysr¤ r5 r5 r6 r¿ s2
|
|
z-ComponentReflectionTest.test_get_foreign_keysc
|
C s | d|jj dtjj dtjj ¡\}}}t|}| |j¡}t t
|
|d |d }t |d tjj t |d |j t |d d g t |d
|
d g |j|jtjjd }t t
|
|d |d } t | d d |jjfk t | d |j t | d d g t | d
|
d g d S )Nz%s.local_tablez%s.remote_tablez%s.remote_table_2r+ r rW rX rV r> rK r rD r ) r rf r r r rH r r¾ rY r r¦ r' )
|
ri ry r r r rp Z local_fkeysr¾ Z remote_fkeysZfkey2r5 r5 r6 Ú"test_get_inter_schema_foreign_keys³ s:
|
|
|
ý
|
ÿþÿÿz:ComponentReflectionTest.test_get_inter_schema_foreign_keysc C sz |r t j}nd }t|}|jd|d}| j|d}| |||df | j¡ | jjj }| |j||d|||f | j¡ d S )NrÙ rD )
|
r rH r rÀ rk r» rl r r rY )ri ry r rE rp Úindexesr£ r¤ r5 r5 r6 rÁ Ù s"
|
ÿ
|
|
ýz(ComponentReflectionTest.test_get_indexes)r r )r r z tname,ixnamec C s t |}| |¡}| ¡ d |f }| ||| j¡ t|t |d}tt|j d t
|
t |j d j | tt |j d j | d S )Nr´ r+ r )r rÀ rk r» rl r r r r¦ rÀ r
|
rL r± rY )ri ry ÚtnameZixnamerp rÀ Zexpected_indexesr r5 r5 r6 Útest_get_noncol_indexô s
|
z-ComponentReflectionTest.test_get_noncol_indexc C sB t |}| ¡ }| |¡}| jddd |f }| ||| j¡ d S )NT)rq )r rX r rr r» rl )ri ry rp rY Ú reflectedr£ r5 r5 r6 Ú&test_get_temp_table_unique_constraints
|
s
|
|
z>ComponentReflectionTest.test_get_temp_table_unique_constraintsc C sn t |}| ¡ }| |¡}|D ]}| dd ¡ q ddgddg}tjjjrVg |d d< tdd |D | d S )
|
Nrc Fr r )rî rb rY r rd c S s g | ]}|d dkr|qS )rY r r5 ©r- r r5 r5 r6 rh s zGComponentReflectionTest.test_get_temp_table_indexes.<locals>.<listcomp>) r rX rÀ rC r rF Ú index_reflects_included_columnsr/ r )ri ry rp rb rÀ ÚindÚexpectedr5 r5 r6 Útest_get_temp_table_indexes s
|
ÿ
|
þz3ComponentReflectionTest.test_get_temp_table_indexesc C s |r t j}nd }tddgdddddgdddddgddd d
|
gdd dgdd dgdgt d ¡d}td|tdt d¡tdt d¡tdtj td t d¡td
|
t d¡|d}|D ]"}|
|
tj |d d |d i¡ q¼| |¡ t |}t|jd|dt d ¡d} t }
|
tt|t| t|| D ]B\} } | dd ¡} | rT|
|
| ¡ t| dd ¡d t| | q0t }td|||d} dd | jD }dd | jD dg¡}| |¡rÂt|
|
rÞt|
|
| t|t | jj j }t|j||dg d S )NZunique_ar )rY rb Z unique_a_b_cÚbr Z unique_c_a_bZunique_asc_keyZascÚkeyz i.have.dotsz i have spacesrY ©rË Ztesttblrõ rí rD rb rm r¡ )rµ rE c S s h | ]
|
}|j qS r5 r rÅ r5 r5 r6 Ú <setcomp>o s zFComponentReflectionTest.test_get_unique_constraints.<locals>.<setcomp>c S s h | ]}t |tjr|jqS r5 )r³ r\ r¨ rY )r- Zuqr5 r5 r6 rÍ p s þ) r rH r ÚoperatorÚ
|
itemgetterr r r\ r r Zappend_constraintr¨ rm r r r r r¦ r¥ rC r2 r rÀ Ú constraintsÚ
|
differencer® r r r rY )ri rN ry r rE Zuniquesr± rp rp rà Znames_that_duplicate_indexri ZreflZdupeZreflected_metadataZ idx_namesZuq_namesr¤ r5 r5 r6 rà $ sx
|
|
|
ú÷
|
÷ ÿ
|
þ
|
ü þü
|
|
z3ComponentReflectionTest.test_get_unique_constraintsc C s@ |r t j}nd }t|}dD ] }|j||d}tt| q d S )N)r9 r8 r7 rD )r rH r r· r' Úbool)ri ry r rE rp Úviewr. r5 r5 r6 r¹ ~ s z0ComponentReflectionTest.test_get_view_definitionc C sH t |}tt | d¡ W 5 Q R X tt | d¡ W 5 Q R X d S )NZview_does_not_existrÙ )r r r r· rx r5 r5 r6 Ú'test_get_view_definition_does_not_exist s
|
|
|
z?ComponentReflectionTest.test_get_view_definition_does_not_existc C sF t |}dD ]4\}}| |¡}dd |D | }| dd¡s tq dS )a test that 'autoincrement' is reflected according to sqla's policy.
|
|
Don't mark this test as unsupported for any backend !
|
|
(technically it fails with MySQL InnoDB since "id" comes before "id2")
|
|
A backend is better off not returning "autoincrement" at all,
|
instead of potentially returning "False" for an auto-incrementing
|
primary key column.
|
|
))rÙ rÚ )rò ré )rç rè c S s i | ]}|d |qS r r5 rf r5 r5 r6 r1 ª s zBComponentReflectionTest.test_autoincrement_col.<locals>.<dictcomp>r? TN)r rº Úgetr )ri ry rp rÁ ÚcnamerM Zid_r5 r5 r6 Útest_autoincrement_col s
|
|
z.ComponentReflectionTest.test_autoincrement_colc C s t tj}|rtjnd }tjjjr\|jd|d}t t
|
|t |jd|d}t t
|
|t n"t t |jd|d}W 5 Q R X d S )NrÙ rD r )r r r3 rH r rF r± r/ r² r' r³ r2 r r´ )ri r rp rE rµ r5 r5 r6 r¶ s
|
|
|
z.ComponentReflectionTest.test_get_table_optionsc sv t tj tjjjrV|r tjnd jd} fdd j dD }t
|
|| n t t ¡ }W 5 Q R X d S )NrD c s i | ]}|f j |d qS )rD )r² )r- r± ©rp rE r5 r6 r1 Å s ÿ zHComponentReflectionTest.test_multi_get_table_options.<locals>.<dictcomp>) r r r3 r rF r± r/ rH Úget_multi_table_optionsr r r r´ )ri r rµ r£ r5 rØ r6 Ú test_multi_get_table_options¾ s
|
|
|
þ
|
z4ComponentReflectionTest.test_multi_get_table_optionsc s fdd}|S )Nc s t }||d ||d}| r&| } g }tj|krD| dddg¡ tj|kr\| ddg¡ tj|krt| ddg¡ | r| |d< |r||d < || ||| d ¡d
|
} |g}
|
|tjkrÎ| ¡ } |
|
d ¡ |
|
| ¡ |tjkrô| ¡ } |
|
d ¡ |
|
| ¡ t |
|
| fS ) Nrò )r, r rù rÙ zdoes-not-existr8 r7 rE rÒ )rE r, r rÒ r, r ) r r rÏ rj rÐ rÑ rÕ r rÌ ÚcopyrC Úappend) rE r, r rË Zsingle_reflect_fnZ
|
exp_methodrp ra rÒ r£ ÚkwsZnkw©ry r5 r6 Úprovide_fixtureÐ sD
|
|
|
ÿ
|
|
ü
|
|
|
|
|
|
z>ComponentReflectionTest.get_multi_exp.<locals>.provide_fixturer5 )ri ry rß r5 rÞ r6 Ú get_multi_expÎ s .z%ComponentReflectionTest.get_multi_expc C sH |||||t j| j\}}}|D ]"} | ¡ |jf | }
|
t|
|
| q d S r{ )r r² r; ro rÙ r © ri rà rE r, r rË rp rÝ r£ ra Úresultr5 r5 r6 Ú#test_multi_get_table_options_tables s ú
|
z;ComponentReflectionTest.test_multi_get_table_options_tablesc
|
C sD |||||t j| j\}}}|D ] } | ¡ t|jf | | q d S r{ )r rÄ r> ro r Zget_multi_table_comment)
|
ri rà rE r, r rË rp rÝ r£ ra r5 r5 r6 Ú test_get_multi_table_comment s ú
|
z4ComponentReflectionTest.test_get_multi_table_commentc sV t ddd t|tr8t fdd| ¡ D || nt fdd|D || d S )N©r< c S s t dd| ¡ ¡ S )Nz['\" ]r× )ÚreÚsubrw rå r5 r5 r6 Ú_clean$ s z:ComponentReflectionTest._check_expressions.<locals>._cleanc s i | ]\}} ||qS r5 r5 )r- Úer. ©rè r5 r6 r1 ( s z>ComponentReflectionTest._check_expressions.<locals>.<dictcomp>c s g | ] } |qS r5 r5 )r- ré rê r5 r6 rh * s z>ComponentReflectionTest._check_expressions.<locals>.<listcomp>)r{ r³ r2 r r4 )ri râ r£ Úerr_msgr5 rê r6 Ú_check_expressions# s
|
z*ComponentReflectionTest._check_expressionsc C s¸ |d krt ||| nt t|t|| t||D ]~\}}t|t|B D ]d}||ksh||krL||krL| d| d| }|dkr| || || |¡ qLt || || | qLq4d S )Nz - )re r` )r r¦ r¥ r rì ) ri râ r£ Úreq_keysÚmsgÚrré r rë r5 r5 r6 r» , s z#ComponentReflectionTest._check_listc C s\ t t| ¡ t| ¡ |D ]8}|| || }}|rF|g|g }}| ||||¡ q d S r{ )r r Úkeysr» )ri râ r£ rí Ú
|
make_listsr rï ré r5 r5 r6 Ú_check_table_dict: s z)ComponentReflectionTest._check_table_dictc C sN |||||t j| j\}}}|D ](} | ¡ |jf | }
|
| |
|
|| j¡ q d S r{ )r rº rH ro Úget_multi_columnsrò rJ rá r5 r5 r6 Útest_get_multi_columnsB s ú
|
z.ComponentReflectionTest.test_get_multi_columnsc C sR |||||t j| j\}}}|D ],} | ¡ |jf | }
|
| j|
|
|| jdd q d S )NT)rñ )r r¼ rP ro Zget_multi_pk_constraintrò rQ rá r5 r5 r6 Ú test_get_multi_pk_constraintT s" ú
|
ÿz4ComponentReflectionTest.test_get_multi_pk_constraintc C sT t jjjsP||fD ]<}| ¡ D ].}t|dkr tdd |D r |j|d q qd S )Nr+ c s s" | ]}| d ¡dtjfkV qdS )rY N)rÕ r( rÎ )r- r. r5 r5 r6 Ú <genexpr>l s z7ComponentReflectionTest._adjust_sort.<locals>.<genexpr>rÌ )r rF r½ r/ r5 r¦ ÚanyÚsort)ri râ rÈ rË ÚobjrO r5 r5 r6 Ú _adjust_sorth s
|
ÿz$ComponentReflectionTest._adjust_sortc C s` |||||t j| j\}}}|D ]:} | ¡ |jf | }
|
| |
|
|dd ¡ | |
|
|| j¡ q d S )Nc S s t | d S )NrK ©Útuple©Údr5 r5 r6 r r zEComponentReflectionTest.test_get_multi_foreign_keys.<locals>.<lambda>)r r¾ r^ ro Zget_multi_foreign_keysrú rò r_ rá r5 r5 r6 Útest_get_multi_foreign_keysq s" ú
|
ÿz3ComponentReflectionTest.test_get_multi_foreign_keysc C sN |||||t j| j\}}}|D ](} | ¡ |jf | }
|
| |
|
|| j¡ q d S r{ )r rÀ rk ro Zget_multi_indexesrò rl rá r5 r5 r6 Útest_get_multi_indexes s ú
|
z.ComponentReflectionTest.test_get_multi_indexesc C s` |||||t j| j\}}}|D ]:} | ¡ |jf | }
|
| |
|
|dd ¡ | |
|
|| j¡ q d S )Nc S s t | d S )Nrb rû rý r5 r5 r6 r ¨ r zKComponentReflectionTest.test_get_multi_unique_constraints.<locals>.<lambda>)r r rr ro Z get_multi_unique_constraintsrú rò rs rá r5 r5 r6 Ú!test_get_multi_unique_constraints s ú
|
z9ComponentReflectionTest.test_get_multi_unique_constraintsc C s` |||||t j| j\}}}|D ]:} | ¡ |jf | }
|
| |
|
|dd ¡ | |
|
|| j¡ q d S )Nc S s t | d S )Nry rû rý r5 r5 r6 r » r zJComponentReflectionTest.test_get_multi_check_constraints.<locals>.<lambda>)r rÆ r| ro Zget_multi_check_constraintsrú rò r} rá r5 r5 r6 Ú test_get_multi_check_constraints« s ú
|
z8ComponentReflectionTest.test_get_multi_check_constraintsr² rº r¼ r¾ rÀ r rÆ rÄ Úmethodc C s2 t |}t||}tt |d W 5 Q R X d S )NZtable_does_not_exists)r Úgetattrr r )ri r ry rp r r5 r5 r6 Útest_not_existing_table¾ s
|
|
z/ComponentReflectionTest.test_not_existing_tablec
|
s` t j fdd}tj t d|¡4 ttd t| t dt
|
d ¡ W 5 Q R X W 5 Q R X d S )Nc s" | di ¡}td|d< | |S )NZ unreflectableÚerr)NÚ
|
some_table)Ú
|
setdefaultr )r r Úur©Zmcr5 r6 ÚpatchedÞ s z;ComponentReflectionTest.test_unreflectable.<locals>.patchedró r r ) r ró r( ÚpatchÚobjectr r r Z reflect_tabler r )ri ry r r5 r
|
r6 Útest_unreflectableÛ s
|
ÿz*ComponentReflectionTest.test_unreflectabler c s t }|rtjnd |j| |dd t|}| ¡}|rr|| ¡7 }z|| ¡7 }W n tk
|
rp Y nX r fdd|D }t t
|
|j t
|
| d S )NF)rE r Z resolve_fksc s g | ]} d | qS )rÖ r5 r rD r5 r6 rh û s z9ComponentReflectionTest.test_metadata.<locals>.<listcomp>) r r rH Úreflectr r r r r´ r r r )ri ry r r Úmrp r r5 rD r6 Ú test_metadataé s
|
z%ComponentReflectionTest.test_metadatac C s t d|tdtddtdtdddd | |¡ t|}| d¡}t|ddi | d¡}d d
|
|D }ddd }t|| d S ) NÚunicode_commentsÚunicodeu é試èáºÎ©rü Úemojiu âï¸â¨u 試èáºÎ©â¨r< c S s i | ]}|d |d qS rä r5 rf r5 r5 r6 r1 s zAComponentReflectionTest.test_comments_unicode.<locals>.<dictcomp>)r r ©r r r Ú
|
create_allr rÄ r rº )ri ry rN rp ÚtcrM Úvaluer£ r5 r5 r6 Útest_comments_unicodeþ s û
|
|
|
|
z-ComponentReflectionTest.test_comments_unicodec C sp t d|tdtdddd | |¡ t|}| d¡}t|ddi | d¡d }t|d |d iddi d S )
|
Nr r u& ðð§ðð§ââï¸ð§ââï¸rü u& ð©ð°ðð¤·ââï¸ð¤·ââï¸r< r rY r¡ r )ri ry rN rp r r r5 r5 r6 Útest_comments_unicode_full s ü
|
|
z2ComponentReflectionTest.test_comments_unicode_full)N)NN)NF)mr8 r9 r: Ú run_insertsÚ run_deletesr r; rO rÕ rX rL rJ r% r' r6 r rÎ r r; r> rH ÚpropertyrJ rP rQ r^ r_ rk rl rr rs r| r} r rF Zschema_reflectionr r r r Zschema_create_deleter r r r Ú!foreign_key_constraint_reflectionrG r r r3 r rI r_ r rÉ r¡ r¢ r r» r r¶ r· r¬ r¹ Ú!primary_key_constraint_reflectionr½ r¿ r r¿ r rÁ r r r rÈ rÄ Ztemp_table_reflect_indexesrÉ rà r¹ rÔ Útable_reflectionr× r¶ rÚ Úfixturerà r± rÓ rã rä rì r» rò rô rõ rú rÿ r r rÊ r r r r r r Z comment_reflection_full_unicoder r5 r5 r5 r6 rÔ Ö s
|
|
.
|
|
!
|
|
-û
|
!û
|
&û
|
`
|
û
|
0
|
û
|
X
|
û
|
u
|
ú
|
E
|
û
|
:
|
|
|
|
|
|
|
|
ý
|
ÿ $
|
ÿ
|
|
|
|
ý÷
|
B
|
|
|
|
ÿ
|
ÿ & $
|
ÿ ý
|
|
ÿ V
|
ÿ
|
|
|
|
ÿ
|
|
|
1
|
|
|
|
þþ
|
þþ
|
ë
|
|
ÿ
|
rÔ c @ sh e Zd ZdZdZejdd Zejdd Zdd Z d d
|
Z
|
d d Z ej j d d Zej j dd ZdS )ÚTableNoColumnsTest)Zreflect_tables_no_columnsTc C s t d| | |¡ d S ©Nr= )r r ©ri ry rN r5 r5 r6 Útable_no_columns* s
|
z#TableNoColumnsTest.table_no_columnsc C s< t d| t |dtd¡ t |dtd¡ | |¡ d S )Nr= rP z*CREATE VIEW empty_v AS SELECT * FROM emptyrQ zDROP VIEW IF EXISTS empty_v)r r rR r r r$ r5 r5 r6 Úview_no_columns/ s
|
ý ÿz"TableNoColumnsTest.view_no_columnsc C s$ t dt |d}tt|jg d S )Nr= r´ ©r r r rL r )ri ry r% Út2r5 r5 r6 Ú test_reflect_table_no_columns? s z0TableNoColumnsTest.test_reflect_table_no_columnsc C s2 t |}t| d¡g | ¡ }t|dg i d S )Nr= r# )r r rº ró )ri ry r% rp Úmultir5 r5 r6 Ú!test_get_columns_table_no_columnsC s z4TableNoColumnsTest.test_get_columns_table_no_columnsc C s* t }| |¡ t|j dg¡s&td S r# )r r r r r® r )ri ry r% r r5 r5 r6 Ú"test_reflect_incl_table_no_columnsI s
|
z5TableNoColumnsTest.test_reflect_incl_table_no_columnsc C s$ t dt |d}tt|jg d S )NÚempty_vr´ r' )ri ry r& r( r5 r5 r6 Ú test_reflect_view_no_columnsN s z/TableNoColumnsTest.test_reflect_view_no_columnsc C s8 t |}t| d¡g |jtjd}t|dg i d S )Nr- )r )Nr- )r r rº ró r rÐ )ri ry r& rp r* r5 r5 r6 Ú test_get_columns_view_no_columnsS s z3TableNoColumnsTest.test_get_columns_view_no_columnsN)r8 r9 r: Ú __requires__r r r! r% r& r) r+ r, rF r r. r/ r5 r5 r5 r6 r" & s
|
|
|
r" c
|
@ sø e Zd ZdZejdejjfdddejjdd Z ejj
|
dd Z ejj d d
|
Z d d Zejjd d Zejjdd Zejjdd Zejdddejjfdddejjfi ddejjfi ddejjfdddejjfdddejjfdddd ZdS )Ú ComponentReflectionTestExtraTrº r r c sÚ |r t j}nd }td|tdt tjdddtjddd|d td |td
|
t d ¡|d | |¡ t |}t
|
|j d|dt d ¡d }dd fdd|D }t|ddddddg d }t|j ||dg d S )NZsa_ccr za > 1 AND a < 5Zcc1r za = 1 OR (a > 2 AND a < 5)Z
|
UsesCasingrD r rA rõ rY rÌ c S s d t d| ¡ tj¡¡S )Nú zand|\d|=|a|or|<|>)Újoinræ Úfindallrw ÚI)ry r5 r5 r6 Ú normalize
s ÿzJComponentReflectionTestExtra.test_get_check_constraints.<locals>.normalizec s" g | ]}|d |d dqS )rY ry ©rY ry r5 )r- Úitem©r6 r5 r6 rh s ÿzKComponentReflectionTestExtra.test_get_check_constraints.<locals>.<listcomp>za = 1 or a > 2 and a < 5r7 za > 1 and a < 5)r rH r r r r\ rª r r r r rÆ rÎ rÏ r )ri rN ry r rE rp rà r¤ r5 r9 r6 rÇ _ sL
|
ÿø
|
ü
|
þ
|
þþþz7ComponentReflectionTestExtra.test_get_check_constraintsc s t d|tdtdtdtdtdtd}tdt |jj¡|jjt |jj ¡ dtdt
|
|jj¡ td |jj | ¡ t }d dgd
|
i d g} fd d }||d G dd dt }G fdddt }tjjjrtdd dd g|dd|dgd
|
d} || | d| ¡ dd g|d dgd
|
d}
|
||
|
| |
|
¡ t| d¡| t } t d| d} n8td* t| d¡| t } t d| d} W 5 Q R X | | | jj¡ d S )Nr Úxrí ÚyÚzÚt_idxa° long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string Z
|
t_idx_longZt_idx_2F)rY rb rî rc c s: t jjjr*g | d< jj dg i| d< n | di ¡ d S )Nrd Z_includerc )r rF rÆ r/ r rY r )ÚentryrÞ r5 r6 Ú completeIndex´ s
|
ÿ
|
zYComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.completeIndexr c @ s e Zd Zdd ZdS )z[ComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.lower_index_strc S s | ¡ }d|ko d|kp d|kS )Nrw r: r; ©rw )ri rS Úolr5 r5 r6 rT À s zbComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.lower_index_str.__eq__NrU r5 r5 r5 r6 Úlower_index_str¿ s rB c s e Zd Z fddZdS )z^ComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.coalesce_index_strc s d| ¡ ko |kS )NÚcoalescer@ rR ©Úlong_strr5 r6 rT Æ s zeComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.coalesce_index_str.__eq__NrU r5 rD r5 r6 Úcoalesce_index_strÅ s rF zlower(x)zlower(y))rY rb re rî z coalesce(x, 'z')r´ z>Skipped unsupported reflection of expression-based index t_idx)r r r r! r rw r r: r< r; rC r r r{ r rF Z reflect_indexes_with_expressionsr/ ÚinsertrÜ r rÀ r r Z!compare_table_index_with_expectedr rY ) ri rN ry r rp rÈ r? rB rF Z
|
expr_indexZexpr_index_longÚm2r( r5 )ry rE r6 Ú%test_reflect_expression_based_indexes sp û&
|
üÿ ýø
|
ÿú
|
ÿ ÿzBComponentReflectionTestExtra.test_reflect_expression_based_indexesc C sÖ t d|tdtdtdtd}td|jj}dg|j|jj d< | |¡ t
|
|}| d¡}t |ddgdgdt jdg t |d d
|
d |jj dg t dt |d }t t|jd j|jj d dg d S ) Nr r: rí r; r= ÚincludeF)rY rb rd rî rc r rc z
|
%s_includer´ )r r r r! r r: rc r rY r r rÀ r r( rÎ r rL rÀ )ri rN ry r r rp rÀ r( r5 r5 r6 Útest_reflect_covering_indexó sD ü
|
|
ûÿþ
|
|
ÿüÿüz8ComponentReflectionTestExtra.test_reflect_covering_indexc G s@ t d|fdd t|D }| |¡ dd t| d¡D S )Nr c S s g | ]\}}t d | |qS )zt%dr )r- r² Útype_r5 r5 r6 rh "
|
s zAComponentReflectionTestExtra._type_round_trip.<locals>.<listcomp>c S s g | ] }|d qS )r@ r5 rf r5 r5 r6 rh &
|
s )r r§ rm r rº )ri ry rN r r r5 r5 r6 Ú_type_round_trip
|
s þý
|
z-ComponentReflectionTestExtra._type_round_tripc C sH | ||t dd¡¡D ],}t|tjs*tt|jd t|jd qd S )Né rÜ )rM rª r¯ r³ r r Z precisionZscale©ri ry rN Útypr5 r5 r6 Útest_numeric_reflection(
|
s
|
ÿ z4ComponentReflectionTestExtra.test_numeric_reflectionc C s8 | ||t d¡¡d }t|tjs(tt|jd d S )Né4 r )rM rª r r³ r r ÚlengthrO r5 r5 r6 Útest_varchar_reflection1
|
s ÿþz4ComponentReflectionTestExtra.test_varchar_reflectionc C sT t d|tdtddtdtdd}| |¡ tdd t| d¡D ddd d S )
|
Nr r TrÝ rÊ Fc S s i | ]}|d |d qS )rY rÞ r5 r¸ r5 r5 r6 r1 C
|
s ÿ zIComponentReflectionTestExtra.test_nullable_reflection.<locals>.<dictcomp>)r rÊ )r r r rm r r rº )ri ry rN r r5 r5 r6 Útest_nullable_reflection9
|
s ü
|
þûz5ComponentReflectionTestExtra.test_nullable_reflectionNZCASCADEzSET NULLz NO ACTIONZRESTRICTzexpected,ondelete,onupdatec s" i }|r||d< |r ||d< |d kr(|}t d|tdtdddd t d|tdtddtd ttd
|
d d td tddd t d|tdtddtdtdddtdttjdgdgfddi|dd | |¡ t|}| d¡d d t
|
fdd D i | d¡d d t
|
| d S )NÚondeleteÚonupdater: r> Tr? r¥ r± Zx_idzx.idÚxidr Útesté
|
ÚuserrY rB FrÝ Útidztable.idZmyfkr r- c s i | ]} | r| | qS r5 r5 )r- r ©Úoptsr5 r6 r1 ¡
|
s zMComponentReflectionTestExtra.test_get_foreign_key_options.<locals>.<dictcomp>) r r r r r r\ r© r r r¾ r )ri ry rN rÈ rV rW r- rp r5 r] r6 Ú test_get_foreign_key_optionsJ
|
sV * ü ú ÿÿÿ÷
|
z9ComponentReflectionTestExtra.test_get_foreign_key_options)r8 r9 r: r r r rF rG rÊ rÇ Zindexes_with_expressionsrI rÆ rK rM r rQ rT rU Z1foreign_key_constraint_option_reflection_ondeleteZ1foreign_key_constraint_option_reflection_onupdateZ1fk_constraint_option_reflection_ondelete_noactionZ1fk_constraint_option_reflection_onupdate_restrictZ1fk_constraint_option_reflection_ondelete_restrictr_ r5 r5 r5 r6 r1 [ sj
|
ÿ 5
|
Z
|
*
|
|
|
|
üüüüüüÛ'r1 c @ s0 e Zd ZdZdZedd Zdd Zdd Zd S )
|
ÚNormalizedNameTest)Zdenormalized_namesTc C sL t tddd|tdtdd t tddd|tdtddtdtd d S ) NÚt1T©r r> r? r( Út1idzt1.id)r r" r r r rM r5 r5 r6 rO ¬
|
s
|
ý
|
üz NormalizedNameTest.define_tablesc C s~ t }ttddd|tjd}|jd }|jj |jj ¡s>t
|
t }|j tjdd d |jd jj |jd jj ¡szt
|
d S ) Nr( Trb r´ ra c S s | ¡ dkS )N©ra r( r@ )rY r r5 r5 r6 r Å
|
r zINormalizedNameTest.test_reflect_lowercase_forced_tables.<locals>.<lambda>)Úonly) r r r" r r3 r r rc Z
|
referencesr> r r )ri rH Zt2_refZt1_refZm3r5 r5 r6 Ú$test_reflect_lowercase_forced_tablesº
|
s
|
ÿ
|
ÿz7NormalizedNameTest.test_reflect_lowercase_forced_tablesc C sP dd t tj ¡ D }t|d ¡ |d ¡ t|d ¡ |d ¡ d S )Nc S s g | ]}| ¡ d kr|qS )rd r@ r r5 r5 r6 rh Ê
|
s þz;NormalizedNameTest.test_get_table_names.<locals>.<listcomp>r r+ )r r r3 r r Úupperrw )ri Z
|
tablenamesr5 r5 r6 r É
|
s
|
þz'NormalizedNameTest.test_get_table_namesN) r8 r9 r: r0 r r; rO rf r r5 r5 r5 r6 r` ¨
|
s
|
r` c @ s< e Zd Zdd Zdd Zdd Zdd Zejj d d
|
Z
|
d S ) ÚComputedReflectionTestc C s^ t tj}| d¡}dd |D }td|d d k t|d d d t|d d d d S ) NÚcomputed_default_tablec S s i | ]}|d |qS r r5 rf r5 r5 r6 r1 Ù
|
s zLComputedReflectionTest.test_computed_col_default_not_set.<locals>.<dictcomp>Z42Ú with_defaultrA ÚnormalÚ computed_col)r r r3 rº r' r
|
)ri rp rM Zcol_datar5 r5 r6 Ú!test_computed_col_default_not_setÕ
|
s
|
|
z8ComputedReflectionTest.test_computed_col_default_not_setc C s¶ t tj}| d¡}dd |D }dD ]}td|| k q&|d }td|k td|d k t| |d d ¡d td |d ktjj j
|
tjj j
|
r²t|d d tjj j
|
d S )
|
Nri c S s i | ]}|d |qS r r5 rf r5 r5 r6 r1 â
|
s zKComputedReflectionTest.test_get_column_returns_computed.<locals>.<dictcomp>)r> rk rj Úcomputedrl ry ú normal+42Ú persisted) r r r3 rº r' r r6 r rF Ú"computed_columns_reflect_persistedr/ Ú"computed_columns_default_persisted)ri rp rM rA rË ÚcompDatar5 r5 r6 Ú test_get_column_returns_computedÞ
|
s$
|
|
|
þ
|
|
þz7ComputedReflectionTest.test_get_column_returns_computedc C sX t d|| k || d }t| |d ¡| tjjjrTt d|k t|d | d S )Nrn ry rp )r' r r6 r rF rq r/ r
|
)ri rA Úcolumnry rp rs r5 r5 r6 Ú check_columnó
|
s
|
z#ComputedReflectionTest.check_columnc C sp t tj}| d¡}dd |D }| |ddtjjj¡ tjj jrR| |ddd¡ tjj
|
jrl| |d d
|
d ¡ d S ) NÚcomputed_column_tablec S s i | ]}|d |qS r r5 rf r5 r5 r6 r1 ÿ
|
s zLComputedReflectionTest.test_get_column_returns_persisted.<locals>.<dictcomp>Úcomputed_no_flagro Úcomputed_virtualznormal+2FÚcomputed_storedz normal-42T) r r r3 rº rv r rF rr r/ Úcomputed_columns_virtualÚcomputed_columns_stored©ri rp rM rA r5 r5 r6 Ú!test_get_column_returns_persistedû
|
s.
|
|
ü
|
ü
|
üz8ComputedReflectionTest.test_get_column_returns_persistedc C sv t tj}|jdtjd}dd |D }| |ddtjjj ¡ tjj
|
j rX| |ddd ¡ tjj j rr| |d
|
d d ¡ d S ) Nrw rD c S s i | ]}|d |qS r r5 rf r5 r5 r6 r1 s zXComputedReflectionTest.test_get_column_returns_persisted_with_schema.<locals>.<dictcomp>rx z normal/42ry znormal/2Frz z normal*42T) r r r3 rº rH rv r rF rr r/ r{ r| r} r5 r5 r6 Ú-test_get_column_returns_persisted_with_schema s4
|
ÿü
|
ü
|
üzDComputedReflectionTest.test_get_column_returns_persisted_with_schemaN) r8 r9 r: rm rt rv r~ r rF rG r r5 r5 r5 r6 rh Ô
|
s rh c @ sH e Zd Zd ZZdZdZedd Zdd Z dd Z
|
e j j d
|
d ZdS ) ÚIdentityReflectionTestNT)Zidentity_columnsr c C s| t d|tdttdtt t d|tdttdddd d
|
dd d tjjjrxt d|tdttdttdd dtj d d S )Nra rk Úid1r( Úid2Tr r éþÿÿÿr é ©ÚalwaysÚstartÚ incrementÚminvalueÚmaxvalueÚcycleÚcacherõ )r r rD )
|
r r r r r rF rG r/ r rH rM r5 r5 r6 rO ; s> üùýý
|
ûz$IdentityReflectionTest.define_tablesc C sÔ t jjjr¬d}t|D ]}||kr| |¡ q|r tt|t| |D ]T}|dkrjt|| || k qH|dkrt|| || k qHt|| || | qHqÐt|| n$t|d |d t|d |d d S )Nr
r > r r r r ) r rF Zidentity_columns_standardr/ rL rC r r¦ r' )ri r r£ ÚapproxZ common_keysr r5 r5 r6 Úcheck] s
|
z IdentityReflectionTest.checkc C s t tj}| d¡| d¡ }|D ]à}|d dkr@td|k q"|d dkr¢d|kr`t|d t|d d td|k | j|d td d
|
d
|
d
|
d d d
|
d d d q"|d dkr"d|krÂt|d t|d d td|k | j|d td ddddd dd d d q"d S )Nra r( rY rk Úidentityr r? rA Fr+ éÿÿÿr
T©r r r r r r r ) r r r3 rº r& r' r r r2 ©ri rp rM rl r5 r5 r6 Útest_reflect_identityz sR
|
ù õ ù õz,IdentityReflectionTest.test_reflect_identityc C s¢ t tj}|jdtjd}|D ]~}|d dkr<td|k q |d dkr d|kr\t|d t|d d td|k | j|d t d d
|
d d d d d dd d q d S )Nra rD rY rk r r r? rA Trõ r+ r Fr
r )
|
r r r3 rº rH r& r' r r r2 r r5 r5 r6 Ú test_reflect_identity_schema¦ s.
|
ù õz3IdentityReflectionTest.test_reflect_identity_schema)r8 r9 r: r r r r0 r; rO r r r rF rG r r5 r5 r5 r6 r 5 s
|
! ,r c @ s< e Zd ZdZedd Zejjdd Z ejj
|
dd Z dS ) ÚCompositeKeyReflectionTestTc C s¢ t d|tdttdttdt d¡tjdddddd dd }t d
|
|tdtdd td ttd ttdt d¡tjdd d g|jj |jj
|
|jj gddd dd d S )NÚtb1r> ÚattrrY rõ Zpk_tb1r Træ Útb2r? ÚpidÚpattrÚpnameZfk_tb1_name_id_attr) r r r rª r^ r\ r§ r© r rY r> r )r4 rN r r5 r5 r6 rO Å s2 ø
|
ýóz(CompositeKeyReflectionTest.define_tablesc C s2 t |}| | jjj¡}t| d¡dddg d S )NrK rY r> r )r r¼ r r rY r rÕ )ri ry rp r@ r5 r5 r6 Útest_pk_column_orderá s z/CompositeKeyReflectionTest.test_pk_column_orderc C s^ t |}| | jjj¡}tt|d |d }t| d¡dddg t| d¡dd d
|
g d S ) Nr+ r rV rY r> r rK r r r )r r¾ r r rY r r¦ rÕ )ri ry rp Z foreign_keysr¾ r5 r5 r6 Útest_fk_column_orderè s z/CompositeKeyReflectionTest.test_fk_column_orderN) r8 r9 r: r r; rO r rF r r r r r5 r5 r5 r6 r  s
|
|
r )
|
rÔ r1 r" r r< r r` rh r r )BrÎ ræ r0 r\ r× r r r r r r r r
|
Z provisionr r rE r r r r r r r r r r r r rª r r r r Úexcr r r r! Z sql.elementsr" Z
|
sql.schemar# r$ r% r& r' r( rN rÙ Z
|
TablesTestr) r< r r rÓ rÔ ZTestBaser" r1 r` Z ComputedReflectionFixtureTestrh r r Ú__all__r5 r5 r5 r6 Ú<module> s L ^5 O,a 1
|
