Python, Flask: Executemany with multiple fields in HTML form

Question

I don't know how can I improve this code, I'm trying to insert multiple data with same field with different values. Can someone improve my code?

<form action="/submits/ method="POST">

    <input type="text" name="book" value="Divergent">
    <input type="text" name="author" value="Veronica Roth">

    <input type="text" name="book" value="Allegiant">
    <input type="text" name="author" value="Veronica Roth">

    <input type="text" name="book" value="Inferno">
    <input type="text" name="author" value="Dan Brown">

    <input type="submit" value="Submit">

</form>

@app.route('/submits/', methods = ['POST'])
def books():
    if method == "POST":
        BOOK = request.form['book']
        AUTHOR = request.form['author']
        stmt = "INSERT INTO shelf (book_column, author_column) VALUES (%s, %s)"
        c.executemany(stmt, (BOOK, AUTHOR))
        conn.commit()

First of all remove the typo here BOOK = request.form['book] you need one more single quote after book. — 0decimal0
– 0decimal0, Commented Sep 1, 2017 at 13:28
0decimal0 I'm not really sure if my code will really work, is it? I'm new to Python and Flask, may you consider this problem. — Jom
– Jom, Commented Sep 1, 2017 at 13:34

user8060120 · Accepted Answer · 2017-09-01 13:45:20Z

1

you can try use getlist:

if method == "POST":
    stmt = "INSERT INTO shelf (book_column, author_column) VALUES (%s, %s)"
    books = request.form.getlist('book')
    authors = request.form.getlist('author')
    for i, book in enumerate(books):
        c.executemany(stmt, (book, authors[i]))
        c.commit()

answered Sep 1, 2017 at 13:45

user8060120

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

Collectives™ on Stack Overflow

Python, Flask: Executemany with multiple fields in HTML form

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related