관리-도구
편집 파일: oracle.cpython-38.pyc
U 0?�fc � @ s8 d dl mZ d dlZd dlmZ d dlmZ d dlmZ d dlmZ ddl m Z dd l m Z dd l m Z dd l m Z dd l mZ dd l mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddlmZ ddlmZ e�r"d dlm Z d dl m Z d dl m Z G dd � d e�Z!ee d �d d d d!�d"d#��Z"eed �d$d d d!�d%d&��Z#eed �d'd d d!�d(d)��Z$eed �d*d d d!�d+d,��Z%ee d �d-d d d!�d.d/��Z&ee d �d0d d d!�d1d2��Z'eed �d3d d d!�d4d5��Z(d d d d6�d7d8�Z)d d9d d:�d;d<�Z*eed �d=d d>�d?d@��Z+dS )A� )� annotationsN)�Any)�Optional)� TYPE_CHECKING)�sqltypes� )� AddColumn)� alter_table)� ColumnComment)� ColumnDefault)� ColumnName)�ColumnNullable)� ColumnType��format_column_name)�format_server_default)�format_table_name)� format_type)�IdentityColumnDefault)� RenameTable)� DefaultImpl� )�compiles)�OracleDDLCompiler)� CursorResult)�Columnc s� e Zd ZdZdZdZdZejddhddd d d d hd ddhf ZdZ dd�� fdd� Z ddd�� fdd� Z dd� Z dd�d d �Z dd�d d �Z� ZS ) � OracleImpl�oracleF�/� ZVARCHARZVARCHAR2ZBIGINTZINTEGERZSMALLINTZDECIMALZNUMERIC�NUMBER�DOUBLE�FLOATZDOUBLE_PRECISION� �None)�returnc s$ t � j||� | j�d| j�| _d S )NZoracle_batch_separator)�super�__init__Z context_opts�get�batch_separator)�self�arg�kw�� __class__r# �@/opt/hc_python/lib/python3.8/site-packages/alembic/ddl/oracle.pyr' / s �zOracleImpl.__init__r zOptional[CursorResult])� constructr% c s0 t � j|f|�|�}| jr,| jr,| �| j� |S )N)r& �_execZas_sqlr) Z static_output)r* r0 �argsr, �resultr- r# r/ r1 5 s zOracleImpl._execc C sX |d k r$t �dd|�}t �dd|�}|d k rPt �dd|�}t �dd|�}|�� }||kS )Nz ^\((.+)\)$z\1z^\"?'(.+)'\"?$)�re�sub�strip)r* Zinspector_columnZmetadata_columnZrendered_metadata_defaultZrendered_inspector_defaultr# r# r/ �compare_server_default; s0 � � � �z!OracleImpl.compare_server_defaultc C s | � d� d S )NzSET TRANSACTION READ WRITE�r1 �r* r# r# r/ � emit_beginW s zOracleImpl.emit_beginc C s | � d� d S )NZCOMMITr8 r9 r# r# r/ � emit_commitZ s zOracleImpl.emit_commit)�__name__� __module__� __qualname__Z __dialect__Ztransactional_ddlr) Zcommand_terminatorr Z type_synonymsZidentity_attrs_ignorer' r1 r7 r: r; � __classcell__r# r# r- r/ r # s � r r r r �str)�element�compilerr% c K s$ dt || j| j�t|| jf|�f S )Nz%s %s)r � table_name�schema� add_column�column�rA rB r, r# r# r/ �visit_add_column^ s �rH r c K s, dt || j| j�t|| j�| jr$dndf S )N�%s %s %sZNULLzNOT NULL)r rC rD � alter_column� column_nameZnullablerG r# r# r/ �visit_column_nullableh s �rL r c K s. dt || j| j�t|| j�dt|| j� f S )NrI z%s)r rC rD rJ rK r �type_rG r# r# r/ �visit_column_types s �rN r c K s* dt || j| j�t|| j�t|| j�f S )Nz%s RENAME COLUMN %s TO %s)r rC rD r rK ZnewnamerG r# r# r/ �visit_column_name~ s �rO r c K s< dt || j| j�t|| j�| jd k r4dt|| j� ndf S )NrI z DEFAULT %sz DEFAULT NULL)r rC rD rJ rK �defaultr rG r# r# r/ �visit_column_default� s ��rQ r c K s: d}|j �| jd k r| jndt�� �}|j| j| j|d�S )Nz9COMMENT ON COLUMN {table_name}.{column_name} IS {comment}r )rC rK �comment)Z sql_compilerZrender_literal_valuerR r �String�formatrC rK )rA rB r, ZddlrR r# r# r/ �visit_column_comment� s ��rU r c K s" dt || j| j�t|| jd �f S )Nz%s RENAME TO %s)r rC rD r Znew_table_namerG r# r# r/ �visit_rename_table� s �rV )rB �namer% c C s dt | |� S )Nz MODIFY %sr )rB rW r# r# r/ rJ � s rJ z Column[Any])rB rF r% c K s d| j |f|� S )NzADD %s)Zget_column_specification)rB rF r, r# r# r/ rE � s rE r )rA rB c K sN dt || j| j�t|| j�f }| jd kr6|d7 }|S ||�| j�7 }|S d S )Nz%s %s z DROP IDENTITY)r rC rD rJ rK rP �visit_identity_column)rA rB r, �textr# r# r/ rX � s � rX ),� __future__r r4 �typingr r r Zsqlalchemy.sqlr �baser r r r r r r r r r r r r �implr Zutil.sqla_compatr Z sqlalchemy.dialects.oracle.baser Zsqlalchemy.engine.cursorr Zsqlalchemy.sql.schemar r rH rL rN rO rQ rU rV rJ rE rX r# r# r# r/ �<module> sV ;