# Database schema example using SQLAlchemy ORM

from sqlalchemy import Column, Integer, String, Text

from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class User(Base):

__tablename__ = 'users'

id = Column(Integer, primary_key=True)

数据分析平台

name = Column(String(50), nullable=False)

email = Column(String(100), unique=True)

class Project(Base):

__tablename__ = 'projects'

id = Column(Integer, primary_key=True)

title = Column(String(100), nullable=False)

description = Column(Text)

status = Column(String(20))

]]>

# Example Flask app setup

from flask import Flask, request, jsonify

from models import db, User, Project

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///科研管理系统.db'

@app.route('/project', methods=['POST'])

def create_project():

data = request.get_json()

new_project = Project(title=data['title'], description=data['description'])

db.session.add(new_project)

db.session.commit()

return jsonify({'message': 'Project created successfully!'}), 201

if __name__ == '__main__':

db.init_app(app)

app.run(debug=True)

]]>