sqlalchemy查询数据库并以html格式显示

pcrecxhr  于 2021-06-19  发布在  Mysql
关注(0)|答案(0)|浏览(342)

在flask web应用上工作,我有一个工作行sql命令将数据插入到我的数据库中。

if request.method == 'POST':
    cur = connection.cursor()
    employee_id = request.form['employee_id']
    emp_nums = {'1000': 'DEV', '1001': 'ANA'}
    if employee_id in emp_nums:
        print(employee_id)
        resultValue = cur.execute('''SELECT * FROM employee_data WHERE team 
        = "{}"'''.format(emp_nums[employee_id]))
        if resultValue > 0:
            print(resultValue)
            userDetails = cur.fetchall()
            return 
            render_template('attendance.html',userDetails=userDetails)
        return render_template('login.html')

我试图修改此代码以使用sqlalchemy,但无法获得查询结果

@app.route('/attendance', methods = ['GET', 'POST'])
def attendance():
    if request.method == 'POST':
        o_id = request.form['o__id']
        emp_nums = {'1000': 'DEV', '1001': 'ANA'}
        team = emp_nums.get(o_id,'')
        print('team is',team)
        userDetails = Employee_data.query.filter_by(team = team).all()
        print(userDetails)
       return render_template('take_attendance.html', 
       userDetails=userDetails)
    return 'no data corresponding '

上面的代码不返回任何内容。谢谢你的帮助

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题