import static org.junit.Assert.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import javax.management.RuntimeErrorException;
import models.Bloc;
import models.vendor.Vendor;
import models.vendor.VenueVendor;
import models.vendor.tag.AreaTag;
import models.vendor.tag.FunctionTag;
import models.vendor.tag.Tag;
import models.*;
import org.junit.Before;
import org.junit.Test;
import play.Logger;
import play.test.Fixtures;
import play.test.UnitTest;
public class FixturesTest extends UnitTest {
@Before
public void setup() {
Fixtures.deleteAll();
}
@Test
public void loadData() {
Fixtures.load("vendor-data.yml");
assertEquals(2, Vendor.findAll().size());
assertEquals(4, Tag.findAll().size());
assertEquals(2, AreaTag.findAll().size());
assertEquals(2, FunctionTag.findAll().size());
assertEquals(2, VenueVendor.findAll().size());
VenueVendor vendor = VenueVendor.all().first();
assertEquals(4, vendor.tags.size());
Fixtures.deleteAllModels();
Fixtures.load("vendor-data.yml", "vendor-data1.yml", "vendor-data2.yml");
assertEquals(4, VenueVendor.findAll().size());
assertEquals(3, Vendor.find(
"SELECT DISTINCT v.id " +
"FROM Vendor v " +
"JOIN v.tags as t " +
"WHERE t.label IN ('China', 'Wedding') " +
"GROUP BY v.id HAVING count(t.id) = 2 ").fetch().size());
assertEquals(1, Bloc.count());
Bloc b = Bloc.<Bloc>findAll().get(0);
assertEquals("Yop", b.name);
assertEquals(2, b.criterias.size());
assertEquals("value1", b.criterias.get("key1"));
assertEquals("value2", b.criterias.get("key2"));
try {
assertEquals(new SimpleDateFormat("yyyy/MM/dd HH:mm:ss Z").parse("2001/11/23 21:03:17 +0100"), b.created);
} catch (ParseException e) {
throw new RuntimeException(e);
}
}
@Test
public void loadTemplateData() throws Exception {
Fixtures.load("vendor-data-template.yml");
assertEquals(2, Vendor.findAll().size());
assertEquals(4, Tag.findAll().size());
assertEquals(2, AreaTag.findAll().size());
assertEquals(2, FunctionTag.findAll().size());
assertEquals(2, VenueVendor.findAll().size());
}
@Test
public void checkEmptyReferences() {
Fixtures.load("refs.yml");
assertEquals(1, Referenced.count());
assertEquals(2, Base.count());
Base b1 = Base.find("byName", "Base1").first();
Referenced r = Referenced.all().first();
assertNotNull(b1);
assertNotNull(b1.ref);
assertEquals(r, b1.ref);
Base b2 = Base.find("byName", "Base2").first();
assertNotNull(b2);
assertNull(b2.ref);
}
@Test
public void withGenericModel() {
Fixtures.load("pc.yml");
Parent parent = Parent.all().first();
assertNotNull(parent);
assertNotNull(parent.children);
assertFalse(parent.children.isEmpty());
}
@Test
public void withEmbeddedCompositePrimaryKey() {
Fixtures.loadModels("composite-primary-key.yml");
assertEquals(3, RegionalArticle.count());
RegionalArticle a = RegionalArticle.all().first();
assertEquals("1", a.pk.key1);
assertEquals("1", a.pk.key2);
RegionalArticle b = RegionalArticle.findById(new RegionalArticlePk("1","2"));
assertEquals("sugar", b.name);
RegionalArticle c = RegionalArticle.findById(new RegionalArticlePk("2","1"));
assertEquals("nutella", c.name);
}
}