File: //opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyc
�
�M!Vc @ 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
m Z m Z m Z m Z m Z m Z d d
l m Z d d l m Z d e f d
� � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ e e
d � e e d � e e d � e e d � d � � � � � Z e e d � d � � Z e e d � d � � Z e e d � d � � Z d � Z d � Z e e j! d � d � � Z" d S( i����( t compiles( t types( t schemai ( t string_types( t utili ( t DefaultImpl( t ColumnNullablet
ColumnNamet
ColumnDefaultt
ColumnTypet AlterColumnt format_column_namet format_server_default( t alter_table( t comparet MySQLImplc B sV e Z d Z e Z d e d d d d d d d d d �
Z d � Z d � Z d � Z RS( t mysqlc
K s� | d k r� | j t | | d | d | d | d k r< | n |
d k rN |
n t d | d k rf | n | d | t k r~ | n | d | d k r� | n | �� n� | d k s� | d k s� | d k rp| j t | | d | d | d k r� | n | d | d k r | n |
d k r|
n t d | d k r3| n | d | t k rK| n | d | d k rc| n | �� n. | t k r�| j t | | | d | �� n d S( NR t newnamet nullablet type_t defaultt
autoincrement( t Nonet _exect MySQLChangeColumnt Truet Falset MySQLModifyColumnt MySQLAlterDefault( t selft
table_namet column_nameR t server_defaultt nameR R t
existing_typet existing_server_defaultt existing_nullableR t existing_autoincrementt kw( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt alter_column sF
c C sM | j j t j k r? | j r? | j r? | r? | d k r? t S| | k Sd S( Ns '0'( t typet _type_affinityt sqltypest Integert primary_keyR R ( R t inspector_columnt metadata_columnt rendered_metadata_defaultt rendered_inspector_default( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt compare_server_defaultM s
c C sK t � } x� t | � D]� } | j r+ q n x� | j D]� } | j | j k rn | j | � | j | j � Pn xD | j D]9 } | j | j k rx | j | � | j | j � Pqx qx W| j | k r5 Pq5 q5 Wq Wx3 t | � D]% } | j | k r� | j | � q� q� Wt g | D] } | j d k r| j ^ q� }
t g | D]' } | j d k rAt j
| � j ^ qA� } t g | D] } | j r{| j ^ q{� } t d � | D� � }
t d � | D� � } x| t |
� j
| � D]e } | |
k r#t j
|
| � j | k rC| j |
| � qCq�| | k r�| j | | � q�q�Wd S( Nc s s | ] } | j | f Vq d S( N( R! ( t .0t cons( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pys <genexpr>� s c s s' | ] } | j r | j | f Vq d S( N( t uniqueR! ( R2 R3 ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pys <genexpr>� s ( t sett listR4 t columnsR! t removet addt foreign_keysR R t _uq_constraint_sigt sigt dictt intersectiont discard( R t conn_unique_constraintst conn_indexest metadata_unique_constraintst metadata_indexest removedt idxt colt fkR3 t metadata_uq_namest unnamed_metadata_uqst metadata_ix_namest
conn_uq_namest
conn_ix_namest overlap( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt correct_for_autogen_constraints] sN
!
*( c C s� t d � | D� � } t d � | D� � } x� t | � j | � D]� } | | } | | } | j d k r� | j j � d k r� | j d k r� d | _ n | j d k rB | j j � d k rB | j d k rB d | _ qB qB Wd S( Nc s s' | ] } t j | � j | f Vq d S( N( R t _fk_constraint_sigR< ( R2 RG ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pys <genexpr>� s c s s' | ] } t j | � j | f Vq d S( N( R RO R< ( R2 RG ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pys <genexpr>� s t restrictt RESTRICT( R= R5 R> t ondeleteR t lowert onupdate( R t conn_fkst metadata_fkst conn_fk_by_sigt metadata_fk_by_sigR< t mdfkt cnfk( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt correct_for_autogen_foreignkeys� s
N(
t __name__t
__module__t __dialect__R t transactional_ddlR R' R1 RN R[ ( ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyR s / DR c B s e Z d d � Z RS( c C s2 t t | � j | d | �| | _ | | _ d S( NR ( t superR
t __init__R R ( R R! R R R ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyRa � s N( R\ R] R Ra ( ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyR � s R c B s# e Z d d d d e d d � Z RS( c C s} t t | � j | d | �| | _ | | _ | | _ | | _ | | _ | d k rg t j
d � � n t j | � | _
d S( NR sD All MySQL CHANGE/MODIFY COLUMN operations require the existing type.( R` R
Ra R R R R R R R t CommandErrorR* t to_instanceR ( R R! R R R R R R R ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyRa � s N( R\ R] R R Ra ( ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyR � s R c B s e Z RS( ( R\ R] ( ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyR � s R c K s t d � � d S( Ns9 Individual alter column constructs not supported by MySQL( t NotImplementedError( t elementt compilerR& ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt _mysql_doesnt_support_individual� s c K sT d t | | j | j � t | | j � | j d k rL d t | | j � n d f S( Ns %s ALTER COLUMN %s %ss SET DEFAULT %ss DROP DEFAULT( R
R R R R R R R ( Re Rf R& ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt _mysql_alter_default� s
%c
K sY d t | | j | j � t | | j � t | d | j d | j d | j d | j �f S( Ns %s MODIFY %s %sR R R R (
R
R R R R t _mysql_colspecR R R R ( Re Rf R& ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt _mysql_modify_column� s c K sh d t | | j | j � t | | j � t | | j � t | d | j d | j d | j d | j
�f S( Ns %s CHANGE %s %s %sR R R R ( R
R R R R R Ri R R R R ( Re Rf R& ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt _mysql_change_column s c C s+ t | t � r d | S| j j | � Sd S( Ns '%s'( t
isinstanceR t sql_compilert process( Rf t expr( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt
_render_value s c C st d | j j j | � | r! d n d f } | r> | d 7} n | t k rp | d k rp | d t | | � 7} n | S( Ns %s %st NULLs NOT NULLs AUTO_INCREMENTs DEFAULT %s( t dialectt
type_compilerRn R R Rp ( Rf R R R R t spec( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyRi s
c K sk | j } t | t j t j t j f � r: | j | | � St | t j � r[ t d � � n t d � � d S( sV Redefine SQLAlchemy's drop constraint to
raise errors for invalid constraint type.s) MySQL does not support CHECK constraints.sF No generic 'DROP CONSTRAINT' in MySQL - please specify constraint typeN( Re Rl R t ForeignKeyConstraintt PrimaryKeyConstraintt UniqueConstraintt visit_drop_constraintt CheckConstraintRd ( Re Rf R& t
constraint( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt _mysql_drop_constraint% s N(# t sqlalchemy.ext.compilerR t
sqlalchemyR R* R t util.compatR t R t implR t baseR R R R R
R R R
t autogenerateR R R R R Rg Rh Rj Rk Rp Ri t DropConstraintR{ ( ( ( sB /opt/alt/python27/lib/python2.7/site-packages/alembic/ddl/mysql.pyt <module> s, 4� !