一站式网上办事大厅

CREATE TABLE Trademark (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

registration_number VARCHAR(50) UNIQUE,

category ENUM('教育', '科技', '文化') NOT NULL,

status ENUM('已注册', '待审核', '未通过') DEFAULT '待审核',

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

from flask import Flask, request, jsonify

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:password@localhost/university'

db = SQLAlchemy(app)

class Trademark(db.Model):

id = db.Column(db.Integer, primary_key=True)

name = db.Column(db.String(255), nullable=False)

智慧学工管理系统

registration_number = db.Column(db.String(50), unique=True, nullable=False)

category = db.Column(db.Enum('教育', '科技', '文化'), nullable=False)

status = db.Column(db.Enum('已注册', '待审核', '未通过'), default='待审核')

created_at = db.Column(db.TIMESTAMP, server_default=db.func.current_timestamp())

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

def add_trademark():

data = request.get_json()

trademark = Trademark(

name=data['name'],

registration_number=data['registration_number'],

category=data['category']

)

db.session.add(trademark)

db.session.commit()

return jsonify({'message': '商标添加成功！'}), 201

if __name__ == '__main__':

app.run(debug=True)

@app.route('/get_trademarks', methods=['GET'])

def get_trademarks():

trademarks = Trademark.query.all()

result = []

for t in trademarks:

result.append({

'id': t.id,

'name': t.name,

'registration_number': t.registration_number,

'category': t.category,

'status': t.status,

'created_at': t.created_at

})

return jsonify(result)