python中的IF语句with请求.form.get()

Question

我尝试在SQlite数据库中执行“INSERT INTO table（…）”，这取决于用户在我的网站上选择的选项。以下是我的html（在顶部）和python（底部）的一部分：

<form action="/calendar" method="post" autofocus name="name" placeholder="name" type="text">
        <div class="form-group">
            <select class="form-control" name="expenses">
                <option disabled selected value>Expenses</option>
                    <option value="home">home expense</option>
                    <option value="food">food expense</option>
                    <option value="child">child expense</option>
                    <option value="debt">debt expense</option>
                    <option value="healthcare">healthcare expense</option>
                    <option value="transportation">transportation expense</option>
                    <option value="personalcare">personalcare expense</option>
                    <option value="petcare">petcare expense</option>
                    <option value="entertainment">entertainment expense</option>
                    <option value="others">others expense</option>

            </select>


if request.method == "POST":
        # return apology page if anything isn't provided correctly
        note = request.form.get("note")
        amount = float(request.form.get("amount"))
        if amount < 0:
            return apology("provide positive amount")

        if request.form.get("home"):

            db.execute("INSERT INTO home (id, amount, note, date) VALUES(:id, :amount, :note, :date)", id=session["user_id"], amount=usd(amount), note=note, date=now.strftime("%Y-%m-%d %H:%M:%S"))

        elif request.form.get("food"):

            db.execute("INSERT INTO food (id, amount, note, date) VALUES(:id, :amount, :note, :date)", id=session["user_id"], amount=usd(amount), note=note, date=now.strftime("%Y-%m-%d %H:%M:%S"))

如果我不使用If语句，它会正确地插入数据，但是如果使用If语句，它就不能正确地插入数据了。有人能给我一个解释吗？或者给我一些其他的方法来使用python和SQLite数据库来获得同样的结果？在

Answer 1

没有带有name="home"或name="food"的表单输入。这些只是<select>中的选项值，其名称为expenses。你想要的是：

expenses = request.form.get("expenses")
if expenses == "home":
    db.execute("INSERT INTO home (id, amount, note, date) VALUES(:id, :amount, :note, :date)", id=session["user_id"], amount=usd(amount), note=note, date=now.strftime("%Y-%m-%d %H:%M:%S"))
elif expenses = "food":
    db.execute("INSERT INTO food (id, amount, note, date) VALUES(:id, :amount, :note, :date)", id=session["user_id"], amount=usd(amount), note=note, date=now.strftime("%Y-%m-%d %H:%M:%S"))