[web2py] Re: app slow on pythonanywhere

2016-09-03 Thread Paolo Valleri
Have you disabled migrations?

Paolo

On Saturday, September 3, 2016 at 7:01:39 PM UTC+2, Scott Hunter wrote:
>
> I have an app which runs *much* slower than expected on pythonanywhere.
>
> I enabled the profiler, and one thing stood out: on pythonanywhere, the 
> function the most time was spent in, by far, is fcntl.flock from inside 
> portalocker while loading the models.  In fact, when run locally, 
> portalocker isn't even being called: it goes straight from save_dbt to 
> cPickle.dump.
>
> Is there some configuration specific to web2py that might address this, or 
> is it something I should take up w/ the people at PA?
>
> - Scott
>

-- 
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: app slow on pythonanywhere

2016-09-03 Thread Scott Hunter
A number of times.  What is that supposed to have accomplished?

On Saturday, September 3, 2016 at 3:23:56 PM UTC-4, 黄祥 wrote:
>
> had you already tried to reload pythonanywhere web app?
>
> 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.


[web2py] Re: app slow on pythonanywhere

2016-09-03 Thread 黄祥
had you already tried to reload pythonanywhere web app?

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.


[web2py] app slow on pythonanywhere

2016-09-03 Thread Scott Hunter
I have an app which runs *much* slower than expected on pythonanywhere.

I enabled the profiler, and one thing stood out: on pythonanywhere, the 
function the most time was spent in, by far, is fcntl.flock from inside 
portalocker while loading the models.  In fact, when run locally, 
portalocker isn't even being called: it goes straight from save_dbt to 
cPickle.dump.

Is there some configuration specific to web2py that might address this, or 
is it something I should take up w/ the people at PA?

- Scott

-- 
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: wrong record getting selected in recursive select

2016-09-03 Thread Anthony
If you mean that request.args(0) contains the name of the restaurant, then 
you need a join:

t = db((db.Menu.Restaurant == db.Restaurant.id) &
   (db.Restaurant.name == request.args(0))).select(db.Menu.id).first()

Note, in that case, the Menu id will be in t.Menu.id rather than just t.id.

You can also use a reverse recursive select (which will result in two 
queries rather than just one):

t = db.Restaurant(name=request.args(0)).Menu.select(db.Menu.id).first()

A simpler option might be to make request.args(0) be the id of the 
restaurant instead of the name -- then you can just do:

t = db.Menu(restaurant=request.args(0))

Finally, if each restaurant has only one menu, then why not just move the 
menu field(s) into the Restaurant table?

Anthony




On Friday, September 2, 2016 at 2:27:23 PM UTC-4, @brooks wrote:
>
> I want to  select those records in the Menu table such that the name of 
> the restaurant with id in the Menu.restaurant field 
> ==request.args(0).So,what should be the DAL query here?
>
>
> On Fri, Sep 2, 2016 at 6:51 PM, Anthony  wrote:
>
>> indices=db(db.Menu).select()
>>> for index in indices:
>>> t=db(index.restaurant.Name
>>> ==request.args[0]).select(db.Menu.ALL).first()
>>>
>>
>> Above, index.restaurant.Name is simply a string value (the name of the 
>> restaurant in question), as is request.args(0). Therefore, 
>> index.restaurant.Name==request.args(0) is not a DAL Query object but 
>> simply a standard Python boolean that is either True or False. Regardless 
>> of the value of that boolean, the results of the query will be the same -- 
>> all records from db.Menu will be selected.
>>
>> Perhaps you can explain what you are trying to achieve here.
>>
>> Anthony
>>
>> -- 
>> 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/E4VyjG0jS94/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.


[web2py] File widget traduction

2016-09-03 Thread Gael Princivalle
Hello.

I've add in a custom form this field:
{{=form_event.custom.widget.cover_image}}

Language still English.
'Browse...' and 'No file selected.' don't appear in it.py.



Probably I have to add the T() to both text in this widget. How can I do it?

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.