[web2py] admin table query focus

I've long been bugged by going through the appadmin controller to do database maintenance and not having the focus be anywhere useful. I think I even have a comment about that somewhere in the forum. I finally figured out a way to fix that ... the following change puts the focus on the query

[web2py] Re: Incorrect archive/restore behavior?

I've been working on this for a while now off and on and have, I believe, fixed the web2py gluon code bugs to correct this problem. I filed my fix here - https://github.com/web2py/web2py/issues/2483 On Wednesday, January 17, 2024 at 3:28:37 PM UTC-8

Re: [web2py] web2py AWS cognito authentication

You still know how you did it ? Best Regards kryto...@gmail.com schrieb am Dienstag, 18. September 2018 um 22:32:15 UTC+7: > Hi, yes the pool has been created successfully in AWS. When I use test > units to test the code on the class the authentication works correctly and > AWS responds

[web2py] Re: web2py website

On Wednesday, February 21, 2024 at 11:29:07 AM UTC-8 syna...@gmail.com wrote: Will the web2py website be getting a refresh anytime? That award badge - it's from 14 years ago. web2py is in maintenance mode. Spiffing up the website isn't an important sales tool. Here's hoping py4web gets

[web2py] Re: 2.19.0 vs 2.27.1

On Monday, February 12, 2024 at 8:12:05 AM UTC-8 gaelpri...@gmail.com wrote: Hello everybody. I've actually some instances of web2py running with the 2.19.0 version. 0 problems, thank you web2py. One of these is this one: https://www.hydrover.it/ It uses the web2py grid, Bootstrap 2.3.2. I

Re: [web2py] shell.py, unqualified exec is not allowed

On Tuesday, February 6, 2024 at 11:40:00 AM UTC-8 apinho wrote: Hi, Thank you. I was under the impression that web2py was only compatible with Python2.7, and that py4web was for Python3x. I now understand that py2web has been modified and is also compatible with Python3, up to 3.11. That

[web2py] web2py website

Will the web2py website be getting a refresh anytime? That award badge - it's from 14 years ago. -- 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

[web2py] Re: Front end framework

I think BS5 will be fine - the classes and so forth should be the same as BS4 and I’ve not encountered any real issues with BS5 and py4web. https://superdevresources.com/bootstrap5-vs-bootstrap4-whats-new/ Donald On Saturday, February 17, 2024 at 3:55:26 AM UTC Massimo Di Pierro wrote: > I

[web2py] Re: Front end framework

I do not know how much different 4 and 5 are. Only the names of the classes in the forms may be an issue. I would recommend you try it with BS 5 and if you run into any issue it may be possible to address it with a new adapter or, maybe easier, a few lines of JS. On Monday 12 February 2024 at

[web2py] 2.19.0 vs 2.27.1

Hello everybody. I've actually some instances of web2py running with the 2.19.0 version. 0 problems, thank you web2py. One of these is this one: https://www.hydrover.it/ It uses the web2py grid, Bootstrap 2.3.2. I must install a new web2py instance, where I'll copy the

[web2py] setting user is authenticated

Hi, I have made an alternative login system to web2py that consists of sending a token by email to the user's email, once I validate that everything is right, how can I set that the user is authenticated? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] setting user is authenticatedout of web2py control access

I have made an alternative login system to web2py that consists of sending a token by email to the user's email, once I validate that everything is right, how can I set that the user is authenticated? I use the Auth database tables. Thanks -- Resources: - http://web2py.com -

[web2py] Front end framework

Hello all. I've to update a Web2py app that uses Bootstrap 2.3.2. Now the Web2py 2.27.1 uses Bootstrap 4? Is it possible to use Bootstrap 5? Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] adding routes.py causes a module import error

