[web2py] Re: web2py 2.14.4 is OUT

2016-06-06 Thread Dave S
On Friday, June 3, 2016 at 9:30:10 AM UTC-7, PRACHI VAKHARIA wrote: > > > > > > > *Great! 😇What are some of the major updates in 2.14.4 – that we users > should note or be aware of?* > ## 2.14.6 - Increased test coverage (thanks Richard) - Fixed some newly discovered security issues in admin:

[web2py] Re: MySQL connection error after scheduled task completes

2016-06-06 Thread Andre Kozaczka
Well. adding "sync_output=200" ended up working for tasks that were just over the 300 second mark (where previously I was failing). I changed the task length to 600 seconds and I'm back to failing. Ah... so close!!! I tried changing sync_output to 100 but still failed. Unless you have ano

[web2py] Re: How to edit the menu bar so as to remove profile and name in front of welcome in the dropdown?

2016-06-06 Thread Anthony
On Monday, June 6, 2016 at 2:45:00 PM UTC-4, Ron Chatterjee wrote: > > I get this error. > > EOL while scanning string literal: , line 1, pos 68 > > While typing > navbar.element(_href=re.compile('register'))[0] = 'Registration Page" > Not sure how/why you are getting that error (hard to say with

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

2016-06-06 Thread Anthony
On Monday, June 6, 2016 at 5:30:50 PM UTC-4, Niphlod wrote: > > okay but . > """ > Withimmediate=True you can force the check for new tasks: it will happen > at most as heartbeat seconds are passed > """ > clearly states that "it" is "check for new tasks". > Yes, but earlier it says: immedi

[web2py] Re: Output format of an SQL query

2016-06-06 Thread Anthony
On Monday, June 6, 2016 at 5:17:34 PM UTC-4, Sammy wrote: > > Oh sure, I understand the importance of define.table as a way to create > table if it does not exist already. But for existing tables, how is it that > an oracle client is able to understand the structure of a table to do > queries wi

[web2py] Re: Weird form issue

2016-06-06 Thread Mark Graves
Hey Jeff, Most likely the date/time format. If you can post a sample sqlite file and SQLGRID code, happy to help. -Mark On Monday, June 6, 2016 at 12:42:16 PM UTC-7, Jeff Riley wrote: > > Sorry quick update. Rows is returning information, so I must have a > problem with my javascript. I st

[web2py] Re: How to properly set cache.action parameters in order to have different cache for logged-in and not?

2016-06-06 Thread Niphlod
it's kinda chicken-and-egg here, because your real trouble is that the unlogged user hits a page that you want to be cached client-side as long as he is not logged in. if you let it cache client-side, having the user returning to the same page to expect a different outcome is impossible. IMHO t

[web2py] Re: Output format of an SQL query

2016-06-06 Thread Niphlod
the oracle client really doesn't know anything about your database, it just spits what oracle has to tell. DAL is an "Abstraction", so to "abstract" a model, it needs the definition (the brain that designed the oracle table had it, it just translated to SQL rather than python) But let's put it

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2016-06-06 Thread Donald McClymont
Sounds good - possibly worth trying to contact someone on the psa team as well. I think we need to decide whether an updated plug-in is the best way to go or whether this should be a core part of either PSA or web2py. The plug-in may be the quickest way forward but it might well be better to g

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

