
    VhC                     V    d dl Z d dlZd dlmZmZ d dlmZmZ d dlm	Z	  G d de      Z
y)    N)BaseCommandCommandError)DEFAULT_DB_ALIASconnections)
LOOKUP_SEPc                   F    e Zd ZdZg ZdZdZd Zd Zd Z	d Z
d Zd	 Zd
 Zy)CommandzXIntrospects the database tables in the given database and outputs a Django model module.)table_name_filterz	django.dbc                     |j                  ddt        d       |j                  dt        t        t              d       |j                  dd	d
       |j                  dd	d       y )Ntable*z4Selects what tables or views should be introspected.)nargstypehelpz
--databasezMNominates a database to introspect. Defaults to using the "default" database.)defaultchoicesr   z--include-partitions
store_truez(Also output models for partition tables.)actionr   z--include-viewsz&Also output models for database views.)add_argumentstrr   tupler   )selfparsers     Y/home/dcms/DCMS/lib/python3.12/site-packages/django/core/management/commands/inspectdb.pyadd_argumentszCommand.add_arguments   s    G	 	 	
 	$+& 	 	
 	"; 	 	

 	9 	 	
    c                     	 | j                  |      D ]  }| j                  j                  |        y # t        $ r t	        d      w xY w)NzPDatabase inspection isn't supported for the currently selected database backend.)handle_inspectionstdoutwriteNotImplementedErrorr   )r   optionslines      r   handlezCommand.handle-   sT    	..w7 (!!$'(" 	$ 	s	   14 A	c           
   #   p  K   t         |d      }|j                  d      }|j                         5 }d d d d d d d	 d
| j                  z   g }dh}|d   r|j	                  d       |d   r|j	                  d       |j
                  j                  |      }|D ci c]  }|j                  |v s|j                  |  }}|d   xs t        d |D              D ]V  }	|t        |      r	 ||	      s	 	 |j
                  j                  ||	      }
	 |j
                  j                  ||	      }|j
                  j                  ||	      xs g }t        |      dk(  r|d   nd }|j!                         D cg c]   }|d   rt        |d         dk(  r|d   d   " }}|j
                  j#                  ||	      }| j'                  |	      }d d d|z   |j)                  |       t        |      dkD  r+dj+                  |D cg c]  }d| d
 c}      }d| d g }i }t-               }|D ]  }g }i }|j                  }||
v }| j/                  |||      \  }}}|j1                  |       |j3                  |       |j)                  |       |||<   ||k(  rd|d<   n	||v rd|d<   |r|
|   \  } }!|j5                  dd       s|j                  d      rd!}"n*d"}"|j
                  j7                  ||!      }#|#r
|#| k7  r| |d#<   |!|	k(  rd$n| j'                  |!      }$|$|v r|"d%|$}%n|"d&|$d}%|$|v r|j9                         d'|d(|d)<   |j	                  |$       n>| j;                  ||	|      \  }%}&}'|j1                  |&       |j3                  |'       |%d%z  }%|d*k(  r>|ddik(  r7|%d+k(  r|%|j<                  j>                  d,   d%z   k(  r|j)                  d-       |j@                  r
d|d.<   d|d/<   |d0d1|%v rdnd2|%}(|%jC                  d3      r|(d4z  }(|j<                  jD                  r|jF                  r|jF                  |d5<   |r?|(jI                  d%      s|(dz  }(|(dj+                  d6 |jK                         D              z  }(|(dz  }(|r|(d7d8j+                  |      z   z  }(d9|(z    d })|j                  |	      x}rA|j                  dk(  }*|j                  dk(  }+|j<                  jD                  r|jF                  })nd }*d }+| jM                  |	|||*|+|)      E d {    Y 	 d d d        y c c}w # t        $ r i }
Y ?w xY w# t        $ r i }Y 4w xY wc c}w # t$        $ r}d|	z   d|z   Y d }~d }~ww xY wc c}w 7 i# 1 sw Y   y xY ww):Ndatabaser
   z0# 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.zfrom %s import modelstinclude_partitionspinclude_viewsvr   c              3       K   | ]  }|  y wN ).0names     r   	<genexpr>z,Command.handle_inspection.<locals>.<genexpr>X   s     8U$8Us      r   uniquecolumnsz# Unable to inspect table '%s'z# The error was: %s zclass %s(models.Model):, 'z$    pk = models.CompositePrimaryKey()Tprimary_keyFOneToOneField
