智慧会议创建

from flask import Flask, request, jsonify
import sqlite3

app = Flask(__name__)

def db_connection():
    conn = None
    try:
        conn = sqlite3.connect('meetings.db')
    except sqlite3.error as e:
        print(e)
    return conn

@app.route('/create_meeting', methods=['POST'])
def create_meeting():
    if request.is_json:
        meeting = request.get_json()
        title = meeting['title']
        date = meeting['date']
        time = meeting['time']
        
        conn = db_connection()
        cursor = conn.cursor()
        cursor.execute("INSERT INTO meetings (title, date, time) VALUES (?, ?, ?)", (title, date, time))
        conn.commit()
        conn.close()
        
        return jsonify({"message": "Meeting created successfully!"}), 201
    else:
        return jsonify({"error": "Request must be JSON"}), 400

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