Insert data into sqlite db with Go Fiber / Gorm

Question

Hello I'm using Go Fiber together with gorm sqlite. I was wondering if there is a way to pre load data into the database with a sql script?

I know that in Spring Boot it is possible to create a data.sql file to preload data. Is there a same way to accomplish that for go fiber / gorm sqlite?

Please ask the author of fiber. – Volker Feb 06 '22 at 19:58 — Volker, Feb 06 '22 at 19:58

score 0 · Accepted Answer · answered Feb 06 '22 at 20:26

0

You could read the sql file and execute the raw query in Gorm, and you could execute this before booting up the server.

path := filepath.Join("path", "to", "script.sql")

c, ioErr := ioutil.ReadFile(path)
if ioErr != nil {
     // handle error.
}

sql := string(c)

// gorm *DB
err := db.Exec(sql).Error
if err != nil {
    // handle error
}

answered Feb 06 '22 at 20:26

shahin mahmud

945
4
11

Yes this is what I was looking for thanks! – Ronny Giezen Feb 09 '22 at 15:54

Insert data into sqlite db with Go Fiber / Gorm

1 Answers1