[web2py] Re: are auth tables different than any other non-auth table?

2015-06-17 Thread Anthony
On Wednesday, June 17, 2015 at 4:42:57 PM UTC-4, Alex Glaros wrote: > > db.auth_group is doing double duty in my app as a role table for > everything in addition to permissions. Examples: (a) Partnership roles with > the organization. (b) Employee roles such as SME for a project. There may > be

[web2py] Re: Upgrade to 2.11.2 and Admin Interface doesn't render correctly

2015-06-17 Thread Dave S
On Wednesday, June 17, 2015 at 5:37:57 PM UTC-7, Dave S wrote: > > > > On Wednesday, June 17, 2015 at 2:03:21 PM UTC-7, Carlos A. Armenta Castro > wrote: >> >> Please clear your browser cache and try again. If you test in other >> computer you will see the page renders normally. > > > If that

[web2py] Re: Upgrade to 2.11.2 and Admin Interface doesn't render correctly

2015-06-17 Thread Dave S
On Wednesday, June 17, 2015 at 2:03:21 PM UTC-7, Carlos A. Armenta Castro wrote: > > Please clear your browser cache and try again. If you test in other > computer you will see the page renders normally. If that isn't sufficient, see Kiran's msg in another thread: https://groups.google.com/f

[web2py] Re: are auth tables different than any other non-auth table?

2015-06-17 Thread Alex Glaros
Didn't mean to use "*permissions"* ambiguously. db.auth_group will contain the "role" e.g., SME, and db.auth_membership will contain the IDs of people in that SME role. but what does this mean: *million users doesn't really qualify for a single postgres database*? That a million users is t

[web2py] Re: Problem importing modules from other app (having symlinked models and modules)

2015-06-17 Thread Niphlod
there's a distinct lack of singular/plurals in your statements that may pinpoint the problem. multiple apps --> multiple uwsgi processes either you "hg update" all the apps, and restart ALL uwsgi processes (more a reload than a restart, hopefully, touching EACH and EVERYONE of the files uwsgi

[web2py] Re: are auth tables different than any other non-auth table?

2015-06-17 Thread Niphlod
BTW: a million users doesn't really qualify for a single postgres database, no matter what. On Wednesday, June 17, 2015 at 11:17:39 PM UTC+2, Niphlod wrote: > > auth_group is for groups. auth_permissions is for permissions. as any > other table in your db, the problem is not the # of records, ra

[web2py] Re: are auth tables different than any other non-auth table?

2015-06-17 Thread Niphlod
auth_group is for groups. auth_permissions is for permissions. as any other table in your db, the problem is not the # of records, rather than what query you need to do on those. On Wednesday, June 17, 2015 at 10:42:57 PM UTC+2, Alex Glaros wrote: > > db.auth_group is doing double duty in my app

[web2py] Upgrade to 2.11.2 and Admin Interface doesn't render correctly

2015-06-17 Thread Carlos A. Armenta Castro
Please clear your browser cache and try again. If you test in other computer you will see the page renders normally. -- 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

[web2py] are auth tables different than any other non-auth table?

2015-06-17 Thread Alex Glaros
db.auth_group is doing double duty in my app as a role table for everything in addition to permissions. Examples: (a) Partnership roles with the organization. (b) Employee roles such as SME for a project. There may be millions of people reading/writing concurrently. Is there anything different

Re: [web2py] Re: language detecting

2015-06-17 Thread Michele Comitini
I suggest never block anyone. It's better to use honeytraps/sandboxes. Use a geoip library (http://pythonhosted.org/python-geoip/ or similar) if ipfrom == 'ru': redirect(... nice static page ...) If you use nginx you can do that almost out of the box with many other options such as throttling

[web2py] Re: language detecting

2015-06-17 Thread Derek
That may work, but I have multiple accept-languages. I can read in Russian and English, even though I am an American living in USA. Accept-Language values can have multiple values, so by blocking ru-RU you are just blocking anyone who can read russian. here's my header... en-US,en;q=0.8,ru;q=0.

[web2py] Re: form validate check form vars

2015-06-17 Thread 黄祥
don't know is this a bug or not. *code* *models/db.py* db.delivery_header.sale_order_no.show_if = (db.delivery_header.delivery_type == 'Sale Order') *controllers/default.py* def delivery_form(): if request.post_vars.delivery_type == 'Sale Order': db.delivery_header.stock_transfer_no.

[web2py] Re: How to access request.args in download() controller ?

2015-06-17 Thread Anthony
Is your download function in the same controller as the action that displays the link (if not, you need to specify the controller in the URL() function)? Also, where are you looking for the printed value -- it will appear in the console? Finally, you have the @cache.action() decorator on the do

[web2py] Re: grid

2015-06-17 Thread Anthony
On Wednesday, June 17, 2015 at 8:07:45 AM UTC-4, Oli wrote: > > > set paginate to the size you want. > > SQLFORM.grid(..., paginate=1, ...) > > see > http://web2py.com/books/default/chapter/29/07/forms-and-validators?search=SQLFORM.grid+signature#SQLFORM-grid-signature > For very large

