3
W­E^©G  ã               @   s€   d dl Z d dlmZ d dlZd dlmZmZmZ d dl	m
Z
 edejd ƒZe jdƒZdd	„ ZG d
d„ dƒZG dd„ deƒZdS )é    N)Ú
namedtuple)ÚBaseDatabaseIntrospectionÚ	FieldInfoÚ	TableInfo)ÚIndexr   Úpkz&^\s*(?:var)?char\s*\(\s*(\d+)\s*\)\s*$c             C   s    t j| ƒ}|rt|jdƒƒS dS )z8 Extract the size number from a "varchar(11)" type name é   N)Úfield_size_reÚsearchÚintÚgroup)ÚnameÚm© r   úJ/tmp/pip-build-78s3knkw/Django/django/db/backends/sqlite3/introspection.pyÚget_field_size   s    
r   c               @   s>   e Zd Zdddddddddddd	d
d
dddddœZdd„ ZdS )ÚFlexibleFieldLookupDictZBooleanFieldÚSmallIntegerFieldZPositiveSmallIntegerFieldÚIntegerFieldÚBigIntegerFieldZPositiveIntegerFieldZDecimalFieldZ
FloatFieldZ	TextFieldZ	CharFieldZBinaryFieldZ	DateFieldZDateTimeFieldZ	TimeField)ÚboolÚbooleanZsmallintzsmallint unsignedZsmallintegerr   ÚintegerZbigintzinteger unsignedÚdecimalÚrealÚtextÚcharZvarcharZblobÚdateÚdatetimeÚtimec             C   s"   |j ƒ jddƒd jƒ }| j| S )Nú(r   r   )ÚlowerÚsplitÚstripÚbase_data_types_reverse)ÚselfÚkeyr   r   r   Ú__getitem__2   s    z#FlexibleFieldLookupDict.__getitem__N)Ú__name__Ú
__module__Ú__qualname__r$   r'   r   r   r   r   r      s&   r   c                   sv   e Zd Zeƒ Z‡ fdd„Zdd„ Zdd„ Zf fdd„Zd	d
„ Z	dd„ Z
dd„ Zdd„ Zdd„ Zdd„ Zdd„ Z‡  ZS )ÚDatabaseIntrospectionc                s$   t ƒ j||ƒ}|jr |dkr dS |S )Nr   r   r   Z	AutoField>   r   r   r   )ÚsuperÚget_field_typer   )r%   Ú	data_typeÚdescriptionZ
field_type)Ú	__class__r   r   r-   :   s    z$DatabaseIntrospection.get_field_typec             C   s   |j dƒ dd„ |jƒ D ƒS )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 namec             S   s"   g | ]}t |d  |d d  ƒ‘qS )r   r   )r   )Ú.0Úrowr   r   r   ú
<listcomp>J   s    z8DatabaseIntrospection.get_table_list.<locals>.<listcomp>)ÚexecuteÚfetchall)r%   Úcursorr   r   r   Úget_table_listB   s    z$DatabaseIntrospection.get_table_listc             C   s*   |j d| jjj|ƒ ƒ dd„ |jƒ D ƒS )zi
        Return a description of the table with the DB-API cursor.description
        interface.
        zPRAGMA table_info(%s)c             S   s:   g | ]2\}}}}}}t ||d t|ƒd d | ||dkƒ	‘qS )Nr   )r   r   )r1   Zcidr   r.   ZnotnullÚdefaultr   r   r   r   r3   S   s   z?DatabaseIntrospection.get_table_description.<locals>.<listcomp>)r4   Ú
connectionÚopsÚ
quote_namer5   )r%   r6   Ú
table_namer   r   r   Úget_table_descriptionL   s    z+DatabaseIntrospection.get_table_descriptionc             C   s   | j ||ƒ}||dœgS )N)ÚtableÚcolumn)Úget_primary_key_column)r%   r6   r<   Ztable_fieldsZpk_colr   r   r   Úget_sequencesZ   s    z#DatabaseIntrospection.get_sequencesc             C   sŠ  i }|j d|gƒ |jƒ \}}|dkr*|S ||jdƒd |jdƒ… }�x<|jdƒD �],}|jƒ }|jdƒrnqTtjd|tj	ƒ}|s„qTd	d
„ |j
ƒ D ƒ\}	}
|jdƒrÈtjd|tj	ƒ}|j
ƒ d jdƒ}n|jƒ d jdƒ}|j d|	gƒ |jƒ d }|d jƒ }|jdƒ|jdƒ }}||d |… }xZ|jdƒD ]L}|jƒ }|jdƒ�rN�q2|jddƒd jdƒ}||
k�r2||	f||< P �q2W qTW |S )z—
        Return a dictionary of {field_name: (field_name_other_table, other_table)}
        representing all relationships to the given table.
        zUSELECT sql, type FROM sqlite_master WHERE tbl_name = %s AND type IN ('table', 'view')Úviewr    r   ú)ú,ÚUNIQUEz$references (\S*) ?\(["|]?(.*)["|]?\)c             S   s   g | ]}|j d ƒ‘qS )ú")r#   )r1   Úsr   r   r   r3   }   s    z7DatabaseIntrospection.get_relations.<locals>.<listcomp>zFOREIGN KEYzFOREIGN KEY\s*\(([^\)]*)\).*r   rF   z1SELECT sql FROM sqlite_master WHERE tbl_name = %sú )r4   ÚfetchoneÚindexÚrindexr"   r#   Ú
