/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package addressbook;

import java.sql.SQLException;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSource;

import static org.junit.Assert.*;
import static addressbook.ContactManagerImplTest.newContact;
import static addressbook.ContactManagerImplTest.assertContactCollectionDeepEquals;
import static addressbook.ContactManagerImplTest.assertContactDeepEquals;
import static addressbook.GroupManagerImplTest.newGroup;
import static addressbook.GroupManagerImplTest.assertGroupCollectionDeepEquals;
import static addressbook.GroupManagerImplTest.assertGroupDeepEquals;
import java.util.Arrays;
import java.util.Collections;
import common.DBUtils;
import common.IllegalEntityException;
import common.ServiceFailureException;
import common.ValidationException;
import java.sql.SQLException;
import java.util.List;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSource;
import org.junit.*;

/**
 *
 * @author Maroš Benka
 */
public class AddressBookManagerImplTest {
    private AddressBookManagerImpl manager;
    private ContactManagerImpl contactManager;
    private GroupManagerImpl groupManager;
    private DataSource ds;

    private static DataSource prepareDataSource() throws SQLException {
        BasicDataSource ds = new BasicDataSource();
        ds.setUrl("jdbc:derby:memory:addressBookmgr-test;create=true");
        return ds;
    }
    private Contact c1,c2,c3,contactWithNullId,contactNotInDb;
    private Group g1,g2,g3,groupWithNullId,groupNotInDb;

    private void prepareTestData() {

        c1 = newContact("Franta", "Novák", "123456789", "franta@novak.cz");
        c2 = newContact("Pepa", "Zdepa", "123456789", "pepa@zdepa.cz");
        c3 = newContact("Karol", "Vopička", "123456789", "franta@vopicka.cz");

        g1 = newGroup("grupa1","ti co maju radi modru");
        g2 = newGroup("grupa2","ti co nemaju radi modru");
        g3 = newGroup("grupa3","ti co maju radi cervenu");

        contactManager.createContact(c1);
        contactManager.createContact(c2);
        contactManager.createContact(c3);

        groupManager.createGroup(g1);
        groupManager.createGroup(g2);
        groupManager.createGroup(g3);

        contactWithNullId = newContact("a","a","a","Without ID");
        contactNotInDb = newContact("a","a","a","Not in DB");
        contactNotInDb.setId(c1.getId() + 100);
        groupWithNullId = newGroup("a","No ID");
        groupNotInDb = newGroup("b","Not in DB");
        groupNotInDb.setId(g1.getId() + 100);

    }

    @Before
    public void setUp() throws SQLException {
        ds = prepareDataSource();
        DBUtils.executeSqlScript(ds, ContactManager.class.getResource("createTables.sql")); //tieto riadky si su OK ???
        manager = new AddressBookManagerImpl();
        manager.setDataSource(ds);
        contactManager = new ContactManagerImpl();
        contactManager.setDataSource(ds);
        groupManager = new GroupManagerImpl();
        groupManager.setDataSource(ds);
        prepareTestData();
    }

    @After
     public void tearDown() throws SQLException {
        DBUtils.executeSqlScript(ds, ContactManager.class.getResource("dropTables.sql"));
    }

    @Test
    public void findContactsForGroup() {

        assertNull(manager.getAllContactsFromGroup(g1));
        assertNull(manager.getAllContactsFromGroup(g2));
        assertNull(manager.getAllContactsFromGroup(g3));

        manager.addContactToGroup(c1, g3);

        assertEquals(g3, manager.getAllContactsFromGroup(g3));
        assertContactDeepEquals(c1, manager.getAllContactsFromGroup(g3));
        assertNull(manager.findGraveWithBody(b2));
        assertNull(manager.findGraveWithBody(b3));
        assertNull(manager.findGraveWithBody(b4));
        assertNull(manager.findGraveWithBody(b5));

        try {
            manager.findGraveWithBody(null);
            fail();
        } catch (IllegalArgumentException ex) {}

        try {
            manager.findGraveWithBody(bodyWithNullId);
            fail();
        } catch (IllegalEntityException ex) {}

    }



}