[web2py] Re: Scheduling several recursive scheduled tasks monopolize the scheduler

2015-02-05 Thread Niphlod
glad it's fixed. On Wednesday, February 4, 2015 at 11:35:59 PM UTC+1, Antonio Salazar wrote: > > I apologize for the mangled subject, I rewrote it several times and left > some typos. > It should be "Scheduling several recursive tasks monopolizes the scheduler" > > El miércoles, 4 de febrero de 2

Re: [web2py] Re: Please help us test the 2.9.12 binaries

2015-02-05 Thread mcamel
Works fine. Just a typo with 'dat' instead of 'dal'. :-) Thanks! El viernes, 16 de enero de 2015, 22:40:36 (UTC+1), mweissen escribió: > > Same problem. This works both with 2.9.11 and 2.9.12: > > try: >from gluon.dat.objects import Row > except: >from gluon.dal import Row > > Regards,

[web2py] Did one click install. Now all sites try to use https: How go I get http: ?

2015-02-05 Thread tim spear
I did the "one step deployment" from the web2py guide on Ubuntu on digital ocean Now all my sites try to use https:/ giving "This Connection is Untrusted You have asked Firefox to connect securely to www.fborder.com, but we can't confirm that your connection is secure." error messages for us

Re: [web2py] Re: Form input show decimal fields with 4 decimals? (How to format input field in forms?)

2015-02-05 Thread Richard Vézina
I use represent to prevent this kind of stuff... represent=lambda value, row: '{0:.1f}'.format(value) if value is not None else T('N/A')), With microformat language provide by .format() It allows me to also, extend my field domain (more places) and keep the display unchanged at webapp level...

Re: [web2py] Re: Question about web2py roadmap.

2015-02-05 Thread Richard Vézina
Joe, Do you know form.custom ? It allows to customize in view (or controller but begin and end should be present in view) generated form from SQLFORM. I think, that MVC is not really respected at all in web2py... I think that when there is a possible hack that can brings incredible feature and m

[web2py] Dalfiddle or dalpen

2015-02-05 Thread António Ramos
Hello, Sometimes i need to experiment my dal knowledge but having to create an app just for that dismisses my will. "Sometimes i´m too lazy!" Is it possible to create an online app to experiment just the dal syntax just like jsfiddle or codepen. Thank you António -- Resources: - http://web2py

Re: [web2py] Re: Question about web2py roadmap.

2015-02-05 Thread Anthony
Rather than speaking abstractly about "breaking MVC," it would be helpful to see code examples along with an explanation of why they are problematic and how they can be improved. I believe one of the motivations behind MVC (or MTV if you prefer the Django/Flask terminology) is to de-couple inde

[web2py] form.custom.dspval and IS_IN_DB

2015-02-05 Thread Omi Chiba
I'm trying to display (P = Precision) instead of "P". I tired both form.custom.dspval and form.custom.inpval but both shows "P". It looks fine when see the field in Edit mode in Admin. Any idea? *My View* {{=form.custom.begin}} Cover : {{=form.custom.dspval.Cover}} {{=form.custom.

[web2py] Re: Dalfiddle or dalpen

2015-02-05 Thread Anthony
I typically fiddle around in a web2py shell (specifically, I use an IPython Notebook, in which I have defined some special functions to render HTML, such as forms and grids). I keep the notebook server running in a VM, and when I need to try something, I just go to the notebook in my browser. Th

[web2py] (foreign key constraint failed) with onupdate=auth.archive

