[web2py] Re: SQLFORM.grid question

2017-04-26 Thread Jim Russell
On Tuesday, April 25, 2017 at 9:19:59 AM UTC-5, Anthony wrote: > > On Tuesday, April 25, 2017 at 3:20:23 AM UTC-4, Jim Russell wrote: >> >> I worked around this by setting the wltype field to string and adding >> a requires=IS_IN_SET. This makes the editing page have a dropdown with the >> set

Re: [web2py] Re: btw: great job

2017-04-26 Thread José Luis Redrejo
I recognize all what Massimo has done, of course, and to all the contributors. Web2py is always my first option whenever I need to choose a web framework. However, I also think we have to thank to people like Anthony, Niphlod or in the past Bruno Rocha or Jonathan Lundell who have been providing su

Re: [web2py] btw: great job

2017-04-26 Thread Massimiliano
+1 On Sun, Apr 23, 2017 at 5:35 AM, lucas wrote: > hey everyone, > > I think we should recognize and congratulate Massimo and the developers of > web2py. its been nearly a year since the last production update and the > whole platform is just excellent. > > it is the most stable platform I've e

[web2py] How to change menu bar background and font colors

2017-04-26 Thread Karoly Kantor
I am a little embarrassed to ask this, but I've been trying to do this for hours now... I find outdated info only in various posts. So, how exactly do I change the menu bar background and font colors? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com

[web2py] Re: scheduled task ignoring period

2017-04-26 Thread James Holstead
I've tried returning 0,1,2,None. It behaves the same regardless. There is only one user in my development database: DEBUG:web2py.app.myapp:Found user: 123456789 DEBUG:web2py.app.myapp:Updated. DEBUG:web2py.app.myapp:new task report: COMPLETED DEBUG:web2py.app.myapp: result: 1 DEBUG:

[web2py] Creating a custom authentication method through http request by passing credentials in URL

2017-04-26 Thread Oasis Agano
Hello, I'm trying to create a method that gets credentials from the url as arguments and works as the normal login of web2py then return a token or session id. is there a safe way of doing it. kr oasis -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.

[web2py] Re: UPDATE BOOTSTRAP VERSION FROM 3 TO 4

2017-04-26 Thread Leonel Câmara
The forms in Boostrap 4 are pretty much the same as in bootstrap 3, you do need to change some stuff in the menu and grid. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Re

Re: [web2py] Re: UPDATE BOOTSTRAP VERSION FROM 3 TO 4

2017-04-26 Thread Áureo Dias Neto
Yes Leonel, when I update the files to bootstrap 4, only have problems with grid and the nav's -- 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 receive

Re: [web2py] Re: btw: great job

2017-04-26 Thread Dave S
On Wednesday, April 26, 2017 at 12:46:17 AM UTC-7, José L. wrote: > > I recognize all what Massimo has done, of course, and to all the > contributors. Web2py is always my first option whenever I need to choose a > web framework. > However, I also think we have to thank to people like Anthony, N

[web2py] Re: scheduled task ignoring period

2017-04-26 Thread Dave S
On Wednesday, April 26, 2017 at 6:09:30 AM UTC-7, James Holstead wrote: > > I've tried returning 0,1,2,None. It behaves the same regardless. There is > only one user in my development database: > > DEBUG:web2py.app.myapp:Found user: 123456789 > > DEBUG:web2py.app.myapp:Updated. > > DEBUG:web

Re: [web2py] Re: btw: great job

2017-04-26 Thread Alfonso Serra
Great initiative, Lucas. My thanks to Massimo, Anthony, Niphlod and everybody helping and collaborating in the past, present and future of this wonderful framework. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Re: scheduled task ignoring period

2017-04-26 Thread James Holstead
Status is COMPLETED in the scheduler_run table, run time of about 5 seconds. Checking the scheduler_task table I'm noticing the next_run_time is 1 day ahead. period is 86400, repeats is 0, times_run is 1 Thanks for the help! > The next check is the entries in the "scheduler_run" table, which

{Disarmed} Re: {Disarmed} Re: [web2py] Re: btw: great job

2017-04-26 Thread Carlos Cesar Caballero Díaz
+1, even better, +100 :) Greetings. El 26/04/17 a las 15:53, Alfonso Serra escribió: Great initiative, Lucas. My thanks to Massimo, Anthony, Niphlod and everybody helping and collaborating in the past, present and future of this wonderful framework. -- Resources: - http://web2py.com - http

[web2py] Re: Creating a custom authentication method through http request by passing credentials in URL

2017-04-26 Thread Dave S
On Wednesday, April 26, 2017 at 6:46:07 AM UTC-7, Oasis Agano wrote: > > Hello, > > I'm trying to create a method that gets credentials from the url as > arguments and works as the normal login of web2py then return a token or > session id. > is there a safe way of doing it. > > kr > oasis > B

[web2py] Re: How to change menu bar background and font colors

2017-04-26 Thread Dave S
On Wednesday, April 26, 2017 at 5:20:12 AM UTC-7, Karoly Kantor wrote: > > I am a little embarrassed to ask this, but I've been trying to do this for > hours now... I have found various items in the css files i was sure at the > time they would do the job, but none of them had any impact eventu

[web2py] Re: Creating a custom authentication method through http request by passing credentials in URL

2017-04-26 Thread Anthony
Not a good idea to put login credentials in a URL -- see http://stackoverflow.com/a/3150712/440323. Anthony On Wednesday, April 26, 2017 at 9:46:07 AM UTC-4, Oasis Agano wrote: > > Hello, > > I'm trying to create a method that gets credentials from the url as > arguments and works as the normal

