Sqlalchemy-Python Plus two Base Query

Question

I want to have a collection containing these two base query. How can I do that?

I have tried using operator '+' like List but it doesn't work.

My code's here:

question1 = Question.query.filter_by(question_hard=1).order_by(func.random()).limit(10)
question2 = Question.query.filter_by(question_hard=2).order_by(func.random()).limit(20)

Looking for something like this: question = question1 + question2

user11527247 · Accepted Answer · 2019-12-24 15:30:05Z

3

You can use it this way:

question = question1.union(question2)

sqlalchemy.orm.query.Query.union

answered Dec 24, 2019 at 15:30

user11527247

2381 silver badge6 bronze badges

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

1 Comment

Khang Thinh Nguyen Over a year ago

Thank you very much! I tried putting all() after limit() and then I plus them like List. Fortunately, it also worked!

Collectives™ on Stack Overflow

Sqlalchemy-Python Plus two Base Query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related