[web2py] Re: web2py scheduler with huge output or return values always timeout (even if the task finishes)

2016-05-12 Thread Niphlod
results get stored to a tempfile. it has been recently fixed. Huge "prints" are still a problem and are discouraged, but now you can have a result as big as you wish. On Thursday, May 12, 2016 at 5:19:04 AM UTC+2, Andre Kozaczka wrote: > > I'm curious what workarounds folks have come up with reg

[web2py] Re: What's wrong with this script?

2016-05-12 Thread Fernando D. Bozzo
Well, may be there is a simple solution for this: Don't use it in a tab and open a new Window. I don't think that Chrome checks if it is the active Window or not. Regards.- El miércoles, 11 de mayo de 2016, 23:39:14 (UTC+2), Niphlod escribió: > > aside from considering a browser "as the best"

[web2py] unexpected behavior on sqlite insert

2016-05-12 Thread Sandro Javiel
Hi all, My app has model as shown below. If I use appadmin interface I can insert on tables which have some onstraints like classroom (fk: professor.id and institution.id). However using form =FORM('Nome da turma:', INPUT(_name='name', requires=IS_NOT_EMPTY()), 'Disciplina:'

[web2py] 2.14.6: Mobile plugin and shell do not work?

2016-05-12 Thread Armando Hernandez
Same situation here mobile interface not working 2.14.5-stable+timestamp.2016.04.14.03.26.16 (Ejecutando en nginx/1.9.14, Python 2.7.11+) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py

[web2py] How to create the namespaces for web2py application database

2016-05-12 Thread Chandra Bhushan Nulu
I am new to web2py and google app engine, i tried to develop simple CRUD operations web2py application have one database table like db.regiser and deploy this application in google app engine in two different regions and now i need to create the namespaces for this application database to access

[web2py] Re: How To Select Only The Latest Rows from a Table

2016-05-12 Thread Zenia Zen
*Use the argument groupby instead of distinct, and you'll get the desired results.* *so groupby fieldname2 and retrieve max(time).* *What does groupby do exactly?* 1– Does it group rows by a certain column's values – *such that repeating values are hidden*? 2– Does it group rows by a certai

[web2py] Re: How to create the namespaces for web2py application database

2016-05-12 Thread Kiran Subbaraman
Will this help you: http://web2py.com/books/default/chapter/29/13/deployment-recipes#Using-replicated-databases ? On Thursday, May 12, 2016 at 2:27:29 PM UTC+5:30, Chandra Bhushan Nulu wrote: > > I am new to web2py and google app engine, i tried to develop simple CRUD > operations web2py appl

[web2py] Re: How to create the namespaces for web2py application database

2016-05-12 Thread Anthony
Answered on Stack Overflow: http://stackoverflow.com/a/37139874/440323 On Thursday, May 12, 2016 at 4:57:29 AM UTC-4, Chandra Bhushan Nulu wrote: > > I am new to web2py and google app engine, i tried to develop simple CRUD > operations web2py application have one database table like db.regiser an

[web2py] Grid remove class date/datetime

2016-05-12 Thread isi_jca
Hi!!! Is possible to remove class date/datetime from form Grid?. Thanks in advance -- 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 mes

[web2py] Re: How to take HTML tag out out of list string, in set

2016-05-12 Thread rajjmatthur
Notice that render() option doesn't always shows up. my_post = db.Post(request.args(0)). render (represent that field) is not available even though its But for example: posts = db().select(db.Post.all). Its also a and I can do render(). But we still have list string in my_post like you ha

[web2py] Re: How to take HTML tag out out of list string, in set

2016-05-12 Thread Anthony
On Thursday, May 12, 2016 at 9:10:33 AM UTC-4, rajjmatt...@gmail.com wrote: > > Notice that render() option doesn't always shows up. > > my_post = db.Post(request.args(0)). render (represent that field) is not > available even though its > > But for example: > > posts = db().select(db.Post.all).

[web2py] Re: unexpected behavior on sqlite insert

2016-05-12 Thread Anthony
How are you doing the insert? Is it via application code during an HTTP request, or in the shell or a script. If the latter, you need to call db.commit() to commit any changes to the database (this is done automatically in the context of HTTP requests). Anthony On Thursday, May 12, 2016 at 4:5

[web2py] change dropdown menu login

2016-05-12 Thread Alessio Varalta
Hi, I want to change the dropdown menu in the rigth corner of the web2py application. I don't want the text Login but a icon..I see that the code is imported with {{='auth' in globals() and auth.navbar('Welcome',mode='dropdown') or ''}} But where is defined this code? -- Reso

[web2py] Re: again on javascript chart

2016-05-12 Thread Anthony
On Wednesday, May 11, 2016 at 9:39:17 AM UTC-4, Paolo Amboni wrote: > > *Since it seems an hot topic:* > > witch js library works better with web2py - python - (pandas) to plot some > nice charts? > The question is really which works best with Python/Pandas (web2py is irrelevant), and for that y

[web2py] Scheduler - limit on how large the result can be?

2016-05-12 Thread Andre Kozaczka
This question is in reference to Brad's post a couple years ago: https://groups.google.com/forum/#!searchin/web2py/scheduler$20results/web2py/WM7cyrUV5-U/49JVuq5uL0wJ Is there a limit on how large a "result" from a scheduled task can be? If so, how are folks working around this? My site parses s

[web2py] Re: Scheduler - limit on how large the result can be?

2016-05-12 Thread Alfonso Serra
A Task's run_output and run_result fields types are mapped to LONGTEXT if you are using mysql, this is 4gb storage capacity. Python strings should be around 3Gb depending on your system's ram amount. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.co

[web2py] Re: again on javascript chart

2016-05-12 Thread Paolo Amboni
Ok, thanks. After long searching on the web i choose Chart.js. It seems very simple to use (in the web2py filosofy). I'll build my own library to port the data form "pyadl" or from pandas!! Il giorno giovedì 12 maggio 2016 15:42:38 UTC+2, Anthony ha scritto: > > On Wednesday, May 11, 2016 at 9

Re: [web2py] Highcharts in web2py

2016-05-12 Thread Alfonso Serra
Actually is quite easy. Prepare some data on your controller: import json def index(): ... #get some rows from any source countries = XML(json.dumps([[r.country_name, r.population] for r in rows ])) At your view: //declare the libraries here, jquery hc, etc

[web2py] Re: Thread with own db connection

2016-05-12 Thread Alfonso Serra
I kinda have it but its very bad. i have to declare the connection as: class customthread(Thread): def __init__ self.db = DAL(cnnstring, migrate=False) self.db['dontclose'] = True At gluon/packages/pydal/connection.py wich handles the ConnectionPool modify the line 56

[web2py] list:reference how to show option popup instead of plain id's?

2016-05-12 Thread Mirek Zvolský
Friends, what I do wrong? I want that user always can see 'name' instead of plain 'id' In model I have related table with format: format=lambda r: r.name And in the master table I define the list:reference field so: Field('ekosystemtypes', 'list:reference ekosystemtypes', r

[web2py] Re: list:reference how to show option popup instead of plain id's?

2016-05-12 Thread Mirek Zvolský
oops, when I remove requires= completly, i.e. when I run with default IS_IN_DB validator, then I see a different widget (probably a proper one): all choices listed, and I can choose more rows using Ctrl+click. So probably I should write better requires= When I replace: [IS_NOT_EMPTY(), IS_IN

[web2py] How to take javascript variables from one view to a different view using ?

2016-05-12 Thread Steve Joe
syntax for the same? -- 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-us

[web2py] How to take javascript variables from one view to a different view?

2016-05-12 Thread Steve Joe
can u write syntax for the same? -- 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] Re: Scheduler - limit on how large the result can be?

2016-05-12 Thread Niphlod
this has been solved recently (the result couldn't be larger than 64k on most platforms). Right now it has no limitations, although its surely finite. Please do keep in mind that (on top of your task being forced to pass around big chunks of data) result is always json string. Whenever you nee

[web2py] Re: change dropdown menu login

2016-05-12 Thread Niphlod
gluon.tools is the place where Auth lives. On Thursday, May 12, 2016 at 3:39:30 PM UTC+2, Alessio Varalta wrote: > > Hi, I want to change the dropdown menu in the rigth corner of the web2py > application. I don't want the text Login but a icon..I see that the code is > imported with > > >

[web2py] Re: How to take javascript variables from one view to a different view?

2016-05-12 Thread Dave S
On Thursday, May 12, 2016 at 12:24:39 PM UTC-7, Steve Joe wrote: > > can u write syntax for the same? > This question could mean either of 1) How do I share javascript data between 2 pages? or 2) How do I copy javascript code from one template to another. If you meant 1), then my guess at the an

[web2py] Re: How to take javascript variables from one view to a different view?

2016-05-12 Thread Dave S
On Thursday, May 12, 2016 at 12:57:07 PM UTC-7, Dave S wrote: > > On Thursday, May 12, 2016 at 12:24:39 PM UTC-7, Steve Joe wrote: >> >> can u write syntax for the same? >> > > This question could mean either of > > 1) How do I share javascript data between 2 pages? > or > 2) How do I copy javasc

[web2py] Re: web2py 2.14.6 is OUT

2016-05-12 Thread Dave S
On Monday, May 9, 2016 at 5:31:38 PM UTC-7, Massimo Di Pierro wrote: > > A few vulnerabilities have been found in admin. One of them was serious > and it made admin vulnerable to brute force password attacks under some > conditions. > They have been been fixed in version 2.14.6. If you expose adm

[web2py] Are web2py apps safe from xss attacks?

2016-05-12 Thread Steve Joe
how? -- 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 u

[web2py] Re: Are web2py apps safe from xss attacks?

2016-05-12 Thread Anthony
As long as you're allowed to write your own code, nothing is safe, but one thing web2py does to help protect against XSS attacks is to automatically escape all content inserted in views. Anthony On Thursday, May 12, 2016 at 4:14:00 PM UTC-4, Steve Joe wrote: > > how? -- Resources: - http://we

