ó
¿b›]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 d l  m Z d e j f d „  ƒ  YZ d Z d S(   i   (   t   config(   t   fixtures(   t   util(   t   eq_(   t   requirementsi   (   t   Column(   t   inspect(   t   Integer(   t   schema(   t   String(   t   Tablet   TableDDLTestc           B   sÎ   e  Z e Z d	 d  „ Z d „  Z d „  Z e j	 e
 j d „  ƒ ƒ Z e j	 e
 j d „  ƒ ƒ Z e j e
 j d „  ƒ ƒ Z e j	 e
 j d „  ƒ ƒ Z e j e
 j d „  ƒ ƒ Z e j e
 j d „  ƒ ƒ Z RS(
   c      
   C   s@   t  d |  j t d t d t d t ƒt d t d ƒ ƒ d | ƒS(   Nt
   test_tablet   idt   primary_keyt   autoincrementt   datai2   R   (   R
   t   metadataR   R   t   Truet   FalseR	   (   t   selfR   (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   _simple_fixture   s    c      
   C   s:   t  d |  j t d t d t d t ƒt d t d ƒ ƒ ƒ S(   Nt   _test_tableR   R   R   t   _datai2   (   R
   R   R   R   R   R   R	   (   R   (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   _underscore_fixture   s
    c         C   s`   t  j j ƒ  K } | j | j ƒ  j d ƒ ƒ | j | j ƒ  ƒ } t | j ƒ  d ƒ Wd  QXd  S(   Ni   s	   some data(   i   s	   some data(   i   s	   some data(	   R    t   dbt   begint   executet   insertt   valuest   selectR   t   first(   R   t   tablet   connt   result(    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   _simple_roundtrip"   s    c         C   s3   |  j  ƒ  } | j t j d t ƒ|  j | ƒ d  S(   Nt
   checkfirst(   R   t   createR    R   R   R#   (   R   R    (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   test_create_table(   s    c         C   s<   |  j  d t j ƒ } | j t j d t ƒ|  j | ƒ d  S(   NR   R$   (   R   R    t   test_schemaR%   R   R   R#   (   R   R    (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   test_create_table_schema/   s    c         C   s<   |  j  ƒ  } | j t j d t ƒ| j t j d t ƒd  S(   NR$   (   R   R%   R    R   R   t   drop(   R   R    (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   test_drop_table6   s    c         C   s3   |  j  ƒ  } | j t j d t ƒ|  j | ƒ d  S(   NR$   (   R   R%   R    R   R   R#   (   R   R    (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   test_underscore_names=   s    c         C   sn   |  j  ƒ  } | j t j d t ƒd | _ t j j t j | ƒ ƒ t	 t
 t j ƒ j d ƒ i d d 6ƒ d  S(   NR$   s	   a commentR   t   text(   R   R%   R    R   R   t   commentR   R   t   SetTableCommentR   R   t   get_table_comment(   R   R    (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   test_add_table_commentD   s    	c         C   s‡   |  j  ƒ  } | j t j d t ƒd | _ t j j t j | ƒ ƒ t j j t j	 | ƒ ƒ t
 t t j ƒ j d ƒ i d  d 6ƒ d  S(   NR$   s	   a commentR   R,   (   R   R%   R    R   R   R-   R   R   R.   t   DropTableCommentR   R   R/   t   None(   R   R    (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   test_drop_table_commentP   s    	N(   t   __name__t
   __module__R   t   __backend__R2   R   R   R#   R   t   create_tableR   t   provide_metadataR&   R(   t
   drop_tableR*   R+   t   comment_reflectionR0   R3   (    (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyR      s    			N(   R   (   t    R    R   R   t
   assertionsR   R   R   R   R   R   R	   R
   t   TestBaseR   t   __all__(    (    (    s@   lib/python2.7/site-packages/sqlalchemy/testing/suite/test_ddl.pyt   <module>   s   M