Python计算每秒有多少次点击

import time
import MySQLdb

# 连接数据库
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="database")
cursor = db.cursor()

# 获取当前时间和一秒前的时间
current_time = time.time()
one_second_ago = current_time - 1

# 执行数据库查询
query = "SELECT COUNT(*) FROM clicks WHERE timestamp >= %s AND timestamp <= %s"
cursor.execute(query, (one_second_ago, current_time))

# 获取查询结果
clicks_per_second = cursor.fetchone()[0]

# 输出点击次数
print("每秒点击次数：", clicks_per_second)

# 关闭数据库连接
db.close()