[web2py] Applying Custom Navigation to web2py

2016-05-12 Thread Ron Chatterjee
Trying to create a custom navigation using menu.py intact. Leveraging from this link: http://bootsnipp.com/snippets/featured/fancy-sidebar-navigation I modified the layout.html as it comes from the welcome app to following. Result is a horrible looking navbar. Why? # using sidebars need

[web2py] Re: unexpected behavior on sqlite insert

2016-05-12 Thread Sandro Javiel
HI Anthony, I have a function in controller group exposed using url group/new def new(): if(session.auth is not None and session.auth.user.id is not None): user_id = session.auth.user.id professor_id = db(db.professor.id == user_id).select(db.professor.id)[0]['id'] p

[web2py] Re: unexpected behavior on sqlite insert

2016-05-12 Thread Sandro Javiel
In fact form is processed and new classroom is created, however with insititution and professor equals None: Em quinta-feira, 12 de maio de 2016 20:45:35 UTC-3, Sandro Javiel escreveu: > > HI Anthony, > > I have a function in controller group exposed using url group/new > > def new(

[web2py] Re: unexpected behavior on sqlite insert

2016-05-12 Thread Anthony
Not sure what the problem is. How are you determining whether the insert was successful? Do you flash message after submitting the form? What does the view look like? Also, a few notes on your code: def new(): > if(session.auth is not None and session.auth.user.id is not None): > us

[web2py] Re: unexpected behavior on sqlite insert

2016-05-12 Thread Sandro Javiel
I just figured out the problem is in *request.vars.professor_inst_id* and *request.vars.professor_id*How should I access form field names professor_inst_id for instance? Tkx Em quinta-feira, 12 de maio de 2016 21:00:09 UTC-3, Sandro Javiel escreveu: > > In fact form is processed and new cla

[web2py] Re: How To Select Only The Latest Rows from a Table

2016-05-12 Thread PRACHI VAKHARIA
*Use the argument groupby instead of distinct, and you'll get the desired results.* *so groupby fieldname2 and retrieve max(time).* *What does groupby do exactly?* 1– Does it group rows by a certain column's values – *such that repeating values are hidden*? 2– Does it group rows by a certai

[web2py] Re: unexpected behavior on sqlite insert

2016-05-12 Thread Anthony
form.vars.professor_inst_id. But it should also be in request.vars.professor_inst_id. On Thursday, May 12, 2016 at 8:17:43 PM UTC-4, Sandro Javiel wrote: > > I just figured out the problem is in > *request.vars.professor_inst_id* > and > > > *request.vars.professor_id*How should I access form

[web2py] Re: unexpected behavior on sqlite insert

2016-05-12 Thread Sandro Javiel
Thanks a lot for general comments regarding user validation. User is not expected to edit professor_id neither institution_id. Anyway such information should be stored in classroom table. I tried to use SQLFORM(db.classroom), but I don´t want to allow use choose both Ids. Is there an alternat

[web2py] Re: Grid remove class date/datetime

2016-05-12 Thread isi_jca
Hello!!! In my particular case, I wrote this code in my view: jQuery('input#tmatrizlaboral_fecingreso').removeClass('date form-control'); Greetings. El jueves, 12 de mayo de 2016, 9:45:07 (UTC-3), isi_jca escribió: > > Hi!!! > > Is possible to remove class date/datetime from form Grid?. > >

[web2py] Re: unexpected behavior on sqlite insert

2016-05-12 Thread Anthony
On Thursday, May 12, 2016 at 9:25:02 PM UTC-4, Sandro Javiel wrote: > > Thanks a lot for general comments regarding user validation. > > User is not expected to edit professor_id neither institution_id. Anyway > such information should be stored in classroom table. > > I tried to use SQLFORM(db.

[web2py] Re: Scheduler - limit on how large the result can be?

2016-05-12 Thread Andre Kozaczka
Ah, well by "recently" I'm guessing you mean within the last 6 months. I just did an update and works now :) Thanks for the additional advice - I will have the scheduled task return a TABLE(). Now I need to take a closer look at your w2p_tvseries code to get the PeriodicalUpdater to work. -And

[web2py] Re: unexpected behavior on sqlite insert

2016-05-12 Thread Sandro Javiel
Hi Anthony, I fixed all things related to id and auth as you pointed and decided to use form with just name and subject. In the case of success in insert I used new id to update professor and institution information. Tkx again for the support. I am enjoying pretty much web2py and I´ll used in