If something still fails, can you place post the result of print db(...)
_select(...)
On Saturday, 5 January 2013 18:45:26 UTC-6, Massimo Di Pierro wrote:
>
> I made some changes in trunk. Can you please try again?
>
> On Saturday, 5 January 2013 07:05:48 UTC-6, Paolo valleri wrote:
>>
>> Hi, I made a few more tests:
>> from gluon.dal import geoPoint, geoLine, geoPolygon
>> db.define_table('test_geo',
>> Field('loc_test','geometry()'))
>> db.test_geo.insert(loc_test=geoPoint(45.89096,11.0401399))
>> db.test_geo.insert(loc_test=geoPolygon((0,0),(150,0),(150,150),(0,150),(0
>> ,0)))
>>
>> query = db.test_geo.loc_test.st_contains(geoPoint(1,1))
>> print db(query).select(db.test_geo.id, db.test_geo.loc_test)
>>
>> dist = db.test_geo.loc_test.st_distance(geoPoint(45.0,11.0)).with_alias(
>> 'dist')
>> print db(db.test_geo.id>0).select(db.test_geo.id, dist)
>>
>> dist = db.test_geo.loc_test.st_distance(geoPoint(45.0,11.0))
>> print db(db.test_geo.id>0).select(db.test_geo.id, dist)
>> The results are the following:
>>
>> The first query worked
>>
>> The second query failed with the following error:
>> Traceback (most recent call last):
>>
>> File "/home/paolo/Dropbox/git/web2py/gluon/restricted.py", line 212, in
>> restricted
>> exec ccode in environment
>> File "/home/paolo/Dropbox/git/web2py/applications/bikend/models/db.py"
>> <http://127.0.0.1:8000/admin/default/edit/bikend/models/db.py>, line 589, in
>> <module>
>> print db(db.test_geo.id>0).select(db.test_geo.id, dist)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 8975, in select
>> return adapter.select(self.query,fields,attributes)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1636, in select
>> return self._select_aux(sql,fields,attributes)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1601, in
>> _select_aux
>> self.execute(sql)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1714, in execute
>> return self.log_execute(*a, **b)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1708, in
>> log_execute
>> ret = self.cursor.execute(*a, **b)
>> ProgrammingError: syntax error at or near "AS"
>> LINE 1: ...GeomFromText('POINT (45.000000 11.000000)',4326)) AS dist) F...
>>
>>
>> The third one failed with the following error:
>>
>> Traceback (most recent call last):
>> File "/home/paolo/Dropbox/git/web2py/gluon/restricted.py", line 212, in
>> restricted
>> exec ccode in environment
>> File "/home/paolo/Dropbox/git/web2py/applications/bikend/models/db.py"
>> <http://127.0.0.1:8000/admin/default/edit/bikend/models/db.py>, line 586, in
>> <module>
>> print db(db.test_geo.id>0).select(db.test_geo.id, dist)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 8975, in select
>> return adapter.select(self.query,fields,attributes)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1636, in select
>> return self._select_aux(sql,fields,attributes)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1601, in
>> _select_aux
>> self.execute(sql)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1714, in execute
>> return self.log_execute(*a, **b)
>> File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1708, in
>> log_execute
>> ret = self.cursor.execute(*a, **b)
>> ProgrammingError: function st_astext(double precision) does not exist
>> LINE 1: SELECT test_geo.id, ST_AsText(ST_Distance(test_geo<span
>> style="color: #660;"...
>> Show original
>> <https://groups.google.com/group/web2py/msg/6ff54d463de23269?dmode=source&output=gplain&noredirect>
>>
>>
--
