/** USE THIS INSTEAD OF THE BATGEN DELETE It also deletes associated events of the object.s */ public int delete(Long key) throws BoException { SqlSession session = null; int result = 0; String where = "KEY='" + key + "' "; Map<String, Object> map = new HashMap<String, Object>(); map.put("where", where); // first delete all events associated with this object EventBo.getInstance().deleteEventsOf(ItemType.SOFTWARE, key); try { session = SessionFactory.getSession(); SoftwareDao mapper = session.getMapper(SoftwareDao.class); result = mapper.delete(map); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } return result; }
@Test public void shouldExecuteSelectOneAuthorUsingMapperClassThatReturnsALinedHashMap() { SqlSession session = sqlMapper.openSession(); try { AuthorMapper mapper = session.getMapper(AuthorMapper.class); LinkedHashMap<String, Object> author = mapper.selectAuthorLinkedHashMap(101); assertEquals(101, author.get("ID")); } finally { session.close(); } }
@Test public void shouldExecuteSelectAllAuthorsUsingMapperClassThatReturnsAnArray() { SqlSession session = sqlMapper.openSession(); try { AuthorMapper mapper = session.getMapper(AuthorMapper.class); Author[] authors = mapper.selectAllAuthorsArray(); assertEquals(2, authors.length); } finally { session.close(); } }
@Test public void shouldSelectAllPostsUsingMapperClass() throws Exception { SqlSession session = sqlMapper.openSession(); try { BlogMapper mapper = session.getMapper(BlogMapper.class); List<Map> posts = mapper.selectAllPosts(); assertEquals(5, posts.size()); } finally { session.close(); } }
@Test public void shouldSelectAuthorsUsingMapperClass() { SqlSession session = sqlMapper.openSession(); try { AuthorMapper mapper = session.getMapper(AuthorMapper.class); List<Author> authors = mapper.selectAllAuthors(); assertEquals(2, authors.size()); } finally { session.close(); } }
@Test public void shouldExecuteSelectOneAuthorUsingMapperClass() { SqlSession session = sqlMapper.openSession(); try { AuthorMapper mapper = session.getMapper(AuthorMapper.class); Author author = mapper.selectAuthor(101); assertEquals(101, author.getId()); } finally { session.close(); } }
@Test public void shouldExecuteSelectAllAuthorsUsingMapperClassThatReturnsLinkedList() { SqlSession session = sqlMapper.openSession(); try { AuthorMapper mapper = session.getMapper(AuthorMapper.class); Collection<Author> authors = mapper.selectAllAuthorsLinkedList(); assertEquals(2, authors.size()); } finally { session.close(); } }
@Test public void shouldSelectAuthorsUsingMapperClassWithResultHandler() { SqlSession session = sqlMapper.openSession(); try { DefaultResultHandler handler = new DefaultResultHandler(); AuthorMapper mapper = session.getMapper(AuthorMapper.class); mapper.selectAllAuthors(handler); assertEquals(2, handler.getResultList().size()); } finally { session.close(); } }
@Test public void shouldDeleteAuthorUsingMapperClass() throws Exception { SqlSession session = sqlMapper.openSession(); try { AuthorMapper mapper = session.getMapper(AuthorMapper.class); int count = mapper.deleteAuthor(101); assertEquals(1, count); assertNull(mapper.selectAuthor(101)); } finally { session.close(); } }
@Test(expected = BindingException.class) public void shouldFailExecutingAnAnnotatedMapperClassWithResultHandler() { SqlSession session = sqlMapper.openSession(); try { DefaultResultHandler handler = new DefaultResultHandler(); AuthorMapper mapper = session.getMapper(AuthorMapper.class); mapper.selectAuthor2(101, handler); Author author = (Author) handler.getResultList().get(0); assertEquals(101, author.getId()); } finally { session.close(); } }
@Test public void shouldLimitResultsUsingMapperClass() throws Exception { SqlSession session = sqlMapper.openSession(); try { BlogMapper mapper = session.getMapper(BlogMapper.class); List<Map> posts = mapper.selectAllPosts(new RowBounds(0, 2), null); assertEquals(2, posts.size()); assertEquals(1, posts.get(0).get("ID")); assertEquals(2, posts.get(1).get("ID")); } finally { session.close(); } }
@Test public void shouldExecuteSelectOneAuthorUsingMapperClassWithResultHandler() { SqlSession session = sqlMapper.openSession(); try { DefaultResultHandler handler = new DefaultResultHandler(); AuthorMapper mapper = session.getMapper(AuthorMapper.class); mapper.selectAuthor(101, handler); Author author = (Author) handler.getResultList().get(0); assertEquals(101, author.getId()); } finally { session.close(); } }
@Test public void shouldUpdateAuthorUsingMapperClass() throws Exception { SqlSession session = sqlMapper.openSession(); try { AuthorMapper mapper = session.getMapper(AuthorMapper.class); Author expected = mapper.selectAuthor(101); expected.setUsername("NewUsername"); int count = mapper.updateAuthor(expected); assertEquals(1, count); Author actual = mapper.selectAuthor(101); assertEquals(expected.getUsername(), actual.getUsername()); } finally { session.close(); } }
@Test(expected = BindingException.class) public void shouldFailSelectOneAuthorUsingMapperClassWithTwoRowBounds() { Configuration configuration = new Configuration(sqlMapper.getConfiguration().getEnvironment()); configuration.addMapper(AuthorMapperWithRowBounds.class); SqlSessionFactory sqlMapperWithMultipleHandlers = new DefaultSqlSessionFactory(configuration); SqlSession sqlSession = sqlMapperWithMultipleHandlers.openSession(); try { RowBounds bounds1 = new RowBounds(0, 1); RowBounds bounds2 = new RowBounds(0, 1); AuthorMapperWithRowBounds mapper = sqlSession.getMapper(AuthorMapperWithRowBounds.class); mapper.selectAuthor(101, bounds1, bounds2); } finally { sqlSession.close(); } }
/** * Deletes all data (rows) from SOFTWARE * * @throws BoException */ public void deleteAll() throws BoException { SqlSession session = null; try { session = SessionFactory.getSession(); SoftwareDao mapper = session.getMapper(SoftwareDao.class); mapper.deleteAll(); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } }
@Test public void shouldInsertAuthorUsingMapperClass() throws Exception { SqlSession session = sqlMapper.openSession(); try { AuthorMapper mapper = session.getMapper(AuthorMapper.class); Author expected = new Author(500, "cbegin", "******", "*****@*****.**", "Something...", null); mapper.insertAuthor(expected); Author actual = mapper.selectAuthor(500); assertNotNull(actual); assertEquals(expected.getId(), actual.getId()); assertEquals(expected.getUsername(), actual.getUsername()); assertEquals(expected.getPassword(), actual.getPassword()); assertEquals(expected.getEmail(), actual.getEmail()); assertEquals(expected.getBio(), actual.getBio()); } finally { session.close(); } }
/** * Get a list of software objects between (inclusive) the dates start and end. * * @param start * @param end * @return * @throws BoException */ public List<Software> getListByPurchaseRange(Date start, Date end) throws BoException { SqlSession session = null; List<Software> list; try { session = SessionFactory.getSession(); SoftwareDao mapper = session.getMapper(SoftwareDao.class); list = mapper.getListByPurchaseRange(start, end); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } return list; }
/** * Retrieves max size software objects from database (Software table). * * @param size * @return List of software objects to populate results page for empty search bar. * @throws BoException */ public List<Software> getDefaultResults(int size) throws BoException { SqlSession session = null; List<Software> list; try { session = SessionFactory.getSession(); SoftwareDao mapper = session.getMapper(SoftwareDao.class); list = mapper.getDefaultResults(size); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } return list; }
/** * Retrieves all software objects from database (Software table) matching search term. * * @param searchText * @return List of all software objects matching search term. * @throws BoException */ public List<Software> search(String searchText) throws BoException { SqlSession session = null; List<Software> list; try { session = SessionFactory.getSession(); SoftwareDao mapper = session.getMapper(SoftwareDao.class); list = mapper.search(searchText); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } return list; }
/** * Get a list of software objects within a cost range * * @param minCost * @param maxCost * @return * @throws BoException */ public List<Software> getListByCostRange(String minCost, String maxCost) throws BoException { SqlSession session = null; List<Software> list; try { session = SessionFactory.getSession(); SoftwareDao mapper = session.getMapper(SoftwareDao.class); list = mapper.getListByCostRange(minCost, maxCost); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } return list; }
public List<Software> getListByIsActive(Boolean key) throws BoException { SqlSession session = null; List<Software> list; try { session = SessionFactory.getSession(); SoftwareDao mapper = session.getMapper(SoftwareDao.class); list = mapper.getListByIsActive(key); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } return list; }
public int update(Fda2 value) throws BoException { SqlSession session = null; int result = 0; try { session = SessionFactory.getSession(); Fda2Dao mapper = session.getMapper(Fda2Dao.class); result = mapper.update(value); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } return result; }
public Fda2 read(Long key) throws BoException { SqlSession session = null; Fda2 result; String where = "KEY='" + key + "' "; Map<String, Object> map = new HashMap<String, Object>(); map.put("where", where); try { session = SessionFactory.getSession(); Fda2Dao mapper = session.getMapper(Fda2Dao.class); result = mapper.read(map); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } return result; }
/** * Retrieves all software objects from the database (Software table) matching search terms. * * @param columns * @param searches * @return List of all software objects matching search terms. * @throws BoException */ public List<Software> searchAdvanced( ArrayList<String> columns, ArrayList<ArrayList<String>> searches) throws BoException { SqlSession session = null; List<Software> list = new ArrayList<Software>(); if (columns.size() == 0 && searches.size() == 0) { return SoftwareBo.getInstance().getAll(); } try { session = SessionFactory.getSession(); SoftwareDao mapper = session.getMapper(SoftwareDao.class); list = mapper.searchAdvanced(columns, searches); session.commit(); } catch (Exception e) { session.rollback(); throw new BoException(e); } finally { if (session != null) session.close(); } return list; }