�
��4]c@s�dd
lm
Z

ddlmZ
ddlmZ
ddlmZ
ddl
mZ
ddlmZ
ddlmZ
dd	lm	Z	
dd
lm
Z

ddlmZ
ddlmZ
d
ej
f
d��YZdZdS(i(
tconfig(
tfixtures(
tutil(
teq_(
trequirementsi(
tColumn(
tinspect(
tInteger(
tschema(
tString(
tTabletTableDDLTestcBs�eZ
eZd	d�
Zd
�Zd�Zej	e
jd��
�
Zej	e
jd��
�
Z
eje
jd��
�
Zej	e
jd��
�
Zeje
jd��
�
Zeje
jd��
�
ZRS(
c
Cs@td
|j
tdtdtdt�tdtd�
�d|
�
S(Nt
test_tabletidtprimary_keyt
autoincrementtdatai2R(R
tmetadataRRtTruetFalseR	(tselfR((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt_simple_fixtures





c


Cs:td
|j
tdtdtdt�tdtd�
��S(Nt_test_tableR
RRt_datai2(R
RRRRRR	(
R((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt_underscore_fixtures





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(	RtdbtbegintexecutetinserttvaluestselectRtfirst(Rttabletconntresult((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt_simple_roundtrip"s



c
Cs3|j�}
|
j
tjd
t�


|j|
�

dS(Nt
checkfirst(RtcreateRRRR#(RR ((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_create_table(s

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


|j|
�

dS(NRR$(RRttest_schemaR%RRR#(RR ((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_create_table_schema/s

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


|
jtjd
t�


dS(NR$(RR%RRRtdrop(RR ((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_drop_table6s

c
Cs3|j�}
|
j
tjd
t�


|j|
�

dS(NR$(RR%RRRR#(RR ((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_underscore_names=s

c
Csn|j�}
|
j
tjd
t�


d|
_tjjtj|
�
�

t	t
tj�
jd�
i
dd6�
dS(NR$s	a commentRttext(RR%RRRtcommentRRtSetTableCommentRRtget_table_comment(RR ((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_add_table_commentDs

	



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


d|
_tjjtj|
�
�

tjjtj	|
�
�

t
ttj�
jd�
i
dd6�
dS(NR$s	a commentRR,(RR%RRRR-RRR.tDropTableCommentRRR/tNone(RR ((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyttest_drop_table_commentPs

	


N(t__name__t
__module__Rt__backend__R2RRR#Rtcreate_tableRtprovide_metadataR&R(t
drop_tableR*R+tcomment_reflectionR0R3(((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyRs 
			





N(
R(tRR
Rt
assertionsRRRRRRR	R
tTestBaseRt__all__(((sT/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt<module>
s









M