def convert_data(data, format):
if format == "json":
return json.loads(data)
elif format == "csv":
return csv.DictReader(data.splitlines())
else:
raise ValueError("Unsupported format")
]]>
class User:
def __init__(self, username, role):
self.username = username
self.role = role
def has_permission(self, action):
allowed_actions = {
"admin": ["read", "write"],
"student": ["read"]
}
return self.role in allowed_actions and action in allowed_actions[self.role]
]]>
import mysql.connector
db = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="university_data"
)
cursor = db.cursor()
cursor.execute("CREATE TABLE IF NOT EXISTS students (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), age INT)")
]]>
from flask import Flask, request, jsonify
app = Flask(__name__)
@app.route('/add_student', methods=['POST'])
def add_student():
data = request.get_json()
# Validate data
cursor.execute("INSERT INTO students (name, age) VALUES (%s, %s)", (data['name'], data['age']))
db.commit()
return jsonify({"message": "Student added successfully"}), 201
]]>
本站知识库部分内容及素材来源于互联网,如有侵权,联系必删!