package com.sample;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

import org.kie.api.KieServices;
import org.kie.api.runtime.KieContainer;
import org.kie.api.runtime.KieSession;

public class TestJPA {

	public static void main(String[] args) {
		// TODO Auto-generated method stub

		KieServices ks = KieServices.Factory.get();
	    KieContainer kContainer = ks.getKieClasspathContainer();
    	KieSession kSession = kContainer.newKieSession("ksession-rules");


        List<Modele> listaModele= new ArrayList<Modele>();
		listaModele.add(new Modele(1,"Q3"));
		listaModele.add(new Modele(2,"Q5"));
		listaModele.add(new Modele(3,"Q7"));
		listaModele.add(new Modele(4,"A1"));
		listaModele.add(new Modele(5,"A3"));
		listaModele.add(new Modele(6,"A4"));
		listaModele.add(new Modele(7,"A5"));
		listaModele.add(new Modele(8,"A6"));
		listaModele.add(new Modele(9,"Seria1"));
		listaModele.add(new Modele(10,"Seria2"));
		listaModele.add(new Modele(11,"Seria3"));
		listaModele.add(new Modele(12,"Seria4"));
		listaModele.add(new Modele(13,"Seria5"));
		listaModele.add(new Modele(14,"X1"));
		listaModele.add(new Modele(15,"X2"));
		listaModele.add(new Modele(16,"X3"));
		listaModele.add(new Modele(17,"X5"));
		listaModele.add(new Modele(18,"X6"));
		listaModele.add(new Modele(19,"Coupe"));
		listaModele.add(new Modele(20,"Linea"));
		listaModele.add(new Modele(21,"Marea"));
		listaModele.add(new Modele(22,"Panda"));
		listaModele.add(new Modele(23,"Punto"));

		kSession.fireAllRules();
        EntityManagerFactory emf=Persistence.createEntityManagerFactory("ST_MK");
 		EntityManager em=emf.createEntityManager();
        em.getTransaction().begin();

        em.createQuery("DELETE FROM Modele").executeUpdate();

		em.persist(listaModele.get(0));
		em.persist(listaModele.get(1));
		em.persist(listaModele.get(2));
		em.persist(listaModele.get(3));
		em.persist(listaModele.get(4));
		em.persist(listaModele.get(5));
		em.persist(listaModele.get(6));
		em.persist(listaModele.get(7));
		em.persist(listaModele.get(8));
		em.persist(listaModele.get(9));
		em.persist(listaModele.get(10));
		em.persist(listaModele.get(11));
		em.persist(listaModele.get(12));
		em.persist(listaModele.get(13));
		em.persist(listaModele.get(14));
		em.persist(listaModele.get(15));
		em.persist(listaModele.get(16));
		em.persist(listaModele.get(17));
		em.persist(listaModele.get(18));
		em.persist(listaModele.get(19));
		em.persist(listaModele.get(20));
		em.persist(listaModele.get(21));
		em.persist(listaModele.get(23));
		em.getTransaction().commit();

		List<Modele> lstModelePersistente= em.createQuery("SELECT m FROM Modele m").getResultList();
		System.out.println("Lista modele masini persistente/ salvate in baza de date");
		for(Modele m: lstModelePersistente)
			System.out.println("idModel: "+m.getIdModel() +", model: "+ m.getModel());
		em.getTransaction().begin();

		//Read-Update
				Modele m2= em.find(Modele.class, 2);
				if(m2!= null){
					m2.setModel("4X4");
				em.persist(m2);
				}

		//Read-Remove
				Modele m3=(Modele) em.createQuery("SELECT mn FROM Modele mn Where mn.idModel=3").getSingleResult();
				if(m3!=null){
					em.remove(m3);
				}

		//realizare tranzactie - sincronizare cu baza de date
				em.getTransaction().commit();
				lstModelePersistente= em.createQuery("SELECT m FROM Modele m").getResultList();
				System.out.println("Lista finala modele masini persistente/ salvate in baza de date");
				for(Modele m: lstModelePersistente)
				System.out.println("idModel: "+m.getIdModel() +", model: "+ m.getModel());


				List<Clienti> listaClienti=new ArrayList<Clienti>();
				listaClienti.add(new Clienti(1,"Popescu Ionel", "popescu.ionel@yahoo.com", "str. Fericirii", "+40762324345", convertDateFromString("1999/09/01")));
				listaClienti.add(new Clienti(2,"Miron Adina", "adina21@yahoo.com", "str. Pantelimon", "+40762324343", convertDateFromString("2002/08/01")));
				listaClienti.add(new Clienti(3,"Garleanu Adi", "adi.garleanu@yahoo.com", "str. Sperantei", "+40762325645", convertDateFromString("1998/09/11")));
				listaClienti.add(new Clienti(4,"Costin Radu", "costin.radu@yahoo.com", "str.Principala ", "+40762324345", convertDateFromString("1989/01/07")));
				listaClienti.add(new Clienti(5,"Anghel Florina", "anghel.florina@yahoo.com", "str. Unirii", "+40766624345", convertDateFromString("2000/08/21")));
				listaClienti.add(new Clienti(6,"Anton Madalina", "anton.mada@yahoo.com", "str. Fericirii", "+40767824345", convertDateFromString("1999/02/01")));
				listaClienti.add(new Clienti(7,"Cretu Adriana", "cretu.adriana@yahoo.com", "str. Teilor", "+40762344345", convertDateFromString("2000/09/01")));
				listaClienti.add(new Clienti(8,"Dumitrache Ramona", "dumitrache.rami@yahoo.com", "str. Salcamilor", "+40762324309", convertDateFromString("2011/09/21")));
				listaClienti.add(new Clienti(9,"Ionescu Alex", "popescu.ionel@yahoo.com", "str. Fericirii", "+40745624345", convertDateFromString("1979/11/01")));





	}

	public static Date convertDateFromString(String dateInString){
		SimpleDateFormat formatter = new SimpleDateFormat("yyyy/MM/dd");
        Date date = null;
        try {

            date = formatter.parse(dateInString);
            System.out.println(date);
            System.out.println(formatter.format(date));

        } catch (ParseException e) {
            e.printStackTrace();
        }

        return date;

	}


}