Create a column with an @property that hits an external service

[dwwoelfel]

I'm trying to add a column that pulls in data about my users from an external API. For example, I want to have a column that shows whether they're subscribed to a mailing list in Mailchimp.

I can easily add the column using @property, like this:

class User(db.Model):
  id = db.Column(db.Integer, primary_key=True)
  email = db.Column(db.String(255))
  @property
  def subscribed_to_list(self):
    requests.get("https://mailchimp.com/is_subscribed").text

With that approach every pageload takes multiple seconds as an API request is made for each row. Is there some way to send the computed property asynchronously?

I found form_ajax_refs, but I need something that works on the list page.

[zaniar]

Try to override ModelView's get_list() method