Foren

JUnit test case for Dynamic Query

Alex Man, geändert vor 7 Jahren.

JUnit test case for Dynamic Query

Junior Member Beiträge: 70 Beitrittsdatum: 08.02.16 Neueste Beiträge
I have a dynamic query like as given below

DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(College.class, getClassLoader());
dynamicQuery.add(RestrictionsFactoryUtil.eq("collegeName", "SUT"));  
dynamicQuery.add(RestrictionsFactoryUtil.eq("collegePlace", "Chennai")); 
dynamicQuery.setProjection(ProjectionFactoryUtil.projectionList()
		.add(ProjectionFactoryUtil.groupProperty("collegeName"), "collegeName"));
dynamicQuery.addOrder(OrderFactoryUtil.asc("collegeName")); 
try {
	List<string> collegeDetails = (List<string>)CollegeLocalServiceUtil.dynamicQuery(dynamicQuery, start, end);
} catch (SystemException e) {
	e.printStackTrace();
}
</string></string>



For the above code I have written a JUnit test cases like as shown below using mokito. I have followed this tutorial for achieving this


BeanLocator beanLocator = mock(BeanLocator.class); 
PortalBeanLocatorUtil.setBeanLocator(beanLocator); 

CollegeLocalService collegeLocalService = mock(CollegeLocalService.class); 
DynamicQuery dynamicQuery = mock(DynamicQuery.class);

when(beanLocator.locate(CollegeLocalService.class.getName())).thenReturn(collegeLocalService);

when((List<string>)CollegeLocalService.dynamicQuery(dynamicQuery)).thenReturn(returnCollegeDetails());
assertTrue(CollegeLocalService.dynamicQuery(dynamicQuery).size()&gt;0);</string>



returnCollegeDetails() function

private List<string> returnCollegeDetails()
{
	List<string> collegeDetails = new ArrayList<string>();
	collegeDetails.add("ABC");
	collegeDetails.add("DEC");
	collegeDetails.add("XYZ");
	return collegeDetails;
}</string></string></string>



But I don't know how to cover the RestrictionsFactoryUtil, ProjectionFactoryUtil and OrderFactoryUtil.

Can anyone please tell me how to do this
thumbnail
Jignesh Thakkar, geändert vor 7 Jahren.

RE: JUnit test case for Dynamic Query

Junior Member Beiträge: 26 Beitrittsdatum: 10.05.10 Neueste Beiträge
Hi Alex

Did you get solution for this, I am also facing the same problem.

Regards
Jignesh Thakkar
Alex Man, geändert vor 7 Jahren.

RE: JUnit test case for Dynamic Query

Junior Member Beiträge: 70 Beitrittsdatum: 08.02.16 Neueste Beiträge
Jignesh Thakkar:
Hi Alex

Did you get solution for this, I am also facing the same problem.

Regards
Jignesh Thakkar


Till date ...No Jignesh emoticon

Do you have any findings on this