[web2py] Cant access Google Cloud SQL on GAE application

ver.py:116] Starting admin server at: http://localhost:8000 but when I try to open my app url: http://localhost:8080/trahello I get the following error. Traceback (most recent call last): File "/home/bernardo/PycharmProjects/w2p_trahello/web2py/gluon/restricted.py", line 219, in

[web2py] Re: How to customize widgets to act like Onsen UI components

You are right, thank you! El sábado, 16 de septiembre de 2017, 17:58:36 (UTC-5), Anthony escribió: > > On Saturday, September 16, 2017 at 4:23:43 PM UTC-4, Bernardo Leon wrote: >> >> Awesome as always Anthony Thank you! >> >> Yes I am talking about the SQLFORM Field

[web2py] Re: How to customize widgets to act like Onsen UI components

s -- see the various > widget classes in gluon.sqlhtml. Once you've got some custom widgets, you > could then monkey patch SQLFORM.widgets by overwriting some or all of its > items with your custom classes -- then your custom widgets will be the > defaults used by SQLFORM. > >

[web2py] How to customize widgets to act like Onsen UI components

I have been researching about UI Frameworks and stumbled upon Onsen UI . It seems easy and provides good results but to use this UI Framework I need to use their components which are html tags. If I have a field that is rendered as an html input how can I customize its

[web2py] Re: response.js does not execute in the oncreate callback

Hi Massimo, done. The issue is #1693 Try to take a look at it please, thank you! El sábado, 22 de julio de 2017, 15:35:57 (UTC-5), Massimo Di Pierro escribió: > > Please open a ticket about this it gets tracked. > > On Thursday, 20 July 2017 20:43:40 UTC-5, Bernardo Leon wrote: &g

[web2py] Re: Is a good practice add .table files to source control?

You are right, maybe a development server and a production server could have different .table files but share the same model file. There is no problem for us to keep one of our versions with fake_migrate=True. Can we switch who is using migrate=True? What happens if both of us use migrate=True

[web2py] Re: Page with four LOAD components is too slow

It seems that you are right, I set up a virtual machine with 4gb ram only for the database and I ran the code along with redis on my laptop with 16gb ram and my times now are nearly the 600ms. I think it is good enough. Having some components that don't perform selects rendering only a simple

[web2py] response.js does not execute in the oncreate callback

Hello, I have a component which has an SQLFORM.grid and an oncreate and ondelete callbacks on which I execute a response.js. When I delete a record the response.js javascript function is executed but when I create a record the response.js javascript function does not get executed (but the

[web2py] Re: Page with four LOAD components is too slow

Yes, the application, redis and the database are in the same server. This server has 512 MB of RAM but I don't think I am using all the ram. I have 48mb free right now. Regarding the code, it just makes simple selects on one or two tables (the querys arent doing anything weird). Do you still

[web2py] Is a good practice add .table files to source control?

If two developers use git to develop an application and obviously they have their model file on git do they need to have the same .table files? I have a postgresql development database on a digitalocean server and my partner is unable to connect to the database that I created originally even

[web2py] Re: Page with four LOAD components is too slow

don't think it is an application issue. Is it ok? Thank you El miércoles, 19 de julio de 2017, 11:51:22 (UTC-5), Bernardo Leon escribió: > > Hi, I am facing a problem with performance. I have a view with four LOAD > calls that is taking almost 15 seconds to load. I know

[web2py] Re: app slow on pythonanywhere

I am using now redis for session handling on the same machine of the webserver and got rid of big fcntl.flock lock. Thank you so much for your help! El martes, 18 de julio de 2017, 23:04:33 (UTC-5), Bernardo Leon escribió: > > Thank you for your answer, Indeed I am using several ajax re

[web2py] Re: Can't log into the application if using redis for sessions

Thank you so much! I've been as dumb as fry ;) Now I can log in without issues. El miércoles, 19 de julio de 2017, 9:41:03 (UTC-5), Leonel Câmara escribió: > > Nevermind I found your problem. You are connecting the Session after > instantiating Auth. You need to do it before as Auth checks

[web2py] Re: Can't log into the application if using redis for sessions

Thank you for your answer, I installed redis as localhost and changed that line to use RConn() without parameters unfortunately I am still getting the same problem. If I run: redis-cli KEYS "*" I get 3 keys created 1) "w2p:sess:app:serial" 2) "w2p:sess:app:1" 3) "w2p:sess:app:id_idx" So I

