[web2py] Re: Getting "invalid controller" error after updating routes.py (DigitalOcean setup)

[William]

Ok managed to fix this problem by restarting my droplet *facepalm*. Case 
closed. 

-- 
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] @auth.requires_signature() vs @auth.requires_login()

[Vlad]

I generally understand how to use both, @auth.requires_signature() 
and @auth.requires_login(),
but from a practical point of view, when in real life would you prefer to 
use one vs. another? 

-- 
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] Getting "invalid controller" error after updating routes.py (DigitalOcean setup)

[William]

Hi all, I have successfully deployed Web2py on DigitalOcean following this 
tutorial . But after 
updating my routes.py file, I  sometimes get the error "*invalid controller*" 
when I visit pages. 

This is what I wrote in the routes.py file:

routers = dict(
> BASE = dict(
> default_application = 'viewbase',
> ),
> )

 
I have tried the following but still get the same error:

   - Clicking the "reload routes" button
   - Restarting nginx

Any of you know what went wrong? Thank you. 

-- 
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: grid reloading the page and outdated flash msgs? (strange behavior...)

[Eliezer (Vlad) Tseytkin]

I got it,
finally,
It was purely mystical for me, but now it makes sense... Grid is quite a
sophisticated beast and does some magic behind the stage...

Thank you very much!



On Thu, Dec 27, 2018 at 11:08 PM Anthony  wrote:

