【AI Shift Advent Calendar 2023】GitHubCopilot ChatとCursorを使ってみた

@SpringBootApplication
public class RelationalDataAccessApplication implements CommandLineRunner {

    private static final Logger log = LoggerFactory.getLogger(RelationalDataAccessApplication.class);

    public static void main(String args[]) {
        SpringApplication.run(RelationalDataAccessApplication.class, args);
    }

    @Autowired
    JdbcTemplate jdbcTemplate;

    @Override
    public void run(String... strings) throws Exception {

        log.info("Creating tables");

        jdbcTemplate.execute("DROP TABLE customers IF EXISTS");
        jdbcTemplate.execute("CREATE TABLE customers(" +
                "id SERIAL, first_name VARCHAR(255), last_name VARCHAR(255))");

        // Split up the array of whole names into an array of first/last names
        List<Object[]> splitUpNames = Arrays.asList("John Woo", "Jeff Dean", "Josh Bloch", "Josh Long").stream()
                .map(name -> name.split(" "))
                .collect(Collectors.toList());

        // Use a Java 8 stream to print out each tuple of the list
        splitUpNames.forEach(name -> log.info(String.format("Inserting customer record for %s %s", name[0], name[1])));

        // Uses JdbcTemplate's batchUpdate operation to bulk load data
        jdbcTemplate.batchUpdate("INSERT INTO customers(first_name, last_name) VALUES (?,?)", splitUpNames);

        log.info("Querying for customer records where first_name = 'Josh':");
        jdbcTemplate.query(
                "SELECT id, first_name, last_name FROM customers WHERE first_name = ?",
                (rs, rowNum) -> new Customer(rs.getLong("id"), rs.getString("first_name"), rs.getString("last_name")), "Josh")
        .forEach(customer -> log.info(customer.toString()));
    }
}

@Override
    public void run(String... strings) throws Exception {

        log.info("Creating tables");
        createTable();
        List<Object[]> splitUpNames = splitNames(Arrays.asList("John Woo", "Jeff Dean", "Josh Bloch", "Josh Long"));
        logNames(splitUpNames);
        insertNames(splitUpNames);
        queryNames("Josh");
    }

@Override
    public void run(String... strings) throws Exception {
        createTable();
        insertData();
        queryData();
    }

public interface CustomerUseCase {
    void createCustomers(List names);
    List getCustomersByName(String name);
}

public class CustomerUseCaseImpl implements CustomerUseCase {
    private CustomerRepository customerRepository;

    public CustomerUseCaseImpl(CustomerRepository customerRepository) {
        this.customerRepository = customerRepository;
    }

    @Override
    public void createCustomers(List names) {
        List customers = names.stream()
            .map(name -> name.split(" "))
            .map(nameParts -> new Customer(null, nameParts[0], nameParts[1]))
            .collect(Collectors.toList());

        customerRepository.saveAll(customers);
    }

    @Override
    public List getCustomersByName(String name) {
        return customerRepository.findByName(name);
    }
}

public interface CustomerRepository {
    void saveAll(List customers);
    List findByName(String name);
}

public interface CustomerRepository {
    void createTable();
    void insert(List<Customer> customers);
    List<Customer> findByFirstName(String firstName);
}