Hi Anthony,
My code is the following:
# -*- coding: utf-8 -*-
from gluon.serializers import json
@auth.requires(lambda: AuthHelper.valid_token(), requires_login=False)
@request.restful()
def search():
session.forget()
def post(*args, **vars):
response.headers["Content-Type"] = "application/json"
retval, error = RequestHelper.parse(request)
if error is not None:
return json(error)
encoded_zip = int(StringHelper.encode_postcode(retval["zip_code"]))
house_number = int(retval["house_number"])
return json(dict(result=db((db.addresses.encoded_zip_code ==
encoded_zip) & (db.addresses.house_number == house_number)).select(
db.addresses.street.with_alias('straat'),
db.addresses.city.with_alias('plaats),
distinct=True).as_list()))
return dict(GET=post, POST=post)
2016-07-21 17:12 GMT+02:00 Anthony <abasta...@gmail.com>:
> Please show your code.
>
> On Wednesday, July 20, 2016 at 3:55:19 PM UTC-4, Eric wrote:
>>
>> Hi Anthony,
>>
>> I'm not including them. I'm only using with_alias() and the select in
>> combination with as_list(). I would not expect to get the _extra as a
>> little bonus when you use with_alias()...
>>
>> That's why I'm asking :)
>>
>> Greetings,
>>
>> Eric
>>
>>
>> 2016-07-20 20:56 GMT+02:00 Anthony <abasta...@gmail.com>:
>>
>>> The "_extra" dictionary stores values generated from expressions (rather
>>> than raw values from individual fields). If you don't want them to appear
>>> in the conversion of the Rows to a list of dictionaries, then don't include
>>> them in the original .select() call that generated the Rows object.
>>>
>>> Anthony
>>>
>>> On Wednesday, July 20, 2016 at 10:00:57 AM UTC-4, Eric wrote:
>>>>
>>>> Hi There,
>>>>
>>>> Is there a way in Web2Py to suppress the _extra information when
>>>> selecting data with as_list() or as_dict()?
>>>>
>>>> I can't find it and option for it, but maybe I'm just overlooking it in
>>>> the documentation ;)
>>>>
>>>> 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 a topic in the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/web2py/d3YmI1e3iaQ/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> web2py+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/d3YmI1e3iaQ/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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.
