Hi Massimo, I've tried the same 3 tests.
The first one failed, it was working before though, the ticket:
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(query)._select(db.test_geo.id, db.test_geo.loc_test)
File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 8928, in _select
return adapter._select(self.query,fields,attributes)
File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1478, in _select
sql_f = ', '.join(map(geoexpand, fields))
File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1477, in geoexpand
return self.expand(field)
File "/home/paolo/Dropbox/git/web2py/gluon/dal.py", line 1312, in expand
return op(first, second)
TypeError: ST_ASTEXT() takes exactly 2 arguments (3 given)
The other two test worked, but than the application failed raising the same
ticket as the first test.
Hope it helps,
Paolo
On Sunday, January 6, 2013 1:46:00 AM UTC+1, Massimo Di Pierro wrote:
>
> 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>
>>>
>>>
--
