|
Server : Apache System : Linux iad1-shared-b8-43 6.6.49-grsec-jammy+ #10 SMP Thu Sep 12 23:23:08 UTC 2024 x86_64 User : dh_edsupp ( 6597262) PHP Version : 8.2.26 Disable Function : NONE Directory : /lib/python3/dist-packages/django/db/backends/oracle/__pycache__/ |
Upload File : |
o
3�a�# � @ sD d dl Z d dlZd dlZd dlmZ d dlmZ G dd� de�ZdS )� N)�
DatabaseError)�BaseDatabaseSchemaEditorc s� e Zd ZdZdZdZdZdZdZeZ dZ
dZ d Z d
Z
d Zd d
� Z� fdd�Z� fdd�Zd+� fdd� Z� fdd�Z� fdd�Zdd� Zdd � Zd d � Z� fd d �Z� fd!d"�Zd#d$� Zd%d&� Zd'd(� Z � fd)d*�Z � Z S ),�DatabaseSchemaEditorz3ALTER TABLE %(table)s ADD %(column)s %(definition)szMODIFY %(column)s %(type)szMODIFY %(column)s NULLzMODIFY %(column)s NOT NULLz%MODIFY %(column)s DEFAULT %(default)sz MODIFY %(column)s DEFAULT NULLz'MODIFY %(column)s %(type)s%(collation)sz,ALTER TABLE %(table)s DROP COLUMN %(column)szHCONSTRAINT %(name)s REFERENCES %(to_table)s(%(to_column)s)%(deferrable)sz(DROP TABLE %(table)s CASCADE CONSTRAINTSz9CREATE INDEX %(name)s ON %(table)s (%(columns)s)%(extra)sc C sz t |tjtjtjf�rd| S t |t�r d|�dd��dd� S t |tttf�r.d|� � S t |t
�r9|r7dS dS t|�S )Nz'%s'�'z''�%z%%�1�0) �
isinstance�datetime�date�time�str�replace�bytes� bytearray�
memoryview�hex�bool��self�value� r �B/usr/lib/python3/dist-packages/django/db/backends/oracle/schema.py� quote_value s
z DatabaseSchemaEditor.quote_valuec s6 | � |jj|j�r| �|jj|j� t� �||� d S �N)�_is_identity_column�_meta�db_table�column�_drop_identity�super� remove_field)r �model�field�� __class__r r r! % s z!DatabaseSchemaEditor.remove_fieldc s0 t � �|� | �dd| jj�|jj�i � d S )NaK
DECLARE
i INTEGER;
BEGIN
SELECT COUNT(1) INTO i FROM USER_SEQUENCES
WHERE SEQUENCE_NAME = '%(sq_name)s';
IF i = 1 THEN
EXECUTE IMMEDIATE 'DROP SEQUENCE "%(sq_name)s"';
END IF;
END;
/�sq_name)r � delete_model�execute�
connection�ops� _get_no_autofield_sequence_namer r )r r" r$ r r r' , s
�z!DatabaseSchemaEditor.delete_modelFc
s� z t � �||||� W d S tyn } zVt|�}d|v s d|v r(| �|||� n-d|v r>| �|jj|j� | �||||� n d|v rT|j rT| j
|dd� | �|||� n� W Y d }~d S W Y d }~d S W Y d }~d S d }~ww )Nz ORA-22858z ORA-22859z ORA-30675z ORA-30673T)�strict) r � alter_fieldr r
� _alter_field_type_workaroundr r r r � primary_key�_delete_primary_key)r r" � old_field� new_fieldr, �e� descriptionr$ r r r- < s$ ���z DatabaseSchemaEditor.alter_fieldc s� t �|�}|�� dv|_| �|j�|_| �||� | �|j�}|�| j �}t
� d|�r1d| }d}t
� d|�rU|�� }|dkrDd| }n|dkrMd | }n|d
krUd | }| � d | �|j
j�| �|j�|f � | �||� t� �|||� d
S )a�
Oracle refuses to change from some type to other type.
What we need to do instead is:
- Add a nullable version of the desired field with a temporary name. If
the new column is an auto field, then the temporary column can't be
nullable.
- Update the table to transfer values from old to new
- Drop old column
- Rename the new column and possibly drop the nullable property
)� AutoField� BigAutoField�SmallAutoFieldz^N?CLOBz TO_CHAR(%s)�VARCHAR2z ^N?VARCHAR2� DateFieldzTO_DATE(%s, 'YYYY-MM-DD')�
DateTimeFieldz,TO_TIMESTAMP(%s, 'YYYY-MM-DD HH24:MI:SS.FF')� TimeFieldzCTO_TIMESTAMP(CONCAT('1900-01-01 ', %s), 'YYYY-MM-DD HH24:MI:SS.FF')zUPDATE %s set %s=%sN)�copy�deepcopy�get_internal_type�null�_generate_temp_namer � add_field�
quote_name�db_typer) �re�matchr( r r r! r r- )r r" r1 r2 �new_temp_field� new_value�old_type�new_internal_typer$ r r r. R s0
� z1DatabaseSchemaEditor._alter_field_type_workaroundc sV h d�}|� � |v r"|� � |vr"| �|jj|j�r"| �|jj|j� t� �||||�S )N> r5 r6 r7 )r> r r r r r r �_alter_column_type_sql)r r" r1 r2 �new_type�auto_field_typesr$ r r rJ � s �z+DatabaseSchemaEditor._alter_column_type_sqlc C s2 | � |�}|d dkr|d dkr|dd� }|S )z�
Get the properly shortened and uppercased identifier as returned by
quote_name() but without the quotes.
r �"���� )rB )r �name�nnr r r �normalize_name� s
z#DatabaseSchemaEditor.normalize_namec C s* t t|���� dd� }| �|d | �S )z@Generate temporary names for workarounds that need temp columns.rO N�_)r �hash�upperrR )r �for_name�suffixr r r r@ � s z(DatabaseSchemaEditor._generate_temp_namec C s
| � |�S r )r r r r r �prepare_default� s
z$DatabaseSchemaEditor.prepare_defaultc s: t � �||�}|�| j�}|d ur|�� | jjv rdS |S )NF)r �_field_should_be_indexedrC r) �lower�_limited_data_types)r r" r# � create_indexrC r$ r r rY � s
z-DatabaseSchemaEditor._field_should_be_indexedc s t � �||�o
| �||� S r )r �_unique_should_be_added�_field_became_primary_key)r r1 r2 r$ r r r] � s �z,DatabaseSchemaEditor._unique_should_be_addedc C sb | j �� �"}|�d| �|�| �|�g� |�� }|r |d ndW d � S 1 s*w Y d S )Nz�
SELECT
CASE WHEN identity_column = 'YES' THEN 1 ELSE 0 END
FROM user_tab_cols
WHERE table_name = %s AND
column_name = %s
r F�r) �cursorr( rR �fetchone)r �
table_name� column_namer` �rowr r r r � s �$�z(DatabaseSchemaEditor._is_identity_columnc C s$ | � d| �|�| �|�d� � d S )Nz5ALTER TABLE %(table)s MODIFY %(column)s DROP IDENTITY)�tabler )r( rB )r rb rc r r r r � s �z#DatabaseSchemaEditor._drop_identityc C sN | j �� �}|�d| �|�g� |�� d W d � S 1 s w Y d S )Nz]
SELECT default_collation FROM user_tables WHERE table_name = %s
r r_ )r rb r` r r r �_get_default_collation� s
�
$�z+DatabaseSchemaEditor._get_default_collationc s( |d u r | � |jj�}t� �||||�S r )rf r r r �_alter_column_collation_sql)r r" r2 rK �
new_collationr$ r r rg � s z0DatabaseSchemaEditor._alter_column_collation_sql)F) �__name__�
__module__� __qualname__�sql_create_column�sql_alter_column_type�sql_alter_column_null�sql_alter_column_not_null�sql_alter_column_default�sql_alter_column_no_default� sql_alter_column_no_default_null�sql_alter_column_collate�sql_delete_column�sql_create_column_inline_fk�sql_delete_table�sql_create_indexr r! r' r- r. rJ rR r@ rX rY r] r r rf rg �
__classcell__r r r$ r r s8 .
r )r< r
rD � django.dbr � django.db.backends.base.schemar r r r r r �<module> s