mindful.py

"""
Project: Super Health App
Creators: Aaryan Sharma, Ayush Bhardwaj
SparkHacks-2024 (University of Illinois at Chicago)
    hey"""

import tkinter as tk
from tkinter import scrolledtext
import sqlite3


class MindfulPage(tk.Frame):
    def __init__(self, master, goBackCall):
        super().__init__(master)
        self.master = master
        self.master.title('Mindful Space')
        self.widget()
        self.goBackCall = goBackCall
        self.pack()

    def widget(self):
        intro_label = tk.Label(self, text="Welcome to our search engine your health companion!",fg = "purple4", bg = "white", font =("Arial", 30, "bold"), wraplength=500, justify="left")
        intro_label.pack(pady=(10, 20))

        tk.Label(self, text="Enter tags for search:",fg = "purple4", bg = "white", font =("Arial", 30, "bold")).pack()
        self.search_entry = tk.Entry(self)
        self.search_entry.pack()

        self.content_var = tk.StringVar()
        self.content_var.set('book')

        tk.Radiobutton(self, text="Books/Articles",fg = "purple4", bg = "white", font =("Arial", 30, "bold"), variable=self.content_var, value='book').pack(anchor=tk.W)
        tk.Radiobutton(self, text="Videos",fg = "purple4", bg = "white", font =("Arial", 30, "bold"), variable=self.content_var, value='video').pack(anchor=tk.W)

        search_button = tk.Button(self, fg = "purple4", bg = "white", font =("Arial", 30, "bold"), text="Search", command=self.searchContent)
        search_button.pack(pady=20)

        back_button = tk.Button(self, fg = "purple4", bg = "white", font =("Arial", 30, "bold"), text="Back", command=self.goBack)
        back_button.pack(pady=20)

        # Change from Label to ScrolledText for displaying search results
        self.results_display = scrolledtext.ScrolledText(self, height=10, wrap=tk.WORD)
        self.results_display.pack(pady=20)

    def searchContent(self):
        content_type = self.content_var.get()
        search_tags = self.search_entry.get()
        results = self.getContent(content_type, search_tags)

        # Clear previous results
        self.results_display.delete('1.0', tk.END)

        if not results:
            self.results_display.insert(tk.END, "Uh Oh! No results found.\n\n")
        else:
            for title, url in results:
                self.results_display.insert(tk.END, f"Title: {title}\nURL: {url}\n\n")

    def getContent(self, content_type, search_tags):
        conn = sqlite3.connect('project.db')
        cursor = conn.cursor()
        search_query = f"%{search_tags}%"
        cursor.execute("SELECT title, url FROM mindful_space WHERE contentType=? AND (tags LIKE ? OR title LIKE ?)", (content_type, search_query, search_query))
        results = cursor.fetchall()
        conn.close()
        return results

    def goBack(self):
        self.destroy()
        self.goBackCall()