#!/usr/bin/env python
# -*- coding: utf-8 -*-
import tkinter as tk
from tkinter.filedialog import *
from tkinter import ttk
from tkinter import tix
import tkinter.messagebox
import time
import sys
import pymysql

#from Home import *


def id():

    conect=Tk()
    conect.geometry("%dx%d+%d+%d" % (450, 120, 200, 200))
    conect.title("Authentification")

    Motdepasse= StringVar()
    iden = StringVar()

    def test():

       #base de donnée
        try :
            #connexion au serveur
            conn = pymysql.connect(host="localhost",user="root",password="root", database="sagem")
            cursor = conn.cursor()
            conect.k = conect.e1.get()
            conect.j = conect.e2.get()
            count=cursor.execute("""SELECT count(*) FROM authentification WHERE user ='%s' AND password ='%s'  """ %(conect.e1.get(),conect.e2.get()))
            conect.kf=cursor.fetchone()[0]

            #test mdp
            if conect.kf:
                conect.destroy()
                main()

            else :
                tkinter.messagebox.showerror('Resultat','Mot de passe incorrect.\nVeuillez recommencer !')

            conn.close()

        except pymysql.err.OperationalError :
            tkinter.messagebox.showerror('Erreur','Connexion echoué!')

    #fonction fermer interface
    def quitc():
        if tkinter.messagebox.askyesno('Quitter', 'Etes-vous sur de vouloir faire Ca?'):
            conect.destroy()

    def callback (event):
        test()

      #label
    conect.label = Label(conect, text="Veuillez entrer le nom d'utilisateur :")
    conect.label.grid(row =0, padx =10, pady =5,sticky =W)
    conect.label = Label(conect, text="Veuillez donner votre mdp :")
    conect.label.grid(row =1, padx =10, pady =5,sticky =W)

      #entry
    conect.e1 = Entry(conect, textvariable= iden)
    conect.e1.grid(row =0, column =1)
    conect.e2 = Entry(conect, textvariable= Motdepasse , show='*')
    conect.e2.grid(row =1, column =1)
    conect.e2.bind("<Return>", callback)
      #boutton conecter & quitter
    conect.boutton=Button(conect,text="connecter",command=test,width=10)
    conect.boutton.grid(row =2, column =0, padx =10, pady =10)
    conect.boutton2=Button(conect,text="quitter",command=quitc,width=10)
    conect.boutton2.grid(row =2, column =1, padx =10, pady =10)
    conect.mainloop()


   def Apropos():
           tkinter.messagebox.showinfo("A propos","Ceci est realisé par SAGEMCOM ")
   def alert():
        tkinter.messagebox.showinfo("alerte", "Good!")

id()