CREATE TABLE Assets (
AssetID INT PRIMARY KEY AUTO_INCREMENT,
AssetName VARCHAR(100) NOT NULL,
Category VARCHAR(50),
PurchaseDate DATE,
Value DECIMAL(10, 2)
);
CREATE TABLE Users (
UserID INT PRIMARY KEY AUTO_INCREMENT,
UserName VARCHAR(50) NOT NULL,
Role ENUM('Admin', 'User') DEFAULT 'User'
);
]]>
from flask import Flask, request, jsonify
import mysql.connector
app = Flask(__name__)
@app.route('/assets/query', methods=['GET'])
def query_assets():
category = request.args.get('category')
db = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="asset_management"
)
cursor = db.cursor()
cursor.execute("SELECT * FROM Assets WHERE Category=%s", (category,))
result = cursor.fetchall()
db.close()
return jsonify(result)
if __name__ == '__main__':
app.run(debug=True)
]]>