File: //opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyc
�
��4]c @ 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 e j
f d
� � YZ d S( i ( t config( t fixtures( t eq_( t Column( t Tablei ( t
ForeignKey( t Integer( t select( t String( t testingt CTETestc B s� e Z e Z d
Z d Z d Z e d � � Z e d � � Z d � Z
d � Z d � Z e
j j e
j j d � � � Z e
j j e
j j d � � � Z e
j j d � � Z RS( t ctest eachc C s� t d | t d t d t �t d t d � � t d t d � � � t d | t d t d t �t d t d � � t d t � � d S( Nt
some_tablet idt primary_keyt datai2 t parent_ids
some_table.idt some_other_table( R R R t TrueR R ( t clst metadata( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt
define_tables s c C s� t j j | j j j � i d d 6d d 6d d 6i d d 6d d 6d d 6i d d 6d d 6d d 6i d
d 6d d 6d d 6i d d 6d
d 6d d 6g � d S( Ni R t d1R R i t d2i t d3i t d4i t d5( R t dbt executet tablesR
t insertt None( R ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt insert_data& s c C s� | j j } t j j � �� } t | g � j | j j j d d d g � � j
d � } | j t | j j g � j | j j j d d g � � � } t | j
� d g � Wd QXd S( NR R R t some_cteR ( R ( R R
R R t connectR t wheret cR t in_t cteR R t fetchall( t selfR
t connR' t result( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt# test_select_nonrecursive_round_trip3 s ! 6c C s" | j j } t j j � �} t | g � j | j j j d d d g � � j
d d t �} | j d � } | j � } | j
t | g � j | j j | j j k � � } | j t | j j g � j | j j d k � j | j j j � � � } t | j � d d d
d d d
g � Wd QXd S( NR R R R" t recursivet c1R ( R ( R ( R ( R ( R ( R ( R R
R R R# R R$ R% R R& R' R t aliast union_allR R R t order_byt descR R( ( R) R
R* R' t cte_aliast st1R+ ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt test_select_recursive_round_tripA s ! - c C s� | j j } | j j } t j j � �� } t | g � j | j j j
d d d g � � j d � } | j | j
� j d d d g t | g � � � t | j t | g � j | j j � � j � d d
d g � Wd QXd S( NR R R R" R R R i i i i ( i R i ( i R i ( i R i ( R R
R R R R# R R$ R% R R& R' R R t from_selectR R1 R R( ( R) R
R R* R' ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt" test_insert_from_select_round_trip\ s ! $c
C s | j j } | j j } t j j � �� } | j | j � j d d d g t | g � � � t | g � j
| j j j
d d d g � � j d � } | j | j � j d d � j
| j j | j j k � � t | j t | g � j | j j � � j � d d d d d g � Wd QXd S( NR R R R R R R" i i R i i i R ( i R N( i R i ( i R i ( i R i ( i R i ( R R
R R R R# R R R6 R R$ R% R R& R' t updatet valuesR R1 R R( R ( R) R
R R* R' ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt test_update_from_round_tripr s* ! $c
C s | j j } | j j } t j j � �� } | j | j � j d d d g t | g � � � t | g � j
| j j j
d d d g � � j d � } | j | j � j
| j j | j j k � � t | j t | g � j | j j � � j � d
d g � Wd QXd S( NR R R R R R R" i R i R i ( i R N( i R i ( R R
R R R R# R R R6 R R$ R% R R& R' t deleteR R1 R R( R ( R) R
R R* R' ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt test_delete_from_round_trip� s ! $c
C s* | j j } | j j } t j j � �� } | j | j � j d d d g t | g � � � t | g � j
| j j j
d d d g � � j d � } | j | j � j
| j j t | j j g � j
| j j | j j k � k � � t | j t | g � j | j j � � j � d
d g � Wd QXd S( NR R R R R R R" i R i R i ( i R N( i R i ( R R
R R R R# R R R6 R R$ R% R R& R' R; R R R1 R( R ( R) R
R R* R' ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt" test_delete_scalar_subq_round_trip� s$ ! "$( R ( t __name__t
__module__R t __backend__t __requires__t run_insertst run_deletest classmethodR R! R, R5 R7 R t requirest ctes_with_update_deletet update_fromR: t delete_fromR< R= ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyR
s
# N( t R R t
assertionsR t schemaR R R R R R R t
TablesTestR
( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt <module> s