teste.go

package main

import (
	"encoding/json"
	"fmt"
	"gorm.io/driver/postgres"
	"gorm.io/gorm"
	"io/ioutil"
)

type AutoGenerated struct {
	ID         string  `json:"_id"`
	Index      int     `json:"index"`
	GUID       string  `json:"guid"`
	IsActive   bool    `json:"isActive"`
	Balance    string  `json:"balance"`
	Picture    string  `json:"picture"`
	Age        int     `json:"age"`
	EyeColor   string  `json:"eyeColor"`
	Name       string  `json:"name"`
	Gender     string  `json:"gender"`
	Company    string  `json:"company"`
	Email      string  `json:"email"`
	Phone      string  `json:"phone"`
	Address    string  `json:"address"`
	About      string  `json:"about"`
	Registered string  `json:"registered"`
	Latitude   float64 `json:"latitude"`
	Longitude  float64 `json:"longitude"`
	Pessoas    []struct {
		ID       int    `json:"id"`
		Name     string `json:"name"`
		Salario  string `json:"salario"`
		Contatos []struct {
			ID   int    `json:"id"`
			Nome string `json:"nome"`
		} `json:"contatos"`
	} `json:"pessoas"`
	Tags    []string `json:"tags"`
	Friends []struct {
		ID   int    `json:"id"`
		Name string `json:"name"`
	} `json:"friends"`
	Greeting      string `json:"greeting"`
	FavoriteFruit string `json:"favoriteFruit"`
}

func main() {
	plan, _ := ioutil.ReadFile("C:\\Users\\Rodrigo\\Downloads\\generated2.json")
	var data []AutoGenerated
	err := json.Unmarshal(plan, &data)
	if err != nil {

	}

	dsn := "host=localhost user=postgres password=test dbname=teste port=5432 sslmode=disable"
	//	create:=`create table empresa
	//(
	//	id serial
	//		constraint empresa_pk
	//			primary key,
	//	doc jsonb
	//);
	//
	//`
	//db.Exec(create)
	db, err := gorm.Open(postgres.Open(dsn), &gorm.Config{})
	if err != nil {
		fmt.Sprint(err)
	}
	fmt.Print("Inicio")
	for _, value := range data {
		jsonValue,err := json.Marshal(value)
		if err != nil {

		}
		sql := fmt.Sprintf("INSERT INTO empresa(doc)values('%s')", fmt.Sprint(string(jsonValue)))
		db.Exec(sql)
	}
	fmt.Print("Fim")

}