[web2py] Updted Nginx+Ubuntu20.04+web2py script

Hey everyone, I struggled last night to setup web2py on my VPS Linux server which uses ubuntu 20.04. I had to update the script with multiple edits. Most of them around new pip syntax, updated requirements of nginx for self-signed certs and updated package names. I will create a pull request on

[web2py] German Translation

I am currently updating web2pys German translation of the sample app. Currently its a mix of German, Catalan and English. Will push some updates soon, but thought to just already send a heads up. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2

[web2py] Re: DAL Could not create constraint or index

Hello Villas, first al all...thank you thank you thank you! But I didn't arrived to the end of the game yet. but I think I'm near with your suggestions. I followed the "easier solution" and, with a lot of effort, now I have my MSSQL database filled of my data. But when I start tha application

[web2py] Re: How to debug "lost password"

Any suggestions on how to debug "password lost" email not being sent. Thanks, Jon. On Wed, Aug 19, 2020 at 7:49 PM Jon Subscripted wrote: > Hi everyone, > I'm having some trouble sending "lost password" emails to my users. > Whenever I test it I get an "Unable to send email" message. > > But I d

[web2py] Re: DAL Could not create constraint or index

UPDATES in appconfig.ini I changed from migrate= true to migrate=false. tha system doesn't create me the sql.log and .table file definitions in the folder databases, but the application seems start to work! How is posisble? Il giorno giovedì 20 agosto 2020 16:45:35 UTC+2, Andrea Fae' ha sc

[web2py] count() with left join

Hi I'm trying to get the count of records to be returned in a query using: db(query).count() Adding complexity to the situation is that query may sometimes be over multiple tables with need a left clause added. When selecting records you do this by passing the left= parameter inside the .sele

[web2py] Re: count() with left join

Hi Jim, I had this issue some time ago and I solved it by the workaround of using len(db(query).select()). The count()-method is a little more performant, but in my case it didn't matter. If you need the rows object of the select for further processing anyway, you can have the len() on the rows

[web2py] Re: count() with left join

Clemens Thanks so much, that worked perfect. I guess I was a little concerned about the performance, doing the whole select, but then realized that this should cut down on result set size, so shouldn't matter that much. Again, thank you -Jim On Thursday, August 20, 2020 at 2:14:26 PM UTC-5,

[web2py] Re: How to debug "lost password"

What does your mail setup in db.py look like? -Jim On Thursday, August 20, 2020 at 9:47:11 AM UTC-5, Jonsubs wrote: > > Any suggestions on how to debug "password lost" email not being sent. > Thanks, Jon. > > On Wed, Aug 19, 2020 at 7:49 PM Jon Subscripted > wrote: > >> Hi everyone, >> I'm havi

[web2py] Re: count() with left join

u_cnt = db.auth_user.id.count().with_alias('user_count') user_count = db(db.auth_user).select(u_cnt, left = ...).first().user_count or just passing raw SQL as field: user_count = db(db.auth_user).select('count(id) AS user_count', left = ...).first().user_count четверг, 20 августа 2020 г.

[web2py] Re: count() with left join

Thanks, I'll check that out too. Might be more efficient than the other alternative. -Jim On Thursday, August 20, 2020 at 7:28:26 PM UTC-5, valq...@gmail.com wrote: > > u_cnt = db.auth_user.id.count().with_alias('user_count') > user_count = db(db.auth_user).select(u_cnt, left = ...).first().u

[web2py] Re: count() with left join

len(db(query).select()) - is bad solution, since it loads all records into memory + parsing/transforming into pydal records пятница, 21 августа 2020 г. в 03:35:33 UTC+3, Jim S: > Thanks, I'll check that out too. Might be more efficient than the other > alternative. > > -Jim > > > On Thursd

Re: [web2py] Re: count() with left join

I have just resorted to pure SQL using db.executesql (I know that doesnt help you). Can't get much faster than that though. I like how the results can be returned as a simple dictionary. But i realised i need to be careful if i ever target a different DB provider. And permissions and common filters

Re: [web2py] Re: count() with left join

Thanks Andrew, but for my situation I need to use a dal query. I'm going to give the previous suggestion a try in the morning. Jim On Thu, Aug 20, 2020, 9:56 PM AGRogers wrote: > I have just resorted to pure SQL using db.executesql (I know that doesnt > help you). Can't get much faster than th