관리-도구
편집 파일: mssql.cpython-37.pyc
B �M!V� � @ s< d dl mZ ddlmZ ddlmZ ddlmZmZm Z m Z m Z m Z m Z mZmZmZmZmZ d dlmZmZ G dd � d e�ZG d d � d ee�ZG d d � d ee�Zeed�dd� �Zeed�dd� �Zeed�dd� �Zdd� Z ee d�dd� �Z eed�dd� �Z ee d�dd � �Z eed�d d � �Z ee d�d d � �Z!d!S )"� )�compiles� )�util� )� DefaultImpl) � alter_table� AddColumn� ColumnName� RenameTable�format_table_name�format_column_name�ColumnNullable� alter_column�format_server_default� ColumnDefault� format_type� ColumnType)� ClauseElement� Executablec sn e Zd ZdZdZdZ� fdd�Z� fdd�Zdd � Z� fd d �Z d� fdd� Z � fdd�Z � fdd�Z � Z S )� MSSQLImpl�mssqlTZGOc s( t t| �j||� | j�d| j�| _d S )NZmssql_batch_separator)�superr �__init__Z context_opts�get�batch_separator)�self�arg�kw)� __class__� �B/opt/alt/python37/lib/python3.7/site-packages/alembic/ddl/mssql.pyr s zMSSQLImpl.__init__c s4 t t| �j|f|�|�}| jr0| jr0| �| j� |S )N)r r �_exec�as_sqlr � static_output)r Z construct�argsr �result)r r r r! s zMSSQLImpl._execc C s | � d| j � d S )NzBEGIN TRANSACTION)r# Zcommand_terminator)r r r r � emit_begin s zMSSQLImpl.emit_beginc s* t t| ��� | jr&| jr&| �| j� d S )N)r r � emit_commitr" r r# )r )r r r r' s zMSSQLImpl.emit_commitNFc s� |d k r,|d kr,|d k r"|}d }n t �d��tt| �j||f||||| d�| �� |dk r�| dk sj|d kr|| �t||d�� |d k r�tt| �j||||d� |d k r�tt| �j||||d� d S )NzhMS-SQL ALTER COLUMN operations with NULL or NOT NULL require the existing_type or a new type_ be passed.)�nullable�type_�schema� existing_type�existing_nullableFzsys.default_constraints)r* �server_default)r* �name)r Z CommandErrorr r r r! �_ExecDropConstraint) r � table_name� column_namer( r- r. r) r* r+ Zexisting_server_defaultr, r )r r r r $ s> zMSSQLImpl.alter_columnc sh | j rN| �d| jj�|� � tt| �j||f|� | �d| jj�|� � ntt| �j||f|� d S )NzSET IDENTITY_INSERT %s ONzSET IDENTITY_INSERT %s OFF)r" r! ZdialectZidentifier_preparerZ format_tabler r � bulk_insert)r �tableZrowsr )r r r r2 Z s zMSSQLImpl.bulk_insertc s~ |� dd�}|r"| �t||d�� |� dd�}|rD| �t||d�� |� dd�}|rd| �t||�� tt| �j||f|� d S )NZmssql_drop_defaultFzsys.default_constraintsZmssql_drop_checkzsys.check_constraintsZmssql_drop_foreign_key)�popr! r/ �_ExecDropFKConstraintr r � drop_column)r r0 �columnr Z drop_defaultZ drop_checkZdrop_fks)r r r r6 h s" zMSSQLImpl.drop_column)NFNNNNNN)�__name__� __module__� __qualname__Z __dialect__Ztransactional_ddlr r r! r& r' r r2 r6 � __classcell__r r )r r r s" . r c @ s e Zd Zdd� ZdS )r/ c C s || _ || _|| _d S )N)�tname�colnamer) )r r< r= r) r r r r � s z _ExecDropConstraint.__init__N)r8 r9 r: r r r r r r/ s r/ c @ s e Zd Zdd� ZdS )r5 c C s || _ || _d S )N)r< r= )r r< r= r r r r � s z _ExecDropFKConstraint.__init__N)r8 r9 r: r r r r r r5 � s r5 r c K s0 | j | j| j }}}d|||t||d �d� S )Nz�declare @const_name varchar(256) select @const_name = [name] from %(type)s where parent_object_id = object_id('%(tname)s') and col_name(parent_object_id, parent_column_id) = '%(colname)s' exec('alter table %(tname_quoted)s drop constraint ' + @const_name))�typer< r= � tname_quoted)r< r= r) r )�element�compilerr r< r= r) r r r �_exec_drop_col_constraint� s rB c K s& | j | j }}d||t||d �d� S )Nah declare @const_name varchar(256) select @const_name = [name] from sys.foreign_keys fk join sys.foreign_key_columns fkc on fk.object_id=fkc.constraint_object_id where fkc.parent_object_id = object_id('%(tname)s') and col_name(fkc.parent_object_id, fkc.parent_column_id) = '%(colname)s' exec('alter table %(tname_quoted)s drop constraint ' + @const_name))r< r= r? )r< r= r )r@ rA r r< r= r r r � _exec_drop_col_fk_constraint� s rC c K s$ dt || j| j�t|| jf|�f S )Nz%s %s)r r0 r* �mssql_add_columnr7 )r@ rA r r r r �visit_add_column� s rE c K s d| j |f|� S )NzADD %s)Zget_column_specification)rA r7 r r r r rD � s rD c K s6 dt || j| j�t|| j�t|| j�| jr.dndf S )Nz %s %s %s %s�NULLzNOT NULL)r r0 r* r r1 r r+ r( )r@ rA r r r r �visit_column_nullable� s rG c K s* dt || j| j�t|| j�t|| j�f S )Nz%s ADD DEFAULT %s FOR %s)r r0 r* r �defaultr r1 )r@ rA r r r r �visit_column_default� s rI c K s* dt || j| j�t|| j�t|| j�f S )Nz$EXEC sp_rename '%s.%s', %s, 'COLUMN')r r0 r* r r1 Znewname)r@ rA r r r r �visit_rename_column� s rJ c K s* dt || j| j�t|| j�t|| j�f S )Nz%s %s %s)r r0 r* r r1 r r) )r@ rA r r r r �visit_column_type� s rK c K s$ dt || j| j�t || j| j�f S )NzEXEC sp_rename '%s', %s)r r0 r* Znew_table_name)r@ rA r r r r �visit_rename_table� s rL N)"Zsqlalchemy.ext.compilerr � r �implr �baser r r r r r r r r r r r Zsqlalchemy.sql.expressionr r r r/ r5 rB rC rE rD rG rI rJ rK rL r r r r �<module> s 8t