How to work immudb with gorm?

[sujit-baniya]

Hi,
I'm new to immudb. I tried to use immudb with gorm and used immudbgorm library (forked locally) for testing.

package main

import (
	"fmt"
	"github.com/sujit-baniya/db"
	"gorm.io/gorm"
)

type Customer struct {
	gorm.Model
	CustomerName string `gorm:"customer_name"`
}

func main() {
	DB, err := connect(Config{
		Driver:   "immudb",
		Host:     "127.0.0.1",
		Username: "immudb",
		Password: "immudb",
		DBName:   "defaultdb",
		Port:     3322,
	})
	if err != nil {
		panic(err)
	}
	fullText(DB)
}

type Config struct {
	Driver     string `yaml:"driver" env:"DB_DRIVER"`
	Host       string `yaml:"host" env:"DB_HOST"`
	Username   string `yaml:"username" env:"DB_USER"`
	Password   string `yaml:"password" env:"DB_PASS"`
	DBName     string `yaml:"db_name" env:"DB_NAME"`
	Debug      bool   `yaml:"debug" env:"DB_DEBUG" env-default:"false"`
	Port       int    `yaml:"port" env:"DB_PORT"`
	MaxOpenCon int    `yaml:"connections" env:"DB_CONNECTIONS" env-default:"100"`
	MaxIdleCon int    `yaml:"idle_connections" env:"DB_IDLE_CONNECTIONS" env-default:"80"`
}

func connect(cfg Config) (*gorm.DB, error) {
	connectionString := fmt.Sprintf("immudb://%s:%s@%s:%d/%s", cfg.Username, cfg.Password, cfg.Host, cfg.Port, cfg.DBName)
	return gorm.Open(db.OpenImmudb(connectionString, &db.ImmuGormConfig{Verify: true}), &gorm.Config{
		DisableForeignKeyConstraintWhenMigrating: true,
	})
}

func fullText(DB *gorm.DB) {
	var customers []Customer
	err := DB.Table("customers").Find(&customers).Error
	if err != nil {
		panic(err)
	}
	fmt.Println(customers)
}

But I'm getting error

panic: rpc error: code = Unknown desc = column does not exist; rpc error: code = Unknown desc = column does not exist

goroutine 1 [running]:
main.fullText(0x194b23c?)
        /Users/sujit/Sites/Projects/db/examples/main.go:40 +0xdd
main.main()
        /Users/sujit/Sites/Projects/db/examples/main.go:32 +0x45
exit status 2

Please help

[Razikus]

Did you try to AutoMigrate schema?

Like in the example
https://github.com/codenotary/immugorm/blob/main/README.md?plain=1#L39

[sujit-baniya]

@Razikus The table already exists. So I don't need db.AutoMigrate(&Customer{}).
Also I did use sample from mentioned link