[arquillian-issues] [JBoss JIRA] (ARQ-1015) Testing of JPA queries with @UsingDataSet and @ShouldMatchDataSet

[Nicklas Karlsson (JIRA)]

Nicklas Karlsson created ARQ-1015:
-------------------------------------

             Summary: Testing of JPA queries with @UsingDataSet and @ShouldMatchDataSet
                 Key: ARQ-1015
                 URL: https://issues.jboss.org/browse/ARQ-1015
             Project: Arquillian
          Issue Type: Feature Request
      Security Level: Public (Everyone can see)
          Components: Extension - Persistence
    Affects Versions: persistence_1.0.0.Alpha4
            Reporter: Nicklas Karlsson
            Assignee: Bartosz Majsak


It would be handy to automagically be able to test JPA queries with a method like

@Test
@UsingDataSet("all.xls")
@ShouldMatchDataSet("hits.xls")
public List<Customer> getAllowedCustomers() {
  return em.createNamedQuery("customers", Customer.class).getResultList();
}

for methods with signatures returning List<?>. Currently I have functionality like 

    @Test
    @UsingDataSet("all.xls")
    public void testCustomers() throws Exception
    {
	IDataSet expected = new XlsDataSet(getClass().getResourceAsStream("/hits.xls"));
	ITableMetaData metadata = expected.getTableMetaData(expected.getTableNames()[0]);
	IDataSet real = new PojoDataSet(em.createNamedQuery("customers", Customer.class).getResultList(), metadata);
	Assertion.assertEquals(expected, real);
    }

and


ublic class PojoDataSet extends DefaultDataSet
{

    public PojoDataSet(List<?> entities, ITableMetaData metaData)
    {
	try
	{
	    DefaultTable table = new DefaultTable(metaData);
	    for (Object entity : entities)
	    {
		List<Object> values = new ArrayList<Object>();
		for (Column column : metaData.getColumns())
		{
		    values.add(BeanUtils.getNestedProperty(entity, column.getColumnName()));
		}
		table.addRow(values.toArray());
	    }
	    addTable(table);
	} catch (Exception e)
	{
	    throw new IllegalArgumentException(e);
	}
    }

}

With the column names in the metadata (from the xls) mapped to Apache BeanUtils nested properties. This approach only verifies the identities of the top-level objects (OK, it can descend @OneToOne relations) and doesn't cover the whole POJO structure. 

It would be nice if this process could somehow be automated with Arquillian-persistence.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira