import kivy
from kivy.app import App
from kivy.uix.gridlayout import GridLayout
from kivy.uix.label import Label
from kivy.uix.textinput import TextInput
from kivy.uix.button import Button
import mysql.connector

class Formularz(GridLayout):
    def __init__(self, **kwargs):
        super(Formularz, self).__init__(**kwargs)
        self.cols = 2
        self.label = self.add_widget(Label(text="Wpisz swój login", font_size="17"))
        self.login = TextInput(hint_text="Wpisz login", padding=[28,24,3,1])
        self.login.background_color = [1,1,0,1]
        self.add_widget(self.login)
        self.label2 = self.add_widget(Label(text="Wpisz swoje hasło", font_size="17"))
        self.haslo = TextInput(hint_text="Wpisz hasło", padding=[28,24,3,1], multiline = False, password=True)
        self.haslo.background_color = [1,1,0,1]
        self.add_widget(self.haslo)
        self.submit=Button(text="Wyślij", font_size="22")
        self.submit.background_color = [1,0,0,1]
        self.add_widget(self.submit)
        self.submit.bind(on_press=self.sprawdz)
        self.wynik=Label(text="", font_size="12")
        self.add_widget(self.wynik)
        
    def sprawdz(self, instance):
        login = self.login.text
        haslo = self.haslo.text
        baza = mysql.connector.connect(
            host = "localhost",
            user = "root",
            password = "",
            database = "dane"
            
        )
        zapytanie = """SELECT login, haslo FROM uzytkownicy WHERE login =%s AND haslo=%s"""
        con = baza.cursor()
        con.execute(zapytanie, (login,haslo))
        wynik = con.fetchall()
        if len(wynik) >0:
            self.wynik.text=f"Jesteś zalogowany jako {login}"
            self.login.text==""
            self.haslo.text==""
        else:
            self.wynik.text=f"Podałeś złe dane"
            self.login.text==""
            self.haslo.text==""
class MobileApp(App):
    def build(self):
        return Formularz()
        
if __name__=='__main__':
    MobileApp().run()