【python】python社交交友平台系统设计与实现（源码+数据库）【独一无二】

import pymysql
import sys

connection = pymysql.connect(host='127.0.0.1',
                             user='root',
                             password='root',
                             db='SocialNetwork',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

CREATE DATABASE SocialNetwork;

USE SocialNetwork;

-- 用户表
CREATE TABLE Users (
    user_id INT AUTO_INCREMENT PRIMARY KEY,
    # 略....
    name VARCHAR(50),
    gender ENUM('M', 'F', 'Other'),
    birth_date DATE,
    age INT
);

-- 好友关系表
CREATE TABLE Friends (
    user_id INT,
    # 略....
    PRIMARY KEY (user_id, friend_id)
);

-- 朋友圈表
CREATE TABLE Moments (
    moment_id INT AUTO_INCREMENT PRIMARY KEY,
    # 略....>👉👉👉 源码获取 关注【测试开发自动化】公众号，回复 “社交” 获取。👈👈👈

    FOREIGN KEY (user_id) REFERENCES Users(user_id)
);

-- 评论表
CREATE TABLE Comments (
    comment_id INT AUTO_INCREMENT PRIMARY KEY,
    # 略....
    FOREIGN KEY (user_id) REFERENCES Users(user_id)
);

def login():
    username = input("请输入用户名: ")
    password = input("请输入密码: ")
    try:
        with connection.cursor() as cursor:
            sql = "SELECT * FROM Users WHERE username = %s AND password = %s"
            # 略 ....
    except Exception as e:
        print(e)

def register():
    username = input("请选择用户名: ")
    password = input("请选择密码: ")
    try:
        with connection.cursor() as cursor:
            # 略 ....
    except Exception as e:
        print("注册失败，错误: ", e)
        main_menu()

def user_menu(user_id):
    print("\n======用户菜单======")
    print("1. 更新资料")
    print("2. 管理好友")
    # 略 ....>👉👉👉 源码获取 关注【测试开发自动化】公众号，回复 “社交” 获取。👈👈👈

def update_profile(user_id):
    print("\n******更新资料******")
    name = input("请输入全名: ")
    # 略 ....

def manage_friends(user_id):
    print("\n======管理好友======")
    print("1. 添加好友")
    print("2. 删除好友")
    # 略 ....

def add_friend(user_id):
    friend_name = input("请输入要添加的好友用户名: ")
    group_name = input("请输入该好友的分组名称: ")
    try:
        with connection.cursor() as cursor:
            # 略 ....

def remove_friend(user_id):
    friend_name = input("请输入要删除的好友用户名: ")
    try:
        with connection.cursor() as cursor:
            sql = "SELECT user_id FROM Users WHERE username = %s"
            cursor.execute(sql, (friend_name,))
            # 略 ....

def list_friends(user_id):
    try:
        with connection.cursor() as cursor:
            sql = "SELECT username FROM Users WHERE user_id IN (SELECT friend_id FROM Friends WHERE user_id = %s)"
            cursor.execute(sql, (user_id,))
            results = cursor.fetchall()
            # 略 ....

def post_moment(user_id):
    content = input("请输入动态内容（最多300字符）: ")
    if len(content) > 300:
        # 略 ....