Re: [web2py] Re: Show "count()" result in view
Thanks guys. That's exactly what I needed.
Sorry I was not able to fint it myself...
Regards, Jon.
On Sat, Dec 29, 2018 at 4:19 AM Anthony wrote:
> See
> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Grouping-and-counting
> .
>
> On Friday, December 28, 2018 at 6:46:25 AM UTC-5, Jonsubs wrote:
>>
>> Hi all,
>> I'd like to know how to access the ".count()" result of a query from a
>> view.
>>
>> I have the following query in the controller:
>>
>> rows =
>> db(db.probdata).select(db.probdata.game,db.probdata.game.count(),groupby=db.probdata.game)
>>
>> And would like to show both the 'game' field and the number of entries
>> for each game. I tried the code below, but it crashes:
>>
>>
>> {{for r in rows:}}
>>
>> {{=A(r.probdata.game,_href=URL('list_problems_by_game',args=r.probdata.game))}}
>> {{=r.probdata.game.count()}}
>> {{pass}}
>>
>>
>> How should I access the result of the ".count()" part of the query from
>> the view?
>> Thanks, Jon.
>>
> --
> 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.
>
--
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: Show "count()" result in view
See
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Grouping-and-counting.
On Friday, December 28, 2018 at 6:46:25 AM UTC-5, Jonsubs wrote:
>
> Hi all,
> I'd like to know how to access the ".count()" result of a query from a
> view.
>
> I have the following query in the controller:
>
> rows =
> db(db.probdata).select(db.probdata.game,db.probdata.game.count(),groupby=db.probdata.game)
>
> And would like to show both the 'game' field and the number of entries for
> each game. I tried the code below, but it crashes:
>
>
> {{for r in rows:}}
>
> {{=A(r.probdata.game,_href=URL('list_problems_by_game',args=r.probdata.game))}}
>
> {{=r.probdata.game.count()}}
> {{pass}}
>
>
> How should I access the result of the ".count()" part of the query from
> the view?
> Thanks, Jon.
>
--
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.
Re: [web2py] Re: Show "count()" result in view
pardon, not sure got what you want to achieve think if you want to count the rows data, should it better to count the data first (using compute in table constructor or count it manually before insert to the table) before put it on table? or do the count calculation manually on the fly (on the view side, just extract the data n count it manually) *ref:* http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Table-constructor http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#callbacks-on-record-insert-delete-and-update best regards, stifan -- 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.
Re: [web2py] Re: Show "count()" result in view
Thanks Stifan,
I see how can I do that for the whole query.
How can I do this row-wise? Can I create a "count_db" variable per row? As
I'm grouping by game and counting how many entries I have per game (after
grouping them), I would like to show the count per row.
The closest I got so far is by printing the whole row using:
{{=r}}
{{=A(r.probdata.game,_href=URL('list_problems_by_game',args=r.probdata.game))}}
And getting the result below:
- 338841246
- 338978835
- 338995915
But I just want the {'COUNT("probdata"."game")': 1L} part of the row.
Which for the lines above it would be something like this:
- Game 338841246
1
- Game 338978835
2
- Game 338995915
2
Thanks & regards, Jon.
On Fri, Dec 28, 2018 at 1:52 PM 黄祥 wrote:
> just assign it to variable then pass it to the view
> *e.g. (not tested)*
> *controllers/default.py*
> def index():
> count_db = db(db.person.id > 0).count()
> dict(count_db = count_db)
>
> *views/default/index.html*
> {{= count_db}}
>
> *ref:*
>
> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#count-isempty-delete-update
>
> best regards,
> stifan
>
> --
> 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.
>
--
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: Show "count()" result in view
just assign it to variable then pass it to the view
*e.g. (not tested)*
*controllers/default.py*
def index():
count_db = db(db.person.id > 0).count()
dict(count_db = count_db)
*views/default/index.html*
{{= count_db}}
*ref:*
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#count-isempty-delete-update
best regards,
stifan
--
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.
