type_elements.py

[Uncle Buddy]

<drive>:\treebard\app\python\search.py Last Changed 2023-12-26

# type_elements.py

import sqlite3
from files import current_drive, default_new_tree
from query_strings import (
   select_all_event_types, select_all_name_types,
)
import dev_tools as dt
from dev_tools import look, seeline



def get_all_event_types(full_path_to_tree):
   conn = sqlite3.connect(full_path_to_tree)
   cur = conn.cursor()
   cur.execute(select_all_event_types)
   all_event_types = [i[0] for i in cur.fetchall()]
   cur.close()
   conn.close()
   return all_event_types

def get_all_name_types(full_path_to_tree):
   conn = sqlite3.connect(full_path_to_tree)
   cur = conn.cursor()
   cur.execute(select_all_name_types)
   all_name_types = [i[0] for i in cur.fetchall()]
   cur.close()
   conn.close()
   return all_name_types