flask下的MySQL增查配置

flask下的MySQL增删配置

添加数据

@app.route('/add')
def add_data():
    u = UserInfo()
    new_user1 = UserInfo(nickname='flask_test1', mobile='13888888888', signature='理想', create_time=datetime.now(), role_id=1)
    new_user2 = UserInfo(nickname='flask_test2', mobile='13999999999', signature='信念', create_time=datetime.now(), role_id=2)
    new_user3 = UserInfo(nickname='flask_test3', mobile='13777777777', signature='坚持', create_time=datetime.now(), role_id=1)
    new_user4 = UserInfo(nickname='flask_test4', mobile='13666666666', signature='奋斗', create_time=datetime.now(), role_id=2)
    u.add(new_user1)
    u.add(new_user2)
    u.add(new_user3)
    u.add(new_user4)
    return "添加数据成功"

查询数据

@app.route('/query1')
def query_data1():
    user_list = UserInfo.query.all()
    result = []
    for user in user_list:
        result.append(user.to_dict())
    return {'users': result}

@app.route('/query2')
def query_data2():
    user=UserInfo.query.get(3)  #主键查询
    return {'users': user.to_dict()}

@app.route('/query3')
def query_data3():
    first_user = UserInfo.query.first()  #查询第一条数据
    return {'users': first_user.to_dict()}

@app.route('/query4')
def query_data4():
    user_list = UserInfo.query.filter(UserInfo.signature == '理想').all()  #条件查询
    result = []
    for user in user_list:
        result.append(user.to_dict())
    return {'users': result}

@app.route('/query5')
def query_data5():
    userlist = UserInfo.query.filter_by(signature='信念').all()  #根据字段
    result = []
    for user in userlist:
        result.append(user.to_dict())
    return {'users': result}