实时更新mysql里面的状态字段

Question

python开发，项目表（mysql）里面有一个status(状态)字段，这个字段需要根据项目的 开始和结束时间，实时更新。状态分为：未开始、进行中、已结束。
请问用Python怎么做呢？

Answer 1

看一下这个：

import pymysql  
  
# 连接MySQL数据库  
connection = pymysql.connect(  
    host='your_host',  
    user='your_user',  
    password='your_password',  
    database='your_database'  
)  
  
try:  
    with connection.cursor() as cursor:  
        # 查询项目表并更新状态  
        sql = "UPDATE project_table SET status = CASE WHEN start_time >= CURRENT_TIMESTAMP AND end_time <= CURRENT_TIMESTAMP THEN '进行中' WHEN start_time > CURRENT_TIMESTAMP THEN '未开始' WHEN end_time < CURRENT_TIMESTAMP THEN '已结束' END WHERE project_id = %s"  
        cursor.execute(sql, (project_id,))  
  
    # 提交事务  
    connection.commit()  
  
finally:  
    connection.close()