CREATE TABLE users (

user_id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(255) NOT NULL,

password VARCHAR(255) NOT NULL

);

CREATE TABLE content (

content_id INT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255) NOT NULL,

description TEXT,

author_id INT,

FOREIGN KEY (author_id) REFERENCES users(user_id)

);

CREATE TABLE leaderboard (

user_id INT PRIMARY KEY,

多系統(tǒng)單點(diǎn)登錄

score INT NOT NULL,

FOREIGN KEY (user_id) REFERENCES users(user_id)

);

from flask import Flask, jsonify, request

app = Flask(__name__)

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

def get_leaderboard():

# 查詢排行榜數(shù)據(jù)

leaderboard = []

# 假設(shè)我們有一個(gè)數(shù)據(jù)庫連接對(duì)象db_connection

cursor = db_connection.cursor()

cursor.execute("SELECT * FROM leaderboard ORDER BY score DESC")

for row in cursor.fetchall():

leaderboard.append({'user_id': row[0], 'score': row[1]})

return jsonify(leaderboard)

if __name__ == '__main__':

app.run(debug=True)