gD d dl mZ d dlZd dlmZ d dlmZ d dlmZ d dlm Z d dl
m Z d dl m
Z
ed ej d
z Z e
d Zd Z G d
d Z G d de Zy) )
namedtupleN)
DatabaseError)BaseDatabaseIntrospection) FieldInfo) TableInfo)Index)_lazy_re_compiler )pkhas_json_constraintz&^\s*(?:var)?char\s*\(\s*(\d+)\s*\)\s*$c P t j | }|rt |d S dS )z6Extract the size number from a "varchar(11)" type name N)
field_size_researchint)namems /var/www/python.vincentserveurtest.ovh/public_html/venv/lib/python3.12/site-packages/django/db/backends/sqlite3/introspection.pyget_field_sizer s' T"A3qt9#t# c e Zd Zi ddddddddddd d
d d
d d
dddddddddddddddd d d d d d!Zd" Zy#)$FlexibleFieldLookupDictbool BooleanFieldbooleansmallintSmallIntegerFieldzsmallint unsignedPositiveSmallIntegerField smallintegerr IntegerFieldintegerbigintBigIntegerFieldzinteger unsignedPositiveIntegerFieldzbigint unsignedPositiveBigIntegerFielddecimal DecimalFieldreal
FloatFieldtext TextFieldchar CharFieldvarcharblob BinaryFielddate DateField
DateTimeField TimeField)datetimetimec |j j dd d j }| j | S )N(r
r )lowersplitstripbase_data_types_reverse)selfkeys r __getitem__z#FlexibleFieldLookupDict.__getitem__6 s9 iik Q'*002++C00r N)__name__
__module__ __qualname__r; r> r r r r s > ' 8
+ ~
> # 2 4 > ;
! " # $ $' ,1r r c j e Zd Z e Z fdZd Zd Zd dZd Z d Z
d Z d Z d Z
d
Zd Z xZS )
DatabaseIntrospectionc d t | || }|j r|dv ry|j ry|S )N> r r" r AutoField JSONField)superget_field_typer
r )r< data_type description
field_type __class__s r rI z$DatabaseIntrospection.get_field_type> s> W+I{C
>>j -
* * r c |j d |j D cg c] }t |d |d d c}S c c}w )z>Return a list of table and view names in the current database.z
SELECT name, type FROM sqlite_master
WHERE type in ('table', 'view') AND NOT name='sqlite_sequence'
ORDER BY namer r
)executefetchallr )r< cursorrows r get_table_listz$DatabaseIntrospection.get_table_listL sK
9?8IJ8I #a&#a&),8IJJJs Ac |j d| j j j | z |j }|st d| d | j
|| }t }| j j j rG|D ]B }|d }d|z }|j d||g j } | s2|j | D |D
cg c]A \ }
} } }
}}}|dv r3t | | t | ddd|
||j | |dk( | |v C c}}}}
} } }
S c c}}}}
} } }
w ) zi
Return a description of the table with the DB-API cursor.description
interface.
zPRAGMA table_xinfo(%s)zTable z does not exist (empty pragma).r
z%%json_valid("%s")%%z
SELECT sql
FROM sqlite_master
WHERE
type = 'table' AND
name = %s AND
sql LIKE %s
)r N)rO
connectionops
quote_namerP r _get_column_collationssetfeaturescan_introspect_json_fieldfetchoneaddr r get)r< rQ
table_name
table_info
collations json_columnslinecolumnjson_constraint_sqlr cidr rJ notnulldefaultr
hiddens r get_table_descriptionz+DatabaseIntrospection.get_table_descriptionX sp
$t':':'E'Ej'Q Q
__&
& 4S TU U00D
u ?? # # = =" a&: : #
s
A%
c |j d| j j j | z |j D cg c] ^}}}}|s | c}}}S c c}}}w )NzPRAGMA table_info(%s)rt )r< rQ ra ru r r
s r get_primary_key_columnsz-DatabaseIntrospection.get_primary_key_columns sX #doo&9&9&D&DZ&P P
-3OO,=D,= D1b,=DDDs A"A"c d }d }d }d }d}g }d} g }
d} |D ]< }|j t j j d r| dz
} ni|j t j j d r
| dz } | dk r5 n| dk( r-|j t j j d r n|-|j t j j d }|r|r||j
t j j t j j fv r
|j }nJ|j
t j j j j k( r|j dd }|j t j j d rd
}| } n|r | k( r|rd}|j
t j j t j j fv r |j |j n |j
t j j j j k( r|j |j dd n||j
t j j t j j fv r
|j }nJ|j
t j j j j k( r|j dd }|j t j j d r|g}|j t j j d rd
} | }
S| sW
| k( r|
rd} b|j
t j j t j j fv r-|j |v s|
j |j |j
t j j j j k( s |j dd |v s |
j |j dd ? |r d
|dd ddd nd }|
r d
|
ddd dd
nd }||||fS )NFr r7 r
),
CONSTRAINTUNIQUETCHECK)uniquecolumns primary_key foreign_keycheckindex)r r r r r r ) matchsqlparsetokens PunctuationKeywordttypeNamevalueLiteralStringSymbolappend)r< r r tokenis_constraint_definition
field_nameconstraint_namer unique_columnsr
check_columns braces_deepunique_braces_deepcheck_braces_deepunique_constraintcheck_constraints r &_parse_column_or_constraint_definitionzq ? !ekk(//2M2Ms&S'/+0;; OO++\,( , '"* {{x';';X__=T=T&UU*/++ (?(?(F(F(M(MM*/++a*;;;x 6 6A !F)4&)[8)%*F {{x';';X__=T=T&UU&--ekk: (?(?(F(F(M(MM&--ekk!B.?@ % {{x';';X__=T=T&UU%*[[
(?(?(F(F(M(MM%*[[2%6
;;x 6 6A&0\N{{8??22G< $/!$ 3$ % ;;8??#7#7 9P9P"QQ {{g-%,,U[[9[[HOO$;$;$B$B$I$II {{1R(G3%,,U[[2->? R ) $ #
* ( $ #
13CUJJr c t j | d }i }d}d |j D }|D ]. }|j t j j
d s. n | j
|| \ }} }
} | r|r| ||< n
|dz
}| |d|z < |
r|r|
||< n
|dz
}|
|d|z < | j t j j
d r |S s)Nr c 3 : K | ] }|j r| y wN)
is_whitespace).0r s r zADatabaseIntrospection._parse_table_constraints.. s T%8E@S@S%%8s r7 r
z__unnamed_constraint_%s__r} )r parseflattenr r r r ) r< sqlr statement constraintsunnamed_constrains_indexr r r r r end_tokens r _parse_table_constraintsz.DatabaseIntrospection._parse_table_constraints s NN3'* #$ TY%6%6%8TE{{8??66< ;;FGL
"39K0,1, 36NN "38K0,1, 36NN x : :C@3 r c : i } |j d| j j j | j d }| j || D ch c] }|j }}|j | j || |j d| j j j | z |j D ] }|dd \ }} }
|j d| j j j | z |j xs d\ } | s]|j d| j j j | z |j D ]6 \ } }
}| |vrg d t |
dd d
d || < || d j | 8 || d
st j || d< | j | }|||| d< | j! || }|r |d
d dd d d |d< t# | j% || j' }|j |D ci c] \ } \ }\ }}d| |gd d ||fd d d c}}}} |S c c}w # t $ r Y w xY wc c}}}} w )zu
Retrieve any constraints or keys (unique, pk, fk, check, index) across
one or more columns.
z:SELECT sql FROM sqlite_master WHERE type='table' and name=r zPRAGMA index_list(%s)NrV z