2016-06-06 Thread Niphlod
okay but . """ Withimmediate=True you can force the check for new tasks: it will happen at most as heartbeat seconds are passed """ clearly states that "it" is "check for new tasks". A more-specific """ with immediate=True the worker will check for new tasks as soon as possible (without wai

[web2py] Re: MySQL connection error after scheduled task completes

2016-06-06 Thread Niphlod
I'm really not sure on how to tackle this mysql-specific shortcoming but I get the point. What does happen if you queue the task with sync_output=200 ? Functionaly you don't need it, but practically - but still in theory - it would short-circuit the issue keeping the connection alive every 200

[web2py] Re: Output format of an SQL query

2016-06-06 Thread Sammy
Oh sure, I understand the importance of define.table as a way to create table if it does not exist already. But for existing tables, how is it that an oracle client is able to understand the structure of a table to do queries without further instructions but for DAL you need to explicitly defin

[web2py] Re: Output format of an SQL query

2016-06-06 Thread Dave S
On Monday, June 6, 2016 at 1:34:00 PM UTC-7, Sammy wrote: > > I will probably be picking this back up in a few weeks as I will be > sidetracked for a while. I am just curious though why web2py requires one > to define a table even if it already exists. e.g. if I have an Oracle > client install

[web2py] Re: Output format of an SQL query

2016-06-06 Thread Sammy
I will probably be picking this back up in a few weeks as I will be sidetracked for a while. I am just curious though why web2py requires one to define a table even if it already exists. e.g. if I have an Oracle client installed, all I need is a connection string. I don't need to define a model

[web2py] Re: Weird form issue

2016-06-06 Thread Jeff Riley
Sorry quick update. Rows is returning information, so I must have a problem with my javascript. I still however cannot delete the record from the SQLgrid view. On Monday, June 6, 2016 at 2:38:03 PM UTC-5, Jeff Riley wrote: > > Now I am truly confused. I am able to submit the form and create t

[web2py] Re: Weird form issue

2016-06-06 Thread Jeff Riley
Now I am truly confused. I am able to submit the form and create the record in the database, but now rows = db(db.training).select() is not returning anything and I cannot delete the record from the SQLGrid view. I have really wacked something up. On Sunday, June 5, 2016 at 2:34:16 PM UTC-

[web2py] Re: How to edit the menu bar so as to remove profile and name in front of welcome in the dropdown?

2016-06-06 Thread Ron Chatterjee
I get this error. EOL while scanning string literal: , line 1, pos 68 While typing navbar.element(_href=re.compile('register'))[0] = 'Registration Page" So, I am guessing, it looks for the work (pattern) 'register' and change that to the 'registration page'. I printed out the navbar but I don

[web2py] Re: How to properly set cache.action parameters in order to have different cache for logged-in and not?

2016-06-06 Thread Lisandro
I've been doing some more test and a bit more reading about this, and I can see (if I'm not wrong) that this is not a problem, it's the expected behaviour. @cache.action does precisely that: it sets cache headers for client-side caching, that is, browser side caching. And, *optionally*, it allo

Re: [web2py] Re: Ractive example

2016-06-06 Thread Richard Vézina
Where are we going? I also didn't had any answer here : https://groups.google.com/d/msg/web2py-developers/x23GReU0McM/5kX42ft-PAAJ Thanks Richard On Fri, Apr 17, 2015 at 10:56 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > No. That simply decides wheher to display the login menu.

[web2py] Re: Modification in version 2.14.6 not documented ?

2016-06-06 Thread Anthony
Issue submitted with proposed fix: https://github.com/web2py/web2py/issues/1351 On Monday, June 6, 2016 at 11:23:10 AM UTC-4, Anthony wrote: > > I see. With smartgrid, you can pass through any of the standard grid > parameters to the grid, and there is an option to specify any of those > parame

[web2py] Re: Modification in version 2.14.6 not documented ?

2016-06-06 Thread Anthony
I see. With smartgrid, you can pass through any of the standard grid parameters to the grid, and there is an option to specify any of those parameters as a dictionary with table names as keys. The problem is that the code simply checks whether each kwarg is a dictionary, assuming if it is, it m

[web2py] Re: self referenced table - how to show description instead of internal id

2016-06-06 Thread Anthony
On Monday, June 6, 2016 at 9:19:10 AM UTC-4, Mirek Zvolský wrote: > > Thank you, Anthony! > For me was important to be sure that I make no other mistake and proper > way to fix it is with delayed setting of represent=.. > > Based on your answer, this works excellent for me: > db.place.place_id.rep

[web2py] Re: reading values from request.vars

2016-06-06 Thread Anthony
Looks like each set of inputs has the same input names, so you get back a list for each variable. I believe browsers preserve the order of input values for inputs with the same name, so you should be able to just run a loop and do a separate insert for each set of items in the lists (i.e., on t

[web2py] How to properly set cache.action parameters in order to have different cache for logged-in and not?

2016-06-06 Thread Lisandro
I need to decorate a controller function with @cache.action in order to have two different versions of the rendered view: one for logged-in users and another one for not logged-in users. Notice that I don't need one different caché for each user (that could be achieved using session argument).

[web2py] Re: self referenced table - how to show description instead of internal id

2016-06-06 Thread Mirek Zvolský
Thank you, Anthony! For me was important to be sure that I make no other mistake and proper way to fix it is with delayed setting of represent=.. Based on your answer, this works excellent for me: db.place.place_id.represent = lambda id, row: id and id.place or "" (handled for None + different pa

[web2py] Re: Modification in version 2.14.6 not documented ?

2016-06-06 Thread omicron
I want to believe you, but in version 2.13.4 the code for smatgrid is # filter out data info for displayed table if table._tablename in constraints: query = query & constraints[table._tablename] if isinstance(links, dict): links = links.get(table._ta

[web2py] Re: Ajax load function div with incorrect data and duplicates elements of the page

2016-06-06 Thread isi_jca
Hi!!! I commented that you can solve the problem by doing the following: 1°) Modifying the function as follows def fgetlocalidad(): idprovincia = 0 result='' idprovincia = int(request.vars.idprovincia) localidad_rows = db(db.trlocalidad.idprovincia==idprovincia).select(orderby=d

[web2py] self referenced table - how to show description instead of internal id

2016-06-06 Thread Anthony
The "represent" attribute of the field cannot be set automatically in this case because the table has not been defined at the time the field is created. So you must set the "represent" attribute yourself: represent=lambda r, id: id.place Anthony -- Resources: - http://web2py.com - http://web2

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

2016-06-06 Thread Anthony
http://web2py.com/books/default/search/29?search=seconds+are+passed -- 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

[web2py] self referenced table - how to show description instead of internal id

2016-06-06 Thread Mirek Zvolský
I have self refenced table for places (locations), ie. hierarchical structure of places is possible. db.define_table('place', Field('place', 'string'), Field('place_id', 'reference place'), format='%(place)s' ) In Web2py grid for the parent place (place_id) I see:

[web2py] Re: MySQL connection error after scheduled task completes

2016-06-06 Thread Andre Kozaczka
In the "real" world, the task can take anywhere from 1 minute up to 30 minutes. In debugging my problem, I created a dummy task that would loop (sleep 15 seconds then do a db write) and end after a set period of time. I'm seeing the problem when the dummy task takes over 300 seconds - anything

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

2016-06-06 Thread Niphlod
even in a single process you shouldn't notice any "unresponsiveness". it's most likely that locally you have both the browser process and webp2y competing for resources than a problem on the thread executing the work (as the default webserver is multi-threaded). Another thing to consider with a

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

2016-06-06 Thread Niphlod
uhm. maybe it's not strictly clear but what immediate does is checking for new tasks (and the assigning/reassigning cycle) ASAP. There's no guarantee to do anything else (e.g. unavailable workers, single worker occupied processing a previous task, available workers but with a different group_na

[web2py] Re: error starting scheduler: error retreiving status

2016-06-06 Thread Niphlod
nope. what it really happens is that scheduler module "register itself" under the current namespace. When you do -K , it just spawns a process that executes "from gluon import current;current._scheduler.loop()" in the context of the app. Given that DAL under the hood represents a connection, and

[web2py] Re: MySQL connection error after scheduled task completes

2016-06-06 Thread Niphlod
how many seconds does it take to be executed ? On Monday, June 6, 2016 at 3:46:12 AM UTC+2, Andre Kozaczka wrote: > > I'm getting the following error after my scheduled task completes: > > > Traceback (most recent call last): File > "/home/wdis/web2py/gluon/shell.py", line 273, in >run exec(