File manager - Edit - /usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/oracle/__pycache__/schema.cpython-310.pyc
Back
o �h�) � @ sT d dl Z d dlZd dlZd dlmZ d dlmZmZ d dlm Z G dd� de�Z dS )� N)� DatabaseError)�BaseDatabaseSchemaEditor�_related_non_m2m_objects)�duration_iso_stringc s� e Zd ZdZdZdZdZdZdZeZ dZ dZ d Z d Z d d � Z� fd d�Z� fdd�Zd)� fdd� Z� fdd�Z� fdd�Zdd� Zdd� Zd d � Z� fd d �Zd d!� Zd"d#� Zd$d%� Zd*� fd'd(� Z� Z S )+�DatabaseSchemaEditorz3ALTER TABLE %(table)s ADD %(column)s %(definition)sz'MODIFY %(column)s %(type)s%(collation)szMODIFY %(column)s NULLzMODIFY %(column)s NOT NULLz%MODIFY %(column)s DEFAULT %(default)sz MODIFY %(column)s DEFAULT NULLz,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 s� t |tjtjtjf�rd| S t |tj�rdt|� S t |t�r,d|�dd��dd� S t |tt t f�r:d|� � S t |t �rE|rCdS dS t|�S )Nz'%s'�'z''�%z%%�1�0) � isinstance�datetime�date�time� timedeltar �str�replace�bytes� bytearray� memoryview�hex�bool��self�value� r �S/usr/local/CyberCP/lib/python3.10/site-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* 2 s ����z!DatabaseSchemaEditor.delete_modelFc s2 z t � �||||� W d S ty� } z�t|�}d|v s d|v r(| �|||� nPd|v r>| �|jj|j� | �||||� nAd|v rT|j rT| j |dd� | �|||� n2d|v rw|j rw| j |dd� | �||||� |j rv| � | � ||�� n� W Y d }~d S 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)�strictz ORA-43923) r# � alter_fieldr r � _alter_field_type_workaroundr" r r r! � primary_key�_delete_primary_keyr+ �_create_primary_key_sql)r r% � old_field� new_fieldr/ �e� descriptionr' r r r0 I s0 �� ��z DatabaseSchemaEditor.alter_fieldc sd t �|�}|�� dv|_| �|j�|_| �||� | �|j�}|�| j �}t � d|�r1d| }d}t � d|�rY|�� }|dkrDd| }n|dkrMd | }n |d krYd | }d | }| � d | �|j j�| �|j�|f � | �||� t� �|||� |�| j �}|jr�|js�|jr�|jr�||kr�t||�D ]\} } | jjr�| � | �| j| jd �� q�dS dS dS dS )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')� TimeFieldzCONCAT('1900-01-01 ', %s)zUPDATE %s set %s=%s�_fkN)�copy�deepcopy�get_internal_type�null�_generate_temp_namer! � add_field� quote_name�db_typer, �re�matchr+ r r r$ r# r0 r2 �uniquer r& � db_constraint�_create_fk_sql� related_model) r r% r5 r6 �new_temp_field� new_value�old_type�new_internal_type�new_type�_�relr' r r r1 g s^ ��� ��������z1DatabaseSchemaEditor._alter_field_type_workaroundc sZ h d�}|� � |v r"|� � |vr"| �|jj|j�r"| �|jj|j� t� �||||||�S )N> r9 r: r; )rC r r r r! r" r# �_alter_column_type_sql)r r% r5 r6 rS � old_collation� new_collation�auto_field_typesr' r r rV � 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 �"���� )rG )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.r\ NrT )r �hash�upperr_ )r �for_name�suffixr r r rE � 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_indexedrH r, �lower�_limited_data_types)r r% r& � create_indexrH r' r r re � s z-DatabaseSchemaEditor._field_should_be_indexedc 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+ r_ �fetchone)r � table_name� column_namerj �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+ rG )r rl rm r r r r" � s ���z#DatabaseSchemaEditor._drop_identityc C sN | j �� �}|�d| �|�g� |�� d W d � S 1 s w Y d S )Nza SELECT default_collation FROM user_tables WHERE table_name = %s r ri )r rl rj r r r �_get_default_collation� s � $�z+DatabaseSchemaEditor._get_default_collationNc s* |d u r |d ur | � |�}t� �|||�S r )rp r# � _collate_sql)r � collationrW rl r' r r rq � s z!DatabaseSchemaEditor._collate_sql)F)NN) �__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_delete_column�sql_create_column_inline_fk�sql_delete_table�sql_create_indexr r$ r* r0 r1 rV r_ rE rd re r r" rp rq � __classcell__r r r' r r s6 � C r ) rA r rI � django.dbr � django.db.backends.base.schemar r �django.utils.durationr r r r r r �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings