mysql每小时内数据条数为0

import mysql.connector
from datetime import datetime, timedelta

def insert_data():
    try:
        conn = mysql.connector.connect(
            host="your_host",
            user="your_user",
            password="your_password",
            database="your_database"
        )
        cursor = conn.cursor()
        query = "INSERT INTO test_table (timestamp) VALUES (%s)"
        value = (datetime.now(),)
        cursor.execute(query, value)
        conn.commit()
        print("Data inserted successfully")
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        if conn.is_connected():
            cursor.close()
            conn.close()

# 设置定时任务，每小时执行一次
schedule.every().hour.do(insert_data)

while True:
    schedule.run_pending()
    time.sleep(1)