package notUsed;
// lol
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import org.hibernate.tool.hbm2ddl.SchemaExport;

import financeME.model.User;


import junit.framework.TestCase;

/**
 * Testing Class for the Hibernate implementation
 * @author schroeders
 *
 */
public class TestHibernate extends TestCase {

    private static final String NAME = "Testuser";
    private static final String PASSWORD = "lol";
    private SessionFactory sessionFactory;
    private long id;


    protected void setUp() throws Exception {
    super.setUp();
    Configuration configuration = new Configuration().configure();
    //set H2-DB to in-memory-mode
    //configuration.setProperty("hibernate.connection.url", "jdbc:h2:mem:financeME;DB_CLOSE_DELAY=-1");

    SchemaExport export = new SchemaExport(configuration);
    export.create(false, true);
    sessionFactory = configuration.buildSessionFactory();
    id = createUser(NAME, PASSWORD);
    }

    // User anlegen und in DB speichern
    private long createUser(String name, String password) {
    User user = new User();
    user.setName(name);
    user.setPassword(password);

    Session session = null;
    Transaction transaction = null;
    try {
        session = sessionFactory.openSession();
        transaction = session.beginTransaction();
        session.save(user);
        transaction.commit();
    }
    catch (HibernateException e) {
        if (transaction != null) {
        transaction.rollback();
        throw e;
        }
    }
    finally {
        if (session != null) {
        session.close();
        }
    }
    return user.getId();
    }

    // loads an Object from the DB
     public void testLoad() {
    Session session = null;
    try {
        session = sessionFactory.openSession();

        User user = (User) session.load(User.class, id);

        assertEquals(NAME, user.getName());
        assertEquals(PASSWORD, user.getPassword());

    }
    finally {
        if (session != null && session.isConnected()) {
        session.close();
        }
    }
    }

    // searches an Object in the DB
    public void testSearch() {
    Session session = null;
    try {
        session = sessionFactory.openSession();

        Query query = session.createQuery("from User where name='" + NAME + "'");
        List result = query.list();
        assertEquals(1, result.size());
        User user = (User) result.get(0);
    }
    finally {
        if (session != null && session.isConnected()) {
        session.close();
        }
    }
    }

    // update an Object
    public void testUpdate() {
    Session session = null;
    try {
        session = sessionFactory.openSession();
        User user = (User) session.load(User.class, id);
        Transaction transaction = session.beginTransaction();
        user.setName("changed Username");
        transaction.commit();
    }
    finally {
        if (session != null && session.isConnected()) {
        session.close();
        }
    }
    }

    // delete an Object
    public void testDelete() {
    Session session = null;
    try {
        session = sessionFactory.openSession();
        User user = (User) session.load(User.class, id);
        Transaction transaction = session.beginTransaction();
        session.delete(user);
        transaction.commit();
        session.close();
        session = sessionFactory.openSession();
        user = (User) session.get(User.class, id);
        assertNull(user);
    }
    finally {
        if (session != null && session.isConnected()) {
        session.close();
        }
    }
    }

}