�
��4]c@s
dd
lm
Z

ddlmZ
ddlmZ
ddlmZ
ddl
mZ
ddlmZ
ddlm	Z	
dd	lm
Z

dd
lmZ
ddlmZ
ddlm
Z

dd
lmZ
dejf
d��YZdejf
d��YZdejf
d��YZdZdS(i(
tconfig(
tengines(
tfixtures(
teq_(
trequirements(
tColumn(
tTablei(
tInteger(
tliteral(
tliteral_column(
tselect(
tStringt
LastrowidTestcBsceZ
dZeZd	Zi
ed6Zed��
Z	d�Z
d�Zd�Ze
jd��
ZRS(
teachtimplements_get_lastrowidtautoincrement_inserttimplicit_returningc
Csrtd
|
t
dtdtdt�t
dtd�
��
td|
t
dtdtdt�t
dtd�
��
dS(	Nt
autoinc_pktidtprimary_keyttest_needs_autoincrementtdatai2t	manual_pkt
autoincrement(RRRtTrueRtFalse(tclstmetadata((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt
define_tabless







cCs;|j|
j
��
j�}t|tjjjd
f�
dS(Ns	some data(texecuteR
tfirstRRtdbtdialecttdefault_sequence_base(tselfttabletconntrow((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt_assert_round_trip*s

c

Cs?tj
j|jjj�d
d�


|j|jjtj
�
dS(NRs	some data(RRRttablesRtinsertR&(
R"((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_autoincrement_on_insert.s"
c
Csbtj
j|jjj�d
d�

}
tj
jt|jjjj	g
�
�
}t
|
j|g
�
dS(NRs	some data(RRRR'RR(tscalarR
t
cRRtinserted_primary_key(R"t
rtpk((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_last_inserted_id3s	
'
c
Csetj
j|jjj�d
d�

}
|
j}tj
jt|jjj	j
g
�
�
}t||�
dS(NRs	some data(RRRR'RR(t	lastrowidR*R
R+RR(R"R-R0R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_native_lastrowid_autoinc?s
	
	
'
(RR(t__name__t
__module__trun_deletesRt__backend__t__requires__Rt__engine_options__tclassmethodRR&R)R/Rtdbapi_lastrowidR1(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyRs

			tInsertBehaviorTestcBs�eZ
dZeZed
��
Zd�Zej	d��
Z
ejd��
Zej
d��
Zej
d��
Zej
d��
Zej
d��
ZRS(	R
cCs�td
|
t
dtdtdt�t
dtd�
��
td|
t
dtdtdt�t
dtd�
��
td	|
t
dtdtdt�t
dtd�
�t
d
tdd�
t
d
tdtddt�

td�
�
�
dS(NRRRRRi2RRtincludes_defaultst
xtdefaultit
yt
2ttype_i(RRRRRRR	R(RR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyRMs,
















c
CsVtj
jr(tjd
i
td6�
}
n	tj}
|
j|j	j
j�dd�

}dS(NtoptionsRRs	some data(Rt	returningtenabledR
ttesting_engineRRRRR'RR((R"tengineR-((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_autoclose_on_insertls

	
	!c
Cs(tj
j|jjj�d
d�

}
dS(NRs	some data(RRRR'RR((R"R-((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt+test_autoclose_on_insert_implicit_returningzs	
c
Cs[tj
j|jjj��
}
tj
j|jjj�j|jjjj	dk�
�
}
dS(
N(RRRR'RR(R
twhereR+RtNone(R"R-((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_empty_insert�s
	

c
	Cs
|jj
}
|jj}tjj|
j�td
ddd�td
ddd�td
ddd�g�
tjj|j�jd	t	|
j
jg
�
j|
j
jj
ddg�
�
��
}t|jdg
�
tjjt	|j
jg
�
j|j
j�
�
}t|j�d
dg�
dS(NRi
Rtdata1itdata2itdata3(
R(
RL(
RM(R'RRRRRR(tdicttfrom_selectR
R+RRHtin_RR,RItorder_bytfetchall(R"t	src_tablet
dest_tabletresult((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_insert_from_select_autoinc�s 

	
	

	



$	
'c
Cs�|jj
}
|jj}tjj|j�jdt|
j	j
g
�
j|
j	j
jddg�
�
��
}t
|jdg
�
tjjt|j	j
g
�
j|j	j
�
�
}t
|j�g�
dS(NRRLRM(
R(R'RRRRRR(ROR
R+RRHRPRR,RIRQRR(R"RSRTRU((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt'test_insert_from_select_autoinc_no_rows�s
	



$	
'c
	Cs

|jj
}
tjj|
j�td
ddd�td
ddd�td
ddd�g�
tjj|
jd	t�
jdt	|
j
jd
|
j
jg�
j
|
j
jjddg�
�
��

ttjjt	|
j
jg
�
j|
j
j�
�
j�dd
dddg�
dS(NRi
RRKiRLiRMtinlinei(RR(
RK(
RL(
RL(
RM(
RM(R'RRRRR(RNRROR
R+RRRHRPRRQRR(R"R#((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_insert_from_select�s
	
	

	


"
"
	
*c

Cs
|jj
}
tjj|
j�td
ddd�td
ddd�td
ddd�g�
tjj|
jd	t�
jdt	|
j
jd
|
j
jg�
j
|
j
jjddg�
�
��

ttjjt	|
g
�
j|
j
j|
j
j��
j�dddddg�
dS(NRi
RRKiRLiRMRXiiii(RR(i
RKii(iRLii(iRLii(iRMii(iRMii(R'R;RRRR(RNRROR
R+RRRHRPRRQRR(R"R#((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt%test_insert_from_select_with_defaults�s&
	
	

	


"
"
	
-



(R2R3R4RR5R8RRFRRBRGt
empty_insertsRJtinsert_from_selectRVRWRYRZ(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR:Is

	
t
ReturningTestcBsleZ
dZd
ZeZi
ed6Zd�Zed��
Z	e
jd��
Zd�Z
d�Zd	�ZRS(R
RBRRcCs;|j|
j
��
j�}t|tjjjd
f�
dS(Ns	some data(RR
RRRRR R!(R"R#R$R%((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR&

s

c
Cs;td
|
t
dtdtdt�t
dtd�
��
dS(NRRRRRi2(RRRRR(RR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR
s



c
Cs�tj
}
|jj}|
j|j�j|jj�
d
d�

}|j	�d}tj
j
t|jjg
�
�
}t||�
dS(NRs	some datai(
RRR'RRR(RBR+RRR*R
R(R"RER#R-R.t
fetched_pk((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt%test_explicit_returning_pk_autocommit
s	


$
!
c
Cs�tj
}
|jj}|
j��A}|j|j�j|jj	�
d
d�

}|j
�d}WdQXtj
jt|jj	g
�
�
}t
||�
dS(NRs	some datai(RRR'RtbeginRR(RBR+RRR*R
R(R"RER#R$R-R.R^((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt(test_explicit_returning_pk_no_autocommit$
s
	



$
!
c

Cs?tj
j|jjj�d
d�


|j|jjtj
�
dS(NRs	some data(RRRR'RR(R&(
R"((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt/test_autoincrement_on_insert_implicit_returning/
s"
c
Csbtj
j|jjj�d
d�

}
tj
jt|jjjj	g
�
�
}t
|
j|g
�
dS(NRs	some data(RRRR'RR(R*R
R+RRR,(R"R-R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt(test_last_inserted_id_implicit_returning4
s	
'
(RBR(R2R3trun_create_tablesR6RR5R7R&R8RRtfetch_rows_post_commitR_RaRbRc(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR]
s



			N(RR:R](tRR
Rt
assertionsRRtschemaRRRRR	R
Rt
TablesTestRR:R]t__all__(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt<module>
s










:�: