*
* @throws Exception exception
*/
@Test
public void test() throws Exception {
final LinkRepository linkRepository = getLinkRepository();
final int link1Order = 1, link2Order = 2, link3Order = 3;
JSONObject link1 = new JSONObject();
link1.put(Link.LINK_TITLE, "link title");
link1.put(Link.LINK_DESCRIPTION, "link description");
link1.put(Link.LINK_ADDRESS, "link address");
link1.put(Link.LINK_ORDER, link1Order);
Transaction transaction = linkRepository.beginTransaction();
linkRepository.add(link1);
transaction.commit();
Assert.assertNull(linkRepository.getByAddress("test"));
Assert.assertNotNull(linkRepository.getByAddress("link address"));
Assert.assertNull(linkRepository.getByOrder(0));
Assert.assertNotNull(linkRepository.getByOrder(link1Order));
final JSONObject link2 = new JSONObject();
link2.put(Link.LINK_TITLE, "link title");
link2.put(Link.LINK_DESCRIPTION, "link description");
link2.put(Link.LINK_ADDRESS, "link address");
link2.put(Link.LINK_ORDER, link2Order);
transaction = linkRepository.beginTransaction();
final String link2Id = linkRepository.add(link2);
transaction.commit();
Assert.assertEquals(linkRepository.getMaxOrder(), link2Order);
JSONObject link3 = new JSONObject();
link3.put(Link.LINK_TITLE, "link title");
link3.put(Link.LINK_DESCRIPTION, "link description");
link3.put(Link.LINK_ADDRESS, "link address");
link3.put(Link.LINK_ORDER, link3Order);
transaction = linkRepository.beginTransaction();
linkRepository.add(link3);
transaction.commit();
final int total = 3;
Assert.assertEquals(linkRepository.count(), total);
link1 = linkRepository.getUpper(link2Id);
Assert.assertNotNull(link1);
Assert.assertEquals(link1.getInt(Link.LINK_ORDER), link1Order);
link3 = linkRepository.getUnder(link2Id);
Assert.assertNotNull(link3);
Assert.assertEquals(link3.getInt(Link.LINK_ORDER), link3Order);
}