import tkinter as tk
import pymysql

TITLE_FONT = ("Helvetica", 18, "bold")

class dbapp(tk.Tk):

    def __init__(self, *args, **kwargs):
        tk.Tk.__init__(self, *args, **kwargs)

        # the container is where we'll stack a bunch of frames
        # on top of each other, then the one we want visible
        # will be raised above the others
        container = tk.Frame(self)
        container.pack(side="top", fill="both", expand=True)
        container.grid_rowconfigure(0, weight=1)
        container.grid_columnconfigure(0, weight=1)

        self.frames = {}
        for F in (StartPage, PageOne, PageTwo):
            page_name = F.__name__
            frame = F(container, self)
            self.frames[page_name] = frame

            # put all of the pages in the same location;
            # the one on the top of the stacking order
            # will be the one that is visible.
            frame.grid(row=0, column=0, sticky="nsew")

        self.show_frame("StartPage")

    def show_frame(self, page_name):
        '''Show a frame for the given page name'''
        print(page_name)
        frame = self.frames[page_name]
        frame.tkraise()


class StartPage(tk.Frame):
    #self.dbconn=False
    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)
        self.controller = controller
        self.dbconnect()
        print(self.dbconn)
        label = tk.Label(self, text="Student Database", font=TITLE_FONT)
        label.pack(side="top", fill="x", pady=10)
        self.f1=tk.Frame(self)
        self.f1.pack()
        label1 = tk.Label(self.f1, text="Database Not Connected.", font=TITLE_FONT)
        label1.pack(side="left", fill="x", pady=10)
        button = tk.Button(self.f1, text="Reconnect",command=lambda:self.conchk())
        button.pack()
        self.f2=tk.Frame(self)
        label1 = tk.Label(self.f2, text="Connected.", font=TITLE_FONT)
        label1.pack(side="left", fill="x", pady=10)

        self.conchk()
        
    def conchk(self):
        self.dbconnect()
        if(self.dbconn):
            self.f1.destroy()
            self.f2.pack()

    def dbconnect(self):
        print("called")
        try:
            conn = pymysql.connect(host='localhost', user='root', passwd='', db='python')
            self.dbconn= True
        except Exception:
            self.dbconn= False
           
                        


class PageOne(tk.Frame):

    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)
        self.controller = controller
        label = tk.Label(self, text="This is page 1", font=TITLE_FONT)
        label.pack(side="top", fill="x", pady=10)
        button = tk.Button(self, text="Go to the start page",
                           command=lambda: controller.show_frame("StartPage"))
        button.pack()
        


class PageTwo(tk.Frame):

    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)
        self.controller = controller
        label = tk.Label(self, text="This is page 2", font=TITLE_FONT)
        label.pack(side="top", fill="x", pady=10)
        button = tk.Button(self, text="Go to the start page",
                           command=lambda: controller.show_frame("StartPage"))
        button.pack()


if __name__ == "__main__":
    app = dbapp()
    app.geometry("400x400+20+20")
    app.mainloop()