package org.asoware.budget.db;

import java.util.Date;
import java.util.Map;

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

import org.asoware.budget.model.Beweging;
import org.asoware.budget.model.BewegingSoort;
import org.asoware.budget.model.Categorie;
import org.asoware.budget.model.Periode;

public class DbUtil {
	Map<String, String> properties;
	
	public EntityManager getEntityManager() {
		EntityManagerFactory emf = Persistence.createEntityManagerFactory("budget-pu", properties);
		return emf.createEntityManager();
	}
	
	public static void main(String[] args){
		DbUtil dbUtil = new DbUtil();		
		EntityManager em = dbUtil.getEntityManager();
		EntityTransaction tx = null;
		try {
			tx = em.getTransaction();
			tx.begin();
			Categorie cat = new Categorie();
			cat.setNaam("Voeding");

			Beweging bew = new Beweging();
			bew.setBewegingSoort(BewegingSoort.INKOMST);
			bew.setCategorie(cat);
			bew.setDatum(new Date());
			bew.setFrequentieAantal(4);
			bew.setFrequentiePeriode(Periode.JAAR);
			
			em.persist(cat);			
			em.persist(bew);
			tx.commit();
		} catch (Exception e) {
			if ((tx != null) && (tx.isActive())) {
				tx.rollback();
			}
			e.printStackTrace();
		} finally {
			em.close();
		}		
	}
}