[web2py] Re: grid

2015-06-17 Thread Anthony
On Wednesday, June 17, 2015 at 2:57:42 AM UTC-4, jackson.r...@quantachrome.com wrote: > > Is there anyway to make a SQLform.grid scroll instead of using page > numbers. > Are you looking for infinite scrolling (i.e., as you scroll down the page, additional records automatically load via Ajax)?

[web2py] Re: Problem importing modules from other app (having symlinked models and modules)

2015-06-17 Thread Lisandro
That's what I have actually :) I have emperor mode configured as suggested in the book. When I want to restart uwsgi process, I just make a touch to the uwsgi.ini file and the process restart successfully. It's inmediate and transparent to the users (I mean, users browsing the websites). The "

[web2py] Re: Problem importing modules from other app (having symlinked models and modules)

2015-06-17 Thread Niphlod
why don't you use the emperor mode with uwsgi pointing each process to a file that, when you modify it, reloads automatically the process ? On Wednesday, June 17, 2015 at 5:13:02 PM UTC+2, Lisandro wrote: > > Yes, I understand it's not a web2py problem, I was just wondering if there > was a way

[web2py] Re: Problem importing modules from other app (having symlinked models and modules)

2015-06-17 Thread Lisandro
Yes, I understand it's not a web2py problem, I was just wondering if there was a way of achieving that without restarting uwsgi process. I can see the need of restarting the process that runs the app after updating that app. However, most of the times, the update involves changes to static file

[web2py] Re: ERROR on clear cash fron admin DB

2015-06-17 Thread Kiran Subbaraman
The appadmin.py may have changed between web2py releases (release1 being the one which you used to create your application initially, and release2 being the one that you want to run your application in now.) By default this appadmin.py is contained within your application. So, can you try to cop

[web2py] Bug in code for email Queue example.

2015-06-17 Thread Jason (spot) Brower
I was copy pasting the code and noticed that "message" which you use in the email queue example is not valid as it is a reserved word in the Fields. Just thought I would mention it. BR, Jason Brower -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web

[web2py] Re: grid

2015-06-17 Thread Oli
set paginate to the size you want. SQLFORM.grid(..., paginate=1, ...) see http://web2py.com/books/default/chapter/29/07/forms-and-validators?search=SQLFORM.grid+signature#SQLFORM-grid-signature Am Mittwoch, 17. Juni 2015 08:57:42 UTC+2 schrieb jackso...@quantachrome.com: > Is there an

[web2py] distinct=True

2015-06-17 Thread Annet
In a network application I've got the following query: rows = db((db.edg_edge.fromID==vertexID) & (db.edg_edge.toID==db.vtx_vertex.id) & (db.lct_address.label==PHYSICALADDRESSID)).select(db.edg_edge.ALL, db.vtx_vertex.ALL, db.lct_address.ALL, db.wb_app.apptypeID, left=(db.lct_add

Re: [web2py] Re: Sublime Text web2py plugin

2015-06-17 Thread Gergely Orosz
You are more than welcome If you miss some function, feature please let me know. I try to put it into Sublime Regards Greg 2015. június 17., szerda 10:46:15 UTC+2 időpontban Ramos a következőt írta: > > Thank you Gergely Orosz for your work. > > Having the wep2y console and server console inside

Re: [web2py] Re: Sublime Text web2py plugin

2015-06-17 Thread António Ramos
Thank you Gergely Orosz for your work. Having the wep2y console and server console inside Sublime makes me a lot more productive. Just what i was looking for. Regards António 2015-06-12 17:37 GMT+01:00 António Ramos : > Ok.just some some... > Em 12/06/2015 17:27, "António Ramos" escreveu: >

[web2py] Re: response.menu will not display an image

2015-06-17 Thread Niphlod
is hardly the way to display an image . On Wednesday, June 17, 2015 at 8:57:45 AM UTC+2, jackso...@quantachrome.com wrote: > > This does not work. No image is displayed. The layout seems to lose it > too, the response menu now has 2 rows & this causes things to be obscured > by it. Should

[web2py] Re: .json return in nginx/uwsgi

2015-06-17 Thread Niphlod
there's a handy directive for it. https://github.com/web2py/web2py/blob/master/applications/welcome/models/db.py#L33 On Wednesday, June 17, 2015 at 8:57:45 AM UTC+2, K.J. Pamio wrote: > > Hello, > In my app on the local server enough to use the termination .json in function > call that web2py a

[web2py] Re: PostgreSQL - Sort with NULLS FIRST

2015-06-17 Thread Niphlod
nope. On Wednesday, June 17, 2015 at 8:57:45 AM UTC+2, pysab wrote: > > Hi there :) > > I'm using web2py 2.9.10 with a database PostgreSQL 9.4 for a new project > and I have a question about sorting. In PostgreSQL, when I execute a > SELECT, I can specify 'ORDER BY x ASC NULLS FIRST', which is n