recruiting-system / java_persistence_practice_testing-2019-8-29-3-49-16-287 Goto Github PK

• please forked this repo for practice
• use MyBatis-Spring-Boot-Starter-Test to implement Repository testing for follow test cases
• finish the testing and implementation of test cases

We are building a employee management application, this application has Employee entity with fields id,name,age,company_id and Company entity with fields id,name,address. One Company can have many Employee

1. Employee should be fetched by company_id, the result of method should be a entity not a list and the id and other fields should be consist with input.
2. Company should be fetched by id and include it owned Employee list if employee table have related records.
3. Employee can be saved and id generated by database should be returned properly
4. add createdTime field for Employee and let database generate the timestamp, createdTime should be auto filled properly when a new object be inserted.
5. Employee list should be fetched by giving a keyword for name searching
6. Employee list should be save in batch properly

• submit your git repo url to field answer

• create Entity to present your data structure
• create Repository for MyBatis integration
• create Mapper under resources package
• write sql statements
• use Repository for your business to access to database
• write Repository testing

• schema.sql will be loaded and init database when application is starting
• navigate to web consolehttp://localhost:8080/h2-console
• put jdbc:h2:mem:tws_persistence_db in JDBC URL field

• controller layer is not required