Computer scienceProgramming languagesGolangWorking with dataRelational databasesGORM

CRUD Operations — Create

Theory

Creating various records from a map

Report a typo

Emma is working with the music SQLite database, below you can see the database diagram:

music database diagram

Emma wants to insert various records of artists into the artists table using a map; please help Emma write the required additional code to achieve this task.

To solve this task, you need to explicitly create the records using a map and not a model struct!
Write a program in Go
package main

import (
"fmt"
"gorm.io/driver/sqlite"
"gorm.io/gorm"
"log"
"time"
)

// DO NOT modify the model declarations below!
type Artist struct { // Model for the `artists` table
gorm.Model
Name string
Songs []Song `gorm:"many2many:artist_songs"`
}

type Song struct { // Model for the `songs` table
gorm.Model
Title string
Duration time.Duration
Artists []Artist `gorm:"many2many:artist_songs"`
}

func main() {
db := createDB() // DO NOT delete this line! it creates the in-memory `music` database

// Create the Artists records below using a `map`:
artists := []?{
{"Name": "The Jackson 5"},
{"Name": "Backstreet Boys"},
{"Name": "NSYNC"},
}
result := db.?(&Artist{}).?(&?)
if result.Error != nil {
log.Fatalf("cannot create Artists: %v\n", result.Error)
___

Create a free account to access the full topic