Hibernate - Seed database without using import.sql

Question

I come from php/laravel. Whenever I want to seed the database i only need to run php artisan db:seed. This will run some php scripts that will insert data into the database.

I want to achieve this same feature using spring/hibernate. I know I can add an import.sql file to seed the database after schema creation. However, I want to import these fixtures using java and the ORM available so I do not need to maintain an sql.

Is there a way? If not, there should be some configuration to trigger a script that use the ORM entity manager to persist entities in the database after schema creation. The main idea is not to maintain a big sql seeder file over schema revisions.

Thanks!

use a ContextLoaderListener or something like that?

user180100
– user180100

2016-08-03 13:18:56 +00:00
Commented Aug 3, 2016 at 13:18 — user180100
– user180100, Commented Aug 3, 2016 at 13:18

O.Badr · Accepted Answer · 2017-07-26 10:41:03Z

2

If you're using Spring data you can use Repository populators.

Otherwise you may register an event that fires after the spring context is loaded :

@Component
public class YourListener {

    // Declare your autowired beans here 

    @EventListener
    public void handleContextRefresh(ContextRefreshedEvent event) {
        // Your seeder 
        // + You can use all the registred beans (repositories, services...)
    }
}

For more detail check: Better application events in Spring Framework 4.2

answered Jul 26, 2017 at 10:41

O.Badr

3,2012 gold badges31 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate - Seed database without using import.sql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related