[web2py] Re: app slow on pythonanywhere

Thank you for your answer, Indeed I am using several ajax requests and I am not able to use session.forget(response) on my components since I need the session information. I have installed redis to test but now I am facing another problem that I have detailed here:

[web2py] Can't log into the application if using redis for sessions

Hi, I want to use redis to handle my app sessions. I am using the next code in my model: from gluon.tools import Auth from gluon.contrib.redis_utils import RConn from gluon.contrib.redis_session import RedisSession gth_dev_db_connection_string = 'postgres://dev_db:dev_db@[ip]/dev_db' db =

[web2py] Re: app slow on pythonanywhere

I am sorry for resurrecting this post but I am facing the same problem. Using the web2py -F profile option and then reading that dump with runsnakerun I see that fcntl.flock is where more time is spent. I have disabled migrations in the appconfig.ini and in the DAL constructor but I am still

[web2py] Re: best way to put together components that interact between them

sexta-feira, 24 de fevereiro de 2017 18:25:42 UTC-3, Bernardo Leon > escreveu: >> >> Hi, I am trying to create a page that uses 3 components. I want each >> component to be reusable. >> >> The first component is a search box, based on the search box result I

[web2py] Re: best way to put together components that interact between them

reload method of jquery lib to reload the > div that contains the component ( Other approach ) > > Em sexta-feira, 24 de fevereiro de 2017 18:25:42 UTC-3, Bernardo Leon > escreveu: >> >> Hi, I am trying to create a page that uses 3 components. I want each >> comp

[web2py] Re: best way to put together components that interact between them

ion ? > > Em sexta-feira, 24 de fevereiro de 2017 18:25:42 UTC-3, Bernardo Leon > escreveu: >> >> Hi, I am trying to create a page that uses 3 components. I want each >> component to be reusable. >> >> The first component is a search box, based on the search

[web2py] best way to put together components that interact between them

Hi, I am trying to create a page that uses 3 components. I want each component to be reusable. The first component is a search box, based on the search box result I want to load the second component (a grid) with the first result as a parameter. When I click on a link in the second component

[web2py] Re: Problem while integrating Sweet Alert with web2py in a component

does your pedir() function then > receive the proper value of pid? > > Anthony > > On Tuesday, January 3, 2017 at 11:06:33 AM UTC-5, Bernardo Leon wrote: >> >> Hi, I have a component which has a button that performs an action when >> clicked but I want the user acce

[web2py] Problem while integrating Sweet Alert with web2py in a component

Hi, I have a component which has a button that performs an action when clicked but I want the user accept some terms before executing that action. I found Sweet Alert (http://t4t5.github.io/sweetalert/) so I am trying to use their confirm dialog between the click and the action. Since Sweet

[web2py] Is it possible to run doctests for scheduler tasks?

Hi, I have seen in the book that running web2py with the -T flag I can run doctests for my controllers but I want to run doctests for my scheduler tasks. Is it possible? How? Thank you! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Why cant fetch rows using select when importing models using the -M option?

questions ;) El martes, 4 de octubre de 2016, 11:19:50 (UTC-5), Anthony escribió: > > On Tuesday, October 4, 2016 at 10:36:57 AM UTC-4, Bernardo Leon wrote: >> >> Now if I only run >> >> db(db.my_table.logged_user == 1)._select() >> >> I get: >

[web2py] Re: Why cant fetch rows using select when importing models using the -M option?

! El lunes, 3 de octubre de 2016, 12:20:21 (UTC-5), Bernardo Leon escribió: > > Thanks for noting it, now I am passing the user id as part of pvars of the > task but with not much progress, though > > If I run that query I get an empty list: [] > > El lunes, 3 de octubre de

[web2py] Re: Why cant fetch rows using select when importing models using the -M option?

