-
is there a way to insert specific event dates and other info in a calendar date cell
almost 3 years ago
almost 3 years ago
I am trying to select data from the sqllite3 database and insert them into the tkcalendar so the user can insert his event info (registration_check_date, car_type) and view them by clicking on the calendar specific colored date cell, I had converted the selected database data into a tuple, so it's can be inserted as a colored event cell in the calendar but the only info I get is the date when I clicked in the event cell, is there a way to get the date and car_type in a label.
rom tkinter import *from tkinter import ttkimport datetimefrom tkcalendar import DateEntry,Calendar# fuction to get the event date(is there a way to get the other info)def grad_date(self, event):self.eventl.config(text="Selected Date is: " +self.buyingcarsrigcal.get_date())self.events = self.cursorObj.execute('SELECTregistration_check_date, car_type FROM buying_rigistration_dateorder by registration_check_date')self.buying_registrationdates_event_output=self.cursorObj.fetchall()self.eventdict=dict(self.buying_registrationdates_event_output)self.buyingcarsrigcal = Calendar(self.buyingcars_calendar_frame,selectmode='day',year=2022, month=1,day=1)self.buyingcarsrigcal.pack(pady=20, fill="both", expand=True)for k in self.eventdict.keys():date = datetime.strptime(k, "%m-%d-%Y").date()self.buyingcarsrigcal.calevent_create(date, self.eventdict[k][0], self.eventdict[k][1])self.eventl = Label(self.buyingcars_calendar_frame, text="")self.eventl.pack(pady=20)self.buyingcarsrigcal.bind("<<CalendarSelected>>",self.grad_date)
rom tkinter import *
from tkinter import ttk
import datetime
from tkcalendar import DateEntry,Calendar
# fuction to get the event date(is there a way to get the other info)
def grad_date(self, event):
self.eventl.config(text="Selected Date is: " +
self.buyingcarsrigcal.get_date())
self.events = self.cursorObj.execute('SELECT
registration_check_date, car_type FROM buying_rigistration_date
order by registration_check_date')
self.buying_registrationdates_event_output=self.cursorObj.fetchall()
self.eventdict=dict(self.buying_registrationdates_event_output)
self.buyingcarsrigcal = Calendar(self.buyingcars_calendar_frame,
selectmode='day',year=2022, month=1,day=1)
self.buyingcarsrigcal.pack(pady=20, fill="both", expand=True)
for k in self.eventdict.keys():
date = datetime.strptime(k, "%m-%d-%Y").date()
self.buyingcarsrigcal.calevent_create(date, self.eventdict[k]
[0], self.eventdict[k][1])
self.eventl = Label(self.buyingcars_calendar_frame, text="")
self.eventl.pack(pady=20)
self.buyingcarsrigcal.bind("<<CalendarSelected>>",self.grad_date)
0 Answer(s)