ó i4Vdc@sŠddlZddlZddlZddlZddlmZddlmZddlm Z ddl m Z defd„ƒYZ dS(i˙˙˙˙N(tBaseDatabaseSchemaEditor(t DatabaseError(tsix(t force_texttDatabaseSchemaEditorcBszeZdZdZdZdZdZdZdZdZ d„Z d „Z e d „Z d „Zd „Zd „Zd„ZRS(s3ALTER TABLE %(table)s ADD %(column)s %(definition)ssMODIFY %(column)s %(type)ssMODIFY %(column)s NULLsMODIFY %(column)s NOT NULLs%MODIFY %(column)s DEFAULT %(default)ssMODIFY %(column)s DEFAULT NULLs,ALTER TABLE %(table)s DROP COLUMN %(column)ss(DROP TABLE %(table)s CASCADE CONSTRAINTScCsŹt|tjtjtjfƒr)d|St|tjƒrXdtj|ƒjddƒSt|tjƒrdt t j |ƒƒSt|t ƒrž|ršdSdSt |ƒSdS(Ns'%s's's''t1t0(t isinstancetdatetimetdatettimeRt string_typest text_typetreplacet buffer_typesRtbinasciithexlifytbooltstr(tselftvalue((sn/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/schema.pyt quote_values!cCsGtt|ƒj|ƒ|jdi|jjj|jjƒd6ƒdS(Nsb 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; /tsq_name( tsuperRt delete_modeltexecutet connectiontopst_get_sequence_namet_metatdb_table(Rtmodel((sn/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/schema.pyR#s cCszy#tt|ƒj||||ƒWnPtk ru}t|ƒ}d|ksYd|kro|j|||ƒqv‚nXdS(Ns ORA-22858s ORA-22859(RRt alter_fieldRRt_alter_field_type_workaround(RRt old_fieldt new_fieldtstricttet description((sn/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/schema.pyR 3s# cCsWtj|ƒ}t|_|j|jƒ|_|j||ƒ|j|jƒ}|j|j ƒ}t j d|ƒr†d|}d}nt j d|ƒrň|j ƒ}|dkr˝d|}qň|dkrÖd|}qň|d krňd |}qňn|j d |j|jjƒ|j|jƒ|fƒ|j||ƒtt|ƒj|||ƒd S( s[ 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 s^N?CLOBs TO_CHAR(%s)tVARCHAR2s ^N?VARCHAR2t DateFieldsTO_DATE(%s, 'YYYY-MM-DD')t DateTimeFields,TO_TIMESTAMP(%s, 'YYYY-MM-DD HH24:MI:SS.FF')t TimeFieldsCTO_TIMESTAMP(CONCAT('1900-01-01 ', %s), 'YYYY-MM-DD HH24:MI:SS.FF')sUPDATE %s set %s=%sN(tcopytdeepcopytTruetnullt_generate_temp_nametcolumnt add_fieldt quote_nametdb_typeRtretmatchtget_internal_typeRRRt remove_fieldRRR (RRR"R#tnew_temp_fieldt new_valuetold_typetnew_internal_type((sn/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/schema.pyR!?s.            cCsC|j|ƒ}|ddkr?|ddkr?|dd!}n|S(sŠ Get the properly shortened and uppercased identifier as returned by quote_name(), but without the actual quotes. it"i˙˙˙˙i(R2(Rtnametnn((sn/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/schema.pytnormalize_namejs cCs1tt|ƒƒjƒd}|j|d|ƒS(sR Generates temporary names for workarounds that need temp columns it_(thexthashtupperR?(Rtfor_nametsuffix((sn/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/schema.pyR/tscCs |j|ƒS(N(R(RR((sn/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/schema.pytprepare_default{s(t__name__t __module__tsql_create_columntsql_alter_column_typetsql_alter_column_nulltsql_alter_column_not_nulltsql_alter_column_defaulttsql_alter_column_no_defaulttsql_delete_columntsql_delete_tableRRtFalseR R!R?R/RF(((sn/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/schema.pyR s  + ( RR+RR4tdjango.db.backends.base.schemaRtdjango.db.utilsRt django.utilsRtdjango.utils.textRR(((sn/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/schema.pyts