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

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()