Sqlalchemy array_length function

Question

Does SQLALCHEMY has a function to be used in queries for array_length?

ie:

ssn.query(models.MedicationLog.dose_date,
                         func.array_length(models.MedicationLog.
                                    dose_taken_times).label('dose_taken_times'))

Do you mean length or array_agg? Here is a SO Post about how to use this. — AKS
– AKS, Commented May 26, 2016 at 5:45
Length. Since the count will not give length of the array. But let me check the aggregate. Thanks @AKS — Chathuranga
– Chathuranga, Commented May 26, 2016 at 5:48
array_length takes two arguments array_length(array, dimension) — AKS
– AKS, Commented May 26, 2016 at 5:53
@AKS Thanks. It works, only change I had to do was use max aggregate function as I dont have the dose_taken_times in the group by. — Chathuranga
– Chathuranga, Commented May 26, 2016 at 6:50
Please add the changes you made in the answer and accept it. — AKS
– AKS, Commented May 26, 2016 at 6:57

Chathuranga · Accepted Answer · 2016-05-27 11:36:26Z

3

Fixed it with using max and array_length

data = ssn.query(models.MedicationLog.dose_date,
                         func.sum(func.array_length(
                             models.MedicationLog.dose_taken_times, ARRAY_DEPTH
                         )).label('dose_taken_times')).order_by(models.MedicationLog.dose_date).\
        group_by(models.MedicationLog.dose_date).all()

edited May 27, 2016 at 11:36

answered May 26, 2016 at 7:35

Chathuranga

1,0461 gold badge15 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sqlalchemy array_length function

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related