1 | >>> from karrie.django.ogna.models import Project
|
---|
2 | >>> mz = Project.objects.get(name="Mainz")
|
---|
3 | >>> a_dist = Project.objects.distance(mz.center)
|
---|
4 | {'select_field': <django.contrib.gis.db.models.sql.conversion.DistanceField object at 0x34456d0>, 'procedure_fmt': '%(geo_col)s,%%s', 'setup': False, 'select_params': [<django.contrib.gis.db.backends.postgis.adapter.PostGISAdapter object at 0x3445750>], 'geo_field': <django.contrib.gis.db.models.fields.PointField: center>, 'procedure_args': {'function': 'ST_distance_sphere', 'geo_col': '"ogna_project"."center"', 'geom': <Point object at 0x311beb0>}, 'geom_args': ('geom',), 'geom_field': None, 'desc': None}
|
---|
5 | model_att: ST_distance_sphere("ogna_project"."center",%s)
|
---|
6 | select_params: [<django.contrib.gis.db.backends.postgis.adapter.PostGISAdapter object at 0x3445750>]
|
---|
7 | >>> a_dist[0].distance
|
---|
8 | Distance(m=84958.0635775)
|
---|
9 | >>> a_azimuth = Project.objects.azimuth(mz.center)
|
---|
10 | {'select_field': <django.contrib.gis.db.models.sql.conversion.GeomField object at 0x3445710>, 'procedure_fmt': '%(geo_col)s,%%s', 'select_params': [<django.contrib.gis.db.backends.postgis.adapter.PostGISAdapter object at 0x3465a10>], 'procedure_args': {'function': 'ST_Azimuth', 'geo_col': '"ogna_project"."center"', 'geom': <Point object at 0x311beb0>}, 'geom_args': ('geom',), 'desc': None, 'geom_field': None}
|
---|
11 | model_att: ST_Azimuth("ogna_project"."center",%s)
|
---|
12 | select_params: [<django.contrib.gis.db.backends.postgis.adapter.PostGISAdapter object at 0x3465a10>]
|
---|
13 | >>> a_azimuth[0].azimuth
|
---|
14 | Traceback (most recent call last):
|
---|
15 | File "<console>", line 1, in <module>
|
---|
16 | File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 189, in __getitem__
|
---|
17 | return list(qs)[0]
|
---|
18 | IndexError: list index out of range
|
---|
19 | >>>
|
---|