package com.enigma.facebookorm;

import com.enigma.facebookorm.entities.Person;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.query.Query;
import org.hibernate.service.ServiceRegistry;
import java.sql.Date;
import java.util.List;

import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

/**
 * Hello world!
 *
 */
public class App {
	private static SessionFactory factory;

	public List<Person> findAll() {
		Session session = factory.openSession();
		CriteriaBuilder cb = session.getCriteriaBuilder();
		CriteriaQuery<Person> cr = cb.createQuery(Person.class);
		Root<Person> root = cr.from(Person.class);
		cr.select(root)
		.where (cb.like(root.<String>get("name"), "%dik%"));

		Query<Person> query = session.createQuery(cr);

		List<Person> persons = null;

		try {
			Transaction tx = null;
			tx = session.beginTransaction();
			persons = session.createQuery("FROM Person", Person.class).list();
			return persons;
		} catch (Exception x) {
			x.printStackTrace();
		}
		return persons;
	}

	public void create() {
		Session session = factory.openSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			Person person = new Person(null, "dede", Date.valueOf("1998-06-06"));
			session.save(person);
			tx.commit();

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

	public void update() {
		Session session = factory.openSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			Person person = session.get(Person.class, "ff808181706174eb01706174ee530000");
			person.setName("bopak");
			session.update(person);
			tx.commit();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void delete() {
		Session session = factory.openSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			Person person = session.get(Person.class, "ff808181706192620170619265c80000");
			session.delete(person);
			tx.commit();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public static void main(String[] args) {
		try {
			Configuration configuration = new Configuration();
			configuration.configure();
			configuration.addAnnotatedClass(Person.class);

			ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
					.applySettings(configuration.getProperties()).build();
			factory = configuration.buildSessionFactory(serviceRegistry);

		} catch (Exception x) {
			System.err.println("Failed to create sessionFactory object." + x);
			x.printStackTrace();

		}
		App app = new App();
		List<Person> persons = app.findAll();
		app.create();
		app.update();
		app.delete();
		for (Person person : app.findAll()) {
			System.out.println(person);
		}
	}
}