✨🌈💫테스트💫🌈✨ (토비의 스프링)

public class UserDaoTest {

    public static void main(String[] args) throws SQLException {

        UserDao userDao = new DaoFactory().userDao();

        User user = new User("hyewoncc4", "최혜원", "password");
        userDao.add(user);

        System.out.println("등록 성공");

        User foundUser = userDao.get(user.getId());
        System.out.println(foundUser.getName());
        System.out.println(foundUser.getPassword());
        System.out.println(foundUser.getId() + " 조회 성공");
    }
}

public static void main(String[] args) throws SQLException {
    
    UserDao userDao = new DaoFactory().userDao();

    userDao.add(user);
    User user = new User("hyewoncc4", "최혜원", "password");    
    User foundUser = userDao.get(user.getId());
    
    if (!user.getName().equals(foundUser.getName())) {
        System.out.println("테스트 실패 : name");  
    }
    else if (!user.getPassword().equals(foundUser.getPassword())) {
        System.out.println("테스트 실패 : password");  
    } else {
        System.out.println("조회 테스트 성공");
    }
}

testImplementation("org.junit.jupiter:junit-jupiter-api")

class UserDaoTest {

    @DisplayName("사용자 추가 및 조회")
    @Test
    void addAndGet() throws SQLException {
        ApplicationContext applicationContext = new AnnotationConfigApplicationContext(DaoFactory.class);
        UserDao userDao = applicationContext.getBean("userDao", UserDao.class);

        User user = new User("yellow-cat", "노란 고양이", "password");
        userDao.add(user);

        User foundUser = userDao.get(user.getId());
        assertEquals(user.getName(), foundUser.getName());
        assertEquals(user.getPassword(), foundUser.getPassword());
    }
}

testImplementation("org.springframework.boot:spring-boot-starter-test")

class UserDaoTest {

    @DisplayName("사용자 추가 및 조회")
    @Test
    void addAndGet() throws SQLException {
        ApplicationContext applicationContext = new AnnotationConfigApplicationContext(DaoFactory.class);
        UserDao userDao = applicationContext.getBean("userDao", UserDao.class);

        userDao.deleteAll();
        assertThat(userDao.getCount()).isEqualTo(0);

        User user = new User("yellow-cat", "노란 고양이", "password");
        userDao.add(user);
        assertThat(userDao.getCount()).isEqualTo(1);

        User foundUser = userDao.get(user.getId());
        assertThat(foundUser.getName()).isEqualTo(user.getName());
        assertThat(foundUser.getPassword()).isEqualTo(user.getPassword());
    }
}

@DisplayName("존재하지 않는 id 조회 시 예외")
@Test
void get_idDoesNotExists_throwException() throws SQLException {
    ApplicationContext applicationContext = new AnnotationConfigApplicationContext(DaoFactory.class);
    UserDao userDao = applicationContext.getBean("userDao", UserDao.class);

    userDao.deleteAll();

    assertThatThrownBy(() -> userDao.get("unknown_id"))
        .isInstanceOf(EmptyResultDataAccessException.class);
}

java.lang.AssertionError: 
Expecting:
  <java.sql.SQLException: Illegal operation on empty result set.>
to be an instance of:
  <org.springframework.dao.EmptyResultDataAccessException>
but was:
  <"java.sql.SQLException: Illegal operation on empty result set.

public User get(final String id) throws SQLException {
    Connection connection = dataSource.getConnection();

    PreparedStatement statement = connection.prepareStatement(
        "select id, name, password from users where id = ?"
    );
    statement.setString(1, id);

    ResultSet resultSet = statement.executeQuery();
    User user = null;

    if (resultSet.next()) {
        user = new User();
        user.setId(resultSet.getString("id"));
        user.setName(resultSet.getString("name"));
        user.setPassword(resultSet.getString("password"));
    }

        resultSet.close();
        statement.close();
        connection.close();

    if (user == null) {
        throw new EmptyResultDataAccessException(1);
    }

    return user;
}

class UserDaoTest {

    private UserDao userDao;

    @BeforeEach
    void setUp() {
        ApplicationContext applicationContext = new AnnotationConfigApplicationContext(DaoFactory.class);
        userDao = applicationContext.getBean("userDao", UserDao.class);
    }
    
    @Test
    void addAndGet() {...}

    @Test
    void get_idDoesNotExists_throwException() {...}
}

@TestInstance(Lifecycle.PER_CLASS)
class UserDaoTest {
    ...

// 그리고 이쯤에서 DaoFactory 라는 이름이 몹시 잘못되었다는게 보여서 AppConfig로 바꿨다  
@SpringBootTest
@ContextConfiguration(classes = DaoFactory.class)
class UserDaoTest {
    
    @Autowired
    private ApplicationContext applicationContext;
    
    private UserDao userDao;
    
    @BeforeEach
    void setUp() {
        userDao = applicationContext.getBean("userDao", UserDao.class);
    }
    ...

@SpringBootTest
@ContextConfiguration(classes = AppConfig.class)
class UserDaoTest {

    @Autowired
    private UserDao userDao;
    ...

@SpringBootTest
@ContextConfiguration(classes = TestAppConfig.class)
class UserDaoTest {

    @Autowired
    private DataSource dataSource;
    ...

@Configuration
public class TestAppConfig {

    @Bean
    public DataSource dataSource() {
        SimpleDriverDataSource dataSource = new SimpleDriverDataSource();

        dataSource.set...;

        return dataSource;
    }
}

class UserDaoTest {

    private UserDao userDao;

    @BeforeEach
    void setUp() {
        userDao = new UserDao();
        userDao.setDataSource(dataSource());
    }
    
    private DataSource dataSource() {
        SimpleDriverDataSource dataSource = new SimpleDriverDataSource();

        dataSource.setDriverClass(com.mysql.cj.jdbc.Driver.class);
        dataSource.setUrl("jdbc:mysql://localhost:3306/springbook?serverTimezone=Asia/Seoul");
        dataSource.setUsername("spring");
        dataSource.setPassword("book");

        return dataSource;
    }
    ...

public Board(final PiecesSetup piecesSetup) {
    pieces = new Pieces(piecesSetup);
}

public interface PiecesSetup {
    Map<Position, Piece> initialize();
}

@Test
@DisplayName("폰은 상대기물이 목적지에 존재하면 대각선으로 움직일 수 있다")
void pawnCanMoveDiagonal_targetExist() {
    Piece whitePawn = new Piece(Color.WHITE, new Pawn());
    Board board = new Board(() -> {
        Map<Position, Piece> pieces = new HashMap<>();
        pieces.put(Position.of("a2"), whitePawn);
        pieces.put(Position.of("b3"), new Piece(Color.BLACK, new Pawn()));
        return pieces;
    });

    board.move("a2", "b3");
    assertThat(board.findPiece(Position.of("b3")).get()).isEqualTo(whitePawn);
}

internal class BehaviorTest: BehaviorSpec({

    given("when으로 동물 소리룰 찾으면") {
        val grammar = Grammar()

        `when`("고양이는") {
            val name = "cat"
            val sound = grammar.whenAnimalSound(name)
            then("야옹이 나온다") {
                sound shouldBe "meow"
            }
        }

        `when`("개는") {
            val name = "dog"
            val sound = grammar.whenAnimalSound(name)
            then("멍멍이 나온다") {
                sound shouldBe "woff"
            }
        }

        `when`("이름 모를 동물은") {
            val name = "x"
            val sound = grammar.whenAnimalSound(name)
            then("unknown이 나온다") {
                sound shouldBe "unknown"
            }
        }
    }
})