实验室信息管理系统

from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///lab_info.db'
db = SQLAlchemy(app)

class Sample(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    status = db.Column(db.String(20), default='Pending')

@app.route('/samples', methods=['POST'])
def add_sample():
    data = request.get_json()
    new_sample = Sample(name=data['name'])
    db.session.add(new_sample)
    db.session.commit()
    return jsonify({'message': 'Sample added successfully'}), 201

@app.route('/samples/<int:id>', methods=['GET'])
def get_sample(id):
    sample = Sample.query.get_or_404(id)
    return jsonify({'name': sample.name, 'status': sample.status})

if __name__ == '__main__':
    db.create_all()
    app.run(debug=True)