B ©0H[42ã@s\ddlZddlZddlmZddlmZmZddlmZm Z ddl m Z Gdd„deƒZ dS)éN)Ú OrderedDict)Ú BaseCommandÚ CommandError)ÚDEFAULT_DB_ALIASÚ connections)Ú LOOKUP_SEPc@sLeZdZdZdZdZdZdd„Zdd„Zd d „Z d d „Z d d„Z dd„Z dS)ÚCommandzXIntrospects the database tables in the given database and outputs a Django model module.F)Útable_name_filterz django.dbcCs,|jdddtdd|jdddtdd dS) NÚtableÚstoreÚ*z4Selects what tables or views should be introspected.)ÚactionÚnargsÚtypeÚhelpz --databaseÚdatabasezMNominates a database to introspect. Defaults to using the "default" database.)r ÚdestÚdefaultr)Ú add_argumentÚstrr)ÚselfÚparser©rúmC:\Users\HIRONO~1\AppData\Local\Temp\pip-install-6bm3nxem\django\django\core\management\commands\inspectdb.pyÚ add_argumentss zCommand.add_argumentscKsJy(x"| |¡D]}|j d|¡qWWntk rDtdƒ‚YnXdS)Nz%s zPDatabase inspection isn't supported for the currently selected database backend.)Úhandle_inspectionÚstdoutÚwriteÚNotImplementedErrorr)rÚoptionsÚlinerrrÚhandles zCommand.handlec #sÞt|d}| d¡}dd„}dd„‰| ¡¤}dVdVd Vd Vd Vd Vd Vd|jVg}|dp~|j |¡}xL|D]B}|dk r¨t|ƒr¨||ƒs¨qˆyŒy|j ||¡} Wntk rÔi} YnXy|j  ||¡} Wntk ri} YnX|j  ||¡} dd„|   ¡Dƒ} |j  ||¡} Wn:t k rn}zd|Vd|VwˆWdd}~XYnXdVdVd||ƒV| ||ƒ¡g}i}x| D]þ}g}tƒ}|d}|| k}| |||¡\}}}| |¡| |¡| |¡|||<|| krd|d<n|| kr(d|d<|rr| |d|krDdn|| |dƒ}||krhd|}nd|}n0| |||¡\}}}| |¡| |¡|d7}|dkrè|ddikrè|d krÊq¨n|d!krè|jjsè| d"¡|d#r|d$krd%}nd|d&<d|d'<d(|d)|kr$dnd*|f}| d+¡rB|d,7}|r|| d¡s\|d-7}|d- ‡fd.d/„| ¡Dƒ¡7}|d07}|rœ|d1d2 |¡7}d3|Vq¨Wx| || |¡D] }|Vq¼WqˆWWdQRXdS)4Nrr cSst dd| ¡¡S)Nz [^a-zA-Z0-9]Ú)ÚreÚsubÚtitle)Ú table_namerrrÚ table2model&sz.Command.handle_inspection..table2modelcSs| d¡r|dd…S|S)Nzu'é)Ú startswith)ÚsrrrÚ strip_prefix)sz/Command.handle_inspection..strip_prefixz0# 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=TruezL# * Make sure each ForeignKey has `on_delete` set to the desired behavior.zh# * 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 modelsr cSs0g|](}|drt|dƒdkr|dd‘qS)ÚuniqueÚcolumnsr(r)Úlen)Ú.0Úcrrrú Jsz-Command.handle_inspection..z# Unable to inspect table '%s'z# The error was: %sr"zclass %s(models.Model):rTZ primary_keyr,r(rz ForeignKey(%szForeignKey('%s'ú(Úidz AutoField(z IntegerField(z AutoField?éz BooleanField(zNullBooleanField(ZblankÚnullz %s = %s%sÚ.zmodels.z ForeignKey(z, models.DO_NOTHINGz, c3s&|]\}}d|ˆt|ƒƒfVqdS)z%s=%sN)Úrepr)r/ÚkÚv)r+rrú sz,Command.handle_inspection..ú)z # ú z %s)rÚgetÚcursorÚ db_moduleÚ introspectionZ table_namesÚcallableZ get_relationsrZget_constraintsZget_primary_key_columnÚvaluesZget_table_descriptionÚ ExceptionÚappendrÚnormalize_col_nameÚupdateÚextendÚget_field_typeÚfeaturesZcan_introspect_autofieldr)ÚendswithÚjoinÚitemsÚget_meta)rrÚ connectionr r'r>Z known_modelsZtables_to_introspectr&Z relationsÚ constraintsZprimary_key_columnZunique_columnsZtable_descriptionÚeÚused_column_namesÚcolumn_to_field_nameÚrowZ comment_notesZ extra_paramsZ column_nameÚ is_relationZatt_nameÚparamsZnotesZrel_toÚ field_typeÚ field_paramsÚ field_notesZ field_descZ meta_liner)r+rr!s¼                          zCommand.handle_inspectionc Cs’i}g}| ¡}||kr"| d¡|rF| d¡r>|dd…}n||d<t dd|¡\}}|dkrj| d ¡| t¡dkr´x| t¡dkr–| td¡}qzW| ¡ t¡dkr´| d ¡| d¡rÐd |}| d ¡| d¡rìd |}| d¡t   |¡r |d7}| d¡|d  ¡r*d|}| d¡||krpd}x d||f|krX|d7}q:Wd||f}| d¡||krˆ|rˆ||d<|||fS)zU Modify the column name to make it Python-compatible as a field name zField name made lowercase.Ú_idNéýÿÿÿZ 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_%dr(z'Field renamed because of name conflict.) ÚlowerrDrJr#ÚsubnÚfindrÚreplacer)ÚkeywordÚ iskeywordÚisdigit) rZcol_namerQrTrWrXÚnew_nameZnum_replÚnumrrrrE¦sL              zCommand.normalize_col_namecCstƒ}g}y|j |d|¡}Wn"tk rBd}| d¡YnXt|ƒtkrb|\}}| |¡|dkr‚|dr‚t|dƒ|d<|dkrþ|dd ks¢|d d kræ| d ¡|dd k rÀ|dnd |d <|d d k rÜ|d nd |d<n|d|d <|d |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. r(Z TextFieldzThis field type is a guess.Z CharFieldéÚ max_lengthZ DecimalFieldéNézamax_digits and decimal_places have been guessed, as this database handles decimal fields as floaté Z max_digitsZdecimal_places) rr@rHÚKeyErrorrDrÚtuplerFÚint)rrNr&rSrWrXrVÚ new_paramsrrrrHÞs*    zCommand.get_field_typec s˜g}xZ| ¡D]N\}}|dr|d}t|ƒdkrdd ‡fdd„|Dƒ¡d}| |¡qWd d d d |g} |r”dd |¡d }| 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. r,r-r(r2z, c3s|]}dˆ|VqdS)z'%s'Nr)r/r0)rRrrr:sz#Command.get_meta..r;r"z class Meta:z managed = Falsez db_table = '%s'z,)z unique_together = %s)rLr.rKrD) rr&rOrRZunique_togetherÚindexrUr-ÚtupÚmetar)rRrrMs   zCommand.get_metaN) Ú__name__Ú __module__Ú __qualname__rZrequires_system_checksZstealth_optionsr?rr!rrErHrMrrrrr s 8&r) r`r#Ú collectionsrZdjango.core.management.baserrZ django.dbrrZdjango.db.models.constantsrrrrrrÚs