There are 131 issues on pyDAL-GitHub, but the problem is not in the amount
but in that more than half of them without any response. Look at peewee
that has 7.5k stars and only 2 open issues!... yes, this is impolite
comparision - sorry.
I've just need to implement CTE + WITH RECURSIVE (like this
http://docs.peewee-orm.com/en/latest/peewee/querying.html#recursive-ctes)
and I wasted 2 days to figure out how I can do very simple thing like '1
AS foo' in right way that is (as I suppose):
Expression(db, '1', type='integer').with_alias('foo')
So, the question is: why is there nothing about that in the book?
Why does pyDAL have no that very simple but very necessary method which
allows to do cool things like:
db(...).select(
...,
db.exp(
'max(product.price) OVER(PARTITION BY product.category)',
type = 'decimal(n, m)' # the same as Field(..., type = 'decimal(n, m)
')
).with_alias('most_expensive_in_category')
)
here is used WINDOW-function that allows to get products list with
'most_expensive_in_category' in *one* plain query
*without using subquery* with GRUOP BY product.category + join
Also there is my PR on web2py book
https://github.com/web2py/web2py-book/pull/424
it hangs for almost a year - it is just a book, not code
I'm sad
--
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/c832fade-c4c6-4fc0-8ede-bee50b512d1c%40googlegroups.com.