2015-02-05 Thread François Delpierre
Hi, I get an Integrity Error everytime I modify a record in the t_route, and I don't understand what's wrong. The t_route contains only 1 record, the t_route_archive is empty. What should I do? The controller: @auth.requires_login() def route_manage(): form = SQLFORM.smartgrid(db.t_route,

Re: [web2py] Re: Question about web2py roadmap.

2015-02-05 Thread Richard Vézina
Yes man!! web2py is very flexible and you need really few lines of code to actually have webapp working that it greatess strengh... But Joe is right about one point, documentation is pretty dispersed and new undocumented feature are added very often... You have already exposed many of these undo

[web2py] Re: form.custom.dspval and IS_IN_DB

2015-02-05 Thread Omi Chiba
In another word, it shows fine when I use {{=form.custom.widget.Grade}} with edit mode ( form = SQLFORM(db.KR_Product,record, readonly=False)) but not when I do readonly=True -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: Question about web2py roadmap.

2015-02-05 Thread Leonel Câmara
It also depends on how you choose to look at it. From my point of view the message for a label for a field *is* part of the model. The only difference is that you aren't putting it in a database (which you certainly could). The view should only be concerned with how to display the label not with

Re: [web2py] Re: Dalfiddle or dalpen

2015-02-05 Thread António Ramos
Cool, so you have the same need also. And you are one of the Experts here. My desire is not that stupid. An online tool for all should be interesting. Codeschool has a very nice interface to explain javascript ruby, etc. We code in the browser and it updates the result automatically. Just a thoug

[web2py] Re: Question about web2py roadmap.

2015-02-05 Thread Anthony
On Thursday, February 5, 2015 at 12:35:35 PM UTC-5, Leonel Câmara wrote: > > It also depends on how you choose to look at it. From my point of view the > message for a label for a field *is* part of the model. The only > difference is that you aren't putting it in a database (which you certainly

[web2py] Re: form.custom.dspval and IS_IN_DB

2015-02-05 Thread Omi Chiba
I tried edit mode and put the following script in the view which works but feels so stupid and user cannot copy the values which I have to allow them top copy and paste. jQuery(document).ready(function(){ jQuery('#main').find('input, select').attr("readonly", true); }); On Thursday, Februa

[web2py] Re: form.custom.dspval and IS_IN_DB

2015-02-05 Thread Omi Chiba
I'm using 2.4.7 released 2013.05.24 so it could be bug and fixed now but I need to work on this version for now because I have issue with the latest web2py. Anyway, I found this https://groups.google.com/forum/#!searchin/web2py/IS_IN_DB$20readonly/web2py/uBBcvthCDl8/Z7s872JW47IJ and tried some

Re: [web2py] Re: form.custom.dspval and IS_IN_DB

2015-02-05 Thread Richard Vézina
Omi, In this : db.KR_Product.Grade.represent = lambda Name: SPAN(db.KR_GradeLabel[Name].Label) I don't understand where you are going... You try to set a represent over table KR_Product for field Grade right? But you get you represent value from another table KR_GradeLabel... In case of a rep

Re: [web2py] Re: form.custom.dspval and IS_IN_DB

2015-02-05 Thread Omi Chiba
Thank you for the reply. I'm not really sure how to use lamda. The problem is IS_IN_DB doesn't work when it's readonly and I found requires only works for Create/Edit and need to use represent for readonly view. I think this is a bug and should be it's already fixed but doen't matter to me beca

[web2py] Re: SQLFORM hanging on insert

2015-02-05 Thread Ian W. Scott
Hi folks. I still don't really know how to debug this problem beyond what I've done (identify the point in the gluon code where the hang happens). Can anyone at least suggest another strategy for debugging it? Thanks again, Ian On Thursday, January 29, 2015 at 4:00:54 PM UTC-5, Ian W. Scott wr

Re: [web2py] Re: form.custom.dspval and IS_IN_DB

2015-02-05 Thread Omi Chiba
OK, I don't like this but this is only way to do. I can look up the table in the view. What a mess Grade : {{grade = db.KR_GradeLabel(db.KR_GradeLabel.Name==form.custom.dspval.Grade)}} {{if grade:}} {{=grade.Label}} {{else:}} {{=form.custom.dspval.G

[web2py] form.custom.dspval and IS_IN_DB

2015-02-05 Thread Omi Chiba
I want to display the value from IS_IN_DB. I have "P" as value and display "P = Precision" from the table. It's working fine on Edit mode in admin. But when I display the values, form.custom.dspval and form.custom.inpval shows the same value "P". Any idea? *My View* {{=form.custom.begin}}

[web2py] Re: Groupby year on date field

2015-02-05 Thread Moiz Nagpurwala
Yes sir, I'm sure. The sample database I had sent previously and my production database both have records in them. -- 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 Iss

[web2py] unit testing controllers with auth decorators

2015-02-05 Thread James O' Driscoll
All, I am having trouble unit-testing web2py app controllers which are decorated with @auht.requires_login(). I think I am missing something declaring the enviroment as I get, auth is not defined error. It would be great if I could get some assistance on this. class TestListClients(unittest.Te

[web2py] Re: Error in Eclipse kepler for Web2py source: generics.xml

2015-02-05 Thread Carl Hunter Roach
My back-brain has obviously not let this go :) I think it would be an improvement to Web2py for it to not use an XML file extension for non-XML content (or a HTML extension for non-HTML content). If every project/application did this it would soon make file extensions much less useful. :)

