-- 创建资产表
CREATE TABLE assets (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
type VARCHAR(100),
purchase_date DATE,
status ENUM('active', 'inactive') DEFAULT 'active'
);
]]>
from flask import Flask, request, jsonify
app = Flask(__name__)
@app.route('/asset', methods=['POST'])
def add_asset():
data = request.get_json()
# 假设已有数据库连接
cursor.execute("INSERT INTO assets (name, type, purchase_date) VALUES (%s, %s, %s)",
(data['name'], data['type'], data['purchase_date']))
return jsonify({"message": "Asset added successfully"}), 201
if __name__ == '__main__':
app.run(debug=True)
]]>