[web2py] Re: Fetching rows with st_asgeojson()
Thanks Massimo.
It works but the main problem still the same. I cannot call field
properties (I don't know if it's the right term).
For example in the loop if I call for a datetime:
for event in events:
item = {
"type": "Feature",
"properties": {
"description": "Event date: " + str(event[db.events.
event_datetime]),
},
"geometry": loads_json(event[db.events.geometry.
st_asgeojson()])
}
Description is: Event date: 2017-01-10 09:00:00
If I would like to extract the day from the datetime, ticket is :
for event in events:
item = {
"type": "Feature",
"properties": {
"description": "Event date: " + str(event[db.events.
event_datetime.day]),
},
"geometry": loads_json(event[db.events.geometry.
st_asgeojson()])
}
Perhaps it's due to the fact that I ask to the DAL a field value calling it
by db.table.field, and db.events.event_datetime.day is not a field.
But how can I do it?
Calling event.event_datetime.day don't works anymore. Ticket is .
Thanks.
Il giorno lunedì 19 settembre 2016 05:05:22 UTC+2, Massimo Di Pierro ha
scritto:
>
> How about this?
>
> features = []
> for event in events:
> link = A(event[db.events.title], _href=URL('default', 'event_page',
> vars=dict(event_id=event[db.events.id]))).xml()
> item = {
> "type": "Feature",
> "popupContent": link,
> "track_quotation": str(event[db.events.track_quotation]),
> "geometry": loads_json(event[db.events.geometry.st_asgeojson()])
> }
> features.append(item)
>
>
>
>
>
> On Saturday, 17 September 2016 12:57:29 UTC-5, Gael Princivalle wrote:
>>
>> Someone have an idea?
>>
>> Here is the code that works:
>> features= [{"type": "Feature",
>> "properties": {
>> "popupContent": "> 'event_page', vars=dict(event_id=event[db.events.id])) + "'>" +
>> event[db.events.title] + "",
>> "track_quotation":
>> str(event[db.events.track_quotation])
>> },
>> "geometry":
>> loads_json(event[db.events.geometry.st_asgeojson()])} for event in events]
>>
>> But I would like to traduce it in a loop like that:
>> for event in events:
>> ...
>>
>> Il giorno martedì 13 settembre 2016 15:36:32 UTC+2, Gael Princivalle ha
>> scritto:
>>>
>>> Hello.
>>>
>>> Can someone explain me why when I use this set of rows:
>>> events= db(db.events.id>0).select(db.events.id, db.events.title,
>>> db.events.geometry.st_asgeojson())
>>> I can't call my rows with event.title but with event[db.events.title] ?
>>>
>>> It's a problem because if I would like to call for a reference field
>>> like event[db.events.category.category_name] ticket is wrong attribute.
>>>
>>> Thanks.
>>>
>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Fetching rows with st_asgeojson()
How about this?
features = []
for event in events:
link = A(event[db.events.title], _href=URL('default', 'event_page',
vars=dict(event_id=event[db.events.id]))).xml()
item = {
"type": "Feature",
"popupContent": link,
"track_quotation": str(event[db.events.track_quotation]),
"geometry": loads_json(event[db.events.geometry.st_asgeojson()])
}
features.append(item)
On Saturday, 17 September 2016 12:57:29 UTC-5, Gael Princivalle wrote:
>
> Someone have an idea?
>
> Here is the code that works:
> features= [{"type": "Feature",
> "properties": {
> "popupContent": " 'event_page', vars=dict(event_id=event[db.events.id])) + "'>" +
> event[db.events.title] + "",
> "track_quotation":
> str(event[db.events.track_quotation])
> },
> "geometry":
> loads_json(event[db.events.geometry.st_asgeojson()])} for event in events]
>
> But I would like to traduce it in a loop like that:
> for event in events:
> ...
>
> Il giorno martedì 13 settembre 2016 15:36:32 UTC+2, Gael Princivalle ha
> scritto:
>>
>> Hello.
>>
>> Can someone explain me why when I use this set of rows:
>> events= db(db.events.id>0).select(db.events.id, db.events.title,
>> db.events.geometry.st_asgeojson())
>> I can't call my rows with event.title but with event[db.events.title] ?
>>
>> It's a problem because if I would like to call for a reference field like
>> event[db.events.category.category_name] ticket is wrong attribute.
>>
>> Thanks.
>>
>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Fetching rows with st_asgeojson()
Someone have an idea?
Here is the code that works:
features= [{"type": "Feature",
"properties": {
"popupContent": "" +
event[db.events.title] + "",
"track_quotation": str(event[db.events.track_quotation])
},
"geometry":
loads_json(event[db.events.geometry.st_asgeojson()])} for event in events]
But I would like to traduce it in a loop like that:
for event in events:
...
Il giorno martedì 13 settembre 2016 15:36:32 UTC+2, Gael Princivalle ha
scritto:
>
> Hello.
>
> Can someone explain me why when I use this set of rows:
> events= db(db.events.id>0).select(db.events.id, db.events.title,
> db.events.geometry.st_asgeojson())
> I can't call my rows with event.title but with event[db.events.title] ?
>
> It's a problem because if I would like to call for a reference field like
> event[db.events.category.category_name] ticket is wrong attribute.
>
> Thanks.
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
