@Override public Account update(Account account) { assert jdbcTemplate.update("UPDATE accounts SET first_name = ? WHERE last_name = ?", account.getFirstName(), account.getLastName()) > 0; return getAccountByName(account.getFirstName()).get(); }
@Test public void deleteByName() throws Exception { assertEquals(1, accountDao.deleteByName("Ivan")); assertEquals(0, accountDao.deleteByName("NoName")); } }
@Test public void getAccountByName() throws Exception { assertTrue(accountDao.getAccountByName("Ivan").isPresent()); assertFalse(accountDao.getAccountByName("Servey").isPresent()); }
@Test public void update() throws Exception { Account account = accountDao.insert(Account.builder() .firstName("Vasya") .middleName("Vasya") .lastName("Vasya") .build()); account.setFirstName("Kolya"); account = accountDao.update(account); assertNotNull(account.getId()); assertEquals("Kolya", account.getFirstName()); }
@Before public void setUp() throws Exception { // create db for test embeddedDatabase = new EmbeddedDatabaseBuilder() .addDefaultScripts() // added scripts schema.sql and data.sql .setType(EmbeddedDatabaseType.H2) .build(); jdbcTemplate = new JdbcTemplate(embeddedDatabase); accountDao = new AccountDaoImpl(jdbcTemplate); }
@Test public void insert() throws Exception { Account account = accountDao.insert(Account.builder() .firstName("Kolya") .middleName("Kolya") .lastName("Kolya") .build()); assertNotNull(account); assertNotNull(account.getId()); assertEquals("Kolya", account.getFirstName()); }
@Override public Account insert(Account account) { assert jdbcTemplate.update("INSERT INTO accounts (first_name, middle_name, last_name) VALUES (?, ?, ?);", account.getFirstName(), account.getMiddleName(), account.getLastName()) > 0; return getAccountByName(account.getFirstName()).get(); }