[web2py] Re: scheduled task ignoring period

2017-04-26 Thread Anthony
Do you have more than one of the same task getting scheduled? Where is this line: myScheduler.queue_task('myfunc', repeats=0, period=86400, timeout=1200, prevent_drift=True, immediate=True) If it is in a model file, every time the model file is accessed (including whenever a scheduler task is

[web2py] Re: The Almighty Form

2017-04-26 Thread Alfonso Serra
This is great i have found a way to have full control on how a form is displayed and behave other than writing mystyle(form) in a view. This is how it would look like: def stylefrm(self): #create any custom header or form.custom.begin frm = FORM(_class="myform") #iterate over the

Re: [web2py] Re: The Almighty Form

2017-04-26 Thread Carlos Costa
Great tip. I did something similar, but in views. I wrote a function to take a form and break it into a giver number of columns using bootstrap grid classes. The default stacked layout gets pretty boring with time. 2017-04-26 18:18 GMT-03:00 Alfonso Serra : > This is great i have found a way to

[web2py] Re: How can I union 2 different table datasets?

2017-04-26 Thread Alfonso Serra
You can try: sql = """ SELECT * FROM table1 UNION SELECT * FROM table2""" rows = db.executesql(sql, fields = [ Field("name", "string") , Field("age", "integer") , Field("apt_time", "datetime") ]) Always that both tables are the same size and types. Then style your view however you like.

[web2py] Re: How can I create a DAL Select statement from a SQL exists clause?

2017-04-26 Thread Massimo Di Pierro
Unfortunately you will have to use db.executesql for this. On Friday, 21 April 2017 10:17:51 UTC-5, George D Elig wrote: > > I have the following SQL statement that I'm having difficulty converting > to a db()Select statement. I could use a left join but I can only return > one row, which is be

[web2py] Re: Allowing external access to web2py server ?

2017-04-26 Thread Massimo Di Pierro
You have to find out which other process is using port 80 and kill it. You can do it with netstat: netstat -a -b On Friday, 21 April 2017 10:17:51 UTC-5, sebas mora wrote: > > Help please! Im trying to access my web2py server on a Rpi from another > device to run an application that is on the s

[web2py] Re: not authorised flash message when I used SQLFORM.grid, but worked fine with SQLFORM.smartgrid

2017-04-26 Thread Massimo Di Pierro
Strange what is the url that you are using to access this page? On Saturday, 22 April 2017 03:19:15 UTC-5, Rudy wrote: > > Hi there, > > It feels really strange to me that when i used SQLFORM.grid(), I got a > flash message "not authorised", but when i used smartgrid(), it worked just > fine (in

[web2py] Re: Is web2py incompatible with 2nd generation Google Cloud SQL ?

2017-04-26 Thread Massimo Di Pierro
I have not tried it but I have an interest in it. I will try asap and will make sure it works. On Tuesday, 25 April 2017 00:54:08 UTC-5, Karoly Kantor wrote: > > Dear Sirs, > > I can connect my Google App Engine web2py app to a first generation GAE > SQL instance, but not to a second generation

[web2py] Re: quesAn idea to speed up web2py in production

2017-04-26 Thread Massimo Di Pierro
web3py will handle this with imports and it is 10x faster. Will have a prototype out soon. On Tuesday, 25 April 2017 10:47:10 UTC-5, JorgeH wrote: > > > Hello > > I've just had an idea that came to mind. But I'm unsure of its feasability. > > > Can a script be made with pytest ( or something simi

[web2py] Re: lack of documentation

2017-04-26 Thread jean-michel . gaite
Hi, I'm starting with web2py, it seems a very powerfull tool. But concerning the documentation, it's difficult to read : in this document (see link above) it's OK from the beginning up to 75%. After the 75% the explainations and the code (in 'code' box) are inverted. Who is in charge of this, in

[web2py] rocket run https and http in *.nix

2017-04-26 Thread 黄祥
*in windows run_rocket_web2py.bat* @echo off set command=C:\Python27\python.exe web2py.py set certificate=abadijaya.crt set key=abadijaya.key set interfaces=0.0.0.0:80;0.0.0.0:443:abadijaya.key:abadijaya.crt set port=443 start %command% -c %certificate% -k %key% --interfaces=%interfaces% -p %por

[web2py] Posible bug in SQLFORM

2017-04-26 Thread Alfonso Serra
I have declared a table as db.define_table("agencies", Field("hotel", "reference hotels", notnull=True), Field("subgroup", "reference subgroups", label="Subgroup"), Field("agency", "string", length=100, writable= False, label="Agency", notnull=True), Field("alias", "string"), F

[web2py] Re: Posible bug in SQLFORM

2017-04-26 Thread Alfonso Serra
Before i drive you crazy, i have commented the function SQLFORM.createform so i could implement my own form styles just passing the SQLFORM instance to a function like: def renderform(self): style = self.formstyle return str(self.formstyles[style](self)) response.formstyle = "d

[web2py] Re: Is web2py incompatible with 2nd generation Google Cloud SQL ?

2017-04-26 Thread Karoly Kantor
Thanks, Massimo. FYI, some more info that might be helpful in your investigation: Google docs tell me that my app is granted access to the SQL instance by default, as it is in the same project with the Cloud SQL license, so there's nothing to do there. Also, I set a password for the root user i