一站式网上办事大厅

from flask import Flask, request, jsonify

import sqlite3

app = Flask(__name__)

def init_db():

conn = sqlite3.connect('repair.db')

c = conn.cursor()

c.execute('''CREATE TABLE IF NOT EXISTS repairs

(id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT,

description TEXT,

status TEXT)''')

conn.commit()

conn.close()

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

def submit_repair():

data = request.json

name = data.get('name')

desc = data.get('description')

conn = sqlite3.connect('repair.db')

数据中台设计

c = conn.cursor()

c.execute("INSERT INTO repairs (name, description, status) VALUES (?, ?, 'pending')", (name, desc))

conn.commit()

conn.close()

return jsonify({"message": "报修提交成功"}), 201

if __name__ == '__main__':

init_db()

app.run(debug=True)