What happens if you do (note the ._select rather than .select): > > db.executesql(db(db.my_table.logged_user == 1)._select()) > > Anthony > > On Monday, October 3, 2016 at 12:40:09 PM UTC-4, Bernardo Leon wrote: >> >> I load my application in this way: >> $ python

[web2py] Why cant fetch rows using select when importing models using the -M option?

I load my application in this way: $ python web2py.py -M -S myexistingapp if I run: db(db.my_table.logged_user == auth.user_id).select() I get: even if I run: db(db.my_table.logged_user == 1).select() or db(db.my_table.logged_user == 1L).select() I get: but if I run:

[web2py] Re: Scheduler task runs before it is supposed to run

y workers, or a too low heatbeat) > > this is the fix https://github.com/web2py/web2py/pull/1453 . you can > subscribe to it to know when it'll be merged. > > On Tuesday, September 20, 2016 at 5:38:08 PM UTC+2, Bernardo Leon wrote: >> >> Thank you for your reply. Ca

[web2py] Re: Scheduler task runs before it is supposed to run

. El lunes, 19 de septiembre de 2016, 13:37:05 (UTC-5), Niphlod escribió: > > sorry, a bug slipped in. In the wait for the fix, please use next_run_time > in addition to start_time. > > On Monday, September 19, 2016 at 6:27:28 PM UTC+2, Bernardo Leon wrote: >> >> H

[web2py] Scheduler task runs before it is supposed to run

Hi, I am trying to run tasks in the future based on a time the user specifies but as soon as the task is queued it is executed, what am I doing wrong? I am using web2py Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 This is my model.db (part of it) db =

[web2py] Re: Is it possible reload my model.py from an ajax request?

return the new HTML > (or return the relevant data needed for the JS code to construct the HTML). > > Anthony > > On Friday, August 5, 2016 at 4:19:22 PM UTC-4, Bernardo Leon wrote: >> >> The thing is I have already tried that but I got no luck, I know my >> controller

[web2py] Re: Is it possible reload my model.py from an ajax request?

something wrong with my code? Because my onChangeRedTrafico() controller method (where I change the validator) gets called but nothing happens Thanks El viernes, 5 de agosto de 2016, 13:58:02 (UTC-5), Anthony escribió: > > On Friday, August 5, 2016 at 12:28:44 PM UTC-4, Bernardo Leo

[web2py] Re: Is it possible reload my model.py from an ajax request?

; http://demos.telerik.com/kendo-ui/dropdownlist/cascadingdropdownlist > > might help > > On Friday, August 5, 2016 at 1:28:01 PM UTC-4, Bernardo Leon wrote: >> >> No, I am trying to get the cascade dropdowns working. >> >> I want to make an AJAX call from the parent dropdown AN

[web2py] Re: Is it possible reload my model.py from an ajax request?

call from the parent dropdown without refreshing the child? > > On Friday, August 5, 2016 at 11:28:44 AM UTC-5, Bernardo Leon wrote: >> >> Hi, I have an SQLFORM.grid form and when I am inserting data I want to >> make the selectors work in cascade. I have seen some recip

[web2py] Is it possible reload my model.py from an ajax request?

Hi, I have an SQLFORM.grid form and when I am inserting data I want to make the selectors work in cascade. I have seen some recipies where they create by hand the form using plain html and throw some jQuery in the middle but I dont like it, I like the cleaness of web2py so I am looking for a

[web2py] Re: auth.settings.auth_two_factor_enabled = True gives me setting key 'auth_two_factor_enabled' does not

Thanks for your reply, I was making a mistake. I have been calling auth.define_tables(...) before auth.settings.extra_fields['auth_user'] = [Field()] I have switched between them and now I have my field in the database so thank you :) Now I have Google authentication working, thank you

[web2py] Re: auth.settings.auth_two_factor_enabled = True gives me setting key 'auth_two_factor_enabled' does not

with the extra_field issue? What am I doing wrong? And thank you for your help ;) El domingo, 17 de julio de 2016, 12:22:21 (UTC-5), Anthony escribió: > > On Sunday, July 17, 2016 at 12:53:40 PM UTC-4, Bernardo Leon wrote: >> >> Thank you for your reply >> >> my web2py ver