startswithÚrer
   ÚIÚgroupsÚmatchr5   )r%   r6   r<   Z	relationsÚ
create_sqlÚ
table_typeÚresultsÚ
field_descr   r>   r?   Ú
field_nameÚresultZother_table_resultsÚliÚriZ
other_descZ
other_namer   r   r   Úget_relations^   sD    


z#DatabaseIntrospection.get_relationsc             C   s¦   g }|j d|dgƒ |jƒ d jƒ }||jdƒd |jdƒ… }x`t|jdƒƒD ]N\}}|jƒ }|jdƒrlqPtj	d	|tj
ƒ}|s‚qP|jtd
d„ |jƒ D ƒƒƒ qPW |S )z‹
        Return a list of (column_name, referenced_table_name, referenced_column_name)
        for all key columns in given table.
        z?SELECT sql FROM sqlite_master WHERE tbl_name = %s AND type = %sr>   r   r    r   rC   rD   rE   z("(.*)".*references (.*) \(["|](.*)["|]\)c             s   s   | ]}|j d ƒV  qdS )rF   N)r#   )r1   rG   r   r   r   ú	<genexpr>±   s    z8DatabaseIntrospection.get_key_columns.<locals>.<genexpr>)r4   rI   r#   rJ   rK   Ú	enumerater"   rL   rM   r
   rN   ÚappendÚtuplerO   )r%   r6   r<   Zkey_columnsrS   Zfield_indexrT   r   r   r   r   Úget_key_columns˜   s    
 z%DatabaseIntrospection.get_key_columnsc       	      C   s¨   |j d|gƒ |jƒ }|dkr*td| ƒ‚|\}}|dkr>dS ||jdƒd |jdƒ… }xH|jdƒD ]:}|jƒ }tjd	|ƒ}|rf|j	dƒr–|j	dƒS |j	d
