Examples with User org.jpwh.model.customsql.User used on opensource projects

Example 1 with User

use of org.jpwh.model.customsql.User in project microservices by pwillhan.

the class CustomSQL method create.

public CustomSQLTestData create() throws Exception {
    UserTransaction tx = TM.getUserTransaction();
    tx.begin();
    EntityManager em = JPA.createEntityManager();
    CustomSQLTestData testData = new CustomSQLTestData();
    testData.categories = new TestData(new Long[1]);
    testData.items = new TestData(new Long[2]);
    testData.bids = new TestData(new Long[3]);
    testData.users = new TestData(new Long[2]);
    User johndoe = new User("johndoe");
    em.persist(johndoe);
    testData.users.identifiers[0] = johndoe.getId();
    User janeroe = new User("janeroe");
    em.persist(janeroe);
    testData.users.identifiers[1] = janeroe.getId();
    Category category = new Category();
    category.setName("Foo");
    em.persist(category);
    testData.categories.identifiers[0] = category.getId();
    Item item = new Item();
    item.setName("Some item");
    item.setCategory(category);
    item.setSeller(johndoe);
    item.setAuctionEnd(CalendarUtil.TOMORROW.getTime());
    item.getImages().add(new Image("foo.jpg", 640, 480));
    item.getImages().add(new Image("bar.jpg", 800, 600));
    item.getImages().add(new Image("baz.jpg", 640, 480));
    em.persist(item);
    testData.items.identifiers[0] = item.getId();
    for (int i = 1; i <= 3; i++) {
        Bid bid = new Bid();
        bid.setAmount(new BigDecimal(10 + i));
        bid.setItem(item);
        bid.setBidder(janeroe);
        em.persist(bid);
        testData.bids.identifiers[i - 1] = bid.getId();
    }
    Item otherItem = new Item(category, "Inactive item", CalendarUtil.TOMORROW.getTime(), johndoe);
    otherItem.setActive(false);
    em.persist(otherItem);
    tx.commit();
    em.close();
    return testData;
}

Example 2 with User

use of org.jpwh.model.customsql.User in project microservices by pwillhan.

the class CustomSQL method delete.

@Test
public void delete() throws Exception {
    CustomSQLTestData testData = create();
    Long ITEM_ID = testData.items.getFirstId();
    Long USER_ID = testData.users.getFirstId();
    UserTransaction tx = TM.getUserTransaction();
    try {
        tx.begin();
        EntityManager em = JPA.createEntityManager();
        {
            Item item = em.find(Item.class, ITEM_ID);
            assertEquals(item.getImages().size(), 3);
            item.getImages().remove(item.getImages().iterator().next());
            em.flush();
        }
        em.clear();
        loadEventListener.reset();
        {
            Item item = em.find(Item.class, ITEM_ID);
            assertEquals(item.getImages().size(), 2);
            item.getImages().clear();
            em.flush();
        }
        em.clear();
        loadEventListener.reset();
        {
            // Clean up FK references so we can delete a User
            em.createQuery("delete Bid").executeUpdate();
            em.createQuery("delete Item").executeUpdate();
            em.clear();
            User user = em.find(User.class, USER_ID);
            em.remove(user);
            em.flush();
            em.clear();
            assertNull(em.find(User.class, USER_ID));
        }
        em.clear();
        loadEventListener.reset();
        tx.commit();
        em.close();
    } finally {
        TM.rollback();
    }
}

Example 3 with User

use of org.jpwh.model.customsql.User in project microservices by pwillhan.

the class CustomSQL method update.

@Test
public void update() throws Exception {
    CustomSQLTestData testData = create();
    Long USER_ID = testData.users.getFirstId();
    UserTransaction tx = TM.getUserTransaction();
    try {
        tx.begin();
        EntityManager em = JPA.createEntityManager();
        {
            User user = em.find(User.class, USER_ID);
            user.setUsername("jdoe");
            em.flush();
        }
        em.clear();
        loadEventListener.reset();
        tx.commit();
        em.close();
    } finally {
        TM.rollback();
    }
}

Example 4 with User

use of org.jpwh.model.customsql.User in project microservices by pwillhan.

the class CustomSQL method read.

@Test
public void read() throws Exception {
    CustomSQLTestData testData = create();
    Long CATEGORY_ID = testData.categories.getFirstId();
    Long ITEM_ID = testData.items.getFirstId();
    Long BID_ID = testData.bids.getFirstId();
    Long USER_ID = testData.users.getFirstId();
    UserTransaction tx = TM.getUserTransaction();
    try {
        tx.begin();
        EntityManager em = JPA.createEntityManager();
        {
            User user = em.find(User.class, USER_ID);
            assertEquals(loadEventListener.getLoadCount(User.class), 1);
            assertEquals(user.getId(), USER_ID);
        }
        em.clear();
        loadEventListener.reset();
        {
            Bid bid = em.find(Bid.class, BID_ID);
            assertEquals(loadEventListener.getLoadCount(Bid.class), 1);
            assertEquals(loadEventListener.getLoadCount(User.class), 1);
            assertEquals(loadEventListener.getLoadCount(Item.class), 0);
            assertEquals(bid.getId(), BID_ID);
            assertNotNull(bid.getBidder().getUsername());
        }
        em.clear();
        loadEventListener.reset();
        {
            Item item = em.find(Item.class, ITEM_ID);
            assertEquals(loadEventListener.getLoadCount(Item.class), 1);
            assertEquals(loadEventListener.getLoadCount(Bid.class), 3);
            assertEquals(item.getId(), ITEM_ID);
            assertEquals(item.getBids().size(), 3);
            assertEquals(item.getImages().size(), 3);
        }
        em.clear();
        loadEventListener.reset();
        tx.commit();
        em.close();
    } finally {
        TM.rollback();
    }
}