Computer scienceBackendSpring BootData sources

Database pre-population

Theory

@Sql annotation first tries

Report a typo

You are testing your application with the @Sql annotation. How can you use it to pre-populate your database using schema.sql and data.sql scripts? Choose all possible options.

Java

1. @Sql(scripts = {"/schema.sql", "/data.sql"})

2. @Sql({"/schema.sql", "/data.sql"})

3. @Sql("/schema.sql", "/data.sql")

4. @Sql(scripts ={"/schema.sql", "/data.sql"}, executionPhase = Sql.ExecutionPhase.AFTER_TEST_METHOD)

5. @Sql(scripts ={"/schema.sql", "/data.sql"}, executionPhase = Sql.ExecutionPhase.BEFORE_TEST_METHOD)

Kotlin

1. @Sql(scripts = ["/schema.sql", "/data.sql"])

2. @Sql("/schema.sql", "/data.sql")

3. @Sql({"/schema.sql", "/data.sql"})

4. @Sql(scripts =["/schema.sql", "/data.sql"], executionPhase = Sql.ExecutionPhase.AFTER_TEST_METHOD)

5. @Sql(scripts =["/schema.sql", "/data.sql"], executionPhase = Sql.ExecutionPhase.BEFORE_TEST_METHOD)

Select one or more options from the list
___

Create a free account to access the full topic