[web2py] Re: auth.settings.auth_two_factor_enabled = True gives me setting key 'auth_two_factor_enabled' does not

Thank you for yor reply my web2py version is: Version 2.12.3-stable+timestamp.2015.08.19.00.18.03 I am defining one extra field auth.settings.extra_fields['auth_user'] = [Field('motp_secret', 'password', length=512, default='', label='MOTP Secret')] What I am trying to do is implementing

[web2py] Re: dumbest question ever: how do you jump to line in the w2p ide

El viernes, 3 de junio de 2016, 16:51:01 (UTC-5), Mark Billion escribió: > > I cant find this anywhere, but Ive seen it somewhere. Say Im editing in > the admin application and want to jump to line 1000. Whats the key binding > for it? > > Feel free to heckle as long as you also provide the

[web2py] Re: dumbest question ever: how do you jump to line in the w2p ide

Mmm I have no idea but can I suggest you to use pycharm? After all it integrates with web2py and being a full teatured IDE you can jump to lines, set breakpoints, code completion and more, check this: https://www.jetbrains.com/help/pycharm/2016.1/web2py.html El viernes, 3 de junio de 2016,

[web2py] auth.settings.auth_two_factor_enabled = True gives me setting key 'auth_two_factor_enabled' does not

Hello, I am trying to use two factor authentication for my entire app so I have my model like this: db = DAL('sqlite://database.db', migrate_enabled=False, lazy_tables=True) auth = Auth(db) auth.define_tables(username=True, signature=True) auth.settings.actions_disabled.append('register')

[web2py] Re: 'Query' object has no attribute 'tablename' when using show_if

Auth role, so you probably > want something like: > > db.table.field.readable = db.table.field.writable = auth.has_membership(2) > > Anthony > > On Monday, June 20, 2016 at 5:53:27 PM UTC-4, Bernardo Leon wrote: >> >> Hi, a am using show_if to show a field onl

[web2py] 'Query' object has no attribute 'tablename' when using show_if

Hi, a am using show_if to show a field only if the user is a member of a certain group, I am using this query: *db.table.field.show_if = **(db.auth_membership.user_id == auth.user_id) & (db.auth_membership.group_id == 2)* but it gives me this error: 'Query' object has no attribute 'tablename'

[web2py] Re: default_application does not work on 2.14.6 version

in the model file: response.title = 'yourappname' And that's it, I hope it could help to someone else. El domingo, 15 de mayo de 2016, 10:48:35 (UTC-5), Bernardo Leon escribió: > > Good morning, I just clone the github repository and then create a > routes.py file in the web2

[web2py] default_application does not work on 2.14.6 version

Good morning, I just clone the github repository and then create a routes.py file in the web2py folder. This file only have one line: default_application = 'myapplication' but it does not, when I try to load my site it defaults to the welcome application, the only way it works is changing its

[web2py] How can I set the column width of a SQLFORM.grid table?

Hello, I have this table in my model: db.define_table('data', Field('description', 'string'), Field('value', 'integer')) this controller in default.py: def index(): tableN = SQLFORM.grid(db.data, maxtextlengths={'data.description':500})

[web2py] Problems installing web2py in a virtualenv in Windows 7

I'm new to Python and I'm trying to install web2py in a virtualenv. I'm running a 32 bit python 2.7.3 installation on a 64 bit Windows 7. From what I read, this should be the process: - install virtualenv (done) - create the virtualenv (done) - install pywin32 in that env (I've read

Re: [web2py] Re: 1.93.2 broken update_record!

Hi Clayton, How did you fix it? Thanks for your help, Bernardo 2011/3/7 Clayton clayton.grass...@gmail.com Issue 210: Typo in gluon.dal.update_record Patched it manually to get my app up and running. This breaks a lot of apps; how soon can a new release get out? Clayton On Mar 7

Re: [web2py] Re: 1.93.2 broken update_record!

