生成每天重置的票证编号的最佳方法

CREATE TABLE tickets (
    id INT AUTO_INCREMENT PRIMARY KEY,
    ticket_number INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

import datetime
import mysql.connector

def generate_ticket_number():
    db = mysql.connector.connect(
        host="localhost",
        user="user",
        password="password",
        database="database"
    )
    cursor = db.cursor()

    today = datetime.date.today()
    cursor.execute("SELECT MAX(ticket_number) FROM tickets WHERE DATE(created_at) = %s", (today,))
    max_number = cursor.fetchone()[0]

    if max_number is None:
        max_number = 0

    new_ticket_number = max_number + 1
    cursor.execute("INSERT INTO tickets (ticket_number) VALUES (%s)", (new_ticket_number,))
    db.commit()

    cursor.close()
    db.close()

    return new_ticket_number

print(generate_ticket_number())