ForeignKeyto_fieldr   (z('__setrelated_nameidz
AutoField(	AutoFieldz
AutoField?blanknullz = .zmodels.)zForeignKey(zOneToOneField(z, models.DO_NOTHING
db_commentc              3   0   K   | ]  \  }}|d |  yw)=Nr.   )r/   kr+   s      r   r1   z,Command.handle_inspection.<locals>.<genexpr>   s      015Aq!,0s   z  #  z    %s)'r   getcursor	db_moduleaddintrospectionget_table_listr   r0   sortedcallableget_relationsr!   get_constraintsget_primary_key_columnslenvaluesget_table_description	Exceptionnormalize_table_nameappendjoinsetnormalize_col_nameupdateextendpopget_primary_key_columnlowerget_field_typefeaturesintrospected_field_typesnull_ok
startswithsupports_commentscommentendswithitemsget_meta),r   r"   
connectionr
   rL   known_modelstypes
table_infoinfo
table_name	relationsconstraintsprimary_key_columnsprimary_key_columncunique_columnstable_descriptione
model_namecolfieldsused_column_namescolumn_to_field_nameused_relationsrowcomment_notesextra_paramscolumn_nameis_relationatt_nameparamsnotesref_db_columnref_db_tablerel_typeref_pk_columnrel_to
field_typefield_paramsfield_notes
field_descrj   is_viewis_partitions,                                               r   r   zCommand.handle_inspection7   s     !45
#KK(;<  K	FDDPP11RR*
A
 *DNN::LEE+,		#'		##11@@HJ6@WdDIIQVDV$))T/WJW%g.U&8U*8U2U o
