gGֹ d dl mZ d dlZd dlmZ d dlmZ d dlmZ d dlmZ d dl m
Z
dd l m Z dd
l m
Z
dd l mZ dd l mZ dd
l mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddlmZ erd dlm Z d dl m Z d dl m Z G d de Z! ee d d7d# Z" eed d8d% Z# eed d9d' Z$ eed d:d) Z% eed d;d+ Z& eed dd1Z)d?d4Z* eed d@d6 Z+dS )A ) annotationsN)Any)Optional)
TYPE_CHECKING)compiles)sqltypes ) AddColumn) alter_table)
ColumnComment)
ColumnDefault)
ColumnName)ColumnNullable)
ColumnTypeformat_column_name)format_server_default)format_table_name) format_type)IdentityColumnDefault) RenameTable) DefaultImpl)OracleDDLCompiler) CursorResult)Columnc | e Zd ZdZdZdZdZej ddhh dh dfz Zd Z d fd Z
d fd Z d Z ddZ
ddZ xZS )
OracleImploracleF/ VARCHARVARCHAR2> BIGINTNUMBERDECIMALINTEGERNUMERICSMALLINT> FLOATDOUBLEDOUBLE_PRECISION returnNonec t j |i | | j d| j | _ d S )Noracle_batch_separator)super__init__ context_optsgetbatch_separator)selfargkw __class__s d/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib/python3.11/site-packages/alembic/ddl/oracle.pyr2 zOracleImpl.__init__, sH #$$$$ # 0 4 4 $d&:
constructr Optional[CursorResult]c t j |g|R i |}| j r!| j r| | j |S )N)r1 _execas_sqlr5
static_output)r6 r< argsr8 resultr9 s r: r? zOracleImpl._exec2 sX y64666266 ; 54/ 5 t 3 4 4 4
r; c |,t j dd| }t j dd| }|@t j dd| }t j dd| }| }||k S )Nz
^\((.+)\)$z\1z^\"?'(.+)'\"?$)resubstrip)r6 inspector_columnmetadata_columnrendered_metadata_defaultrendered_inspector_defaults r: compare_server_defaultz!OracleImpl.compare_server_default8 s % 0(* u&?) ) % )+!5*C) ) % & 1)+ u&@* * & *,!5*D* * & *D)I)I)K)K &)-FFFr; c 0 | d d S )NzSET TRANSACTION READ WRITEr? r6 s r:
emit_beginzOracleImpl.emit_beginT s
/00000r; c 0 | d d S )NCOMMITrN rO s r: emit_commitzOracleImpl.emit_commitW s
8 r; )r- r. )r< r r- r= )__name__
__module__ __qualname__ __dialect__transactional_ddlr5 command_terminatorr
type_synonymsidentity_attrs_ignorer2 r? rL rP rS
__classcell__)r9 s @r: r r s K O - J III///1 M
G G G81 1 1 1 r; r r elementr
compilerr r- strc d t || j | j dt || j fi |S )N )r
table_nameschema
add_columncolumnr] r^ r8 s r: visit_add_columnrg [ sB
Hg 0'.AAAA8W^22r222 r; r c t || j | j dt || j d| j rdndS )Nra NULLzNOT NULL)r rb rc alter_column column_namenullablerf s r: visit_column_nullablerm e sP
Hg 0'.AAAAXw 23333"2
2 r; r c t || j | j dt || j ddt || j z S )Nra z%s)r rb rc rj rk r type_rf s r: visit_column_typerp p sU
Hg 0'.AAAAXw 23333 {8W]3333 r; r c t || j | j dt || j dt || j S )Nz RENAME COLUMN z TO )r rb rc r rk newnamerf s r: visit_column_namers { sP
Hg 0'.AAAA8W%899998W_555 r; r
c t || j | j dt || j d| j dt
|| j z ndS )Nra z
DEFAULT %sz DEFAULT NULL)r rb rc rj rk defaultr rf s r: visit_column_defaultrv sh
Hg 0'.AAAAXw 23333 ? & ,XwGGGG
r; r c d}|j | j | j ndt j }| | j | j | S )Nz9COMMENT ON COLUMN {table_name}.{column_name} IS {comment}r )rb rk comment) sql_compilerrender_literal_valuerx r Stringformatrb rk )r] r^ r8 ddlrx s r: visit_column_commentr~ si FC#88 #O 7 R G
::%' r; r c j t || j | j dt || j d S )Nz RENAME TO )r rb rc r new_table_namerf s r: visit_rename_tabler s=
Hg 0'.AAAA(G$:DAAA r; namec ( dt | | z S )Nz MODIFY %sr )r^ r s r: rj rj s +Hd;; ;;r; re Column[Any]c $ d | j |fi |z S )NzADD %s)get_column_specification)r^ re r8 s r: rd rd s# 7h7EE"EE EEr; r c t || j | j dt || j d}| j |dz
}|S || | j z
}|S )Nra z
DROP IDENTITY)r rb rc rj rk ru visit_identity_column)r] r^ r8 texts r: r r ss
Hg 0'.AAAAXw 23333 D ..w??? r; )r] r
r^ r r- r_ )r] r r^ r r- r_ )r] r r^ r r- r_ )r] r r^ r r- r_ )r] r
r^ r r- r_ )r] r r^ r r- r_ )r] r r^ r r- r_ )r^ r r r_ r- r_ )r^ r re r r- r_ )r] r r^ r ),
__future__r rE typingr r r sqlalchemy.ext.compilerr sqlalchemy.sqlr baser
r r r
r r r r r r r r r implr sqlalchemy.dialects.oracle.baser sqlalchemy.engine.cursorr sqlalchemy.sql.schemar r rg rm rp rs rv r~ r rj rd r r, r; r: r s~ " " " " " " , , , , , , # # # # # # $ $ $ $ $ $ ' ' ' ' ' ' # # # # # # ' ' ' ' ' ' -AAAAAA555555,,,,,,8 8 8 8 8 8 8 8 v
)X
.(## $#
*h
*h
-"" #"
-"" #""
+x ! < < < <F F F F
**
+*
r;