Python，Flask:HTML格式的多个字段的Executemany

Question

我不知道如何改进这段代码，我试图插入多个具有不同值的相同字段的数据。有人能改进我的代码吗？在

<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>

---

^{pr2}$

Answer 1

您可以尝试使用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()