[web2py] Re: Switching database backend from sqlite to mysql

2018-02-03 Thread Massimo Di Pierro
I believe the problem is that pydal is designed to not allow db to be shared among multiple threads to avoid concurrency issues. Every thread should make its own db object or, if you pass db around, you should call db.reconnect in each thread. On Saturday, 3 February 2018 22:14:41 UTC-6,

[web2py] Re: Script to create models from legacy PostgreSQL tables

2018-02-03 Thread Massimo Di Pierro
How does it compare with this? https://github.com/web2py/web2py/blob/master/scripts/extract_pgsql_models.py If better, can you merge and make a PR? On Thursday, 1 February 2018 08:30:06 UTC-6, Johann Spies wrote: > > I have written a script which I use to create models for an existing >

[web2py] Re: web2py gunicorn dockerfile

2018-02-03 Thread Massimo Di Pierro
Can I ask you to submit a PR to add the dockerfile to the web2py repo? On Saturday, 27 January 2018 07:12:26 UTC-6, 黄祥 wrote: > > want to share the docker stack recipe, if anyone interest perhaps i can pr > to the web2py repo or share it on this group > [stack] > $ ls | grep web2py >

[web2py] Re: how to hash the a users password in bash script

2018-02-03 Thread Massimo Di Pierro
Unfortunately that is not possible. The code you are writing is interpreted by the database. The web2py hash function is implemented in python and based on the pbkdf2 algorithm. I am not aware that it is even possible to implement it in postgresql. On Monday, 22 January 2018 09:10:07 UTC-6,

[web2py] Re: Switching database backend from sqlite to mysql

2018-02-03 Thread jburker
The attached file contains the code that is generating the error, line 4 specifically is called out in the traceback, but if I comment this line out I get the same error from the next line that is querying the database. If I start a web2py shell, I can copy and paste the offending line into the

Re: [web2py] Re: auth.messages.verify_email html template

2018-02-03 Thread Yi Liu
For other people's reference, I ended up modifying gluon/tools.py. It is probably not a good practise. But it is the easiest solution. I edit register() and email_reset_password() modifying something like (depends on which one) message=self.messages.verify_email % d to

[web2py] Re: json to request.vars

2018-02-03 Thread Anthony
Please show your code and its results. If you post JSON with contenttype 'application/json', request.post_vars should end up being the JSON converted to a Python data structure. Anthony On Saturday, February 3, 2018 at 9:08:00 AM UTC-5, lucas wrote: > > hello one and all, > > I know that

[web2py] Re: Download link for dynamic upload folder

2018-02-03 Thread Anthony
> > Another alternative is to change the representation of the file field in > the controller function before creating the SQLFORM.grid. For example: > > db.datasets.file.represent = lambda value, row: A('Download file', _href= > URL('datasets', 'download_dataset', vars={'id': row.id})) > > I

[web2py] Re: Download link for dynamic upload folder

2018-02-03 Thread David Orme
And in my case, using the represent option to feed an id variable to the URL, a download function like this works: from gluon.contenttype import contenttype def download_dataset(): # get the id and record ds_id = request.vars['id'] if ds_id is None: # non-existent id

[web2py] Re: json to request.vars

2018-02-03 Thread 黄祥
perhaps you can use restful web service ref: http://web2py.com/books/default/chapter/29/10/services#Restful-Web-Services best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Download link for dynamic upload folder

2018-02-03 Thread David Orme
Thanks, Anthony. So to sum up what I think the options are: 1) The code laying out the standard SQLFORM.grid record view handles the display of each field and - for upload fields - the download link uses: https://.../controller/sqlform_grid_function/download/file_name That can be changed

[web2py] Re: Switching database backend from sqlite to mysql

2018-02-03 Thread LoveWeb2py
Can you share some of your code from the controller where you're receiving the error? On Friday, February 2, 2018 at 7:31:59 AM UTC-5, jbu...@wgu.edu wrote: > > > I currently have a mysql database that is defined using pydal and used by > several other applications. I am trying to use Web2py

[web2py] Re: Download link for dynamic upload folder

2018-02-03 Thread Anthony
On Saturday, February 3, 2018 at 1:58:26 AM UTC-5, David Orme wrote: > > So at the moment, what users are seeing is a controller presenting > SQLFORM.grid of dataset records, and then in the 'view' argument to that > controller for a particular record, the file field is shown as the output > of

[web2py] json to request.vars

2018-02-03 Thread lucas
hello one and all, I know that web2py sends a json object/dict great. does work great. HOWEVER, I'm asking about the opposite question. how can I send a json object/dict from the client to web2py and it receive it under the controller function's request.vars storage as a python dict? I

[web2py] Re: web2py behind Apache with virtualhosts and SSL (SNI) leads to SSL_ERROR_RX_RECORD_TOO_LONG

2018-02-03 Thread David Zejda
Hi I found it. There was another host config in my setup with such a redirect: ServerName domainxx.com RedirectMatch permanent (.*) http://www.otherdomain.com$1 When I changed it to: ServerName domainxx.com RedirectMatch permanent (.*) http://www.otherdomain.com$1 other domains'