基于Rambarun Komaljeet日历的Tkinter日期选择功能改造需求

Hey Paolo from Bari, Italy! Let's get your calendar component working exactly how you want—closing on date selection, filling the data_operation field, and supporting MySQL read/write updates. Here's a step-by-step breakdown with actionable code tweaks:

1. Modify the Calendar Popup to Populate the Field & Close #

First, we’ll adjust the calendar so clicking a date automatically closes the popup and fills your data_operation field. Assuming you’re using Rambarun Komaljeet’s calendar implementation (which uses a Toplevel window), here’s how to add the selection logic:

import tkinter as tk
from tkinter import ttk
# Import the calendar module (adjust the import path to match your setup)
from your_calendar_file import Calendar  

def open_calendar():
    # Create the calendar popup
    cal_popup = tk.Toplevel(root)
    cal_popup.title("Pick a Date")
    
    # Initialize the calendar with your preferred date format
    cal = Calendar(cal_popup, selectmode='day', date_pattern='yyyy-mm-dd')
    cal.pack(padx=10, pady=10)
    
    # Handle date selection
    def on_date_selected(event):
        # Grab the selected date
        selected_date = cal.get_date()
        # Update the data_operation field
        data_operation_entry.delete(0, tk.END)
        data_operation_entry.insert(0, selected_date)
        # Close the popup immediately
        cal_popup.destroy()
    
    # Bind the selection event (adjust if your calendar uses a different trigger)
    cal.bind("<<CalendarSelected>>", on_date_selected)

# Main window setup
root = tk.Tk()
root.title("Date Operation Tool")

# Your target data_operation field
data_operation_entry = ttk.Entry(root, width=25)
data_operation_entry.pack(padx=20, pady=20)

# Button to open the calendar
open_cal_btn = ttk.Button(root, text="Select Date", command=open_calendar)
open_cal_btn.pack(pady=10)

root.mainloop()

Note: If your calendar uses a button to confirm selection instead of a click event, replace the binding with a confirm button inside the popup that triggers on_date_selected.

2. Add MySQL Read & Update Functionality #

Next, let’s add code to pull an existing date from MySQL into the field, and push changes back to the database. We’ll use mysql-connector-python for this:

First, install the connector if you haven’t:

pip install mysql-connector-python

Then add these database helper functions:

import mysql.connector
from mysql.connector import Error

def load_date_from_mysql():
    """Fetch the stored date from MySQL and populate the field"""
    try:
        # Connect to your database (replace with your actual credentials)
        connection = mysql.connector.connect(
            host="your_db_host",
            database="your_db_name",
            user="your_db_user",
            password="your_db_password"
        )
        
        if connection.is_connected():
            cursor = connection.cursor()
            # Replace with your table, column, and record identifier
            query = "SELECT data_operation FROM your_table WHERE record_id = %s"
            cursor.execute(query, (1,))  # Use your target record's ID here
            result = cursor.fetchone()
            
            if result:
                saved_date = result[0]
                data_operation_entry.delete(0, tk.END)
                data_operation_entry.insert(0, saved_date)
                
    except Error as e:
        print(f"Error loading date: {str(e)}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

def save_date_to_mysql():
    """Update MySQL with the current value in data_operation"""
    new_date = data_operation_entry.get()
    if not new_date:
        print("Please select or enter a valid date first!")
        return
    
    try:
        connection = mysql.connector.connect(
            host="your_db_host",
            database="your_db_name",
            user="your_db_user",
            password="your_db_password"
        )
        
        if connection.is_connected():
            cursor = connection.cursor()
            # Replace with your table, column, and record identifier
            query = "UPDATE your_table SET data_operation = %s WHERE record_id = %s"
            cursor.execute(query, (new_date, 1))
            connection.commit()
            print("Date updated in MySQL successfully!")
            
    except Error as e:
        print(f"Error saving date: {str(e)}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

3. Integrate Everything into Your App #

Add buttons to trigger load/save actions, and auto-load the stored date when the app starts:

# Add to main window setup
load_btn = ttk.Button(root, text="Load Saved Date", command=load_date_from_mysql)
load_btn.pack(pady=5)

save_btn = ttk.Button(root, text="Save Date to Database", command=save_date_to_mysql)
save_btn.pack(pady=5)

# Auto-load the saved date when the app opens
load_date_from_mysql()

root.mainloop()

Quick Tips #

• Replace all placeholder values (database credentials, table names, record IDs) with your actual MySQL setup.
• Add date format validation (e.g., check if the input matches yyyy-mm-dd) before saving to MySQL to avoid invalid data.
• If your calendar component uses a different method to retrieve selected dates, adjust the on_date_selected function to match its API.

内容的提问来源于stack exchange，提问作者pdecaro