|
Server : Apache System : Linux cvar2.toservers.com 3.10.0-962.3.2.lve1.5.73.el7.x86_64 #1 SMP Wed Aug 24 21:31:23 UTC 2022 x86_64 User : njnconst ( 1116) PHP Version : 8.4.18 Disable Function : NONE Directory : /usr/lib64/python2.7/site-packages/sqlalchemy/testing/suite/ |
Upload File : |
� ���\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( ( sG /usr/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 ( ( sG /usr/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 ( s d4( R R R R t connectR t wheret cR t in_t cteR R t fetchall( t selfR t connR' t result( ( sG /usr/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 ( s d4( s d3( s d3( s d1( s d1( s d1( 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+ ( ( sG /usr/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 s d2i ( i s d3i ( i s d4i ( 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' ( ( sG /usr/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 s d1N( i s d2i ( i s d3i ( i s d4i ( i s d5i ( 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' ( ( sG /usr/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 s d1N( i s d5i ( 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' ( ( sG /usr/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 s d1N( i s d5i ( 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' ( ( sG /usr/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= ( ( ( sG /usr/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 ( ( ( sG /usr/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_cte.pyt <module> s