U
|
£ý°dWJ ã @ sÒ d Z ddlmZ ddlmZmZmZmZmZm Z m
|
Z
|
ddl Z ddl m Z ddlmZmZmZ ddlmZ ddlmZ dd lmZ erdd
|
lmZ ed ej d Zed k r´eddZ n
|
eddZ G dd deZ dS )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 & s¨ e Zd ZdZejdejdejdejdej dej
|
dej dej dej dejdejd ejd
|
ejd ejdejdejdejdejdejd
|
iZeeed fd d Zde e dddZ dee e dddZ dee e!e ee"f f dddZ#dee$e! dddZ%d)dee&e e eef dd d Z'dee ee(eef f dd d Z)dee e(eeef dd d!Z*deedd"d#Z+e&e,e e-d$d%d&Z.dee ee&f dd'd(Z/ Z0S )*ÚDatabaseIntrospectionz5Encapsulate backend-specific introspection utilities.Z TextFieldZ DecimalFieldZ DateFieldZ DateTimeFieldZ
|
FloatFieldÚ IntegerFieldÚBigIntegerFieldÚSmallIntegerFieldZ CharFieldZ TimeField)Ú data_typeÚ descriptionÚreturnc st t ||¡}d|jkr<|dkr$dS |dkr0dS |dkr<dS |jrf|dkrNdS |dkrZd S |dkrfd
|
S |jrpd S |S ) NÚauto_incrementr Z AutoFieldr Z BigAutoFieldr ZSmallAutoFieldZPositiveBigIntegerFieldZPositiveIntegerFieldZPositiveSmallIntegerFieldZ JSONField)ÚsuperÚget_field_typer r r )Úselfr r Z
|
field_type©Ú __class__© ú[d:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\mysql/connector/django/introspection.pyr" l s$
|
z$DatabaseIntrospection.get_field_typer )Úcursorr c C s | d¡ dd | ¡ D S )z>Return a list of table and view names in the current database.zSHOW FULL TABLESc S s* g | ]"}t |d ddd |d ¡qS )r ÚtÚv)z
|
BASE TABLEZVIEWé )r Úget)Ú.0Úrowr& r& r' Ú
|
<listcomp>
s ÿz8DatabaseIntrospection.get_table_list.<locals>.<listcomp>)ÚexecuteÚfetchall)r# r( r& r& r' Úget_table_list s
|
þz$DatabaseIntrospection.get_table_list)r( Ú
|
table_namer c C s i }| d|g¡ | ¡ }|r&|d nd}tdk rB| d|g¡ n| d||g¡ dd | ¡ D }| d | jj |¡ d
|
¡ ttt d d d }g }|j
|
D ]ò} || d }
|
tdk r | t | dd
||
|
j pØ| d ||
|
jpè| d ||
|
jpø| d | d |
|
j|
|
j|
|
j| d |kf ¡ q| t | dd
||
|
j pB| d ||
|
jpT| d ||
|
jpf| d | d |
|
j|
|
j|
|
j|
|
j| d |kf ¡ q|S )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()
|
c S s i | ]}|d t | qS )r )r )r- Úliner& r& r' Ú
|
<dictcomp>Å s z?DatabaseIntrospection.get_table_description.<locals>.<dictcomp>zSELECT * FROM z LIMIT 1)Úir c S s | d k rt | S | S ©N)Úint)r7 r& r& r' Úto_intË s z;DatabaseIntrospection.get_table_description.<locals>.to_intNr é é é )r0 ÚfetchoneÚDJANGO_VERSIONr1 Ú
|
connectionÚopsÚ
|
quote_namer r r9 r Úappendr Úmax_lenZnum_precZ num_scaleZcolumn_defaultr r Z collation) r# r( r3 Zjson_constraintsr. Zdefault_column_collationÚ
|
field_infor: Úfieldsr5 Úinfor& r& r' Úget_table_description sj ù ôðÿ
|
|
|
|
÷ÿ
|
|
öÿz+DatabaseIntrospection.get_table_descriptionc C s | d| jj |¡ ¡ t| ¡ }t }|D ] }|d dkr0| |d ¡ q0i }|D ]d}|d |krjqX|d |krddd||d < |d dkr¤d ||d d
|
< |d sXd ||d d < qX|S ) zReturn indexes from table.úSHOW INDEX FROM r r+ r r; F)Ú primary_keyÚuniqueZPRIMARYTrJ rK )r0 r@ rA rB Úlistr1 ÚsetÚadd)r# r( r3 ÚrowsZmulticol_indexesr. Zindexesr& r& r' Ú get_indexesð s" z!DatabaseIntrospection.get_indexesc C s2 | ||¡ ¡ D ] }|d d r|d S qdS )zP
|
Returns the name of the primary key column for the given table
|
r+ rJ r N)rP Úitems)r# r( r3 Úcolumnr& r& r' Úget_primary_key_column s z,DatabaseIntrospection.get_primary_key_columnr& )r( r3 Ú table_fieldsr c C s2 | ||¡D ] }d|jkr ||jdg S q g S )Nr )ÚtablerR )rH r Úname)r# r( r3 rT rE r& r& r' Ú get_sequences s
|
z#DatabaseIntrospection.get_sequencesc C s0 | ||¡}i }|D ]\}}}||f||< q|S )z
|
Return a dictionary of {field_name: (field_name_other_table, other_table)}
|
representing all relationships to the given table.
|
)Úget_key_columns)r# r( r3 Ú constraintsZ relationsZ my_fieldnameZ other_tableZ other_fieldr& r& r' Ú get_relations s
|
z#DatabaseIntrospection.get_relationsc C s$ g }| d|g¡ | | ¡ ¡ |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)r0 Úextendr1 )r# r( r3 Z key_columnsr& r& r' rX , s ø
|
z%DatabaseIntrospection.get_key_columnsc C s, | d|g¡ | ¡ }|s$| jjjS |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 )r0 r> r@ ÚfeaturesZ_mysql_storage_engine)r# r( r3 Úresultr& r& r' Úget_storage_engineA s þ
|
z(DatabaseIntrospection.get_storage_engine)Ú check_clauseÚcolumnsr c C s~ t }t |¡d }dd | ¡ D }|D ]N}|jtjjkr*| jj |j
|
¡|j
|
kr*|j
|
dd
|kr*| |j
|
dd
¡ q*|S )Nr c s s | ]}|j s|V qd S r8 )Z is_whitespace)r- Útokenr& r& r' Ú <genexpr>V s zBDatabaseIntrospection._parse_constraint_columns.<locals>.<genexpr>r+ éÿÿÿÿ) r ÚsqlparseÚparseÚflattenÚttypeÚtokensÚNamer@ rA rB ÚvaluerN )r# r_ r` Z check_columnsZ statementrh ra r& r& r' Ú_parse_constraint_columnsQ s ÿþýz/DatabaseIntrospection._parse_constraint_columnsc C s| i }d}| ||g¡ | ¡ D ]`\}}}}||krlt dddd|rJ||fndd||< | jjjrlg || d< || d |¡ q d} | | |g¡ | ¡ D ]F\}}
|
|
|
¡ dkrÈd || d
|
< d || d < q|
|
¡ d krd || d < q| jjjrtd } d d | ||¡D } d} | | |g¡ | ¡ D ]P\}} |
|
| | ¡}t ||hkrZ| d7 } d| d}|dddd dd||< q"| d| jj |¡ ¡ dd | ¡ D D ]¶\}}}}}}}||krêt ddddd||< | jjjrêg || d< d || d< |dkrtjn| ¡ || d< || d |¡ | jjjr || d |dkrNdnd ¡ q | ¡ D ]}t|d |d< q`|S ) 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` rJ rK ÚindexÚcheckÚ foreign_keyZordersr` 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 keyTrJ rK r c S s h | ]
|
}|j qS r& )rV )r- rG r& r& r' Ú <setcomp> s z8DatabaseIntrospection.get_constraints.<locals>.<setcomp>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+ Z__unnamed_constraint_Ú__rI c S s" g | ]}|d d
|d f qS )Nr= é
|
r& )r- Úxr& r& r' r/ ¶ s z9DatabaseIntrospection.get_constraints.<locals>.<listcomp>)r` rJ rK rm rn rl ZBTREEÚtypeÚDZDESCÚASC)r0 r1 r r@ r\ Z supports_index_column_orderingrN ÚlowerZ can_introspect_check_constraintsrH rk rM rA rB r ÚsuffixrC ÚvaluesrL )r# r( r3 rY Z
|
name_queryÚ
|
constraintrR Z ref_tableZ
|
ref_columnZ
|
type_queryÚkindZunnamed_constraints_indexr` r_ Zconstraint_columnsÚ_rl ÚorderÚtype_r& r& r' Úget_constraints` s ú
|
|
|
ÿ ÿ ú ÿ
|
û
|
ÿ
|
$ z%DatabaseIntrospection.get_constraints)r& )1Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r ZBLOBZDECIMALZ
|
NEWDECIMALZDATEZDATETIMEÚDOUBLEÚFLOATZINT24ÚLONGZLONGLONGÚSHORTÚSTRINGZTIMEÚ TIMESTAMPZTINYZ TINY_BLOBZ MEDIUM_BLOBZ LONG_BLOBZ
|
VAR_STRINGZdata_types_reverseÚstrr r" r r r2 rH r r9 ÚboolrP r rS r rW r rZ rX r^ r r rk r~ Ú __classcell__r& r& r$ r' r S s í þ g þ þ ÿ þ
|
þ þ þ
|
þr ) r Ú collectionsr Útypingr r r r r r r rd Zdjangor
|
r? Z%django.db.backends.base.introspectionr r Z BaseFieldInfor Zdjango.db.modelsr Zdjango.utils.datastructuresr Zmysql.connector.constantsr Zmysql.connector.django.baser Ú_fieldsr r r& r& r& r' Ú<module> s0 $ þþþ
|
