Create Spring JdbcTemplate repositories and entity objects for the provided H2 database schema.
Budget: £20 – £250 GBP
Java 11 based project.
Must use Lombok pre-processing annotations to reduce boiler plate code.
Maven as the build system.
Spring boot version 2.5.5.
See entity.png for an entity model that describes the shape of the Java objects. Attributes from the db tables should be added as fields using standard Java Bean naming conventions.
Use H2 in test to validate the repositories created. Each repository should have an integration test that can validate the CRUD operations, and any additional operations detailed below, that can be verified against an in memory H2 database.
Each entity should have a relevant CRUD repository created. In addition, the following specific repository methods should be created;
(Consent)
List<Consent> findAllByCustomer(Customer customer);
List<Consent> findAllByLead(Lead lead);
(Customer)
List<Customer> findByBillingAddressName(String name);
Customer findByNick(String nick, UUID storeId);
List<Customer> findByStore(UUID storeId);
Must use Lombok pre-processing annotations to reduce boiler plate code.
Maven as the build system.
Spring boot version 2.5.5.
See entity.png for an entity model that describes the shape of the Java objects. Attributes from the db tables should be added as fields using standard Java Bean naming conventions.
Use H2 in test to validate the repositories created. Each repository should have an integration test that can validate the CRUD operations, and any additional operations detailed below, that can be verified against an in memory H2 database.
Each entity should have a relevant CRUD repository created. In addition, the following specific repository methods should be created;
(Consent)
List<Consent> findAllByCustomer(Customer customer);
List<Consent> findAllByLead(Lead lead);
(Customer)
List<Customer> findByBillingAddressName(String name);
Customer findByNick(String nick, UUID storeId);
List<Customer> findByStore(UUID storeId);
Related categories:
Business, Accounting, Human Resources & Legal
Apache Maven
Spring Boot
Spring Data