I think he's after an database-side implementation. If you used limit
and random together then wouldn't you always get the same set of data,
rather than random?


On Dec 8, 4:13 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Not sure I understand our comment:
>
> rows=db(...).select().sort(lambda row: random.random())
>
> sorts the rows that have been already fetched at the web2py/python
> level. That is all. What is wrong with it?
>
> On Dec 7, 9:28 am, blackthorne <francisco....@gmail.com> wrote:
>
> > Seems to be 1.89.5 (2010-11-21 16:03:13)..
>
> > but what about my comment of the random sorting?
>
> > On Dec 7, 3:09 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > You have an old version. aidr is a type fixed some time ago.
>
> > > On Dec 7, 7:13 am, blackthorne <francisco....@gmail.com> wrote:
>
> > > > I don't see howcome this works as random sorting.
> > > > The only random thing I see it's the row chosen for sorting which will
> > > > only change the sorting criteria for the number of rows in the table.
>
> > > > Am I wrong?
>
> > > > P.S.:
> > > > I couldn't make a quick test because:
> > > > isco-Ribeiros-MacBook-Pro-2:web2py blackthorne$ python web2py.py -S
> > > > "test"
> > > > web2py Enterprise Web Framework
> > > > Created by Massimo Di Pierro, Copyright 2007-2010
> > > > Version 1.89.5 (2010-11-21 16:03:13)
> > > > Database drivers available: SQLite3
> > > > application test does not exist, create (y/n)?yes
> > > > Traceback (most recent call last):
> > > >   File "web2py.py", line 23, in <module>
> > > >     gluon.widget.start(cron=True)
> > > >   File "/Users/blackthorne/Code/web2py/gluon/widget.py", line 766, in
> > > > start
> > > >   File "/Users/blackthorne/Code/web2py/gluon/shell.py", line 166, in
> > > > run
> > > > NameError: name 'aidr' is not defined
>
> > > > ?
>
> > > > On Dec 6, 10:53 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > import random
> > > > > ...
> > > > > rows=db(...).select().sort(lambda row: random.random())
>
> > > > > On Dec 6, 4:09 pm, Albert Abril <albert.ab...@gmail.com> wrote:
>
> > > > > > Hi!
>
> > > > > > As said on the book, in a DAL select, orderby='<random>' is not 
> > > > > > supported on
> > > > > > GAE.http://web2py.com/book/default/chapter/06#orderby,-groupby,-limitby,-...
>
> > > > > > Someone knows the best way to randomize a Rows dictionary?
> > > > > > (thinking in GAE deployment of course)
>
> > > > > > Thanks in advance.
>
>

Reply via email to