POST sessionStorage object with AJAX to Flask

Question

I want to post each and every key with value to a function in the Flask framework to store them in a MySQL database. Would I be able do it this way?

JQuery

$.ajax({
        type: "POST",
        url: "{{url_for('savedata')}}", // Function to send data
        data: sessionStorage.serializeArray(),
        success: function(data) {
            window.location.replace("/quit"); // Redirect to another page after saving data
        }
});

app.py

conn = mysql.connect()
cursor = conn.cursor()
@app.route("/savedata"，methods=["POST"])
def savedata():
sql = "INSERT INTO data_table "
data = ""
for (var i = 0; i < sessionStorage.length; i++) {
    var item = sessionStorage.getItem(sessionStorage.key(i));
    data += "item " + "VARCHAR(255)"
}
sql += data
cursor.execute(sql)

score 0 · Answer 1 · answered Sep 07 '16 at 07:18

sessionStorage can't be converted to array

you can do something like this:

 var localdata = {};
   for ( var i = 0, len = localStorage.length; i < len; ++i ) {
           localdata[localStorage.key( i )] = localStorage.getItem( localStorage.key( i ) );

    }

and in the ajax:

data:localdata;

score 0 · Answer 2 · answered Sep 07 '16 at 07:58

0

Extending madalin's answer, I'd like to point out that you cannot work with sessionStorage directly from Flask, but only from you JS code. What you can do is an AJAX POST request with your keys/values from sessionStorage as a JSON string, and then accessing JSON in you Flask view with request.json or better request.get_json:

AJAX:

$.ajax({
    url: "{{ url_for('savedata', _external=True) }}",
    type: 'POST',
    dataType: 'json',
    contentType: 'application/json;charset=UTF-8',
    accepts: {
     json: 'application/json',
    },
    data: JSON.stringify(localdata), // see madalin's answer
    ...
})

Flask view:

@app.route("/savedata"，methods=["POST"])
def savedata():
    your_json_as_dict = request.get_json()
    ...

answered Sep 07 '16 at 07:58

vrs

1,922
16
23

In the Flask view, I would retrieve the JSON keys and values as a dictionary right? – Kimberley Chong Sep 07 '16 at 23:56
@KimberleyChong yes, as a Python dictionary. – vrs Sep 08 '16 at 06:57
@KimberleyChong glad it helped! Please, accept my answer and upvote, so that other people know it worked. – vrs Sep 08 '16 at 07:46
However, I am still encountering problems with it. The code just won't execute the AJAX – Kimberley Chong Sep 09 '16 at 00:18
@KimberleyChong it's better if you post a separate question with a minimal working example, otherwise it's hard to find out what's wrong. – vrs Sep 09 '16 at 09:49
I have asked another question [here](https://stackoverflow.com/questions/39411383/using-flask-mysqldb-to-insert-rows-into-database-with-ajax) – Kimberley Chong Sep 09 '16 at 12:30

POST sessionStorage object with AJAX to Flask

2 Answers2