/usr/local/lib/python3.9/site-packages/django/core/management/commands/__pycache__
a Ӱ�h8C � @ sP d dl Z d dlZd dlmZmZ d dlmZmZ d dlm Z G dd� de�Z dS )� N)� BaseCommand� CommandError)�DEFAULT_DB_ALIAS� connections)� LOOKUP_SEPc @ sL e Zd ZdZg ZdZdZdd� Zdd� Zdd � Z d d � Z d d � Z dd� Z dS )�CommandzXIntrospects the database tables in the given database and outputs a Django model module.)�table_name_filterz django.dbc C sF |j ddtdd� |j dtdd� |j dd d d � |j d d d d � d S )N�table�*z4Selects what tables or views should be introspected.)�nargs�type�helpz --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_argument�strr )�self�parser� r �S/usr/local/lib/python3.9/site-packages/django/core/management/commands/inspectdb.py� add_arguments s* ����zCommand.add_argumentsc K s@ z | � |�D ]}| j�|� q W n ty: td��Y n0 d S )NzPDatabase inspection isn't supported for the currently selected database backend.)�handle_inspection�stdout�write�NotImplementedErrorr )r �options�liner r r �handle, s �zCommand.handlec ) # s$ t |d }|�d�}dd� }|�� ���}dV dV dV dV d V d V d V d | j V g }d h� |d r|� �d� |d r�� �d� |j�|�}� fdd�|D �}|d p�tdd� |D ��D �]6}|d ur�t|�r�||�s�q�z�z|j� ||�} W n t �y i } Y n0 z|j� ||�} W n t �y> i } Y n0 |j� ||�} | �r\| d nd } dd� | � � D �} |j�||�}W nF t�y� } z,d| V d| V W Y d }~q�W Y d }~n d }~0 0 ||�}d V d V d | V |�|� g }i }t� }|D �]�}g }i }|j}|| v }| �|||�\}}}|�|� |�|� |�|� |||< || k�r�d |d < t| �d k�r�|�d!d"�| � � n|| v �r�d |d#< |�rb| | \} } |�d#d$��s�|�d ��r�d%} n*d&} |j�|| �} | �r�| | k�r�| |d'< | |k�r d(n|| �} | |v �r,d)| | f }!n d*| | f }!| |v �rVd+|�� |f |d,< |�| � n0| �|||�\}!}"}#|�|"� |�|#� |!d-7 }!|d.k�r�|d d ik�r�|!d/k�r��qn |!|j j d0 d- k�r�|�d1� |j �r�d |d2< d |d3< d4|d5|!v �rd nd6|!f }$|!� d7��r"|$d87 }$|j j �r>|j!�r>|j!|d9< |�rt|$�"d-��sX|$d"7 }$|$d"�d:d� |�#� D ��7 }$|$d;7 }$|�r�|$d<d=�|� 7 }$d>|$ V �qd }%|�|� }&�r�|&j$dk}'|&j$dk}(|j j �r�|&j!}%nd$}'d$}(| �%|| ||'|(|%�E d H q�W d � n1 �s0 Y d S )?NZdatabaser c S s t �dd| �� �S )Nz [^a-zA-Z0-9]� )�re�sub�title)� table_namer r r � table2model; s z.Command.handle_inspection.<locals>.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 models�tZinclude_partitions�pZ include_views�vc s i | ]}|j � v r|j|�qS r )r �name)�.0�info��typesr r � <dictcomp>X � z-Command.handle_inspection.<locals>.<dictcomp>r c s s | ] }|V qd S �Nr )r) r( r r r � <genexpr>Z r. z,Command.handle_inspection.<locals>.<genexpr>r c S s0 g | ](}|d rt |d �dkr|d d �qS )�unique�columns� r )�len�r) �cr r r � <listcomp>s s �z-Command.handle_inspection.<locals>.<listcomp>z # Unable to inspect table '%s'z# The error was: %sr zclass %s(models.Model):TZ primary_keyr3 zZThe composite primary key (%s) found, that is not supported. The first column is selected.�, r1 FZ OneToOneFieldZ ForeignKeyZto_fieldr z%s(%sz%s('%s'z %s_%s_setZ related_name�(�idz AutoField(Z AutoFieldz AutoField?�blank�nullz %s = %s%s�.zmodels.)z ForeignKey(zOneToOneField(z, models.DO_NOTHINGZ db_commentc s s | ]\}}d ||f V qdS )z%s=%rNr )r) �kr' r r r r0 � s �)z # � z %s)&r �get�cursor� db_module�add� introspectionZget_table_list�sorted�callableZ get_relationsr Zget_constraintsZget_primary_key_columns�valuesZget_table_description� Exception�append�setr( �normalize_col_name�update�extendr4 �join�popZget_primary_key_column�lower�get_field_type�featuresZintrospected_field_typesZnull_ok� startswithZsupports_comments�comment�endswith�itemsr �get_meta))r r � connectionr r$ rB Z known_modelsZ table_infor# Z relations� constraintsZprimary_key_columnsZprimary_key_columnZunique_columnsZtable_description�eZ model_name�used_column_names�column_to_field_nameZused_relations�rowZ comment_notesZ extra_paramsZ column_name� is_relationZatt_name�params�notesZ ref_db_columnZ ref_db_tableZrel_typeZ ref_pk_columnZrel_to� field_type� field_params� field_notesZ field_descrU r* �is_view� is_partitionr r+ r r 6 sN ��� � � ����� " �� �� ����� � � ��� � � �zCommand.handle_inspectionc C s� i }g }|� � }||kr"|�d� |rF|�d�r>|dd� }n||d< t�dd|�\}}|dkrj|�d � |�t�dkr�|�t�dkr�|�td�}qx|� � �t�dkr�|�d � |�d�r�d | }|�d � |�d�r�d | }|�d� t � |��r|d7 }|�d� |d � � �r&d| }|�d� ||v �rhd}d||f |v �rR|d7 }�q4d||f }|�d� ||k�r�|�r�||d< |||fS )zU Modify the column name to make it Python-compatible as a field name zField name made lowercase.Z_idN���Z db_columnz\W�_r z.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_%dr3 z'Field renamed because of name conflict.) rQ rJ rV r �subn�findr �replacerT �keyword� iskeyword�isdigit) r Zcol_namer\ r_ rc rd �new_nameZnum_repl�numr r r rL sT � � zCommand.normalize_col_namec C s� i }g }z|j �|j|�}W n ty< d}|�d� Y n0 |dkrj|jrjt|j� }rj|dkrj||d< |dv r�|jr�|j|d< |dkr�|jd u s�|j d u r�|�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> rr rq Z db_collationZ DecimalFieldNzamax_digits and decimal_places have been guessed, as this database handles decimal fields as float� Z max_digits� Zdecimal_places) rE rR Z type_code�KeyErrorrJ Z display_size�intZ collation� precision�scale)r rY r# r^ rc rd rb �sizer r r rR E s0 ��� zCommand.get_field_typec s� g }d}|� � D ]^} | d r| d } d| v r0d}� fdd�| D �} t| �dkr|�tt� fd d �| D ���� q|rzd } n|r�d } nd } d g} |r�| �d� | dd| d| g7 } |r�dd�|� 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. Fr1 r2 NTc s g | ]}|d ur|� v r|�qS r/ r )r) �x�r] r r r7 � s z$Command.get_meta.<locals>.<listcomp>r3 c 3 s | ]}� | V qd S r/ r r5 r| r r r0 � r. z#Command.get_meta.<locals>.<genexpr>z& # Created from a view. Don't remove.z+ # Created from a partition. Don't remove.r z4 # A unique constraint could not be introspected.z class Meta:z managed = False%sz db_table = %rr9 r8 z,)z unique_together = %sz db_table_comment = )rH r4 rJ r �tuplerO )r r# rZ r] re rf rU Zunique_togetherZhas_unsupported_constraintr` r2 Zmanaged_comment�meta�tupr r| r rX n sB � � �zCommand.get_metaN) �__name__� __module__� __qualname__r Zrequires_system_checksZstealth_optionsrC r r r rL rR rX r r r r r s � T<)r ) rl r Zdjango.core.management.baser r Z django.dbr r Zdjango.db.models.constantsr r r r r r �<module> s
.
Edit
..
Edit
__init__.cpython-39.pyc
Edit
check.cpython-39.pyc
Edit
compilemessages.cpython-39.pyc
Edit
createcachetable.cpython-39.pyc
Edit
dbshell.cpython-39.pyc
Edit
diffsettings.cpython-39.pyc
Edit
dumpdata.cpython-39.pyc
Edit
flush.cpython-39.pyc
Edit
inspectdb.cpython-39.pyc
Edit
loaddata.cpython-39.pyc
Edit
makemessages.cpython-39.pyc
Edit
makemigrations.cpython-39.pyc
Edit
migrate.cpython-39.pyc
Edit
optimizemigration.cpython-39.pyc
Edit
runserver.cpython-39.pyc
Edit
sendtestemail.cpython-39.pyc
Edit
shell.cpython-39.pyc
Edit
showmigrations.cpython-39.pyc
Edit
sqlflush.cpython-39.pyc
Edit
sqlmigrate.cpython-39.pyc
Edit
sqlsequencereset.cpython-39.pyc
Edit
squashmigrations.cpython-39.pyc
Edit
startapp.cpython-39.pyc
Edit
startproject.cpython-39.pyc
Edit
test.cpython-39.pyc
Edit
testserver.cpython-39.pyc
Edit