Ë
|
WñúhJ ã ó d Z ddlmZ ddlmZmZmZmZmZm Z m
|
Z
|
ddl Z ddl m Z ddlmZmZmZ ddlmZ ddlmZ dd lmZ erdd
|
lmZ ed ej8 d z « Zed k r
|
edd« Z n edd« Z G d de« Z y)zDatabase Introspection.é )Ú
|
namedtuple)Ú TYPE_CHECKINGÚAnyÚDictÚListÚOptionalÚSetÚTupleN)ÚVERSION)ÚBaseDatabaseIntrospectionÚ FieldInfoÚ TableInfo)ÚIndex)Ú
|
OrderedSet)Ú FieldType)Ú CursorWrapperr )ÚextraÚ is_unsignedÚhas_json_constraint©é é r ÚInfoLinezNcol_name data_type max_len num_prec num_scale extra column_default is_unsignedzXcol_name data_type max_len num_prec num_scale extra column_default collation is_unsignedc óZ e Zd ZdZi ej
|
dej dej dej dej dej dej dej dej dej dej d ej d
|
ej" d ej$ dej& dej( dej* dej, dej. d
|
i¥Zd ed edef fd Zddde e fdZ dddede e fdZ dddede e!e ee"f f fdZ#dddede$e! fdZ% d dddede&de e eef fdZ'dddede ee(eef f fdZ)dddede e(eeef fdZ*dddedefdZ+d e&d e,e de-fd Z.dddede ee&f fd Z/ xZ0S )!ÚDatabaseIntrospectionz5Encapsulate backend-specific introspection utilities.Ú TextFieldÚ DecimalFieldÚ DateFieldÚ DateTimeFieldÚ
|
FloatFieldÚ IntegerFieldÚBigIntegerFieldÚSmallIntegerFieldÚ CharFieldÚ TimeFieldÚ data_typeÚ descriptionÚreturnc ó¾ t | ||« }d|j v r|dk( ry|dk( ry|dk( ry|j r|dk( ry|dk( ry |dk( ry
|
|j ry |S ) NÚauto_incrementr! Ú AutoFieldr" Ú BigAutoFieldr# ÚSmallAutoFieldÚPositiveBigIntegerFieldÚPositiveIntegerFieldÚPositiveSmallIntegerFieldÚ JSONField)ÚsuperÚget_field_typer r r )Úselfr& r' Ú
|
field_typeÚ __class__s úWH:\Change_password\venv_build\Lib\site-packages\mysql/connector/django/introspection.pyr3 z$DatabaseIntrospection.get_field_typel s
ø ÜWÑ+¨I°{ÓC
|
Ø {× 0Ñ 0Ñ 0Ø^Ò+Ø"ØÐ .Ò.Ø%ØÐ 0Ò0Ø'Ø × "Ò "ØÐ .Ò.Ø0Ø^Ò+Ø-ØÐ 0Ò0Ø2ð × *Ò *Ø ØÐó Úcursorr c
|
ó® |j d« |j « D cg c]& }t |d dddj |d « « ( c}S c c}w )z>Return a list of table and view names in the current database.zSHOW FULL TABLESr ÚtÚv)z
|
BASE TABLEÚVIEWé )ÚexecuteÚfetchallr Úget)r4 r9 Úrows r7 Úget_table_listz$DatabaseIntrospection.get_table_list sW àÐ)Ô*ð Ó(ö
|
àô c!f¨S¸#Ñ >× BÑ BÀ3ÀqÁ6Ó JÕ Kò
|
ð
|
ùò
|
s ¤+AÚ
|
table_namec ó i }|j d|g« |j « }|r|d nd}t dk r|j d|g« n|j d||g« |j « D ci c] }|d t | }}|j d| j
|
j j |« d« d t d
|
t t fd }g } |j D ]Q }||d }
|
t dk r| j t g |d d ¢ ||
|
j « xs |d ||
|
j « xs |d ||
|
j « xs |d |d |
|
j" |
|
j$ |
|
j& |d |v « ®| j t g |d d ¢ ||
|
j « xs |d ||
|
j « xs |d ||
|
j « xs |d |d |
|
j" |
|
j( |
|
j$ |
|
j& |d |v « T | S c c}w )zj
|
Return a description of the table with the DB-API cursor.description
|
interface."
|
z
|
SELECT table_collation
|
FROM information_schema.tables
|
WHERE table_schema = DATABASE()
|
AND table_name = %s
|
r Ú r aÍ
|
SELECT
|
column_name, data_type, character_maximum_length,
|
numeric_precision, numeric_scale, extra, column_default,
|
CASE
|
WHEN column_type LIKE '%% unsigned' THEN 1
|
ELSE 0
|
END AS is_unsigned
|
FROM information_schema.columns
|
WHERE table_name = %s AND table_schema = DATABASE()
|
ax
|
SELECT
|
column_name, data_type, character_maximum_length,
|
numeric_precision, numeric_scale, extra, column_default,
|
CASE
|
WHEN collation_name = %s THEN NULL
|
ELSE collation_name
|
END AS collation_name,
|
CASE
|
WHEN column_type LIKE '%% unsigned' THEN 1
|
ELSE 0
|
END AS is_unsigned
|
FROM information_schema.columns
|
WHERE table_name = %s AND table_schema = DATABASE()
|
zSELECT * FROM z LIMIT 1Úir( c ó | t | « S | S ©N)Úint)rG s r7 Úto_intz;DatabaseIntrospection.get_table_description.<locals>.to_intË s Ø ]3q6Ð 1°Ð 1r8 Nr é é é )r? ÚfetchoneÚDJANGO_VERSIONr@ r Ú
|
connectionÚopsÚ
|
quote_namer r rJ r' Úappendr Úmax_lenÚnum_precÚ num_scaleÚcolumn_defaultr r Ú collation) r4 r9 rD Újson_constraintsrB Údefault_column_collationÚlineÚ
|
field_inforK ÚfieldsÚinfos r7 Úget_table_descriptionz+DatabaseIntrospection.get_table_description sÄ ð ,.Ðàð ð Lô
|
ð ooÓ Ù-0 3 q¢6°bÐ ô IÒ %Ø NNð
|
ð õ ð NNðð *¨:Ð6ô! ð$ <B¿?¹?Ó;LÖM°4d1gx¨Ñ.ÐM
|
ÐMàØ T__× 0Ñ 0× ;Ñ ;¸JÓ GÐ HÈÐ Qô
|
ð 2cð 2h¤smó 2ð Ø×&Ñ&ó DØ d 1gÑ&DÜ Ò)Ø Ü ð
|
Ø bqð
|
á t||Ó,Ò7°°Q±ð
|
ñ t}}Ó-Ò8°°a±ð
|
ñ t~~Ó.Ò9°$°q±'ð
|
ð
|
Qð
|
ð ×+Ñ+ð
|
ð
|
|
ð
|
ð ×(Ñ(ð
|
ð QÐ#3Ð3ò
|
õ ð Ü ð Ø bqð á t||Ó,Ò7°°Q±ð ñ t}}Ó-Ò8°°a±ð ñ t~~Ó.Ò9°$°q±'ð ð
|
Qð ð ×+Ñ+ð ð ð ð
|
|
ð ð ×(Ñ(ð ð QÐ#3Ð3ò ö ð# ð> ùòS Ns Á2H;c ó |j d| j j j |« « t |j « « }t « }|D ] }|d dkD s |j |d « ! i }|D ]@ }|d |v r |d |vr ddd||d < |d dk( r d ||d d
|
< |d r6d ||d d < B |S ) zReturn indexes from table.úSHOW INDEX FROM r r> r rL F)Ú primary_keyÚuniqueÚPRIMARYTrc rd )r? rQ rR rS Úlistr@ ÚsetÚadd)r4 r9 rD ÚrowsÚmulticol_indexesrB Úindexess r7 Ú get_indexesz!DatabaseIntrospection.get_indexesð sù ð Ð)¨$¯/©/×*=Ñ*=×*HÑ*HÈÓ*TÐ)UÐVÔWô FOOÓ%Ó&Ü 5ÐØò -CØ1vzØ ×$Ñ$ S¨¡VÕ,ð -ð /1Øò
|
1CØ1vÐ)Ñ)ØØ1vWÑ$Ø27À5Ñ"IAð 1vÒ"Ø15A Ñ.Øq6Ø,0A Ò)ð
|
1ð r8 c ól | j ||« j « D ] }|d d s |d c S y)zP
|
Returns the name of the primary key column for the given table
|
r> rc r N)rl Úitems)r4 r9 rD Úcolumns r7 Úget_primary_key_columnz,DatabaseIntrospection.get_primary_key_column sD ð ×&Ñ& v¨zÓ:×@Ñ@ÓBò !FØay Ó'Ø ayÒ ð !ð r8 Ú table_fieldsc ót | j ||« D ]" }d|j v s||j dgc S g S )Nr* )Útablero )r` r Úname)r4 r9 rD rq r] s r7 Ú get_sequencesz#DatabaseIntrospection.get_sequences sI ð ×4Ñ4°V¸ZÓHò JJØ :×#3Ñ#3Ò3à",¸
|
¿¹ÑHÐIÒIð Jð r8 c óR | j ||« }i }|D ] \ }}}||f||< |S )z
|
Return a dictionary of {field_name: (field_name_other_table, other_table)}
|
representing all relationships to the given table.
|
)Úget_key_columns)r4 r9 rD Ú constraintsÚ relationsÚ my_fieldnameÚ other_tableÚ other_fields r7 Ú get_relationsz#DatabaseIntrospection.get_relations sH ð ×*Ñ*¨6°:Ó> Ø Ø6Aò AÑ 2L+ {Ø'2°KÐ&@IlÒ #ð AàÐr8 c ón g }|j d|g« |j |j « « |S )z
|
Return a list of (column_name, referenced_table_name, referenced_column_name)
|
for all key columns in the given table.
|
a@
|
SELECT column_name, referenced_table_name, referenced_column_name
|
FROM information_schema.key_column_usage
|
WHERE table_name = %s
|
AND table_schema = DATABASE()
|
AND referenced_table_name IS NOT NULL
|
AND referenced_column_name IS NOT NULL)r? Úextendr@ )r4 r9 rD Ú key_columnss r7 rw z%DatabaseIntrospection.get_key_columns, s> ð "$ Øð :ð Lô
|
ð ×Ñ6??Ó,Ô-ØÐr8 c ó |j d|g« |j « }|s | j j j S |d S )z
|
Retrieve the storage engine for a given table. Return the default
|
storage engine if the table doesn't exist.
|
zBSELECT engine FROM information_schema.tables WHERE table_name = %sr )r? rO rQ ÚfeaturesÚ_mysql_storage_engine)r4 r9 rD Úresults r7 Úget_storage_enginez(DatabaseIntrospection.get_storage_engineA sI ð
|
Ø PØ Lô
|
ð Ó"áØ??×+Ñ+×AÑAÐ AàayÐr8 Ú check_clauseÚcolumnsc ó° t « }t j |« d }d |j « D « }|D ] }|j t j
|
j k( s+| j j j |j « |j k( sh|j dd |v sz|j |j dd « |S )Nr c 3 ó: K | ] }|j r| y wrI )Ú is_whitespace)Ú.0Útokens r7 ú <genexpr>zBDatabaseIntrospection._parse_constraint_columns.<locals>.<genexpr>V s è ø ÒTEÀ×@SÓ@S%ÑTùs r> éÿÿÿÿ) r ÚsqlparseÚparseÚflattenÚttypeÚtokensÚNamerQ rR rS Úvaluerh )r4 r r Ú check_columnsÚ statementr r s r7 Ú_parse_constraint_columnsz/DatabaseIntrospection._parse_constraint_columnsQ s¯ ô %/£L Ü NN <Ó0°Ñ3 ÙT Y×%6Ñ%6Ó%8ÔTØò 5Eà x× 3Ñ 3Ó3ØOO×'Ñ'×2Ñ2°5·;±;Ó?À5Ç;Á;ÓNØKK "Ð%¨Ò0à ×!Ñ! %§+¡+¨a°Ð"3Õ4ð 5ð Ð r8 c ó$ i }d}|j ||g« |j « D ]d \ }}}}||vrBt « dddd|r||fndd||< | j j j
|
rg || d< || d j |« f d} |j | |g« |j « D ]E \ }}
|
|
|
j « dk( rd || d
|
< d || d < *|
|
j « d k( s>d || d < G | j j j rd } | j ||« D ch c] } | j } } d } |j | |g« |j « D ]= \ }}| j || « }t |« |hk( r | dz } d| d}|dddd dd||< ? |j d| j j j |« « |j « D cg c] }|dd |d fz c}D ]Ò \ }}}}}}}||vr;t « ddddd||< | j j j
|
rg || d< d || d< |dk( rt j n|j « || d< || d j |« | j j j
|
sµ|| d j# |dk( rdnd« Ô |j% « D ] }t' |d « |d< |S c c} w c c}w )zu
|
Retrieve any constraints or keys (unique, pk, fk, check, index) across
|
one or more columns.
|
aX
|
SELECT kc.`constraint_name`, kc.`column_name`,
|
kc.`referenced_table_name`, kc.`referenced_column_name`
|
FROM information_schema.key_column_usage AS kc
|
WHERE
|
kc.table_schema = DATABASE() AND
|
kc.table_name = %s
|
ORDER BY kc.`ordinal_position`
|
FN)r rc rd ÚindexÚcheckÚ foreign_keyÚordersr zà
|
SELECT c.constraint_name, c.constraint_type
|
FROM information_schema.table_constraints AS c
|
WHERE
|
c.table_schema = DATABASE() AND
|
c.table_name = %s
|
z primary keyTrc rd r a
|
SELECT cc.constraint_name, cc.check_clause
|
FROM
|
information_schema.check_constraints AS cc,
|
information_schema.table_constraints AS tc
|
WHERE
|
cc.constraint_schema = DATABASE() AND
|
tc.table_schema = cc.constraint_schema AND
|
cc.constraint_name = tc.constraint_name AND
|
tc.constraint_type = 'CHECK' AND
|
tc.table_name = %s
|
r> Ú__unnamed_constraint_Ú__rb rN é
|
)r rc rd r r r ÚBTREEÚtypeÚDÚDESCÚASC)r? r@ r rQ r Ú supports_index_column_orderingrh ÚlowerÚ can_introspect_check_constraintsr` rt r rg rR rS r ÚsuffixrT Úvaluesrf )r4 r9 rD rx Ú
|
name_queryÚ
|
constraintro Ú ref_tableÚ
|
ref_columnÚ
|
type_queryÚkindÚunnamed_constraints_indexr_ r r Úconstraint_columnsÚxÚ_r ÚorderÚtype_s r7 Úget_constraintsz%DatabaseIntrospection.get_constraints` s ð ') ð
|
ð z J <Ô0Ø9?¿ ¹ Ó9Jò ;Ñ 5J ¨:Ø Ñ,ä )|Ø#(Ø #Ø "Ø "Ù>H I¨zÑ#:Èdñ + JÑ'ð ??×+Ñ+×JÒJØ8:K
|
Ñ+¨HÑ5Ø
|
Ñ # IÑ .× 2Ñ 2°6Õ :ð ;ð
|
ð z J <Ô0Ø &§¡Ó 1ò 9Ñ JØzz|}Ò,Ø9= JÑ'¨ Ñ6Ø48 JÑ'¨Ò1Ø Ó)Ø48 JÑ'¨Ò1ð 9ð ??× #Ñ #× DÒ DØ()Ð %à&*×&@Ñ&@ÀÈÓ&TöØ " ðGð ð Jð NN:¨
|
|Ô 4Ø,2¯O©OÓ,=ò Ñ(
|
LØ%)×%CÑ%CØ 'ó&Ð"ô Ð)Ó*¨z¨lÒ:Ø-°Ñ2Ð-Ø#8Ð9RÐ8SÐSUÐ!VJà 1Ø#(Ø #Ø "Ø !Ø#'ñ + JÒ'ð ð& Ð)¨$¯/©/×*=Ñ*=×*HÑ*HÈÓ*TÐ)UÐVÔWà&,§o¡oÓ&7ö5
|
Ø!"AbqEQrUHÓ ò5
|
ò WÑ 0Aq%F E¨5ð KÑ'ä )|Ø#(Ø #Ø "Ø#'ñ & EÑ"ð ??×+Ñ+×JÒJØ35K Ñ& xÑ0Ø*.KÑ wÑ 'à %¨Ò 0 °e·k±k³mð Ñ vÑ &ð Ñ yÑ )× -Ñ -¨fÔ 5Ø×'Ñ'×FÓFØEÑ" 8Ñ,×3Ñ3¸eÀsºl±FÐPUÕVð' Wð* &×,Ñ,Ó.ò @JÜ$(¨°IÑ)>Ó$?JyÒ !ð @àÐùòwùòH5
|
s Ä2LÇ5L )© )1Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r ÚBLOBÚDECIMALÚ
|
NEWDECIMALÚDATEÚDATETIMEÚDOUBLEÚFLOATÚINT24ÚLONGÚLONGLONGÚSHORTÚSTRINGÚTIMEÚ TIMESTAMPÚTINYÚ TINY_BLOBÚ MEDIUM_BLOBÚ LONG_BLOBÚ
|
VAR_STRINGÚdata_types_reverseÚstrr r3 r r rC r` r rJ Úboolrl r rp r ru r
|
r} rw r
r r r r· Ú __classcell__)r6 s @r7 r r S së ø Ù?ðØ ðà×Ñ>ðð × Ñ nðð ð ð
|
×ÑOð ð ×Ñ,ð ð ðð ðð ðð ×ÑÐ -ðð Ð,ðð ×Ñ+ðð ðð ×Ñ_ð ð ð ð ×Ñ[ð!ð" × Ñ {ð#ð$ ×Ñ[Ø× Ñ kñ'Ðð,¨ð ¸)ð Èõ ð,
|
_ð
|
¸¸i¹ ó
|
ðdØ%ðdØ36ðdà i ódðLØ%ðØ36ðà c4T ?Ð"Ñ #óð6 Ø%ð Ø36ð à # ó ð MOñØ%ðØ36ðØFIðà d38nÑ óð Ø%ð Ø36ð à c5c?Ð"Ñ #ó ðØ%ðØ36ðà eCcMÑ"Ñ #óð*¨ ð Àcð Ècó ð Ø ð Ø*-¨c©(ð à ó ð mØ%ðmØ36ðmà c3h ÷mr8 r ) r¼ Ú collectionsr Útypingr r r r r r r
|
r Údjangor rP Ú%django.db.backends.base.introspectionr r Ú BaseFieldInfor Údjango.db.modelsr Údjango.utils.datastructuresr Úmysql.connector.constantsr Úmysql.connector.django.baser Ú_fieldsr r r¸ r8 r7 ú<module>rÞ s ðñ> å "ß G× GÑ Gã å ,÷ñ õ
|
#Ý 2å /ñ å9ñ ØØ×ÑÐ KÑKó ð IÒ ÙØð óHñ Øð óHôzÐ 5õ zr8
|
