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
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
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
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 =
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 г.
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
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,
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
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
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
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
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
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)
-
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
14 matches
Mail list logo
