Spring Boot - initial test data

Question

I am trying to pass data to test the front, but the controller is not getting the data that Spring Boot should start.

My application.properties:

spring.jpa.hibernate.ddl-auto=create

My import.sql:

INSERT INTO convidado
    (id, nome, quantidadeDeAcompanhante)
VALUES(1, 'Pedro', 2);
INSERT INTO convidado
    (id, nome, quantidadeDeAcompanhante)
VALUES(2, 'Ana', 5);
INSERT INTO convidado
    (id, nome, quantidadeDeAcompanhante)
VALUES(3, 'Ricardo', 1);

My controller:

@Controller
public class ConvidadosController {
    @Autowired
    private Convidados convidados;
    @GetMapping("/convidados")
    public ModelAndView listar() {
        ModelAndView modelAndView = new ModelAndView("ListaConvidados");
        modelAndView.addObject("convidados", convidados.findAll());
        System.out.println("***** " + convidados.findAll().toString() + " *******");
        return modelAndView;
    }
}

My Invited Entity:

@Entity
public class Convidado implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue
    private Long id;
    private String nome;
    private Integer quantidadeDeAcompanhante;

My Pository:

import com.gestaofestas.model.Convidado;
public interface Convidados extends JpaRepository<Convidado, Long> {

}

My folders:

In case it is returning an empty array and does not give error. How do I test this way by inserting data into the sql file that Spring Boot loads in Hibernate?

Answer 1

Solution:

1. Put the following in your application.properties:

spring.datasource.initialization-mode=always

2. Rename the file import.sql for data sql.

3. Make sure the file data sql. is located in src/main/Resources

4. Place @Column above the variables/columns name and quantityDepartnering

5. If you have a script to create tables, the script has to be called schema.sql. Then put the following in your application.properties:

spring.jpa.hibernate.ddl-auto=none

See more information in the reference Database initialization spring.