def login():
        def validateLogin(username, password, window):
            res = singleSqlCommand(
                "SELECT * from Users_LogPas where user_login =\"{}\" AND user_pass=\"{}\"".format(username.get(),
                                                                                                  password.get()))
            if len(res) == 0:
                print("Not user, suggest registration")
            else:
                tkWindow.destroy()
                print(list(res[0]))
                if list(res[0])[2] != None:
                    print("student")
                    main_menu_student(list(res[0])[2])
                elif list(res[0])[3] != None:
                    print("teacher")
                    main_menu_teacher(list(res[0])[3])
                elif list(res[0])[4] != None:
                    print("stuff")
                    main_menu_staff(list(res[0])[4])
                else:
                    show("for teacher and staff window coming soon")

        tkWindow = Tk()
        tkWindow.configure(background='green')
        tkWindow.geometry('400x150')
        tkWindow.title('login')

        usernameLabel = Label(tkWindow, text="User Name").grid(row=0, column=0)
        username = StringVar()
        usernameEntry = Entry(tkWindow, textvariable=username).grid(row=0, column=1)

        passwordLabel = Label(tkWindow, text="Password").grid(row=1, column=0)
        password = StringVar()
        passwordEntry = Entry(tkWindow, textvariable=password, show='*').grid(row=1, column=1)

        validateLogin = partial(validateLogin, username, password, tkWindow)

        loginButton = Button(tkWindow, text="Login", highlightbackground="green", command=validateLogin).grid(row=4, column=0)

        tkWindow.mainloop()

    login()


if __name__ == '__main__':
    main()