Flask redirect is not refreshing the browser page

Question

I am programming a Flask/MySQL/Python/HTML web application. When I perform an update to the database I want my webpage to refresh back to the blog itself to display the new entry. The database does update, but the browser will not refresh to the main page.

This is the python code for the application.

    import pymysql.cursors
    from flask import Flask, render_template, request, json, redirect, url_for
    import datetime

    app = Flask(__name__)

    connection = pymysql.connect(host='localhost',
                                user='root',
                                password='m0nkwork',
                                db='mydb',
                                charset='utf8mb4',
                                cursorclass=pymysql.cursors.DictCursor)

    def FixDates(data):
        for item in data:
            date = item['published']
            item['published'] = date.strftime("%A %B %d, %Y")


    @app.route('/')
    @app.route('/index')
    def index():
        cursor = connection.cursor()
        sql = "SELECT * FROM blogentry"
        cursor.execute(sql)
        data = cursor.fetchall()
        cursor.close()
        FixDates(data)
        return render_template('home.html', data=data)


    @app.route('/NewBlog')
    def NewBlog():
        return render_template('newblog.html')


    @app.route('/NewBlog',methods=['POST'])
    def AddBlog():

        # read the posted values from the UI
        Title = request.form['inputTitle']
        Text = request.form['inputText']
        Author = request.form['inputAuthor']

        # validate the received values
        if Title and Text and Author:
            cursor = connection.cursor()
            # Create a new record
            sql = "INSERT INTO blogentry (blogtitle, blogtext, blogauthor, published) VALUES (%s, %s, %s, %s)" 
            cursor.execute(sql, (Title, Text, Author, datetime.datetime.now()))

            # connection is not autocommit by default. So you must commit to save
            # your changes.
            connection.commit()
            return redirect(url_for('index'))
        else:
            connection.close()
            return render_template('newblog.html')

    if __name__ == '__main__':
        app.run(debug=True)

AddBlog is the page containing the form to add a new blog entry. The redirect is going to the index function which is supposed to call the database again, get the data and send it to the home.html page and render the page. This doesn't happen. This function is called but render_template does not refresh the page. The newblog.html page stays put.

Edit: I don't have any ajax code, just a Jquery that handles the onclick and sends it to the python program.

Here is my newblog.html which contains the form and the jquery call to process the form.





    Python Flask Bucket List App
    




    
        
            Navbar
            
            
                
                    Home (current)
                    Add New Blog
                
            
        

        
            Bucket List App
            
                Blog Title
                
                
                Blog Text
                
                
                Author
                
                
                
            
        

        
            © Company 2015

Anup · Accepted Answer

Try adding the header after_request, something like below,

@app.after_request
def adding_header_content(head):
    head.headers["Cache-Control"] = "no-cache, no-store, must-revalidate"
    head.headers["Pragma"] = "no-cache"
    head.headers["Expires"] = "0"
    head.headers['Cache-Control'] = 'public, max-age=0'
    return head

UPDATE: Updating the answer after, the Jquery ajax call code,

Use window.location() to redirect the browser once the server sends a positive response.

success: function (response) {
           window.location("/index");
         },

Flask redirect is not refreshing the browser page

Answers (1)

Related Questions