如何将值（onoff）切换开关按钮插入sql flask

Question

我创建切换开关按钮，我想更新值切换时，我点击按钮。但是这个代码不起作用。请帮帮我

<style>
   .btn .off,.btn.active .on {
            display:block
            }
            .btn.active .off,.btn .on  {
                display:none

            }
</style>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
<form method="post" action="/update">
<div class="btn-group" data-toggle="buttons">
   <label class="btn active btn-insp">
    <input type="checkbox" autocomplete="off" id="gate" name="gate">
    <span class='on' id="gate_on" name="gate" value="1">On</span>
    <span class='off' id="gate_off" name="gate" value="0">Off</span>
   </label>
</div>
<input type="submit" value="OK" />
</form>

这是我的python代码

@app.route('/update', methods=['GET','POST'])
def update():
    if request.method == 'POST':
        gate = request.form['gate']

        conn = mysql.connect()
        cur = conn.cursor(pymysql.cursors.DictCursor)
        cur.execute(""" UPDATE `gate` SET `gate`=%s, WHERE `id`=%s """, (gate, id))
        conn.commit()
        return redirect(url_for('Index'))