python - How do I add an additional entry in SQL Server from Flask?

Question

Hello I am unable to add new entries into my Microsoft SQL database through flask. I have made sure that the connection is working by retrieving entries from the database and displaying them on the page. I have tried many different codes but none of them seems to work. Help!

@app.route('/message', methods=["POST"])
def message():
    try:
        username = request.form.get('username')
        message = request.form.get('message')
        #print(username)
        #print(message)
        

        pusher_client.trigger('chat-channel', 'new-message', {'username' : username, 'message': message})

        insert_query = '''INSERT INTO dbo.Bin (RequestNumber, Request) VALUES(?, ?);'''
        values = (10, message)
        cursor.execute(insert_query, values)
        
        conn.commit()
        
        return jsonify({'result' : 'success'})
    except:
        return jsonify({'result' : 'failure'})
        
    
    
    
    
    return ' '

Answer 1

等待大神答复