3 š(ƒhÁã@sdddlZddlZddlZddlZddlmZddlmZddlm Z ddl m Z Gdd„deƒZ dS)éN)ÚBaseDatabaseSchemaEditor)Ú DatabaseError)Úsix)Ú force_textcsveZdZdZdZdZdZdZdZdZ dZ d d „Z ‡fd d „Z d‡fdd„ Z ‡fdd„Zdd„Zdd„Zdd„Z‡ZS)Ú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)szMODIFY %(column)s DEFAULT NULLz,ALTER TABLE %(table)s DROP COLUMN %(column)sz(DROP TABLE %(table)s CASCADE CONSTRAINTScCs€t|tjtjtjfƒrd|St|tjƒr@dtj|ƒjddƒSt|tjƒr^dt t j |ƒƒSt|t ƒrt|rpdSdSt |ƒSdS)Nz'%s'ú'z''Ú1Ú0)Ú isinstanceÚdatetimeÚdateÚtimerÚ string_typesÚ text_typeÚreplaceZ buffer_typesrÚbinasciiÚhexlifyÚboolÚstr)ÚselfÚvalue©rúD/tmp/pip-install-q3hcpn_q/Django/django/db/backends/oracle/schema.pyÚ quote_values    z DatabaseSchemaEditor.quote_valuecs4tt|ƒj|ƒ|jdd|jjj|jjƒiƒdS)Nab DECLARE i INTEGER; BEGIN SELECT COUNT(*) INTO i FROM USER_CATALOG WHERE TABLE_NAME = '%(sq_name)s' AND TABLE_TYPE = 'SEQUENCE'; IF i = 1 THEN EXECUTE IMMEDIATE 'DROP SEQUENCE "%(sq_name)s"'; END IF; END; /Zsq_name) ÚsuperrÚ delete_modelÚexecuteÚ connectionÚopsZ_get_sequence_nameÚ_metaÚdb_table)rÚmodel)Ú __class__rrr#s z!DatabaseSchemaEditor.delete_modelFcslytt|ƒj||||ƒWnLtk rf}z0t|ƒ}d|ksDd|krT|j|||ƒn‚WYdd}~XnXdS)Nz ORA-22858z ORA-22859)rrÚ alter_fieldrrÚ_alter_field_type_workaround)rr!Ú old_fieldÚ new_fieldÚstrictÚeÚ description)r"rrr#3sz DatabaseSchemaEditor.alter_fieldcsìtj|ƒ}d|_|j|jƒ|_|j||ƒ|j|jƒ}|j|jƒ}t j d|ƒrZd|}d}t j d|ƒr¢|j ƒ}|dkr€d|}n"|dkr’d |}n|d kr¢d |}|j d |j|j jƒ|j|jƒ|fƒ|j||ƒtt|ƒj|||ƒ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 - Update the table to transfer values from old to new - Drop old column - Rename the new column and possibly drop the nullable property Tz^N?CLOBz TO_CHAR(%s)ZVARCHAR2z ^N?VARCHAR2Z DateFieldzTO_DATE(%s, 'YYYY-MM-DD')Z DateTimeFieldz,TO_TIMESTAMP(%s, 'YYYY-MM-DD HH24:MI:SS.FF')Z TimeFieldzCTO_TIMESTAMP(CONCAT('1900-01-01 ', %s), 'YYYY-MM-DD HH24:MI:SS.FF')zUPDATE %s set %s=%sN)ÚcopyÚdeepcopyÚnullÚ_generate_temp_nameÚcolumnZ add_fieldÚ quote_nameZdb_typerÚreÚmatchZget_internal_typerrr Z remove_fieldrrr#)rr!r%r&Znew_temp_fieldZ new_valueZold_typeZnew_internal_type)r"rrr$?s.            z1DatabaseSchemaEditor._alter_field_type_workaroundcCs2|j|ƒ}|ddkr.|ddkr.|dd…}|S)zŠ Get the properly shortened and uppercased identifier as returned by quote_name(), but without the actual quotes. rú"ééÿÿÿÿr4)r/)rÚnameÚnnrrrÚnormalize_namejs  z#DatabaseSchemaEditor.normalize_namecCs*tt|ƒƒjƒdd…}|j|d|ƒS)zR Generates temporary names for workarounds that need temp columns r3NÚ_)ÚhexÚhashÚupperr7)rZfor_nameÚsuffixrrrr-tsz(DatabaseSchemaEditor._generate_temp_namecCs |j|ƒS)N)r)rrrrrÚprepare_default{sz$DatabaseSchemaEditor.prepare_default)F)Ú__name__Ú __module__Ú __qualname__Zsql_create_columnZsql_alter_column_typeZsql_alter_column_nullZsql_alter_column_not_nullZsql_alter_column_defaultZsql_alter_column_no_defaultZsql_delete_columnZsql_delete_tablerrr#r$r7r-r=Ú __classcell__rr)r"rr s  + r) rr*r r0Zdjango.db.backends.base.schemarZdjango.db.utilsrZ django.utilsrZdjango.utils.textrrrrrrÚs