[web2py] Testing and web2py - especially appadmin

2015-02-05 Thread James O' Driscoll
I am currently working on creating tests for my default controller, I have found a few articles relating to web2py and unit testing, but not many. I have two questions: 1. Any recommendations for good resources available to help create tests for web2py. 2. Is there a doctest/unit test av

Re: [web2py] Re: Handling (2006, 'MySQL server has gone away') from Scheduler, pythonanywhere

2015-02-05 Thread Ian Ryder
Think it is pretty similar to this - we have 3 databases open. Seems to only happen when a big process / query runs. More worrying now is that I'm getting situations where a process starts and just disappears into the ether - no timeout, no fail, no error message. Just starts and is never seen

Re: [web2py] Re: Question about web2py roadmap.

2015-02-05 Thread Vinicius Assef
An inline answer. On Wed, 04 Feb 2015 14:11:51 -0300 JoeCodeswell wrote >... > >I find customization difficult: >adding buttons As you have python in views, you can manipulate server side DOM in your view, i.e add/remove class names, create id for elements, etc. Or you can make it t

[web2py] Re: Debian 7 with Lighttpd + web2py setup

2015-02-05 Thread Massimo Di Pierro
Thanks Jon. I have not used this in long time (4 years?) and there has not been much talk about lighttpd since nginx. Anyway I think you do this: 1) copy web2py/handlers/ fcgihandler.py to web2py/fcgihandler.py but you should not rename it. 2) you start it with sudo -u www-data python fcgihandle

[web2py] Re: https only on admin

2015-02-05 Thread Massimo Di Pierro
You are the second person to report this problem. Was this after an upgrade? Have you deleted your session files? Do you have any special/unusual library installed? On Tuesday, 3 February 2015 14:48:21 UTC-6, Juozas Masiulis wrote: > > For certain reasons I could not use https for my entire webs

[web2py] Re: SQLFORM hanging on insert

2015-02-05 Thread Massimo Di Pierro
Does it hang if you use sqlite? Can you provide a minimalist app that we can try. There is nothing wrong with your code except you do not need db.commit() but it should not hurt. On Thursday, 5 February 2015 14:46:58 UTC-6, Ian W. Scott wrote: > > Hi folks. I still don't really know how to debug

Re: [web2py] Re: Question about web2py roadmap.

2015-02-05 Thread Anthony
> > > >I find customization difficult: > >adding buttons > > As you have python in views, you can manipulate server side DOM in your > view, i.e add/remove class names, create id for elements, etc. Or you can > make it through javascript. It's up to you. > > I know it's not the best way, bu

[web2py] Re: Question about web2py roadmap.

2015-02-05 Thread Anthony
> >1. *I* find customization difficult: > 1. adding buttons > 2. specifying custom validation > 3. specifying custom widgets > > Can you share examples of what you were trying to achieve and what you tried? Anthony -- Resources: - http://web2py.com - http://web2py.co

[web2py] Best practices for Lazy Tables

