The .sort() method is done in Python and has nothing to do with SQLite. That makes me think something else is going on, such as something being cached and therefore not updating with your code changes.
Anthony On Friday, November 21, 2014 9:32:00 AM UTC-5, Dominique wrote: > > Hello, > > I have a small personal website published on PythonAnywhere. > PythonAnywhere upgraded SQLITE some time ago. > Since then, one query doesn't work anymore. > > It is a query with a many to many relationship and the select should give > results at random. > rows = db(...).select(..., orderby='<random>') > It doesn't return me a random set of rows but rather always the same rows, > starting from the beginning of the possible matching rows. > > I tried to address the problem without success. > > I also tried not using the web2py dialect and replacing it with > > import random > rows=db(...).select().sort(lambda row: random.random()) > > > as explained in the web2py doc. No success either. > > I also replaced the query with explicit SQL statement using > db.executesql( SELECT.....ORDER BY RANDOM() ) > > No success ! > > I downloaded the database onto my home pc and tested with the same website > in local. > It works perfectly at home. > > I tested on PythonAnywhere another model (based on the docs > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Many-to-many > ). > It works fine returning results randomly. So it seems the upgrade of > SQLite done by PythonAnywhere is not responsible for the problem. > > Does anybody have an idea what's going on, why the query doesn't work on > PythonAnywhere and works locally ? > > Thanks for any hint > Dominique > > -- 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.
