What about requests that are repeated in multiple routes?

Question

ORM

For example, here is a query:

News.query.filter_by(n_active=1).order_by(News.n_id.desc()).all()

It is used in 3 routes.
/
/news
/admin/editnews/

What is the right way to deal with repeated requests?
Move it to a separate function? Or maybe in a separate file and wrapped in a class?
Advise, plz, what is the right way?

Answer 1

class News(db.Model):
  ...
  @classmethod
  get_active_news(cls):
    return cls.query.filter_by(n_active=1).order_by(News.n_id.desc()).all()

Then use:
active_news = News.get_active_news()