python - 如何修复计数查询 mysql 中的输出(flask)

Question

如何修复计数查询 mysql (flask) 中的输出

def addcart():
    cur = mysql.connection.cursor()
    if 'uid' not in session:
        noOfItems = 0
    else:
        uid = session['uid']
        cur.execute("SELECT count(id_phone) FROM cart WHERE id_users = " + str(uid))
        noOfItems = cur.fetchall()
    return (noOfItems)


@app.route('/')
def index():
    noOfItems = addcart()
    return render_template("index.html", noOfItems=noOfItems)

在我的导航栏中

<a href="#" class="btn btn-more i-left">
<small><span class="badge badge-primary">{{noOfItems}}</span></small>
</a>

OUTPUT : ({'count(id_phone)': 3},)

Answer 1

def get_num_of_items():
    cur = mysql.connection.cursor()
    if 'uid' not in session:
        num_of_items= 0
    else:
       uid = session['uid']
       cur.execute("SELECT count(id_phone) FROM cart WHERE id_users = " + str(uid))
       # cur.fetchone() return a dict with a single key:value pair
       num_of_items =  [v for v in cur.fetchone().values()][0]
    return num_of_items