python连接数据库2

import boto3
from flask import Flask , request , jsonify

app = Flask(name)

region = "us-east-1"
dynamodb = boto3.resource('dynamodb', region_name=region)
table = dynamodb.Table('product-table')

@app.route('/add_product', methods=['POST'])
def add_product():
data = request.get_json()
data1 = data["product"]
id1 = data1["code"]
id =id1[-2:]
price = int(data1["price"])
stock = int(data1["stock"])
table.put_item(
Item={
'id': id,
"name" : data1["name"],
'price': price,
'stock': stock
}
)
return jsonify(
{
"Codestatus":200 , "message": "successfully"
}
)

@app.route('/add_product', methods=['GET'])
def get_product1():
id = request.args.get("id")
data = table.get_item(
Key={
"id": id
}
)
item = data['Item']
return jsonify(
{
"Codestatus":200 ,"message": item,
}
)

@app.route('/update_product', methods=['PATCH'])
def get_product2():
id = request.args.get("id")
data = request.get_json()
data1 = data["changes"]
price = int(data1["price"])
stock = int(data1["stock"])
table.update_item(
Key={
"id": id
},
UpdateExpression="SET price=:val1, stock=:val2",
ExpressionAttributeValues={
':val1': price,
':val2': stock
}
)
return jsonify(
{
"Codestatus":200 ,"message":"successfully ",
}
)

@app.route('/update_product', methods=["DELETE"])
def get_product3():
id = request.args.get("id")
table.delete_item(
Key={
"id":id
}
)
return jsonify(
{
"Codestatus":200 ,"message": "successfully deleted",
}
)
if name == "main":
app.run(host="0.0.0.0",port=80)