do_list.py

[Uncle Buddy]

<drive>:\treebard\app\python\do_list.py Last Changed 2024-03-21

# do_list

import tkinter as tk
import sqlite3
from files import get_current_tree, appwide_db_path
from widgets import ScrolledDialog, Scrollbar, configall, make_formats_dict
from query_strings import select_to_do, insert_to_do, delete_do_list_item
import dev_tools as dt
from dev_tools import look, seeline





class DoList(tk.Frame):
   def __init__(
           self, master, formats, family_tree_id, tree, right_panel,  
           *args, **kwargs):
       tk.Frame.__init__(self, master, *args, **kwargs)
       self.master = master
       self.family_tree_id = family_tree_id
       self.formats = formats
       self.tree = tree.split("/")[-1].replace(".tbd", "").replace("_", " ").title()
       self.right_panel = right_panel

       self.highlight_bg = self.formats["highlight_bg"]
       
       self.slidevar = tk.DoubleVar(None, 1.0)

       self.make_widgets()
       self.make_inputs()

   def make_widgets(self):

       self.canvas = tk.Canvas(self)
       ScrolledDialog.nested_canvases.append(self.canvas)
       self.window = tk.Frame(self.canvas)
       self.canvas.create_window(
           0, 0, anchor="nw", window=self.window)
       sbv = Scrollbar(
           self, self.formats, command=self.canvas.yview, hideable=False)
       self.canvas.config(yscrollcommand=sbv.set)

       # children of self
       self.columnconfigure(0, weight=1)
       self.rowconfigure(0, weight=1)
       self.canvas.grid(column=0, row=0, sticky="news")
       sbv.grid(column=1, row=0, sticky="ns")  

   def make_inputs(self):
       conn = sqlite3.connect(appwide_db_path)
       conn.execute("PRAGMA foreign_keys = 1")
       cur = conn.cursor()
       self.current_tree = get_current_tree(self.family_tree_id, cur)[0]        
       cur.execute("ATTACH ? as tree", (self.current_tree,))
       head = tk.Label(self.window, text="Do List ({})".format(self.tree))
       self.do_list_frame = tk.Frame(self.window, takefocus=1)
       self.do_list_frame.bind("<Delete>", self.destroy_items)

       spacer = tk.Frame(self.window, bg="green")
       frm2 = tk.Frame(self.window, bd=2, relief='sunken')
       frm3 = tk.Frame(frm2)
       lab1 = tk.Label(frm3, text="New Item:", anchor="w")
       self.item_input = tk.Entry(frm3)
       self.priority_input = tk.Scale(
           frm2, variable=self.slidevar, length=180, orient="horizontal",
           to=1.0, from_=10.0, resolution=0.1, showvalue=1,
           label="Priority (low > high):")
       add_button = tk.Button(frm2, width=6, text="ADD", command=self.add)

       self.draw_do_list()

       # children of self.window:
       self.window.columnconfigure(0, weight=1)
       self.window.rowconfigure(2, weight=1)
       head.grid(column=0, row=0, sticky="w", columnspan=2, padx=(12,0), pady=(12,0))
       self.do_list_frame.grid(
           column=0, row=1, sticky="news", columnspan=2, padx=12, pady=12)
       spacer.grid(column=0, row=2, sticky="news", columnspan=2)
       frm2.grid(column=0, row=3, sticky="news", padx=12)

       # children of frm2
       frm2.columnconfigure(0, weight=1)
       frm3.grid(column=0, row=0, sticky="news", columnspan=2, padx=(0,6))
       self.priority_input.grid(column=0, row=1, padx=(6,0), pady=(3,6), sticky="ew")
       add_button.grid(column=1, row=1, sticky="se", padx=(0,6), pady=(0,6))

       # children of frm3
       frm3.columnconfigure(1, weight=1)
       lab1.grid(column=0, row=0, sticky="w", padx=(6,0), pady=(6,0))
       self.item_input.grid(column=1, row=0, sticky="ew", padx=(6,0), pady=(6,0))      

       self.update_idletasks()

       total = self.right_panel.winfo_reqwidth()
       diff = self.do_list_frame.winfo_reqwidth()
       item_width = total - (total - diff)

       for item in self.do_list_frame.winfo_children():
           item.config(wraplength=item_width)

       wd = self.window.winfo_reqwidth()
       ht = self.right_panel.winfo_reqheight() + 3
       self.canvas.config(width=wd, height=ht)        
       self.canvas.config(scrollregion=self.canvas.bbox('all'))

       cur.execute("DETACH tree")
       cur.close()
       conn.close()

   def draw_do_list(self):
       self.current_do_list = []
       conn = sqlite3.connect(self.current_tree)
       cur = conn.cursor()
       for child in self.do_list_frame.winfo_children():
           child.destroy()
       self.update_idletasks()
       wraplength = self.right_panel.winfo_reqwidth() - 72
       cur.execute(select_to_do)
       do_list = cur.fetchall()
       if len(do_list) != 0:
           for idx, item in enumerate(do_list):
               lab = tk.Label(
                   self.do_list_frame, anchor="w", text=item[1],
                   wraplength=wraplength, justify="left")
               lab.grid(column=0, row=idx, sticky="ew")
               lab.bind("<Double-Button-1>", self.highlight_items)
               self.current_do_list.append((lab, item[0]))
       else:
           self.do_list_frame.config(width=wraplength + 6)
       cur.close()
       conn.close()
       configall(self.do_list_frame, self.formats)

   def destroy_items(self, evt):
       all_items = self.do_list_frame.winfo_children()
       delete_these = []
       for idx, child in enumerate(all_items):
           if child.cget('bg') == self.highlight_bg:
               delete_these.append(self.current_do_list[idx])
       conn = sqlite3.connect(self.current_tree)
       conn.execute("PRAGMA foreign_keys = 1")
       cur = conn.cursor()
       for tup in list(delete_these):
           widg, to_do_id = tup
           cur.execute(delete_do_list_item, (to_do_id,))
           conn.commit()          

       cur.close()
       conn.close()

       self.draw_do_list()

   def highlight_items(self, evt):            
       widg = evt.widget
       self.do_list_frame.focus_set()
       self.update_idletasks()
       if widg.cget("bg") == self.highlight_bg:
           widg.config(bg=self.formats["bg"])
       else:
           widg.config(bg=self.formats["highlight_bg"])        

   def add(self):
       new_item = self.item_input.get()
       priority = self.slidevar.get()
       conn = sqlite3.connect(self.current_tree)
       conn.execute("PRAGMA foreign_keys = 1")
       cur = conn.cursor()
       cur.execute(insert_to_do, (new_item, priority))
       conn.commit()
       cur.close()
       conn.close()
       self.item_input.delete(0, "end")
       self.slidevar.set(1.0)
       self.draw_do_list()