ƒS qfW dS )z>Return the column name of the primary key for the given table.zUSELECT sql, type FROM sqlite_master WHERE tbl_name = %s AND type IN ('table', 'view')NzTable %s does not existrB   r    r   rC   rD   z1(?:(?:["`\[])(.*)(?:["`\]])|(\w+)).*PRIMARY KEY.*é   )
r4   rI   Ú
ValueErrorrJ   rK   r"   r#   rM   rP   r   )	r%   r6   r<   r2   rQ   rR   Z
fields_sqlrT   r   r   r   r   r@   µ   s     "z,DatabaseIntrospection.get_primary_key_columnc       
      C   sh   i }|j d| jjj|ƒ ƒ xF|jƒ D ]:}|d d… \}}}}}	|gdd||	fdddœ|d| < q&W |S )NzPRAGMA foreign_key_list(%s)é   F)ÚcolumnsÚprimary_keyÚuniqueÚforeign_keyÚcheckrJ   zfk_%d)r4   r9   r:   r;   r5   )
r%   r6   r<   Úconstraintsr2   Zid_Ú_r>   Úfrom_Ztor   r   r   Ú_get_foreign_key_constraintsÌ   s    z2DatabaseIntrospection._get_foreign_key_constraintsc             C   sÄ  d }d }d }d }d}g }d}	g }
d}�xX|D �]N}|j tjjdƒrL|d7 }n>|j tjjdƒrp|d8 }|dk rŠP n|dkrŠ|j tjjdƒrŠP |d kr¨|j tjjdƒ}|r¨q,|�rz|d krô|jtjjtjjfkrÔ|j}n |jtjjj	j
krô|jdd… }|j tjjdƒ�rd	}|}nh|�rÞ||k�r*|r,d}q,|jtjjtjjfk�rP|j|jƒ n(|jtjjj	j
k�rÞ|j|jdd… ƒ nd|d k�rÆ|jtjjtjjfk�r¤|j}n"|jtjjj	j
k�rÆ|jdd… }|j tjjdƒ�rÞ|g}|j tjjd
ƒ�rúd	}	|}q,|	r,||k�r|
r,d}	q,|jtjjtjjfk�rD|j|k�r||
j|jƒ q,|jtjjj	j
kr,|jdd… |kr,|
j|jdd… ƒ q,W |�r˜d	|dd dddœnd }|
�r´d	|
ddd ddœnd }||||fS )NFr   r    r   rC   rD   Z
CONSTRAINTrE   TZCHECK)rd   rb   rc   re   rf   rJ   )rf   rb   rc   rd   re   rJ   éÿÿÿÿrk   rk   rk   rk   )rP   ÚsqlparseÚtokensÚPunctuationÚKeywordZttypeÚNameÚvalueÚLiteralÚStringZSymbolr\   )r%   rm   rb   ÚtokenZis_constraint_definitionrU   Úconstraint_namerd   Zunique_columnsrf   Zcheck_columnsZbraces_deepZunique_braces_deepZcheck_braces_deepZunique_constraintZcheck_constraintr   r   r   Ú&_parse_column_or_constraint_definitionÜ   s€    



z<DatabaseIntrospection._parse_column_or_constraint_definitionc             C   sÄ   t j|ƒd }i }d}dd„ |jƒ D ƒ}x|D ]}|jt jjdƒr.P q.W xv| j||ƒ\}}	}
}|	r„|rp|	||< n|d7 }|	|d| < |
rª|r–|
||< n|d7 }|
|d| < |jt jjdƒrJP qJW |S )Nr   c             s   s   | ]}|j s|V  qd S )N)Zis_whitespace)r1   rt   r   r   r   rZ   <  s    zADatabaseIntrospection._parse_table_constraints.<locals>.<genexpr>r    r   z__unnamed_constraint_%s__rC   )rl   ÚparseÚflattenrP   rm   rn   rv   )r%   Úsqlrb   Z	statementrg   Zunnamed_constrains_indexrm   rt   ru   rd   rf   Z	end_tokenr   r   r   Ú_parse_table_constraints6  s,    


z.DatabaseIntrospection._parse_table_constraintsc             C   sÚ  i }y&|j d| jjj|ƒf ƒjƒ d }W n tk
r>   Y n*X dd„ | j||ƒD ƒ}|j| j||ƒƒ |j d| jjj|ƒ ƒ �x|j	ƒ D �]}|dd… \}}}	|j d| jjj|ƒ ƒ |jƒ pÆd\}
|
sÐqŒ|j d	| jjj|ƒ ƒ xL|j	ƒ D ]@\}}}||k�r g d
t
|	ƒdd
ddœ||< || d j|ƒ qòW || d rŒ|| d  rŒtj|| d< |
jdƒd jdƒd jdƒ}dd„ |D ƒ}||| d< qŒW | j||ƒ}|�rÄ|gdd
dd
d
dœ|d< |j| j||ƒƒ |S )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=%sr   c             S   s   h | ]
}|j ’qS r   )r   )r1   Úinfor   r   r   ú	<setcomp>e  s    z8DatabaseIntrospection.get_constraints.<locals>.<setcomp>zPRAGMA index_list(%s)Né   z<SELECT sql FROM sqlite_master WHERE type='index' AND name=%szPRAGMA index_info(%s)FT)rb   rc   rd   re   rf   rJ   rb   rJ   rd   Útyper    r   rC   rD   c             S   s   g | ]}|j d ƒrd nd‘qS )ZDESCÚASC)Úendswith)r1   r{   r   r   r   r3   �  s    z9DatabaseIntrospection.get_constraints.<locals>.<listcomp>ÚordersZ__primary__)Nrk   )r4   r9   r:   r;   rI   Ú	TypeErrorr=   Úupdaterz   r5   r   r\   r   Úsuffixr"   r@   rj   )r%   r6   r<   rg   Ztable_schemarb   r2   ÚnumberrJ   rd   ry   Z
index_rankZcolumn_rankr?   Z
order_infor�   Z	pk_columnr   r   r   Úget_constraintsT  sX    

z%DatabaseIntrospection.get_constraints)r(   r)   r*   r   Zdata_types_reverser-   r7   r=   rA   rY   r^   r@   rj   rv   rz   r†   Ú__classcell__r   r   )r0   r   r+   7   s   
:Zr+   )r   )rM   Úcollectionsr   rl   Z%django.db.backends.base.introspectionr   r   ZBaseFieldInfor   Zdjango.db.models.indexesr   Ú_fieldsÚcompiler	   r   r   r+   r   r   r   r   Ú<module>   s   
	