Python flask - refresh html view when a database change has accrued

Question

I'm developing a stock market app with a python flask framework. The user has a route where he can see his details and the number of shares.

If a change in the user shares has occurred, I would like it to be displayed automatically. (Without the need for the user to refresh the page).

To make a long story short, I would like the '/user_page/<user_name>' route to refresh automatically when the '/update_page/' route is writing to the DB.

@app.route('/user_page/<user_name>', methods=['GET', 'POST'])
def user_page(user_name):
    user = Users.query.filter_by(user_name=user_name).first()
    return render_template('user_page.html', user=user)

@app.route('/update_page/<user_name>', methods=['GET', 'POST'])
def update_user_holdiongs(user_name):
    if user_name.bid > last_bid:
        change = TradeBids.query.filter_by(id=user_name.id).update(dict(share_amount=user_name.share_amount - bid.share_amount))

db.session.add(bid)
db.session.commit()

You could use AJAX to achieve this. What do you use for your frontend ? — Ram
– Ram, Commented Jun 26, 2021 at 11:58

Владислав Небеснюк · Accepted Answer · 2021-07-01 10:00:48Z

1

You can use AJAX to monitor changes on your backend and refresh (or rewrite) page.
You need something like that:

setInterval(function() {
    // AJAX send request
    $.ajax({
        url: "your url here",
        type: "GET",
        dataType: "json",
        success: function (data) {
            if (data.success) {
                location.reload();
            }
        },
        error: function (request, error) {}
    });
}, 30000);  // check about changes every 30 seconds

answered Jul 1, 2021 at 10:00

Владислав Небеснюк

7741 gold badge6 silver badges12 bronze badges

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

1 Comment

Владислав Небеснюк Over a year ago

@Monty_emma have a nice day) You can mark answer as correct)

Collectives™ on Stack Overflow

Python flask - refresh html view when a database change has accrued

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