Got it,
Thank you very much
On Tue, Jun 18, 2019, 1:53 PM Anthony <[email protected]> wrote:
> On Tuesday, June 18, 2019 at 11:04:16 AM UTC-4, Vlad wrote:
>>
>> Anthony, it works like a charm, thank you very much!!
>>
>> (Val's solution with also worked great, but it felt awkward to use the
>> whole thing when an alias was created, so emotionally this solution with
>> alias feels better :)
>>
>
> You can always do:
>
> sum = db.cart_sharing.stats.sum()
>
> And then use sum in multiple places.
>
>
>> On a side note, for SQLite orderby=['~shares'] works perfect - it indeed
>> sorts it out properly. Just in case I've verified it again now.
>>
>
> I suppose it works in your case, as you are sorting integers, so the
> bitwise negation yields the expected order. However, it won't work in all
> cases (e.g., sorting strings). It is simply not the appropriate syntax for
> ordering in SQL.
>
>
>> By the way, Val's solution was orderby=[~db.cart_sharing.stats.count()] -
>> with tilda, and it worked even in Postgres. Somehow tilda doesn't work
>> specifically with an alias - but without an alias it's just fine on both
>> dbs.
>>
>
> ~db.cart_sharing.stats.sum() is Python code, not SQL. Here, the ~ is part
> of the DAL syntax, and the DAL translates that to:
>
> SUM("cart_sharing"."stats") DESC
>
> So, Postgres never sees the tilde, only "DESC".
>
> But in any case, orderby=['shares DESC'] works everywhere flawlessly and
>> feels good too, so it's a winner :)
>>
>
> Note in this case, 'shares DESC' is just a string, not Python code. The
> DAL therefore simply passes that string directly to the database as SQL
> code. Also, note there is no reason to put it inside a list.
>
> Anthony
>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/87RAPjGI0_k/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/d89ca392-0d5f-4320-81b5-633ca95d51c2%40googlegroups.com
> <https://groups.google.com/d/msgid/web2py/d89ca392-0d5f-4320-81b5-633ca95d51c2%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/CABZ%2BKCCfCbOjhjwCaHELssgQRX%2BD2%3DFoY7Kgp1o_NXj_HtqOHg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
