@Autowired
SingerReposit singrepo;

//get all records(read)
@GetMapping("/list")
private List<SingerModel> getAll(){
    return singrepo.findAll();
}

//to create and insert a record(create)
@PostMapping("/addsinger")
private SingerModel createSing(@Valid @RequestBody SingerModel sing)
{
    return singrepo.save(sing);
}


@GetMapping("/list/{id}")
private Optional<SingerModel> getSinger(@PathVariable("id") long id)
{
    return singrepo.findById(id);
}

@PutMapping("/update/{id}")
private SingerModel updateSinger(SingerModel sing)
{
    singrepo.deleteById(sing.getId());
    singrepo.save(sing);
    return sing;
}

@DeleteMapping("/delete/{id}")
private Optional<SingerModel> deleteSinger(@PathVariable("id") long id)
{
    Optional<SingerModel> del = singrepo.findById(id);

    singrepo.deleteById(id);

    return del;

}