How can you load initial data in MongoDB through Spring Boot?

Question

Is it possible to load initial data in a MongoDB database using src/main/resources/data.sql or by any other file?

I understand that data.sql is used for SQL DB's whereas MongoDB is a NOSQL DB. But just wanted to know if there is any equivalent of data.sql for NOSQL DB's.

While googling I found out this SO link (Spring Boot - Loading Initial Data) which does what I am looking for but still it's not a standalone file data.sql.

score 5 · Accepted Answer · answered Feb 19 '18 at 17:19

To load initial data you can use db migration tool like MongoBee

It's very useful option to handle data initialization in java. You just need to configure @Bean public Mongobee mongobee in your spring boot and setup component scan for data ChangeLogs where data creation actually happens.

score 5 · Answer 2 · answered Jan 16 '20 at 11:32

5

You can use a repository populator with Spring Data MongoDB. Let me demonstrate this with a code sample in Kotlin:

@Configuration
class TestApplicationConfig {
    @Value("classpath:test_data.json")
    private lateinit var testData: Resource

    @Bean
    @Autowired
    fun repositoryPopulator(objectMapper: ObjectMapper): Jackson2RepositoryPopulatorFactoryBean {
        val factory = Jackson2RepositoryPopulatorFactoryBean()
        // inject your Jackson Object Mapper if you need to customize it:
        factory.setMapper(objectMapper)
        factory.setResources(arrayOf(testData))
        return factory
    }
}

Put test_data.json in resources directory.

answered Jan 16 '20 at 11:32

naXa stands with Ukraine

35,493
19
190
259

can you take the array from test_data.json and populate it 1 by 1? – Shahar Wider Apr 05 '20 at 14:32
@ShaharWider it looks like a new question. please [ask](https://stackoverflow.com/questions/ask) and Stack Overflow will answer. – naXa stands with Ukraine Apr 05 '20 at 14:52
1

i did about 20 days ago. no one answered... https://stackoverflow.com/questions/60711819/spring-mongo-populator-one-by-one – Shahar Wider Apr 06 '20 at 06:24

score 4 · Answer 3 · answered Sep 04 '18 at 06:47

4

you can define your data in json/xml and use populator elements of the repository to load the data.

https://docs.spring.io/spring-data/mongodb/docs/2.0.9.RELEASE/reference/html/#core.repository-populators

answered Sep 04 '18 at 06:47

Deep

76
6

How can you load initial data in MongoDB through Spring Boot?

3 Answers3

Linked