Ok, On line 4776 should appear the following: colset[k] = v kind regards, Bernardo 2011/3/8 Bernardo Botella Corbí estem...@gmail.com Hi Clayton, How did you fix it? Thanks for your help, Bernardo 2011/3/7 Clayton clayton.grass...@gmail.com Issue 210: Typo

Re: [web2py] Re: Upload file default

leave the upload field blank at the form, in database imagen appears with None value. Am I doing anything wrong? thanks a lot, Bernardo 2011/2/7 Massimo Di Pierro massimo.dipie...@gmail.com If you have an uploaded file (with name given by web2py) you can set default='' its filename without

Re: [web2py] Re: Problem with DAL and Postgres

Hi Massimo, tested like that, and still the same error. Bernardo 2011/2/8 Massimo Di Pierro massimo.dipie...@gmail.com Your problem is that this: Field('password', 'password', '''length=512, ''', readable=False, label='Password'), should be Field('password', 'password', length=512

[web2py] Re: Problem with DAL and Postgres

you show your custom auth_user. I am still puzzled by the error. On Feb 6, 4:21 pm, Bernardo Botella Corbí estem...@gmail.com wrote: Yes, the error is on my custom auth_user table. So, Do I reduce the leght numbers? Bernardo 2011/2/6 Massimo Di Pierro massimo.dipie...@gmail.com

Re: [web2py] Re: Problem with DAL and Postgres

Dear Massimo, I've been busy today. I'll post it as soon as possible. thanks for your help, Bernardo 2011/2/7 Massimo Di Pierro massimo.dipie...@gmail.com I am very puzzled. In gluon/dal.py there is this line: field.length = min(field.length,self._db and self._db._adapter.maxcharlength

[web2py] Upload file default

Dear all, is there a way to use a default file in an upload field? Something like: Field('whatever', 'upload', 'default=...') Which one is the best way to do this? thanks a lot for your help, Bernardo

[web2py] Problem with DAL and Postgres

in new DAL? Thanks a lot for your help, Bernardo

Re: [web2py] Re: Problem with DAL and Postgres

Yes, the error is on my custom auth_user table. So, Do I reduce the leght numbers? Bernardo 2011/2/6 Massimo Di Pierro massimo.dipie...@gmail.com Do you have a custom auth_user table? Is seems to miss a length attribute and default to a number too large. I changed the default to 32768

[web2py] Quick reCaptcha question

in the registration form, and not in the login form? Thanks, Bernardo

Re: [web2py] Re: minimal setup on Debian for using Mail()

. with this lines you should be able to send a mail from telnet. Does that work? Bernardo 2010/12/4 Miguel Lopes mig.e.lo...@gmail.com Hi Bernado, 2010/12/4 Bernardo Botella Corbí estem...@gmail.com Hi Miguel, which test did you do from command line? does web2py print something? Any error? Try to do

Re: [web2py] Re: minimal setup on Debian for using Mail()

when trying to send a mail from web2py. Bernardo 2010/12/4 Miguel Lopes mig.e.lo...@gmail.com On Sat, Dec 4, 2010 at 1:12 AM, mdipierro mdipie...@cs.depaul.edu wrote: did you apt-get install portfix? Do you mean postfix? No I didn't. By the way, tp be precise in the config I'm using

[web2py] Re: Problems with mail.send()

Hi Massimo, I finally found where the problem is. It is something to do with the SASL CRAM-MD5 authentification at server side. Just to debug purposes, is there any way to use the 'sasl_method=PLAIN' when using mail.send()? thanks a lot, Bernardo On 1 dic, 23:38, Bernardo estem...@gmail.com

[web2py] Problems with mail.send()

= 'url_to_postfix.cert' Does anyone can figure out what is wrong with all of this? thanks a lot for your time, Bernardo

[web2py] Re: Problems with mail.send()

250-AUTH CRAM-MD5 DIGEST-MD5 LOGIN PLAIN 250-ENHANCEDSTATUSCODES 250-8BITMIME 250 DSN on the other hand, the username is the same I use to send an email from thunderbird. kind regards, Bernardo On 1 dic, 16:49, mdipierro mdipie...@cs.depaul.edu wrote: try telnet mail.mydomain.com 25 and see

Re: [web2py] Re: Problems with mail.send()

It prints False Bernardo 2010/12/1 mdipierro mdipie...@cs.depaul.edu try from the shell python web2py.py -A yourapp -N -M print mail.send(to=@..., message=, subject=...) Massimo On Dec 1, 11:55 am, Bernardo estem...@gmail.com wrote: Hi Massimo, thanks for your reply. I

[web2py] Re: Problems with mail.send()

Ok Massimo, I'll post if I find something. thanks a lot!! Bernardo On 1 dic, 19:30, mdipierro mdipie...@cs.depaul.edu wrote: web2py is failing to connect and send the email. Something is wrong in the settings. To debug, you can try add something some print statements inside the class Mail

[web2py] Re: Problems with mail.send()

question, what is the difference between mail.settings.x509_sign_certfile and mail.settings.x509_crypt_certfiles Does this info makes things clearer? thanks a lot again and kind regards, Bernardo On 1 dic, 20:49, Bernardo estem...@gmail.com wrote: Ok Massimo, I'll post if I find something

[web2py] Re: Problems with mail.send()

' mail.settings.x509_sign_certfile = 'url_to_postfix.cert' mail.settings.x509_crypt_certfiles = 'url_to_postfix.cert' but they should not be urls, they should be full paths to localfiles. On Dec 1, 4:07 pm, Bernardo estem...@gmail.com wrote: More news Massimo, After following the execution of send

Re: [web2py] Limit Related Field Dropdown List

, Bernardo 2010/11/21 Joe J joe.jasin...@gmail.com Hi All, Say I have a pet table and an owner table related to each other in a one to many relationship (one owner has many pets). Each owner can also define several pet types of their choosing. db.create_table('owner', Field('name', text

[web2py] Facebox problems

, and kind regards, Bernardo

[web2py] A simple Whoosh integration approach (for searching)

doubts, please do not hesitate in asking. regards, Bernardo

[web2py] File download after creation

... if not, please ask. Thanks and kind regards, Bernardo

[web2py] Readonly form using SQLFORM with referenced tables

in the reference_table1 is not atribute1, but the id from the record on table1. How can I solve this? If I have not explained myself clearly enough, please do not hesitate on asking me further. Thanks and kind regards, Bernardo

[web2py] Re: Readonly form using SQLFORM with referenced tables

It works!! Thanks Denes!! On 13 oct, 12:35, DenesL denes1...@yahoo.ca wrote: Hi Bernardo, you would have to add a represent to table2.reference_table1: db.table2.reference_table1.represent = lambda v: '%(atribute1)s' %db.table1[v] requires is used during input while represent

[web2py] Re: Question about CRUD forms and compute values

in that form, and it should be. So, is it posible to show compute fields using crud to generate forms? thanks again, Bernardo -- Hola Luis, esos dos fields se encuentran en la misma tabla que n_lote. La parte rara es que n_lote se guarda bien en la base de datos cuando le das al submit del

[web2py] Solved -- Problems with special characters and pyfpdf

, Bernardo

[web2py] Question about CRUD forms and compute values

= crud.read(db.entradas, request.args(0)) The form is created, but, and here it comes the problem, the compute field n_lote is not shown. Why is that? How can I make CRUD to show it on the form? thanks a lot for all your help and kind regards, Bernardo

[web2py:31057] jQuery post callback receiving an array

and compreend that as an array. Thanks -- Bernardo Botelho Fontes bernardo.bote...@peta5.com.br (21) 9629 1621 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email

[web2py:30422] Getting the insertion index at db

Hello for everyone. I'm new at web2py and I'm trying to do some insertion in a table of my database. But, after the insertion, I need to get the id value of the new register. So, I'm using the following code: myID = db.tl.insert(name = tlName, length = tlLength); But I was always getting as

[web2py:30447] Re: Getting the insertion index at db

I've done some reading and i notice that running from the shell i should call db.commit. When i did that, it runs correctly. Thanks you all! -- Bernardo Botelho Fontes bernardo.bote...@peta5.com.br (21) 9629 1621 --~--~-~--~~~---~--~~ You received this message