a Lcf8C@sPddlZddlZddlmZmZddlmZmZddlm Z GdddeZ dS)N) BaseCommand CommandError)DEFAULT_DB_ALIAS connections) LOOKUP_SEPc@sLeZdZdZgZdZdZddZddZdd Z d d Z d d Z ddZ dS)CommandzXIntrospects the database tables in the given database and outputs a Django model module.)table_name_filterz django.dbcCsF|jddtdd|jdtdd|jdd d d |jd d d d dS)Ntable*z4Selects what tables or views should be introspected.)nargstypehelpz --databasezMNominates a database to introspect. Defaults to using the "default" database.)defaultr z--include-partitions store_truez(Also output models for partition tables.)actionr z--include-viewsz&Also output models for database views.) add_argumentstrr)selfparserrf/home/httpd/docs/test/DocsMgr/lib/python3.9/site-packages/django/core/management/commands/inspectdb.py add_argumentss*zCommand.add_argumentscKs@z ||D]}|j|q Wnty:tdYn0dS)NzPDatabase inspection isn't supported for the currently selected database backend.)handle_inspectionstdoutwriteNotImplementedErrorr)roptionslinerrrhandle,s zCommand.handlec) #s$t|d}|d}dd}|}dVdVdVdVd Vd Vd Vd |jVg}d h|dr|d|drd|j|}fdd|D}|dptdd|DD]6}|durt|r||sqzz|j ||} Wnt yi} Yn0z|j ||} Wnt y>i} Yn0|j ||} | r\| dnd} dd| D} |j||}WnFty}z,d|Vd|VWYd}~qWYd}~n d}~00||}dVdVd|V||g}i}t}|D]}g}i}|j}|| v}||||\}}}|||||||||<|| krd|d<t| d kr|d!d"| n|| vrd|d#<|rb| |\}}|d#d$s|drd%}n*d&}|j||}|r||kr||d'<||kr d(n||} | |vr,d)|| f}!n d*|| f}!| |vrVd+||f|d,<|| n0||||\}!}"}#||"||#|!d-7}!|d.kr|ddikr|!d/krqn |!|jjd0d-kr|d1|jrd|d2<d|d3<d4|d5|!vrdnd6|!f}$|!d7r"|$d87}$|jj r>|j!r>|j!|d9<|rt|$"d-sX|$d"7}$|$d"d:d|#D7}$|$d;7}$|r|$d|$Vqd}%||}&r|&j$dk}'|&j$dk}(|jj r|&j!}%nd$}'d$}(|%|| ||'|(|%EdHqWdn1s0YdS)?NZdatabasercSstdd|S)Nz [^a-zA-Z0-9])resubtitle) table_namerrr table2model;sz.Command.handle_inspection..table2modelz0# This is an auto-generated Django model module.z<# You'll have to do the following manually to clean this up:z# * Rearrange models' orderz># * Make sure each model has one field with primary_key=Truez]# * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behaviorzh# * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the tablezR# Feel free to rename the models, but don't rename db_table values or field names.zfrom %s import modelstZinclude_partitionspZ include_viewsvcsi|]}|jvr|j|qSr)r name).0infotypesrr Xz-Command.handle_inspection..r css|] }|VqdSNr)r)r(rrr Zr.z,Command.handle_inspection..rcSs0g|](}|drt|ddkr|ddqS)uniquecolumnsr)lenr)crrr ssz-Command.handle_inspection..z# Unable to inspect table '%s'z# The error was: %srzclass %s(models.Model):TZ primary_keyr3zZThe composite primary key (%s) found, that is not supported. The first column is selected., r1FZ OneToOneFieldZ ForeignKeyZto_fieldrz%s(%sz%s('%s'z %s_%s_setZ related_name(idz AutoField(Z AutoFieldz AutoField?blanknullz %s = %s%s.zmodels.)z ForeignKey(zOneToOneField(z, models.DO_NOTHINGZ db_commentcss|]\}}d||fVqdS)z%s=%rNr)r)kr'rrrr0s)z #  z %s)&rgetcursor db_moduleadd introspectionZget_table_listsortedcallableZ get_relationsrZget_constraintsZget_primary_key_columnsvaluesZget_table_description Exceptionappendsetr(normalize_col_nameupdateextendr4joinpopZget_primary_key_columnlowerget_field_typefeaturesZintrospected_field_typesZnull_ok startswithZsupports_commentscommentendswithitemsr get_meta))rr connectionrr$rBZ known_modelsZ table_infor#Z relations constraintsZprimary_key_columnsZprimary_key_columnZunique_columnsZtable_descriptioneZ model_nameused_column_namescolumn_to_field_nameZused_relationsrowZ comment_notesZ extra_paramsZ column_name is_relationZatt_nameparamsnotesZ ref_db_columnZ ref_db_tableZrel_typeZ ref_pk_columnZrel_to field_type field_params field_notesZ field_descrUr*is_view is_partitionrr+rr6sN            "                             zCommand.handle_inspectionc Csi}g}|}||kr"|d|rF|dr>|dd}n||d<tdd|\}}|dkrj|d |tdkr|tdkr|td}qx|tdkr|d |drd |}|d |drd |}|dt |r|d7}|d|d r&d|}|d||vrhd}d||f|vrR|d7}q4d||f}|d||kr|r||d<|||fS)zU Modify the column name to make it Python-compatible as a field name zField name made lowercase.Z_idNZ db_columnz\W_rz.Field renamed to remove unsuitable characters.z>Field renamed because it contained more than one '_' in a row.zfield%sz*Field renamed because it started with '_'.z%sfieldz(Field renamed because it ended with '_'.Z_fieldz4Field renamed because it was a Python reserved word.z number_%sz:Field renamed because it wasn't a valid Python identifier.z%s_%dr3z'Field renamed because of name conflict.) rQrJrVr subnfindrreplacerTkeyword iskeywordisdigit) rZcol_namer\r_rcrdnew_nameZnum_replnumrrrrL sT             zCommand.normalize_col_namecCsi}g}z|j|j|}Wn ty<d}|dYn0|dkrj|jrjt|j}rj|dkrj||d<|dvr|jr|j|d<|dkr|jd us|j d ur|d |jd ur|jnd |d <|j d ur|j nd |d<n|j|d <|j |d<|||fS)z Given the database connection, the table name, and the cursor row description, this routine will return the given field type name, as well as any additional keyword parameters and notes for the field. TextFieldzThis field type is a guess. CharFieldr max_length>rqrrZ db_collationZ DecimalFieldNzamax_digits and decimal_places have been guessed, as this database handles decimal fields as float Z max_digitsZdecimal_places) rErRZ type_codeKeyErrorrJZ display_sizeintZ collation precisionscale)rrYr#r^rcrdrbsizerrrrREs0    zCommand.get_field_typecsg}d}|D]^} | dr| d} d| vr0d}fdd| D} t| dkr|ttfd d | Dq|rzd } n|rd } nd } d g} |r| d| dd| d|g7} |rdd|d} | d| g7} |r| d|g7} | S)z Return a sequence comprising the lines of code necessary to construct the inner Meta class for the model corresponding to the given database table name. Fr1r2NTcs g|]}|dur|vr|qSr/r)r)xr]rrr7sz$Command.get_meta..r3c3s|]}|VqdSr/rr5r|rrr0r.z#Command.get_meta..z& # Created from a view. Don't remove.z+ # Created from a partition. Don't remove.rz4 # A unique constraint could not be introspected.z class Meta:z managed = False%sz db_table = %rr9r8z,)z unique_together = %sz db_table_comment = )rHr4rJrtuplerO)rr#rZr]rerfrUZunique_togetherZhas_unsupported_constraintr`r2Zmanaged_commentmetatuprr|rrXnsB    zCommand.get_metaN) __name__ __module__ __qualname__r Zrequires_system_checksZstealth_optionsrCrrrrLrRrXrrrrr s T<)r) rlr Zdjango.core.management.baserrZ django.dbrrZdjango.db.models.constantsrrrrrrs