Hi, I'm using web2py Version 2.27.1-stable+timestamp.2023.11.16.08.03.57. Whenever I add a routes.py file I get the below error. I've tried adding "from gluon import fileutils" to the top of the routes.py file even though the issue appears to be with rewrite.py. Any ideas? Traceback (most

[web2py] Seeking Advice: Transitioning from LDAP to AWS Cognito for Authentication

Hello everyone, I've been searching without success and I'm encountering a problem. Currently, I'm utilizing LDAP for authentication in my login system, but I'm interested in switching to AWS Cognito. Unfortunately, I haven't been able to locate any documentation on this transition. I was

Re: [web2py] Digest for web2py@googlegroups.com - 3 updates in 2 topics

Ok, thank you, a lot. I'll do as you recommend. Alexandre On Wednesday 7 February 2024 at 18:30:16 UTC donal...@gmail.com wrote: > Moving web2py from py2 to py3 should be very straightforward. What may or > may not be straightforward is moving your web2py applications from py2 to > py3 as

Re: [web2py] Digest for web2py@googlegroups.com - 3 updates in 2 topics

Moving web2py from py2 to py3 should be very straightforward.  What may or may not be straightforward is moving your web2py applications from py2 to py3 as that depends a fair bit on how they have been written and certainly encoding and changes to string handling between py2 and py3 could need

[web2py] Encode problem after migration web2py to CentOs7

Hi, I was using an web2py app on : Windows Server 2016 2.18.2-stable+timestamp.2019.02.26.06.11.06 (Running on Rocket 1.2.6, Python 2.7.9) Now, I'm using : Centos 7 2.27.1-stable+timestamp.2023.11.15.23.33.20 (Running on Unknown, Python 2.7.5) I'm having lots of encode problems. Take this

Re: [web2py] shell.py, unqualified exec is not allowed

Hi, Thank you. I was under the impression that web2py was only compatible with Python2.7, and that py4web was for Python3x. I now understand that py2web has been modified and is also compatible with Python3, up to 3.11. That definitely opens new horizons for me. I might try to install

Re: [web2py] shell.py, unqualified exec is not allowed

Take a look to pyenv or nix to install a python version apart from the system On Mon, Feb 5, 2024 at 5:37 PM apinho wrote: > Hello everyone, > > I just migrated an old (2017-ish) web2py app, which was still hosted on a > user machine, running on Rocket HTTP server. > > The app is now on a

[web2py] shell.py, unqualified exec is not allowed

Hello everyone, I just migrated an old (2017-ish) web2py app, which was still hosted on a user machine, running on Rocket HTTP server. The app is now on a CentOS 7 VM, under nginx/uwsgi using HTTPS. Web2py version is 2.27.1, over Python 2.7.5, in a virtualenv. All is OK as for the app itself,

[web2py] Re: reCAPTCHA link in online web2py book

Hello. Recpatcha is still working like a charm. Here are some examples about how to use it. if you want to have Recaptcha in login form, set it like this: in models.py #import recaptcha from gluon.tools import Recaptcha2 #enable recaptcha in login form. auth.settings.captcha =

[web2py] Re: reCAPTCHA link in online web2py book

On Sunday, January 28, 2024 at 5:41:01 AM UTC-8 lucas wrote: anyone on this, at all? Sorry, I haven't used recaptcha, but I think there was a recent thread about it in the py4web forum. Good luck /dps On Monday, January 22, 2024 at 9:01:02 AM UTC-5 lucas wrote: hello one and all, the

[web2py] Re: reCAPTCHA link in online web2py book

anyone on this, at all? On Monday, January 22, 2024 at 9:01:02 AM UTC-5 lucas wrote: > hello one and all, > > the link for reCAPTCHA, or, " > http://web2py.com/books/default/reference/29/recaptcha;, under the online > web2py book, " >

Re: [web2py] Embed Plotly Express in Web2PY

in controller ``` import plotly.express as px def my_view(): # Assuming df_dataframe is your Pandas DataFrame fig = px.line(df_dataframe, x="datetime", y="load_avg_fifteen") # Convert the figure to HTML plotly_chart = fig.to_html(full_html=False, include_plotlyjs='cdn')

[web2py] Embed Plotly Express in Web2PY

I would like to embed something on the following lines *import plotly.express as pxfig = px.line(df_dataframe, x="datetime", y="load_avg_fifteen")* show it in html page similar to ** At present I am using HighCharts js, but as I totally work on pandas dataframes.. I imagine it is far more

[web2py] Plotly Express Charts in web2py

I would like to embed something on the following lines *import plotly.express as pxfig = px.line(df_dataframe, x="datetime", y="load_avg_fifteen")* show it in html page similar to ** At present I am using HighCharts js, but as I totally work on pandas dataframes.. I imagine it is far more

[web2py] reCAPTCHA link in online web2py book

hello one and all, the link for reCAPTCHA, or, " http://web2py.com/books/default/reference/29/recaptcha;, under the online web2py book, " http://web2py.com/books/default/chapter/29/09/access-control#CAPTCHA-and-reCAPTCHA;, seems to by unreferenced. is this feature still working in the latest

[web2py] Re: add record no longer available in smartgrid since switch to ms sql

I found the reason. I needed to add user_signature=False The default for this parameter is True and will prevent you from adding records!!! On Thursday, January 18, 2024 at 1:47:37 PM UTC+1 Davidiam wrote: > I recently switched from sqlite to MS SQL and my application no longer > allows me

[web2py] add record no longer available in smartgrid since switch to ms sql

I recently switched from sqlite to MS SQL and my application no longer allows me to add new records using the smartgrad. I have editable and deletable set to True but I can only view the records. If I use a basic SQLFORM I can add records, but I would prefer using the smartgrid. Is there a

[web2py] Re: Incorrect archive/restore behavior?

Sorry, for "*Having cleared out the tables before step 3, this results"* this should have said step 4 for "since there is no row in mediatitles that mediatitles_archive..." this should have said there is no row in mediatitles with the required id On Wednesday, January 17, 2024 at 12:59:59 

[web2py] Incorrect archive/restore behavior?

Hi, *I believe (using python 3.11.7, web2py 2,24,1, mysql 8),* *with web2py record versioning enabled,* *I have verified that * *db.export_to_csv_file does not write table rows that have the "is_active" field set* * to False.* *A simple test case is * 1. add a new

[web2py] Re: Failing to download search results as csv

On Tuesday, August 22, 2023 at 2:32:48 AM UTC-7 mostwanted wrote: Hi guys, i need help downloading results as csv, i am failing dismally I dont know what to do After the search results return values I want to download those results into my computer somewhere the current version of my code is

[web2py] stale session with FORM and its kin

Somewhere along the way, and that probably includes the manual, Massimo has noted that the use of the family of FORM helpers is generally used to get parameters for an action whose results are then displayed on another page as a redirect. "What picture do you want to look at? Okay, let's go

[web2py] Re: cibersecurity audit issue about login

On Thursday, November 16, 2023 at 9:32:58 AM UTC-8 Ramos wrote: Hello friends, i guess this is a similar issue between web2py and py4web so im posting to both groups. Sorry if im abusing ... We had a cibersecurity audit in our web2py app and they found this issue QUOTE During the application

[web2py] Re: Exception Error: 'Field' object has no attribute '__dir__'

This is fixed in master, although I failed to reproduce. Thanks for reporting it and suggesting the fix. On Tuesday 12 December 2023 at 02:06:28 UTC-8 mostwanted wrote: > Is there something wrong with the upload functionality or is just my app? > > On Friday, December 8, 2023 at 7:39:49 PM

[web2py] Re: web2py 2.27.1 released

yes. sorry had forgotten to push the tags. -- 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

[web2py] Re: is upgrade still experimental ?

I think it will always be experimental. I do not want to take any responsibility for breaking your local installation. :-) On Monday 20 November 2023 at 06:20:33 UTC-8 Ramos wrote: > hello is the upgrade button still experimental ? > [image: image.png] > > > > [image: image.png] > > Regards >

[web2py] Re: Exception Error: 'Field' object has no attribute '__dir__'

Is there something wrong with the upload functionality or is just my app? On Friday, December 8, 2023 at 7:39:49 PM UTC+2 mostwanted wrote: > Hi guys, I recently 'upgraded' my web2py version to the latest version > (2.27.1) but i've forgotten the previous version. Now suddenly when i try > to

[web2py] Exception Error: 'Field' object has no attribute '__dir__'

Hi guys, I recently 'upgraded' my web2py version to the latest version (2.27.1) but i've forgotten the previous version. Now suddenly when i try to submit forms i get this error: 'Field' object has no attribute '__dir__' Below is the tracebeack Traceback Traceback (most recent call last):

Re: [web2py] How to perform a DB migration from outside the app where DB is defined?

Ok great! Thanks for the advice. I already made the changes so I already don't depend on having to make a request with migrate=True. I tested it and it works ok: from my main application I connect to the secondary app's database and I use .executesql() to make the changes I need before

[web2py] Re: web2py 2.27.1 released

Great! where we can find it? https://github.com/web2py/web2py/tags ? On Saturday, November 18, 2023 at 7:15:07 PM UTC-3 ra...@tarkus.mx wrote: > Excellent !!! > > On Thursday, November 16, 2023 at 1:10:43 AM UTC-7 Massimo Di Pierro wrote: > >> web2py 2.27.1 was released >> >> - some linting and

Re: [web2py] How to perform a DB migration from outside the app where DB is defined?

Às 11:34 de 28/11/23, Lisandro escreveu: Hey there! I have several web2py apps running, and one of them acts as the main one, taking care of mantainance and upgrading the apps when needed. Sometimes the upgrade requires a database migration. All the process is controlled by the main app,

[web2py] How to perform a DB migration from outside the app where DB is defined?

Hey there! I have several web2py apps running, and one of them acts as the main one, taking care of mantainance and upgrading the apps when needed. Sometimes the upgrade requires a database migration. All the process is controlled by the main app, which takes the app that needs to be upgraded

[web2py] is upgrade still experimental ?

hello is the upgrade button still experimental ? [image: image.png] [image: image.png] Regards António -- 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) ---

[web2py] Re: web2py 2.27.1 released

Excellent !!! On Thursday, November 16, 2023 at 1:10:43 AM UTC-7 Massimo Di Pierro wrote: > web2py 2.27.1 was released > > - some linting and formatting > - added support to Python 3.11 > - fixed regexen and classname > - removed a circular dependency > > -- Resources: - http://web2py.com -

[web2py] Re: cibersecurity audit issue about login

Hello António. Bruteforce in login is a common weakness that can be easy to solve. The most effective solution is implementing a CAPTCHA, in web2py I use google recaptcha because the implementation is easy and stops all the automations. In py4web I'm still unable to implement it in the login

[web2py] cibersecurity audit issue about login

Hello friends, i guess this is a similar issue between web2py and py4web so im posting to both groups. Sorry if im abusing ... We had a cibersecurity audit in our web2py app and they found this issue QUOTE During the application audit process, it was possible to identify that the the company

[web2py] web2py 2.27.1 released

web2py 2.27.1 was released - some linting and formatting - added support to Python 3.11 - fixed regexen and classname - removed a circular dependency -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: web2py 2.26.1 released

I highly recommend moving to py4web. These days I dread working on web2py apps we haven't yet converted to py4web. py4web is so much faster for execution and development. Much more flexibility in form and grid layouts. If there is something missing, let us know, we'd love to get more

Re: [web2py] Re: web2py 2.26.1 released

In my opinion Web2py is really comfortable but I strongly recommend to move to py4web. The scheduler in web2py is replaced with celery which is more powerful and py4web framework is really fast, light and is easy to code like in web2py. I’ve moved all my apps from web2py to py4web and I can’t

Re: [web2py] Re: web2py 2.26.1 released

I´m so comfortable with web2py, the admin dashboard and the scheduler are blocking me from moving to py4web... Regards Em seg., 30 de out. de 2023 às 04:48, Raul Monares escreveu: > Great news. I appreatiate your work on both platforms > > On Sunday, October 29, 2023 at 3:13:31 PM UTC-6 Massimo

[web2py] Re: web2py 2.26.1 released

Great news. I appreatiate your work on both platforms On Sunday, October 29, 2023 at 3:13:31 PM UTC-6 Massimo Di Pierro wrote: > Changelog: > - adds support of python up to version 3.11 > - fixes a bug with serialization of headers introduced in version 2.25.1 > - improves handling of unstable

[web2py] web2py 2.26.1 released

Changelog: - adds support of python up to version 3.11 - fixes a bug with serialization of headers introduced in version 2.25.1 - improves handling of unstable db connections in the scheduler I remind you that py4web has been out for 5 years now as successor of web2py. It has the same template

[web2py] Re: web2py 2.25.1 - bug when running interactive shell?

It should be abspath and should be fixed in master. I plan to release a new version today. On Friday, 27 October 2023 at 01:28:59 UTC-7 Tom Clerckx wrote: > I believe web2py/gluon/shell.py", line 238 should use os.path.*abspath* > instead of *absdir*? > > Unpacked and ran a clean version of

[web2py] Re: Web2py move to a new server resulted in this 'CommonDialect' object has no attribute 'eq'

This is a know issue with has been fixed in master. I will release a new version later today. On Sunday, 22 October 2023 at 02:07:32 UTC-7 vald...@gmail.com wrote: > Whenever I reload, It seems to create a new thread showing this in the CLI. > > For example, when I attempt to run the app, the

Re: [web2py] Re: app not loading external python library

pip install urllib3_secure_extra in my virtual env solved the problem. Thank you Tom for pointing to the solution, I had missed that thread. On October 27, 2023 at 16:59:18, Tom Clerckx (tcler...@gmail.com) wrote: I think this is the same issue as was discussed a few months ago: See this

[web2py] web2py 2.25.1 - bug when running interactive shell?

I believe web2py/gluon/shell.py", line 238 should use os.path.*abspath* instead of *absdir*? Unpacked and ran a clean version of web2py: command: python web2py.py -B -S welcome -M web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2023 Version

[web2py] Re: app not loading external python library

I think this is the same issue as was discussed a few months ago: See this thread: https://groups.google.com/g/web2py/c/xYVWpDGLuzY/m/t9sBabWOAgAJ Seems some issue between the custom importer and the urllib3 module. Can you try once more, but also explicitly pip install *urllib3_secure_extra

[web2py] Re: File Download Broken after Pull Request #2471

Yes, for me it works fine now. Thanks. Carlos. El jueves, 26 de octubre de 2023 a las 7:42:25 UTC+2, Massimo Di Pierro escribió: > I agree with you. I committed your proposed change to master. Please > confirm this indeed fixes it and I will make another release. > > On Wednesday, 4 October

Re: [web2py] Re: AssertionError: Header names/values must be of type str

Can you try once more? On Wed, 25 Oct 2023 at 23:03, Al Ex wrote: > I tried with a new installation of web2py > > $ git clone --recursive https://github.com/web2py/web2py.git > > > It gives the same error > > * >

[web2py] Re: AssertionError: Header names/values must be of type str

I believe this is now fixed in master, thanks to Carlos' suggestion. Can you please give it a try? On Monday, 23 October 2023 at 13:30:34 UTC-7 alex wrote: > Hi, Running web2py in virtualenviroment (python 3.9.5, it happens also in > python 3.10.10) > > > >

[web2py] Re: File Download Broken after Pull Request #2471

I agree with you. I committed your proposed change to master. Please confirm this indeed fixes it and I will make another release. On Wednesday, 4 October 2023 at 08:26:46 UTC-7 CarlosDB wrote: > Hello, > > Today, I downloaded web2py from GitHub to start testing a future update. I > have

[web2py] Re: app not loading external python library

Hello Alex, thank for reporting this problem. Is it only occurring with web2py 2.25.1? On Monday, 23 October 2023 at 14:05:15 UTC-7 alex wrote: > Hi, > > I am running web2py Version 2.25.1-stable in virtualenv (python 3.9.5, it > happens also in python 3.10.10) > > After activating the

[web2py] test message

Hi Jim, this is a test message -- 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] app not loading external python library

Hi, I am running web2py Version 2.25.1-stable in virtualenv (python 3.9.5, it happens also in python 3.10.10) After activating the virtualenv, I installed requests $ pip install request $ pip show requests Name: requests Version: 2.31.0 Summary: Python HTTP for Humans. Home-page:

[web2py] AssertionError: Header names/values must be of type str

Hi, Running web2py in virtualenviroment (python 3.9.5, it happens also in python 3.10.10) ERROR:Rocket.Errors.Thread-3:Traceback (most recent call last): File "/Users/z/dev/web2py/gluon/rocket.py", line 1294, in run self.run_app(conn) File

[web2py] Re: Web2py move to a new server resulted in this 'CommonDialect' object has no attribute 'eq'

Whenever I reload, It seems to create a new thread showing this in the CLI. For example, when I attempt to run the app, the error, shown below, starts with: " ERROR:Rocket.Errors.Thread-2:Traceback (most recent call last):" The next time it runs showing " ERROR:Rocket.Errors.Thread-4:Traceback

[web2py] Re: Web2py move to a new server resulted in this 'CommonDialect' object has no attribute 'eq'

It's as if any attempt to read tables based on the db object causes this error. I was getting this error where IS_IN_DB that references other tables as base tables. I've moved all those references from the models completely and now I'm getting the error when I attempt to log in to the app.

[web2py] Web2py move to a new server resulted in this 'CommonDialect' object has no attribute 'eq'

Hi Guys, I recently upgraded an app I wrote with web2py about 4 years ago to work with Python 3. I got a lot of this 'CommonDialect' object has no attribute 'eq' error until I removed the requires=IS_IN_DB() references to other tables and put the majority of the references into a separate

[web2py] Re: web2py 2.25.1

Hello. I believe this error is related to a thread I opened a few days ago: " File Download Broken after Pull Request #2471 " https://groups.google.com/g/web2py/c/ruhme28jvNo Carlos. El miércoles, 18 de octubre de 2023 a las 18:49:34 UTC+2, xgp.l...@gmail.com escribió: > Hi, > > Modified the

[web2py] Re: web2py 2.25.1

Hi, Modified the code to this: for k, v in iteritems(headers): if isinstance(v, list): rheaders += [(k, str(item)) for item in v] else: rheaders.append((k, str(v))) This was the code from version 2.24.1 Dont know if this is correct.

[web2py] Re: web2py 2.25.1

Hi Massimo, Getting this redirecting from nginx to uwsgi_pass http port. Traceback (most recent call last): File "/home/www-data/web2py/gluon/main.py", line 562, in wsgibase return http_response.to(responder, env=env) File "/home/www-data/web2py/gluon/http.py", line 129, in to

[web2py] Re: uwsgi with web2py hard crash/locking with nginx

yes, i think once the RAM was consumed the server ground to a halt where it appeared to crash. so, i believe it was a soft crash instead of a hard crash. i used "top" to monitor the memory and processes and the soft crash occurred when the RAM was exhausted. so i created a swap file to

Re: [web2py] Re: uwsgi with web2py hard crash/locking with nginx

While I can't provide a specific solution, it might be a better approach to keep resource-intensive tasks separate from web2py, using a tool like Celery. This way, these tasks can run in the background without impacting the web server. This is a small docx about how to put it together:

[web2py] Re: uwsgi with web2py hard crash/locking with nginx

Maybe you should review the 'high calculation/high plotly' pages for memory usage? As the 'OOM killer' kicked in, it looks like the process is using too much memory. One thing to verify this is to monitor the VmRSS of the processes involved (VmRSS is one of the fields in the output when you do

[web2py] uwsgi with web2py hard crash/locking with nginx

hello one and all, i'm using web2py 2.25.1 with uwsgi 2.0.22 which was downloaded and compiled using pip3 under python 3.10.12 under ubuntu 22.04. the nginx is apt installed version 1.18. with that being said, if i install and run my high calculation / high plotly plot pages about 6 to 12

Re: [web2py] Re: How do I query and display Authors and their respective books

Thanks for the reply. It addresses my question. Thanks and Regards. On Wed, 11 Oct 2023, 12:27 Clemens, wrote: > Hello, > > all you need to know (including examples) is described here: > > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#One-to-many-relation > >

[web2py] Re: How do I query and display Authors and their respective books

Hello, all you need to know (including examples) is described here: http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#One-to-many-relation On Wednesday, October 11, 2023 at 6:11:38 AM UTC+2 Moiz Nagpurwala wrote: > Hello, > > I have 2 tables in my database, one

[web2py] How do I query and display Authors and their respective books

Hello, I have 2 tables in my database, one for Author and another for Book. I want to display all Author names as H2 and below each Author I want to display the books for that Author. Please suggest the query and html view code for above scenario. Thanks and regards. -- Resources: -

[web2py] Custom buttons in grid are not displayed on Detail page

I encountered a little issue with SmartGrid not displaying custom links in Detail view. Not sure if I'm missing something or it's a limitation of some sort. Here's what's going on. I have a main grid that looks like this: [image: main_grid.png] There are different custom 'ACTIONS' buttons

[web2py] Re: Displaying images from web2py as a server

In your example, `image_url` is not the URL of the image, it's the value of the "upload" field. Try something similar to this: image = AsyncImage(source=f"http://localhost:8000/download/{image_url};) Carlos. El lunes, 9 de octubre de 2023 a las 6:56:05 UTC+2, mostwanted escribió: > I have a

[web2py] Re: web2py 2.25.1

A fantastic job. Thank you very much. Carlos. El domingo, 8 de octubre de 2023 a las 20:59:27 UTC+2, Massimo Di Pierro escribió: > Hello everybody, > > A new version of web2py, 2.25.1, is out. > > It contains some bug fixes, #2468 #2468 #2236, http headers sanitization, > and fixes this

[web2py] Displaying images from web2py as a server

I have a little functionality here where i'm pulling information from a web2py server and displaying it on a kivy app for the user, all the other details are displaying but the image is failing to display & I get the error:* [ERROR ] [AsyncImage ] Not found .* What am I doing wrong? How do

[web2py] web2py 2.25.1

Hello everybody, A new version of web2py, 2.25.1, is out. It contains some bug fixes, #2468 #2468 #2236, http headers sanitization, and fixes this vulenarbility https://jvn.jp/en/jp/JVN80476432/ (to be published soon). The vulnerabily does not affect most users. It is only in the optional

[web2py] File Download Broken after Pull Request #2471

Hello, Today, I downloaded web2py from GitHub to start testing a future update. I have several "upload" fields for images, and they have all started to fail. After some investigation, I found that this issue started after Pull Request (PR) #2471 (Sanitize Headers) was merged. Link to PR

[web2py] Re: Web2py dal significantly slower than raw query

Think an int, that needs to be "casted" to an int for 50k times. You can't expect an abstraction layer to be as fast as raw sql. DAL doesn't just write queries for you, it adapts the resultset to the model. 50k rows in less than 2 seconds is not that bad. On Tuesday, October 3, 2023 at 8:29:12 

[web2py] Re: Web2py dal significantly slower than raw query

12 columns, 50k rows (17k rows in the query result) cacheable=True is about 0.3s faster. The costliness of building the whole model comes (mostly) from reference types? On Monday, October 2, 2023 at 11:22:53 PM UTC+2 Niphlod wrote: > how many rows and how many columns ? the raw one is

[web2py] Re: Web2py dal significantly slower than raw query

how many rows and how many columns ? the raw one is returning whatever type the underlying database structure has as it is, the pydal one is building the whole model (including references) did you try with cacheable=True in the pydal one ? it won't build update_records and delete_records, for

[web2py] Re: Web2py dal significantly slower than raw query

The only thing I can see is that the SQL needs to be 'built' by pydal, but I find it hard to believe it takes a whole second. Massimo might have to add context here. -Jim On Monday, October 2, 2023 at 1:00:19 PM UTC-5 urban@gmail.com wrote: > Sorry my bad! I mixed up the timings when

[web2py] Re: Web2py dal significantly slower than raw query

Sorry my bad! I mixed up the timings when editing the post. The slower timing is for the dal version. Moreover the dal version is slower even if I remove the .as_list() call. I had originally tried that. When I get the time I'll try "debugging" it by looking at the dal.py source. Asking here if

[web2py] Re: Web2py dal significantly slower than raw query

It's possible I'm reading this wrong (it is Monday morning), but .09s (DAL) is faster than 1.8s (raw SQL). Is that a typo? Or, is it my Monday-morning-brain? If your raw query is slower, could it be because you're converting to a dict instead of a list as in your dal query? -Jim On

[web2py] Web2py dal significantly slower than raw query

ids = tuple(m['id'] for m in relevant_models) raw_q = db.executesql(""" SELECT * FROM "table" WHERE ("table".ref_id" IN {}); """.format(str(ids)), as_dict=True) 1.8s ids = tuple(m['id'] for m in relevant_models)

[web2py] Re: Error importing pydal running from PyCharm

I actually solved it myself. Pycharm with old settings that included gluon as an external library injected gluon into the path. Then web2py html.py was picked up instead of the new python3 html.py Clearing my old .idea file and setting up a new solved it. Tom Ø. fredag 29. september 2023 kl.

[web2py] Error importing pydal running from PyCharm

Hi, when running my web2py app from pycharm I get an error importing pydal. The directory is a full source download, so the full dal package is included. When I run direct from command line It works. I'm working in MacOS Ventura on a Macbook Air M2. *Commandline* *tom@Tom-sin-MacBook-Air-2022

[web2py] Does SQLFORM support "onvalidation"?

Short answer: YES I was having trouble with "onvalidation" ... the code didn't seem to be running. So I was going to ask if SQLFORM supported it ... but [blush] when preparing my question, I realized I had set the option on the wrong form. (I have a ping-pong pair of forms ... you enter

[web2py] Re: 3.11 issues

Hi, Now im running into other issues: cannot import name 'FDPF' from 'fpdf' (unknown location) cannot import name 'num2words' from 'num2words' (unknown location) Suggestions? El jueves, 14 de septiembre de 2023 a las 21:34:01 UTC-5, xgp.l...@gmail.com escribió: > I was able to get redis

[web2py] Re: 3.11 issues

I was able to get redis working using redis==4.5.1. The default pip install version was 5.0.0 Cheers, El jueves, 14 de septiembre de 2023 a las 7:49:11 UTC-5, xgp.l...@gmail.com escribió: > Hi, > > Im trying to run web2py + python3.11 + uwgi but unable to make it work. > Seems web2py can't

[web2py] 3.11 issues

Hi, Im trying to run web2py + python3.11 + uwgi but unable to make it work. Seems web2py can't import libraries, when doing the same over a python3 prompt it works. Example: Needs redis library to work try: import redis from redis.exceptions import WatchError as RWatchError from

[web2py] Re: pyodbc error on windows machine

just as an off chance thing what's the default language of the user ? never had troubles with english. Also, what's your table model definition and what's the DDL for the underlying table ? On Thursday, September 7, 2023 at 10:49:29 PM UTC+2 jays...@gmail.com wrote: > still hoping for

  1   2   3   4   5   6   7   8   9   10   >