�
���ec@s�
dd
lZddl
mZ
ddl
mZ
ddl
mZ
ddl
mZ
ddlmZ
dd	lmZ
dd
lm	Z	
ddlm
Z

ddlmZ
d
dl
m
Z

d
dl
mZ
d
dl
mZ
d
dl
mZ
d
dl
mZ
d
dl
mZ
d
dl
mZ
d
dl
mZ
d
dl
mZ
dejf
d��YZdejefd��YZdejf
d��YZdZd
S(i����Ni
(
ttestingi(
tconfig(
tfixtures(
tutil(
teq_(
tis_false(
tis_true(
trequirements(
tTablei(
tCheckConstraint(
tColumn(
tForeignKeyConstraint(
tIndex(
tinspect(
tInteger(
tschema(
tString(
tUniqueConstrainttTableDDLTestcBsO
eZ
eZdd�
Zd
�Zdd�
Zd�Ze	j
ejd��
�
Z
e	j
e	jejd��
�
�
Ze	jejd��
�
Ze	j
ejd��
�
Ze	jejd��
�
Ze	jejd	��
�
Ze	jejd
��
�
Ze	jejd��
�
Ze	jejd��
�
Ze	jejd
��
�
ZRS(c
Cs@td
|j
tdtdtdt�tdtd�
�d|
�
S(Nt
test_tabletidtprimary_keyt
autoincrementtdatai2R(RtmetadataR
RtTruetFalseR(tselfR((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt_simple_fixture s





c


Cs:td
|j
tdtdtdt�tdtd�
��S(Nt_test_tableRRRt_datai2(RRR
RRRR(
R((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt_underscore_fixture)s





cCs1|jd
|
�
}t
d|jj�}||fS(NRt
test_index(RRt
cR(RRttabletidx((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt_table_index_fixture1s


cCs`tj
j��K}|j|
j�jd�
�

|j|
j��
}t|j�d�
WdQXdS(Ni
s	some data(i
s	some data(i
s	some data(	R
tdbtbegintexecutetinserttvaluestselectRtfirst(RR"tconntresult((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt_simple_roundtrip6s



c
Cs3|j�}
|
j
tjd
t�


|j|
�

dS(Nt
checkfirst(RtcreateR
R%RR.(RR"((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_create_table<s

c
Cs<|jd
t
j�
}
|
jt
jdt�


|j|
�

dS(NRR/(RR
ttest_schemaR0R%RR.(RR"((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_create_table_schemaCs

c
Cs<|j�}
|
j
tjd
t�


|
jtjd
t�


dS(NR/(RR0R
R%Rtdrop(RR"((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_drop_tableKs

c
Cs3|j�}
|
j
tjd
t�


|j|
�

dS(NR/(RR0R
R%RR.(RR"((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_underscore_namesRs

cCse|j�}|j
|
d
t�


d|_|
jtj|�
�

tt|
�
j	d�
i
dd6�
dS(NR/s	a commentRttext(
RR0RtcommentR'RtSetTableCommentRR
tget_table_comment(Rt
connectionR"((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_add_table_commentYs

	



cCs{|j�}|j
|
d
t�


d|_|
jtj|�
�

|
jtj|�
�

tt	|
�
j
d�
i
dd6�
dS(NR/s	a commentRR7(RR0RR8R'RR9tDropTableCommentRR
R:tNone(RR;R"((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_drop_table_commentes

	



cCsa|j�}|
j
tj|d
t�

�

tt|
�
jd�
�

|
j
tj|d
t�

�

dS(Nt
if_not_existsR(RR'RtCreateTableRRR
t	has_table(RR;R"((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_create_table_if_not_existsqs
cCs�|j�\}}|
j
tj|d
t�

�

tt|
�
jd�
�

tdgt|
�
j	d�
D]}|d^qck�

|
j
tj
|d
t�

�

tdgt|
�
j	d�
D]}|d^q�k�

|
j
tj
|d
t�

�

dS(NR@RR tname(R$R'RRARRR
RBRtget_indexestCreateIndex(RR;R"R#tix((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_create_index_if_not_exists{s



-

-cCs�|j�}|j
|
�

tt|
�
jd
�
�

|
jtj|dt�

�

t	t|
�
jd
�
�

|
jtj|dt�

�

dS(NRt	if_exists(
RR0RR
RBR'Rt	DropTableRR(RR;R"((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_drop_table_if_exists�s
cCs�|j�\}}|j
|
�

td
gt|
�
jd�
D]}|d^q;k�

|
jtj|dt�

�

t	d
gt|
�
jd�
D]}|d^q�k�

|
jtj|dt�

�

dS(NR RRDRI(
R$R0RR
RER'Rt	DropIndexRR(RR;R"R#RG((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_drop_index_if_exists�s


-

-N(t__name__t
__module__Rt__backend__R>RRR$R.Rtcreate_tableRtprovide_metadataR1tschemasR3t
drop_tableR5R6tcomment_reflectionR<R?ttable_ddl_if_existsRCtindex_ddl_if_existsRHRKRM(((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyRs4
			







	


tFutureTableDDLTestc
BseZ
RS((RNRO(((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyRX�s
tLongNameBlowoutTestcBs�eZ
dZeZd
�Zd�Zd�Zd�Zd�Z	e
jdddd	e
jj
j�fd
e
jjj�fdd�
d
��
ZRS(sjtest the creation of a variety of DDL structures and ensure
    label length limits pass on backends

    c	Cs�i
d
djd�t
d�
D�
�
d6}||
_td|
tdtdt�
d	t�

td
g
dg
�}td|
td
�
|d	t�

|j}|
j	|�

t
jjj
r�t|�
}|jd�
}|d
d}||fS|dfSdS(NsGforeign_key_%(table_name)s_%(column_0_N_name)s_%(referred_table_name)s_t
_c
ss.|]$}
djd
�t
d�
D�
�
V
qdS(tc
ss|]}
tj
d�
V
qd
S(tabcdefN(trandomtchoice(t.0t
j((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>�siN(tjointrange(R_t
i((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>�s
i
tfkta_things_with_stufftid_long_column_nameRt
test_needs_fktaids'a_things_with_stuff.id_long_column_nametb_related_things_of_valueiRD(RaRbtnaming_conventionRR
RRRRDt
create_allRtrequirest&foreign_key_constraint_name_reflectiontenabledR
tget_foreign_keysR>(	RRR;t
conventiontconstactual_nametinsptfkstreflected_name((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyRd�s8



	









	




c
	Cs�i
d
djd�t
d�
D�
�
d6}||
_td|
tdtdt�
td	tdt�
�}|j}|j}|
j	|�

t
|�
}|jd�
}|d
}	||	fS(Ns.primary_key_%(table_name)s_%(column_0_N_name)sRZc
ss.|]$}
djd
�t
d�
D�
�
V
qdS(R[c
ss|]}
tj
d�
V
qd
S(R\N(R]R^(R_R`((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>

siN(RaRb(R_Rc((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>

s
i
tpkReRfRtid_another_long_nameRD(RaRbRjRR
RRRRDRkR
tget_pk_constraint(
RRR;Rpt
aRqRrRsRvRu((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyRv�s$



	



	
	





c
Cs�i
d
djd�t
d�
D�
�
d6}||
_td|
tdtdt�
td	t��}td|j	j
|j	j�}|j}|
j
|�

t|�
}|jd�
}|d
d}	||	fS(Ns(index_%(table_name)s_%(column_0_N_name)sRZc
ss.|]$}
djd
�t
d�
D�
�
V
qdS(R[c
ss|]}
tj
d�
V
qd
S(R\N(R]R^(R_R`((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>
siN(RaRb(R_Rc((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>
s
i
RGReRfRRwiRD(RaRbRjRR
RRRR>R!RfRwRDRkR
RE(
RRR;RpRyRqRrRsRGRu((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyRG
s$



	




	




c	Cs�i
d
djd�t
d�
D�
�
d6}||
_tdd�}td|
tdtd	t�
tdt�|�
|j}|
j	|�

t
|�
}|jd�
}|d
d}||fS(Ns4unique_constraint_%(table_name)s_%(column_0_N_name)sRZc
ss.|]$}
djd
�t
d�
D�
�
V
qdS(R[c
ss|]}
tj
d�
V
qd
S(R\N(R]R^(R_R`((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>9
siN(RaRb(R_Rc((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>9
s
i
tuqRfRwReRiRD(RaRbRjRRR
RRRDRkR
tget_unique_constraints(	RRR;RpRqRrRsRzRu((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyRz3
s&



	





	




c	Cs�i
d
djd�t
d�
D�
�
d6}||
_td�
}td|
tdtd	t�
td
t�|�
|j}|
j	|�

t
|�
}|jd�
}|dd}||fS(
Nscheck_constraint_%(table_name)sRZc
ss.|]$}
djd
�t
d�
D�
�
V
qdS(R[c
ss|]}
tj
d�
V
qd
S(R\N(R]R^(R_R`((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>U
siN(RaRb(R_Rc((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pys	<genexpr>U
s
i
tckssome_long_column_name > 5ReRfRtsome_long_column_nameiRD(RaRbRjR	RR
RRRDRkR
tget_check_constraints(	RRR;RpRqRrRsR|Ru((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyR|P
s&



	





	




RdRvRGR|Rztargnamesttype_cCs�t||
�||�\}}t
|�
d
ks6t�
|dk	r�|dt
|�
!}t
|�
t
|�
kr�t|dd!|dt
|�
d!�
q�t||�
ndS(Ni�ii����i(tgetattrtlentAssertionErrorR>R(RR�RR;RrRutoverlap((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_long_convention_namel
s	



((
Rd(
Rv(
RG(RNROt__doc__RRPRdRvRGRzR|RtcombinationsRltcheck_constraint_reflectiontas_skipstunique_constraint_reflectionR�(((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyRY�s	.				





(RRXRY(R]R[RR
RRt
assertionsRRRRRRR	R
RRR
RRRtTestBaseRtFutureEngineMixinRXRYt__all__(((sR/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt<module>s,
















��