|
Server : Apache System : Linux cvar2.toservers.com 3.10.0-962.3.2.lve1.5.73.el7.x86_64 #1 SMP Wed Aug 24 21:31:23 UTC 2022 x86_64 User : njnconst ( 1116) PHP Version : 8.4.18 Disable Function : NONE Directory : /usr/lib64/python2.7/site-packages/django/contrib/gis/tests/relatedapp/ |
Upload File : |
�
r�\c @@ s. d d l m Z d d l m Z d d l m Z m Z m Z m Z m Z m
Z
d d l m Z d d l
m Z e r� d d l m Z m Z m Z m Z m Z d d l m Z d d l m Z m Z m Z d d
l m Z m Z m Z m Z m Z m Z m! Z! n e e o e d � d e f d
� � Y� Z" d S( i ( t absolute_import( t HAS_GEOS( t HAS_SPATIAL_DBt mysqlt oraclet no_mysqlt no_oraclet
no_spatialite( t TestCase( t
skipUnless( t Collectt Countt Extentt Ft Union( t Geometry( t GEOSGeometryt Pointt
MultiPointi ( t Cityt Locationt DirectoryEntryt Parcelt Bookt Authort Articles! Geos and spatial db are required.t RelatedGeoModelTestc B@ s� e Z d � Z e d � � Z e e d � � � Z e d � � Z d � Z d � Z d � Z
d � Z d � Z e
d � � Z d
� Z e
d � � Z d � Z e
d
� � Z e
d � � Z e e
e d � � � � Z d � Z d � Z RS( c C@ s� t j j � } t j j � } t j j d � } d d d f } x� | | | f D]} } xt t | | � D]c \ } } | \ } } }
} | j | | j � | j | | j � | j t |
| � | j j
� qe WqO Wd S( s: Testing `select_related` on geographic models (see #7126).t locationt Aurorat TXgƆn�aX�g���tw�@@t Roswellt NMg9�d��!Z�gW%�}��@@t Kecksburgt PAg�u�|�S�g��67�D@N( R R gƆn�aX�g���tw�@@( R R g9�d��!Z�gW%�}��@@( R R! g�u�|�S�g��67�D@( R t objectst allt select_relatedt zipt assertEqualt namet stateR R t point( t selft qs1t qs2t qs3t citiest qst reft ct nmt stt lont lat( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test02_select_related s c @ s� d � � � f d � } d d d f } xa | D]Y \ } } } t t j j d | � j | d
d �� } | t | | � | d j j � q. Wd S( sH Testing the `transform` GeoQuerySet method on related geographic models.i c @ sL � j | j | j � � � j | j | j � � � j | j | j � d S( N( t assertAlmostEqualt xt yR& t srid( R0 t pnt( R* t tol( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt check_pnt. s R i� s( POINT(1490553.98959621 314792.131023984)R i� s( POINT(481902.189077221 868477.766629735)R i� s' POINT(2269923.2484839 7069381.28722222)R' t
field_namet location__pointN( s Kecksburgi� s( POINT(1490553.98959621 314792.131023984)( s Roswelli� s( POINT(481902.189077221 868477.766629735)( s Aurorai� s' POINT(2269923.2484839 7069381.28722222)( t listR R" t filtert transformR R R) ( R* R= t transformedR' R: t wktR/ ( ( R* R< sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test03_transform_related' s *c C@ s� t j j t d � � } d
} d } t j j d d � } t j j d d � j d d � } | d
} d } xb | | f | | f | | f g D]? \ } } x0 t | | � D] \ }
} | j |
| | � q� Wq� Wd S( sI Testing the `extent` GeoQuerySet aggregates on related geographic models.R? g9�d��!Z�g�|zl�=@g�u�|�S�g��67�D@gƆn�aX�R> R( R t location__point__extenti N( g9�d��!Z�g�|zl�=@g�u�|�S�g��67�D@( gƆn�aX�g�|zl�=@g�u�|�S�g��67�D@( R R" t aggregateR t extentt excludeR% R7 ( R* t aggst
all_extentt txpa_extentt e1t e2t e3R< R0 t et ref_valt e_val( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test04a_related_extent_aggregate? s !
. c C@ sF t j j t d � � } t d d � } t d d � } t d d � } t d d � } t d
d � } t r� t | | | | | d d
�} t | | d d
�} n3 t | | | | | d d
�} t | | d d
�} t j j d d � } t j j d d � j d d � }
| d } | j | | � | j | |
� | j | | � d S( sK Testing the `unionagg` GeoQuerySet aggregates on related geographic models.R? g9�d��!Z�gW%�}��@@gƆn�aX�g���tw�@@g�u�|�S�g��67�D@gIG9�M3X�g�M�qd@@g� ��=�W�g�|zl�=@R: i� R> t name__inR t Houstont Dallass
Fort Wortht location__point__unionN( s RoswellRU RV s
Fort Worth(
R R" RG R R R R t unionaggRI R& ( R* RJ t p1t p2t p3t p4t p5t ref_u1t ref_u2t u1t u2t u3( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test04b_related_union_aggregateS s" !
c C@ s t t j j � j � � } d S( s` Testing that calling select_related on a query over a model with an FK to a model subclass worksN( R@ R R" R# R$ ( R* t l( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt$ test05_select_related_fk_to_subclassv s c
C@ s t d d d �} t j j d d � } | j j } | j d d t �} | j d � } t j j
d d d
| d | d | d
| d | � } | j } | j d d t �} t j j
d d d
| d | d | d
| d | � } t j j d t
d
� � } | j d t | � � | j d | d j � t stt j j d t
d
� � } | j d t | � � | j d | d j � n t j j d t
d � � } | j d t | � � | j d | d j � t s
t j j d t
d � � } | j d t | � � | j d | d j � n d S( s* Testing F() expressions on GeometryFields.ss POLYGON((-97.501205 33.052520,-97.501205 33.052576,-97.501150 33.052576,-97.501150 33.052520,-97.501205 33.052520))R: i� R' R i� t cloneid t P1t cityt center1t center2t border1t border2t P2t center1__withini i t center2__withint city__location__pointt border2__containsN( R R R" t getR R) RB t Truet bufferR t createt centroidRA R
R& t lenR' R ( R* t b1t pcityt c1t c2t b2RY RZ R/ ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test06_f_expressions{ s. 3 3c C@ s� t j j � } t j j � } t j j � } x� t | | | � D]q \ } } } | j t | d t � � | j t | d t � � | j | j
| d � | j | j
| d � q@ Wd S( s4 Testing values() and values_list() and GeoQuerySets.R) i N( R R" R# t valuest values_listR% t
assertTruet
isinstanceR R& R) ( R* t gqst gvqst gvlqst mt dt t( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt
test07_values� s "c C@ s[ t j j � } t j j d � } x3 t | | � D]" \ } } | j | j | j � q1 Wd S( s0 Testing defer() and only() on Geographic models.R) N( R R" R# t deferR% R& R) ( R* R/ t def_qst loct def_loc( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test08_defer_only� s c C@ s| d } d
} t j j d � j d d � } xK t | | | � D]7 \ } } } | j | d | � | j | d | � q= Wd S( sM Ensuring correct primary key column is selected across relations. See #10757.i i i i i t idt location__idN( i i i i i ( i i i i i ( R R" t order_byR~ R% R& ( R* t city_idst loc_idst ids_qst val_dictt c_idt l_id( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test09_pk_relations� s "c C@ s� t j j d d � j j j d � } t j j d d � j j j d � } t j j d | � } t j j d | � } | | B} g | D] } | j ^ q� } | j d t | � � | j
d | k � | j
d | k � d S( s9 Testing the combination of two GeoQuerySets. See #10807.R' R g�������?R t location__point__withini N( R R" Rr R R) Rt RA R' R& Rw R� ( R* t buf1t buf2R+ R, t combinedR1 t names( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test10_combine� s $$
c C@ sc d d l } d d l m } t j j � } | j | j � } | j | � } | j | | j
� d S( s? Ensuring GeoQuery objects are unpickled correctly. See #10839.i N( t GeoQuery( t picklet django.contrib.gis.db.models.sqlR� R R" R# t dumpst queryt loadsR& t __class__( R* R� R� R/ t q_strt q( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test11_geoquery_pickle� s c C@ sY t j j d d � } t j j d t d � � j d | j j � } | j d | j � d S( sB Testing `Count` aggregate use with the `GeoManager` on geo-fields.R' RV t
num_citiesRh R� i N(
R R" Rr R t annotateR R R� R& R� ( R* t dallasR� ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt
test12a_count� s -c C@ s� t j j d t d � � j d d � } t j j d � j d t d � � j d d � } | j d t | � � | j d | d j � | j d t | � � | j d | d d � d S( sR Testing `Count` aggregate use with the `GeoManager` on non geo-fields. See #11087.t num_bookst bookst
num_books__gti R' i i N( R R" R� R RA R~ R& Rw R� ( R* R/ t vqs( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt
test12b_count� s '0c C@ s� t j j d d � j d t d � � j d d d � } | j d t | � � | j d | d d � | j t | d d t
� � d S(
s8 Testing `Count` aggregate with `.values()`. See #15305.R� i R� Rh R) i i i N( R R" RA R� R R~ R& Rw R� R� R ( R* R/ ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt
test13c_count s 6c C@ sJ t j j d d � } t j j d � j d d � } | j d | j � d S( sO Testing `select_related` on a nullable ForeignKey via `GeoManager`. See #11381.t titles Without Authort authorN( R R" Ru R$ Rr R& t NoneR� ( R* t no_authort b( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test13_select_related_null_fk s c C@ s� t d � } t j j d d � j d d � } t j j d d � j t d � � d } x: | | f D], } | j d t | � � | j | | � qb Wd S( sA Testing the `collect` GeoQuerySet method and `Collect` aggregate.s_ MULTIPOINT(-97.516111 33.058333,-96.801611 32.782057,-95.363151 29.763374,-96.801611 32.782057)R( R R> R? t location__point__collecti N( R R R" RA t collectRG R
R& Rw ( R* t ref_geomRz R{ t coll( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test14_collect s !(c C@ s% t j j d � } t | j � } d S( sT Testing doing select_related on the related name manager of a unique FK. See #13934.t author__articleN( R R" R$ t strR� ( R* R/ t sql( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test15_invalid_select_related( s c C@ sg g t t j j d t d � � j d d � � D] } | j ^ q. } | j � | j d d g | � d S( sM Ensure annotated date querysets work if spatial backend is used. See #14648.R� R� t dobt yeari� i� N( R@ R R" R� R t datesR� t sortR& ( R* t dtt birth_years( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt test16_annotated_date_queryset0 s @
( t __name__t
__module__R6 R RE R RS Rc Re R} R� R� R� R R� R� R� R� R� R� R� R� R� ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyR s* # 0
N(# t
__future__R t django.contrib.gis.geosR t django.contrib.gis.tests.utilsR R R R R R t django.testR t django.utils.unittestR t django.contrib.gis.db.modelsR
R R R
R t# django.contrib.gis.geometry.backendR R R R t modelsR R R R R R R R ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/tests/relatedapp/tests.pyt <module> s .( 7