2015-02-05 Thread Jim S
Hi I need to take advantage of the performance boost available using lazy_table=True. My problem is that I have lots of table definitions in db.py that look like this: productSequenceTag = db.define_table('productSequenceTag', Field('productSequenceTagId',

[web2py] Problem with sessions2trash.py

2015-02-05 Thread Ivan Gazzola
#!/bin/bash while IFS= read -r app; do python /www/web2py/web2py.py --nogui --no-banner -S $app -M -R /www/web2pyscripts/sessions2trash.py -A -o -x 28800 -f >>/www/web2py/clean.txt 2>&1 done http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source cod

[web2py] Re: Problem with sessions2trash.py

2015-02-05 Thread Massimo Di Pierro
Is it possible you upgraded web2py but you have an older session2trash running? On Thursday, 5 February 2015 17:17:56 UTC-6, Ivan Gazzola wrote: > > #!/bin/bash > while IFS= read -r app; do > python /www/web2py/web2py.py --nogui --no-banner -S $app -M -R > /www/web2pyscripts/sessions2trash.py

[web2py] Re: Is there an issue with my web2py install? "can't pickle function objects"

2015-02-05 Thread Maggs
I am having this issue right now and it's when trying to set my app up in a new dev environment. I'm not using apache or wsdi. Just web2py. I am trying to open the app for the first time to create the database framework and this error is showing up after it creates my database structure. And the

Re: [web2py] Best practices for Lazy Tables

2015-02-05 Thread Richard Vézina
Jim, As far as I can see and from which I know about lazy_table you already lazy_table compliant... What have been said about it application or not once flag is set to true was that you must not define your validator outside model definition (you actually do that in your example)... You can't do

Re: [web2py] Best practices for Lazy Tables

2015-02-05 Thread Richard Vézina
>From performance stand point, I read that avoiding function definition in models files improve a lot... So, considering that you may already had reach the optimization provide by lazy_table, you may have look and make sure you didn't have defined function or class in web2py models files somewhere

[web2py] how may I get programmatically postgres field type from web2py model definition?

2015-02-05 Thread Richard
Hello, I am in the process of refactoring model definition and merging multiple table into one table with multiple columns (denormalisation) and I would like to extract programmatically the time of each of the multiple tables fields... Thanks Richard -- Resources: - http://web2py.com - http

[web2py] Re: Is there an issue with my web2py install? "can't pickle function objects"

2015-02-05 Thread Dave S
On Thursday, February 5, 2015 at 5:57:59 PM UTC-8, Maggs wrote: > > I am having this issue right now and it's when trying to set my app up in > a new dev environment. I'm not using apache or wsdi. Just web2py. > Just to beat Massimo to the initial questions: - What version of web2py? - What OS

[web2py] Re: https only on admin

2015-02-05 Thread tim spear
I think I was the first person to mention it. I just reinstalled everything from scratch on digitalocean Ubuntu 14, with the sudo ./setup-web2py-ubuntu.sh script and I still get https:// on everything eg. http://128.199.113.29/test redirects to https://128.199.113.29/test with the associated

[web2py] Re: https only on admin

2015-02-05 Thread tim spear
PS the web2py admin password on that is Password1! for the moment if you want to check it out On Friday, February 6, 2015 at 12:03:15 PM UTC+7, tim spear wrote: > > I think I was the first person to mention it. > > I just reinstalled everything from scratch on digitalocean Ubuntu 14, with > th

[web2py] Re: Best practices for Lazy Tables

2015-02-05 Thread Niphlod
response.toolbar() holds a pretty nice view of what's lazy and what's not, so what's the issue ? The deal is ideally going throughout the whole model and NEVER see ANY db.tablename, i.e. like the part in red Field('productId', db.product, label='ProductId', -- Resources: - http://web2py.com -

[web2py] Re: Problem with sessions2trash.py

2015-02-05 Thread Ivan Gazzola
I've checked but nothing found. If I try to clean sessions from admin panel I can do it. Il giorno venerdì 6 febbraio 2015 00:50:18 UTC+1, Massimo Di Pierro ha scritto: > > Is it possible you upgraded web2py but you have an older session2trash > running? > > On Thursday, 5 February 2015 17:17:56