File: //opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyc
�
���ec @ s d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m
Z
d d
l m Z d d l m Z d d l m
Z
d d
l m Z d e j f d � � YZ d e j f d � � YZ d e j f d � � YZ d Z d S( i ( t config( t engines( t fixtures( t eq_( t requirements( t Column( t Tablei ( t Integer( t literal( t literal_column( t select( t Stringt
LastrowidTestc B sc e Z d Z e Z d Z i e d 6Z e d � � Z d � Z
d � Z d � Z e
j d � � Z RS(
t eacht implements_get_lastrowidt autoincrement_insertt implicit_returningc
C sr t d | t d t d t d t �t d t d � � � t d | t d t d t d t �t d t d � � � d S( Nt
autoinc_pkt idt primary_keyt test_needs_autoincrementt datai2 t manual_pkt
autoincrement( R R R t TrueR t False( t clst metadata( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt
define_tables s c C s8 | j | j � � j � } t | | j j d f � d S( Ns some data( t executeR
t firstR t dialectt default_sequence_base( t selft tablet connt row( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt _assert_round_trip0 s
c C s? | j | j j j � t d d � � | j | j j | � d S( NR s some data( R t tablesR t insertt dictR% ( R! t
connection( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt test_autoincrement_on_insert: s c C s_ | j | j j j � t d d � � } | j t | j j j j � � } t | j
| f � d S( NR s some data( R R& R R' R( t scalarR
t cR R t inserted_primary_key( R! R) t rt pk( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt test_last_inserted_idA s !!c C sb | j | j j j � t d d � � } | j } | j t | j j j j � � } t
| | � d S( NR s some data( R R& R R' R( t lastrowidR+ R
R, R R ( R! R) R. R1 R/ ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt test_native_lastrowid_autoincI s
! !( R R ( t __name__t
__module__t run_deletesR t __backend__t __requires__R t __engine_options__t classmethodR R% R* R0 R t dbapi_lastrowidR2 ( ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR s
t InsertBehaviorTestc B s� e Z d Z e Z e d � � Z e j d � � Z e j
d � � Z e j d � � Z
e j d � � Z e j d � � Z e j d � � Z e j d � � Z e j d � � Z RS(
R
c C s� t d | t d t d t d t �t d t d � � � t d | t d t d t d t �t d t d � � � t d | t d t d t d t �t d t d � � t d
t d d �t d
t d t d d t �t d � �� d S( NR R R R R i2 R R t includes_defaultst xt defaulti t yt 2t type_i ( R R R R R R R R ( R R ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR W s, c C s� t j j r( t j d i t d 6� } n t j } | j � �. } | j | j
j j � t
d d � � } Wd QX| j s| t � | j s� t � | j s� t � | j s� | j � d k s� t � d S( Nt optionsR R s some data( R t returningt enabledR t testing_engineR R t dbt beginR R& R R' R( t _soft_closedt AssertionErrort closedt is_insertt returns_rowst fetchonet None( R! t engineR# R. ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt test_autoclose_on_insertv s 'c C s� | j | j j j � t d d � � } | j s6 t � | j sF t � | j sU t � | j sd t � t
| j � d � t
| j
� d g � d S( NR s some dataR ( R R& R R' R( RH RI RJ RK RL R RM RN t keys( R! R) R. ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt+ test_autoclose_on_insert_implicit_returning� s !c C s� | j | j j j � � } | j s* t � | j s: t � | j | j j j � j | j j j j
d k � � } t t
| j � � d � d S( Ni ( R R& R R' RH RI RJ R
t whereR, R RN R t lent all( R! R) R. ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt test_empty_insert� s c C s� | j | j j j � i i i g � } | j s6 t � | j sF t � | j | j j j � j | j j j j
d k � � } t t
| j � � d � d S( Ni ( R R& R R' RH RI RJ R
RS R, R RN R RT RU ( R! R) R. ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt test_empty_insert_multiple� s ' c C s | j j } | j j } | j | j � t d d d d � t d d d d � t d d d d � g � | j | j � j d t | j j � j
| j j j d d g � � � � } t | j
d
� | j t | j j � j | j j � � } t | j � d d g � d S(
NR i R t data1i t data2i t data3( R ( N( RY ( RZ ( R& R R R R' R( t from_selectR
R, R RS t in_R R- RN t order_byt fetchall( R! R) t src_tablet
dest_tablet result( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt test_insert_from_select_autoinc� s $$c C s� | j j } | j j } | j | j � j d t | j j � j | j j j
d d g � � � � } t | j d � | j t | j j � j | j j � � } t | j � g � d S( NR RY RZ ( R ( N( R& R R R R' R[ R
R, R RS R\ R R- RN R] R^ ( R! R) R_ R` Ra ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt' test_insert_from_select_autoinc_no_rows� s $$c C s� | j j } | j | j � t d d d d � t d d d d � t d d d d � g � | j | j � j � j d
t | j j d | j j
� j | j j
j d d g � � � � t
| j t | j j
� j | j j
� � j � d d d
d d g � d S( NR i R RX i RY i RZ i ( R R ( RX ( RY ( RY ( RZ ( RZ ( R& R R R' R( t inlineR[ R
R, R R RS R\ R R] R^ ( R! R) R" ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt test_insert_from_select� s "'c
C s | j j } | j | j � t d d d d � t d d d d � t d d d d � g � | j | j � j � j d
t | j j d | j j
� j | j j
j d d g � � � � t
| j t | � j | j j
| j j � � j � d d d d d g � d S( NR i R RX i RY i RZ i i i i ( R R ( i RX i i ( i RY i i ( i RY i i ( i RZ i i ( i RZ i i ( R& R< R R' R( Rd R[ R
R, R R RS R\ R R] R^ ( R! R) R" ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt% test_insert_from_select_with_defaults s& "*( R3 R4 R5 R R6 R9 R R R RP RC RR t
empty_insertsRV t empty_inserts_executemanyRW t insert_from_selectRb Rc Re Rf ( ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR; S s
t
ReturningTestc B sl e Z d Z d
Z e Z i e d 6Z d � Z e d � � Z e
j d � � Z d � Z
d � Z d � Z RS( R
RC R R c C s8 | j | j � � j � } t | | j j d f � d S( Ns some data( R R
R R R R ( R! R" R# R$ ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR% = s
c
C s; t d | t d t d t d t �t d t d � � � d S( NR R R R R i2 ( R R R R R ( R R ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR G s c C sx | j j } | j | j � j | j j � t d d � � } | j � d } | j t
| j j � � } t | | � d S( NR s some datai ( R& R R R' RC R, R R( R R+ R
R ( R! R) R" R. R/ t
fetched_pk( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt% test_explicit_returning_pk_autocommitR s *c C sx | j j } | j | j � j | j j � t d d � � } | j � d } | j t
| j j � � } t | | � d S( NR s some datai ( R& R R R' RC R, R R( R R+ R
R ( R! R) R" R. R/ Rk ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt( test_explicit_returning_pk_no_autocommit\ s *c C s? | j | j j j � t d d � � | j | j j | � d S( NR s some data( R R& R R' R( R% ( R! R) ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt/ test_autoincrement_on_insert_implicit_returninge s c C s_ | j | j j j � t d d � � } | j t | j j j j � � } t | j
| f � d S( NR s some data( R R& R R' R( R+ R
R, R R R- ( R! R) R. R/ ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt( test_last_inserted_id_implicit_returningl s !!( RC R ( R3 R4 t run_create_tablesR7 R R6 R8 R% R9 R R t fetch_rows_post_commitRl Rm Rn Ro ( ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyRj 6 s
N( R R; Rj ( t R R R t
assertionsR R t schemaR R R R R R
R t
TablesTestR R; Rj t __all__( ( ( sU /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt <module> s >�?