JezK
Edit File: test_insert.pyc
� 1��fc @ 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( ( sW /opt/alt/python27/lib64/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( ( sW /opt/alt/python27/lib64/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( ( sW /opt/alt/python27/lib64/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( ( sW /opt/alt/python27/lib64/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/ ( ( sW /opt/alt/python27/lib64/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 ( ( ( sW /opt/alt/python27/lib64/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 ( ( sW /opt/alt/python27/lib64/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. ( ( sW /opt/alt/python27/lib64/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. ( ( sW /opt/alt/python27/lib64/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. ( ( sW /opt/alt/python27/lib64/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. ( ( sW /opt/alt/python27/lib64/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( ( sW /opt/alt/python27/lib64/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 ( ( sW /opt/alt/python27/lib64/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" ( ( sW /opt/alt/python27/lib64/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" ( ( sW /opt/alt/python27/lib64/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 ( ( ( sW /opt/alt/python27/lib64/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$ ( ( sW /opt/alt/python27/lib64/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 ( ( sW /opt/alt/python27/lib64/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( ( sW /opt/alt/python27/lib64/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 ( ( sW /opt/alt/python27/lib64/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) ( ( sW /opt/alt/python27/lib64/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/ ( ( sW /opt/alt/python27/lib64/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 ( ( ( sW /opt/alt/python27/lib64/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__( ( ( sW /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt <module> s >�?