Mapping and querying with JPA/Hibernate SpringBoot

[Craig Star]

hello,

Please consider this scenario

my models

@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@MappedSuperclass
public abstract class BaseEntity implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    private Long id;

    public boolean isNew() {
        return this.id == null;
    }
}

@Getter
@Setter
@AllArgsConstructor
@NoArgsConstructor
@MappedSuperclass
public class Person extends BaseEntity {
    private String firstName;
    private String lastName;
    private String middleName;
    private String alias;
    @Temporal(TemporalType.DATE)
    private Date dateOfBirth;
    private String gender;
}

public class Owner extends Person{
    // maybe some new fields
}

@Data
@Entity
@AllArgsConstructor
@NoArgsConstructor
public class Employee extends Person {
     @OneToOne(cascade = {CascadeType.MERGE, CascadeType.PERSIST})
    private ContactDetails contactDetails;
}

@Data
@Entity
@AllArgsConstructor
@NoArgsConstructor
public class ContactDetails extends BaseEntity {
    private String emailAddress;
    private String mobileTelNo;
    private String homeTelNo;
    private String workTelNo;
    @OneToOne(cascade = {CascadeType.MERGE, CascadeType.PERSIST}, fetch = FetchType.EAGER)
    private Employee employee;
}

I have a very simple repository and controller just to test how the data is persisted

public interface UsersRepository extends JpaRepository<Employee, Integer> {
}

@RestController
@RequestMapping(value = "/rest/users")
public class UsersController {

    @Autowired
    UsersRepository usersRepository;

    @GetMapping(value = "/all")
    public List<Employee> getAll() {
        return usersRepository.findAll();
    }

    @PostMapping(value = "/load")
    public List<Employee> persist(@RequestBody final Employee users) {
        usersRepository.save(users);
        return usersRepository.findAll();
    }

}

I would like to save a record like this using the /load endpoint

{
   "id": 2,
   "firstName": "Cris",
   "lastName": "Star",
   "middleName": "None",
   "alias": "Cr",
   "dateOfBirth": "2020-02-12",
   "gender": "male",
   "contactDetails": {
       "emailAddress": "[e-mail]"
   }
}


What I get now is


[
   {
       "id": 2,
       "firstName": null,
       "lastName": null,
       "middleName": null,
       "alias": null,
       "dateOfBirth": null,
       "gender": null,
       "contactDetails": {
           "id": 8,
           "emailAddress": "hello",
           "mobileTelNo": null,
           "homeTelNo": null,
           "workTelNo": null,
           "employee": null,
           "new": false
       },
       "new": false
   }
]


When I query the MySql data base I can see the record added in the customer_details table.

End goal:
1. save employee details and persist data in contact_details table
2. search by phone_number and list the details(either customer or employee) of the related phone number
3. search by employee_id or customer_id and get customer/employee + contact details back

How could i map my model to start with?
Could anyone help me with the queries, please?

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.10</version>
            <scope>provided</scope>
        </dependency>
    </dependencies>

properties

spring:
  datasource:
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/testing
    username: 
    password: 
  jpa:
    hibernate:
      ddl-auto: validate
    database: mysql
    show-sql: true
    database-platform: org.hibernate.dialect.MySQL5Dialect
    hibernate.ddl-auto: update