> This simply displays an old fashioned grid. Nothing fancy. But now
>> consider just exactly same code, with 2 extra lines (if (id==0):
>> redirect(home) :
>>
>> def test():
>> id = 0
>> try:
>> id = request.args(0, cast=int)
>> except:
>> id = 0
>> pass
>> if (id==0):
>> redirect('home')
>> grid = SQLFORM.grid(db.test_table, user_signature=False)
>> return locals()
>>
>> Now, this looks exactly like the previous one - but this grid is NOT
>> functional. Neither create nor delete work! The buttons are there, but the
>> create and delete functions do NOT perform.
>>
>> Please note that I always specify the parameters - app/default/test/1
>>  or app/default/test/100 - it's never called without a parameter. So
>> logically, unless I am missing something, if (id==0) should never be the
>> case - right?
>>
>
> As mentioned earlier, if you want to use some URL args in your code that
> should not apply to the grid, you must make this explicit by passing args
> that must be preserved by the grid via its "args" argument. See
> http://web2py.com/books/default/chapter/29/07/forms-and-validators#Using-requests-args-safely.
> This tells the grid to preserve the URL args you are using in any URLs it
> creates, and to ignore those args internally.
>
> 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 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.

Re: [web2py] Re: "... records found' on the default grid

[Eliezer (Vlad) Tseytkin]

Thank you!

On Thu, Dec 27, 2018, 10:56 PM Anthony  https://groups.google.com/d/msg/web2py/9_Lz5VWb80A/SgW26gsP3IcJ
>
> On Thursday, December 27, 2018 at 7:47:56 PM UTC-5, Vlad wrote:
>>
>> What would be the best way to get rid of "5 records found" on the upper
>> right corner of the default grid view?
>>
> --
> 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.

Re: [web2py] Re: grid reloading the page and outdated flash msgs? (strange behavior...)

[Anthony]

>
> This simply displays an old fashioned grid. Nothing fancy. But now 
> consider just exactly same code, with 2 extra lines (if (id==0): 
> redirect(home) :  
>
> def test():
> id = 0
> try:
> id = request.args(0, cast=int)
> except:
> id = 0
> pass
> if (id==0):
> redirect('home')
> grid = SQLFORM.grid(db.test_table, user_signature=False)
> return locals()
>
> Now, this looks exactly like the previous one - but this grid is NOT 
> functional. Neither create nor delete work! The buttons are there, but the 
> create and delete functions do NOT perform. 
>
> Please note that I always specify the parameters - app/default/test/1   or 
> app/default/test/100 - it's never called without a parameter. So logically, 
> unless I am missing something, if (id==0) should never be the case - right?
>

As mentioned earlier, if you want to use some URL args in your code that 
should not apply to the grid, you must make this explicit by passing args 
that must be preserved by the grid via its "args" argument. 
See 
http://web2py.com/books/default/chapter/29/07/forms-and-validators#Using-requests-args-safely.
 
This tells the grid to preserve the URL args you are using in any URLs it 
creates, and to ignore those args internally.

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 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: "... records found' on the default grid

[Anthony]

https://groups.google.com/d/msg/web2py/9_Lz5VWb80A/SgW26gsP3IcJ

On Thursday, December 27, 2018 at 7:47:56 PM UTC-5, Vlad wrote:
>
> What would be the best way to get rid of "5 records found" on the upper 
> right corner of the default grid view? 
>

-- 
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] "... records found' on the default grid

[Vlad]

What would be the best way to get rid of "5 records found" on the upper 
right corner of the default grid view? 

-- 
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: grid reloading the page and outdated flash msgs? (strange behavior...)

[Eliezer (Vlad) Tseytkin]

Antony, thank you very much, I got the 1st and the 3rd ones. But about the
2nd one it's tricky. Without going into details of why I need it, could you
please just glance at the following code that works 100%:

def test():
id = 0
try:
id = request.args(0, cast=int)
except:
id = 0
pass
   """ another 100 lines of code is cut off here
grid = SQLFORM.grid(db.test_table, user_signature=False)
return locals()

I am calling it, for example, like this:app/default/test/1
How I use this id field it doesn't really matter - I've simply extracted
the essence of what's going on, leaving another 100 lines of code out.

This simply displays an old fashioned grid. Nothing fancy. But now consider
just exactly same code, with 2 extra lines (if (id==0): redirect(home) :

def test():
id = 0
try:
id = request.args(0, cast=int)
except:
id = 0
pass
if (id==0):
redirect('home')
grid = SQLFORM.grid(db.test_table, user_signature=False)
return locals()

Now, this looks exactly like the previous one - but this grid is NOT
functional. Neither create nor delete work! The buttons are there, but the
create and delete functions do NOT perform.

Please note that I always specify the parameters - app/default/test/1   or
app/default/test/100 - it's never called without a parameter. So logically,
unless I am missing something, if (id==0) should never be the case - right?

What I was surprised to find out was that WHEN I, for example, click delete
button on the grid - the page quietly reloads and this time it's called
without my parameter (without be doing anything and without me being aware
of this), thus (id==0) condition is true, executes appropriate code (which
was never meant to be executed if everything goes right), and this is how
it's somehow messes up delete and create.

I hope I've explained better this time...

On Thu, Dec 27, 2018 at 6:35 PM Anthony  wrote:

> On Thursday, December 27, 2018 at 4:05:40 PM UTC-5, Vlad wrote:
>>
>> Here is a test function in my controller:
>>
>> def test():
>> id = 0
>> try:
>> id = request.args(0, cast=int)
>> session.flash = "Here is the id: " + str(id)
>> except:
>> session.flash = "ID is not valid!"
>> pass
>> if id==0:
>> redirect(URL('home'))
>> query = db.test_table.id == id
>> grid = SQLFORM.grid(query, db.test_table, user_signature=False)
>> return locals()
>>
>
> Regarding the flash message, you should be setting response.flash, not
> session.flash (the latter goes in the session and will not be displayed
> until the *next *request, as you have observed -- it is typically used
> just before a redirect).
>
> What are you attempting to do with this function? Why are you even using
> the grid if you are only intending to display a single record?
>
> Note, your code does nothing in case the request.args(0) is not a valid
> integer -- in that case, your function still returns a grid (though
> presumably using a query you don't want). You might instead want to do a
> redirect in that case.
>
> Also, if your function is going to make use of some of the URL args, you
> must indicate this to the grid by passing in the URL args it is supposed to
> use (via the "args" argument).
>
> Finally, actions other than reading data require either a logged in user
> or user_signature=False.
>
> 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 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: grid reloading the page and outdated flash msgs? (strange behavior...)

[Anthony]

On Thursday, December 27, 2018 at 4:05:40 PM UTC-5, Vlad wrote:
>
> Here is a test function in my controller: 
>
> def test():
> id = 0
> try:
> id = request.args(0, cast=int)
> session.flash = "Here is the id: " + str(id)
> except:
> session.flash = "ID is not valid!"
> pass
> if id==0:
> redirect(URL('home'))
> query = db.test_table.id == id
> grid = SQLFORM.grid(query, db.test_table, user_signature=False)
> return locals()
>

Regarding the flash message, you should be setting response.flash, not 
session.flash (the latter goes in the session and will not be displayed 
until the *next *request, as you have observed -- it is typically used just 
before a redirect).

What are you attempting to do with this function? Why are you even using 
the grid if you are only intending to display a single record?

Note, your code does nothing in case the request.args(0) is not a valid 
integer -- in that case, your function still returns a grid (though 
presumably using a query you don't want). You might instead want to do a 
redirect in that case.

Also, if your function is going to make use of some of the URL args, you 
must indicate this to the grid by passing in the URL args it is supposed to 
use (via the "args" argument).

Finally, actions other than reading data require either a logged in user or 
user_signature=False.

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 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] grid reloading the page and outdated flash msgs? (strange behavior...)

[Vlad]

Here is a test function in my controller: 

def test():
id = 0
try:
id = request.args(0, cast=int)
session.flash = "Here is the id: " + str(id)
except:
session.flash = "ID is not valid!"
pass
if id==0:
redirect(URL('home'))
query = db.test_table.id == id
grid = SQLFORM.grid(query, db.test_table, user_signature=False)
return locals()

Here are issues I've encountered with this (not sure if they are 
independent or related): 

1) the flash msg displays the previously passed parameters, not the latest 
one. This is weird! For example, app/home/test/1 called the first time does 
NOT display any flash msg at all.  When I call it the 2nd time - 
app/home/test/2 - the flash message displays "1", i.e. previously called 
number. At the same time, the page displays correctly - the page knows that 
the correct number is 2 indeed now. 

2) The grid behaves very strangely. Here is how: when I delete a record, 
the page silently reloads (I know this because of the flash message - which 
displays the previous id, not the current one), and in case this is my 
first call to this page, it comes out that ID is not valid and id equals 0 
EVEN THOUGH I passed the parameter through vars (app/home/test/1) it breaks 
the delete - delete never commits to the database. It does delete the row 
from the grid thought, so visually the row is gone, but the database is not 
altered. At the same time, if I remove that redirect('home') - the delete 
completes and commits to the database just fine (i.e. as long as redirect 
is not there - even though this strange reloading of the page is going on - 
it doesn't bother me - the messed up parameter only causes redirect which 
somehow breaks the delete). 

Namely, the following code (same but without redirect): 

def test():
id = 0
try:
id = request.args(0, cast=int)
session.flash = "Here is the id: " + str(id)
except:
session.flash = "ID is not valid!"
pass
query = db.test_table.id == id
grid = SQLFORM.grid(query, db.test_table, user_signature=False)
return locals()

still doesn't display flash msgs correctly, BUT it does not break grid's 
functionality - delete completes (can't fathom how this could be, as if 
request.var is incorrect - then the page should display incorrectly, but if 
request.var is somehow correct then redirect should never happen to begin 
with, how can it influence anything? And if redirect is actually called 
(and it is) on grid's delete operation, it means that the id is now 
incorrect, why doesn't it break the view of the page?? I am totally 
confused...

I hope this doesn't sound messy :) I've been going crazy for a while until 
I've isolated what I've just described... 

And, by the way, the app logic I am trying to achieve is simple: I pass the 
param through request.vars but then first check if the current user is 
authorized, and if not - I redirect. I need some custom authorization logic 
here, so usual auth decorates don't help in my situation.

3) this is more of a side issues, but I'll mention it, as I am on the grid: 
in some situations grids work just fine without user_signature=False , but 
sometimes they refuse and display error msgs like not authorized etc. I 
can't detect the difference when it's needed. This is not a big deal, I can 
just place user_signature=False whenever, but it does bother me, since I 
don't understand what exactly is causing this difference that breaks the 
functionality in some situations. 

Any suggestions are greatly appreciated 
 

-- 
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: Issue with latin /utf8 ??

[Val K]

And make sure that you have   in your html

-- 
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: Issue with latin /utf8 ??

[Leonel Câmara]

 Ramos make sure you either use unicode or you're using utf-8 strings 
everywhere, this means also having # -*- coding: utf-8 -*- as the first 
line in your controller .py files. Then also make sure the javascript code 
you're using to get this knows the json is coming in utf-8. Then make sure 
you decode the string you get from the webservice correctly, this means 
turning it into unicode by decoding from whatever encoding it's using, and 
then converting it to utf-8.



-- 
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] synchronizing / backing up my code between local web2py & PythonAnywhere web2py

[Eliezer (Vlad) Tseytkin]

Awesome article and exactly what I need!
Thank you!!

On Thu, Dec 27, 2018, 8:22 AM Carlos Cesar Caballero Díaz <
carlos.caball...@cfg.jovenclub.cu wrote:

> Maybe this can help:
>
> https://blog.pythonanywhere.com/87/
>
> Greetings.
>
>
> El 23/12/18 a las 1:45 p.m., Vlad escribió:
>
> What do you guys generally do as far an syncing / backup?
>
> I mean, right now I am going back and forth local web2py <->
> PythonAnywhere web2py
>
> So it's tedious to keep track what the latest thing is - I pack up my app
> locally and upload it to PA, and then pack up on PA and upload to local.
>
> Are there some common solutions for this? I would definitely enjoy some
> kind of synchronization which would also take care of  both - sync and a
> backup for me -
> --
> 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.
>

-- 
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] synchronizing / backing up my code between local web2py & PythonAnywhere web2py

[Carlos Cesar Caballero Díaz]

Maybe this can help:

https://blog.pythonanywhere.com/87/

Greetings.


El 23/12/18 a las 1:45 p.m., Vlad escribió:

What do you guys generally do as far an syncing / backup?

I mean, right now I am going back and forth local web2py <-> 
PythonAnywhere web2py


So it's tedious to keep track what the latest thing is - I pack up my 
app locally and upload it to PA, and then pack up on PA and upload to 
local.


Are there some common solutions for this? I would definitely enjoy 
some kind of synchronization which would also take care of  both - 
sync and a backup for me -

--
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.

Re: [web2py] Re: Issue with latin /utf8 ??

[António Ramos]

Maybe not :(
[image: image.png]

Em qua, 26 de dez de 2018 às 22:03, Leonel Câmara 
escreveu:

> The problem you're seeing has only to do with printing it to a console
> because it uses whatever encoding your console has. The json will be fine.
>
> --
> 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.