$0X>O5P,Z8 #'$.$<$<$J$J"J%	
)&0&>&>&N&N"J' #00HH"J  	 ( 23q8 ,A.! ' "-!3!3!5&X;3q|+<+A )Q&N &
 )3(@(@(V(V
)% "66zB
/*<<##J/*+a/!YY>Q'Rs!C5
'RSF@JJ$&!')$!$, h0C " $&L"%((K"-":K.2.E.E#%6/+Hfe !''/!((/%,,X68@(5 #&886:]3$615X."6?6L3|'++He<@P@P)A (7H'3H * 8 8 O O$*L!" *
  --1O;HZ 8  ,z9 #!%!:!:<!H 
 "\14<f)EJ6>)GJ!^3 * 0 0 2 (<L8 '**62 AE@S@S&
CA=
L+ %++L9%,,[9"c)
  4'L]D<Q,Q%5$&)22KKKX! "" *00> {{04W-/3V, !!Z/Y>"	"J ",,-NO"&;;
 "**<<58[[\2#)2237&$.J"dii 09E9K9K9M0 ' 
 #%J$"fsxx/F&FF
"Z//Qh0R %>>*5545"ii3.G#'99#3L!**<<"&,,#G#(L==(   Qo9K	 K	4 X / '$&	' / )&()& ! :ZGG/!33 (SpIK	 K	s   .V6A>V*.UU5V*U%U'AU>%U9-U>AV*V#&LV*>V(?V*	V6V*U$ U>#U$$U>'U62U>5U66U>>	V VV*V  	V**V3/V6c                    i }g }|j                         }||k7  r|j                  d       |r(|j                  d      r|j                  d      }n||d<   t	        j
                  dd|      \  }}|dkD  r|j                  d       |j                  t              dk\  r~|j                  t              dk\  r/|j                  t        d      }|j                  t              dk\  r/|j                         j                  t              dk\  r|j                  d       |j                  d      rd	|z  }|j                  d
       |j                  d      rd|z  }|j                  d       t        j                  |      r|dz  }|j                  d       |d   j                         rd|z  }|j                  d       ||v r2d}d||fz  |v r|dz  }d||fz  |v rd||fz  }|j                  d       ||k7  r|r||d<   |||fS )zU
        Modify the column name to make it Python-compatible as a field name
        zField name made lowercase._id	db_columnz\Wr>   r   z.Field renamed to remove unsuitable characters.z>Field renamed because it contained more than one '_' in a row.zfield%sz*Field renamed because it started with '_'.z%sfieldz(Field renamed because it ended with '_'._fieldz4Field renamed because it was a Python reserved word.z	number_%sz:Field renamed because it wasn't a valid Python identifier.z%s_%dr2   z'Field renamed because of name conflict.)rc   r[   rk   removesuffixresubnfindr   replacerh   keyword	iskeywordisdigit)	r   col_namer   r   r   r   new_namenum_replnums	            r   r^   zCommand.normalize_col_name	  s    >>#x;<  '#007,4[)WWUC:(a<OP==$)--
+q0#++J< --
+q0~~$$Z0A5""T s# 8+HKLS! 8+HIJX& HUVA; "X-HL ((CXsO+/@@q XsO+/@@(C0HHIxK(0L%{22r   c                 L    t        j                  dd|j                               S )z;Translate the table name to a Python-compatible model name.z[^a-zA-Z0-9]r5   )r   subtitle)r   rs   s     r   rZ   zCommand.normalize_table_nameE  s    vvor:+;+;+=>>r   c                 V   i }g }	 |j                   j                  |j                  |      }|dk(  r-|j
                  r!t        |j
                        x}r
|dkD  r||d<   |dv r|j                  r|j                  |d<   |dk(  r|j                  |j                  L|j	                  d	       |j                  |j                  nd
|d<   |j                  |j                  nd|d<   n|j                  |d<   |j                  |d<   |||fS # t        $ r d}|j	                  d       Y w xY w)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.
        	TextFieldzThis field type is a guess.	CharFieldr   
max_length>   r   r   db_collationDecimalFieldzamax_digits and decimal_places have been guessed, as this database handles decimal fields as float
   
max_digits   decimal_places)
rO   rd   	type_codeKeyErrorr[   display_sizeint	collation	precisionscale)r   rn   rs   r   r   r   r   sizes           r   rd   zCommand.get_field_typeI  sA    	>#11@@PSTJ $)9)9C,,---4!8-1\*33+.==L('}}$		(9""?
 &)]]%>CMMB \* "%!6CIIA -. .1]]\*14-.<449  	>$J<=	>s   &D	 	D('D(c           	         g }d}|j                         D ]k  }	|	d   s	|	d   }
d|
v rd}|
D cg c]  }||v s| }
}t        |
      dkD  s:|	d   r@|j                  t        t	        fd|
D                           m |rd	}n|rd
}nd}dg}|r|j                  d       |dd|z  d|z  gz  }|r ddj                  |      z   dz   }|d|z  gz  }|r	|d|gz  }|S c c}w )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.
        Fr3   r4   NTr2   r9   c              3   (   K   | ]	  }|     y wr-   r.   )r/   rx   r   s     r   r1   z#Command.get_meta.<locals>.<genexpr>  s     !Ka"6q"9!Ks   z&  # Created from a view. Don't remove.z+  # Created from a partition. Don't remove.r5   z4    # A unique constraint could not be introspected.z    class Meta:z        managed = False%sz        db_table = %rr=   r6   z,)z        unique_together = %sz        db_table_comment = )rW   rV   r[   r   r   r\   )r   rs   ru   r   r   r   rj   unique_togetherhas_unsupported_constraintr   r4   xmanaged_commentmetatups      `           r   rm   zCommand.get_metar  sE    %*"!((* 	Fh +7?15.&!-AAU<UA  w<!#F=,A#**E!K7!KKL	 FOKO Ot%KKNO'/9#j0
 	

 		/22T9C3c9::D27+>??D5s   C#C#C#N)__name__
__module____qualname__r   requires_system_checksstealth_optionsrM   r   r$   r   r^   rZ   rd   rm   r.   r   r   r	   r	   	   sE    	 	  ,OI
6Pd:3x?'5R/r   r	   )r   r   django.core.management.baser   r   	django.dbr   r   django.db.models.constantsr   r	   r.   r   r   <module>r      s"     	 A 3 1Xk Xr   