基于科研信息管理系统的杭州项目进度优化研究

CREATE TABLE User (

UserID INT AUTO_INCREMENT PRIMARY KEY,

Name VARCHAR(50) NOT NULL,

Email VARCHAR(100) UNIQUE NOT NULL

);

CREATE TABLE Project (

ProjectID INT AUTO_INCREMENT PRIMARY KEY,

Title VARCHAR(100) NOT NULL,

StartDate DATE,

EndDate DATE

);

CREATE TABLE Task (

TaskID INT AUTO_INCREMENT PRIMARY KEY,

Title VARCHAR(100) NOT NULL,

Description TEXT,

Status ENUM('Pending', 'In Progress', 'Completed') DEFAULT 'Pending',

UserID INT,

ProjectID INT,

FOREIGN KEY (UserID) REFERENCES User(UserID),

高校排课系统

FOREIGN KEY (ProjectID) REFERENCES Project(ProjectID)

);

import mysql.connector

def update_task_status():

conn = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="research_system"

)

cursor = conn.cursor()

cursor.execute("UPDATE Task SET Status='Completed' WHERE Status='In Progress' AND EndDate <= CURDATE()")

conn.commit()

cursor.close()

conn.close()

if __name__ == "__main__":

update_task_status()