← Back
Editing: oracle.cpython-312.pyc
� ���gc � � � 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 erd dlm Z d dl m Z d dl m Z G d� d e� Z! ee d � d(d �� Z" eed � d)d �� Z# eed � d*d �� Z$ eed � d+d!�� Z% ee d � d,d"�� Z& ee d � d-d#�� Z' eed � d.d$�� Z(d/d%�Z)d0d&�Z* eed � d1d'�� Z+y)2� )� 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 � � � e Zd ZdZdZdZdZej ddhh d�h d�fz Zd Z d� fd � Z d� fd � Z d � Z dd �Z dd�Z� xZS )� OracleImpl�oracleF�/� �VARCHAR�VARCHAR2> �BIGINT�NUMBER�DECIMAL�INTEGER�NUMERIC�SMALLINT> �FLOAT�DOUBLE�DOUBLE_PRECISION� c �z �� t �| � |i |�� | j j d| j � | _ y )N�oracle_batch_separator)�super�__init__� context_opts�get�batch_separator)�self�arg�kw� __class__s ��A/opt/hc_python/lib/python3.12/site-packages/alembic/ddl/oracle.pyr1 zOracleImpl.__init__/ s9 �� � ���#�$��$� #� 0� 0� 4� 4� $�d�&:�&:� �� � c � �� t �| � |g|��i |��}| j r'| j r| j | j � |S )N)r0 �_exec�as_sqlr4 � static_output)r5 � construct�argsr7 �resultr8 s �r9 r< zOracleImpl._exec5 sC �� ��� �y�6�4�6�2�6�� �;�;�4�/�/� � � �t� 3� 3� 4�� r: c �� � |�.t j dd|� }t j dd|� }|�>t j dd|� }t j dd|� }|j � }||k7 S )Nz ^\((.+)\)$z\1z^\"?'(.+)'\"?$)�re�sub�strip)r5 �inspector_column�metadata_column�rendered_metadata_default�rendered_inspector_defaults r9 �compare_server_defaultz!OracleImpl.compare_server_default; s� � � %� 0�(*��� �u�&?�)� %� )+���!�5�*C�)� %� &� 1�)+��� �u�&@�*� &� *,���!�5�*D�*� &� *D�)I�)I�)K� &�)�-F�F�Fr: c �& � | j d� y )NzSET TRANSACTION READ WRITE�r< �r5 s r9 � emit_beginzOracleImpl.emit_beginW s � � � � �/�0r: c �& � | j d� y )N�COMMITrL rM s r9 � emit_commitzOracleImpl.emit_commitZ s � � � � �8� r: )�return�None)r? r rR zOptional[CursorResult])�__name__� __module__� __qualname__� __dialect__�transactional_ddlr4 �command_terminatorr � type_synonyms�identity_attrs_ignorer1 r< rJ rN rQ � __classcell__)r8 s @r9 r r # s^ �� ��K� ���O��� �-�-� �J� �I�/�1� �M� �� � � G�81� r: r r c �x � t || j | j � �dt || j fi |����S )N� )r � table_name�schema� add_column�column��element�compilerr7 s r9 �visit_add_columnrf ^ s7 � � �H�g� 0� 0�'�.�.�A��8�W�^�^�2�r�2� � r: c � � t || j | j � �dt || j � �d| j rd��S d��S )Nr^ �NULLzNOT NULL)r r_ r` � alter_column� column_name�nullablerc s r9 �visit_column_nullablerl h sT � � �H�g� 0� 0�'�.�.�A��X�w� 2� 2�3��"�"��2� � � )3�2� � r: c � � t || j | j � �dt || j � �ddt || j � z ��S )Nr^ z%s)r r_ r` ri rj r �type_rc s r9 �visit_column_typero s sG � � �H�g� 0� 0�'�.�.�A��X�w� 2� 2�3� �{�8�W�]�]�3�3� � r: c � � t || j | j � �dt || j � �dt || j � ��S )Nz RENAME COLUMN z TO )r r_ r` r rj �newnamerc s r9 �visit_column_namerr ~ sB � � �H�g� 0� 0�'�.�.�A��8�W�%8�%8�9��8�W�_�_�5� � r: c �� � t || j | j � �dt || j � �d| j �dt || j � z ��S d��S )Nr^ z DEFAULT %sz DEFAULT NULL)r r_ r` ri rj �defaultr rc s r9 �visit_column_defaultru � so � � �H�g� 0� 0�'�.�.�A��X�w� 2� 2�3� ���*� �0��7�?�?�K� K� � � � � � � r: c �� � d}|j j | j � | j ndt j � � }|j | j | j |�� S )Nz9COMMENT ON COLUMN {table_name}.{column_name} IS {comment}r! )r_ rj �comment)� sql_compiler�render_literal_valuerw r �String�formatr_ rj )rd re r7 �ddlrw s r9 �visit_column_commentr} � si � � F�C��#�#�8�8� #�O�O� 7�� � �R������G� �:�:��%�%��'�'�� � � r: c �x � t || j | j � �dt || j d � ��S )Nz RENAME TO )r r_ r` r �new_table_namerc s r9 �visit_rename_tabler� � s6 � � �H�g� 0� 0�'�.�.�A��(�G�$:�$:�D�A� � r: c � � dt | |� z S )Nz MODIFY %sr )re �names r9 ri ri � s � � �+�H�d�;� ;�;r: c �. � d | j |fi |��z S )NzADD %s)�get_column_specification)re rb r7 s r9 ra ra � s � � �7�h�7�7��E�"�E� E�Er: c �� � t || j | j � �dt || j � �d�}| j �|dz }|S ||j | j � z }|S )Nr^ z DROP IDENTITY)r r_ r` ri rj rt �visit_identity_column)rd re r7 �texts r9 r� r� � sj � � �H�g� 0� 0�'�.�.�A��X�w� 2� 2�3� �D� ��� � �� ��� � ��.�.�w���?�?��� r: )rd r re r rR �str)rd r re r rR r� )rd r re r rR r� )rd r re r rR r� )rd r re r rR r� )rd r re r rR r� )rd r re r rR r� )re r r� r� rR r� )re r rb z Column[Any]rR r� )rd r re r ),� __future__r rC �typingr r r �sqlalchemy.sqlr �baser r r r r r r r r r r r r �implr �util.sqla_compatr � sqlalchemy.dialects.oracle.baser �sqlalchemy.engine.cursorr �sqlalchemy.sql.schemar r rf rl ro rr ru r} r� ri ra r� r- r: r9 �<module>r� s� �� #� � � � � #� � � � � � � � $� '� #� � '� � � '��A�5�,�8 �� 8 �v �)�X� �� ��"3���� �� �.�(�#�� ��'8���� $�� �*�h� �� ��#4���� �� �*�h� �� ��#4���� �� �-��"� � � �&7� �� � #� � �-��"�� ��&7���� #��" �+�x� �� ��$5���� !��<�F� � ��*� � "� �.?� � +� r:
Save File
Cancel