Home > Enterprise >  Golang Gorm not creating table with constraints
Golang Gorm not creating table with constraints

Time:04-19

I'm working on a Gin app with Gorm. Currently, I've got the following struct which represents a model:

// Category represents a category object in the database
type Category struct {
    Name        string `json:"name" gorm:"size:60,unique,not null"`
    Description string `json:"description" gorm:"size:120"`
    Parent      uint   `json:"parent"`
    Active      bool   `json:"active" gorm:"default:true"`
    gorm.Model
}

as you can see, there are some constraints such as size, unique, and not null.

When I run the migration db.AutoMigrate(&entities.Category{})

the table is in fact created, but not with the specified constraints. Inspecting the table's DDL, here's how it is being created:

CREATE TABLE `categories` (
  `name` longtext DEFAULT NULL,
  `description` varchar(120) DEFAULT NULL,
  `parent` int(10) unsigned DEFAULT NULL,
  `active` tinyint(1) DEFAULT 1,
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_categories_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

any idea what am I doing wrong?

CodePudding user response:

Based on the doc, I believe you should use semicolon (;) instead comma (,) between tag constraints declaration

type Category struct {
    Name        string `json:"name" gorm:"size:60;unique;not null"`
    Description string `json:"description" gorm:"size:120"`
    Parent      uint   `json:"parent"`
    Active      bool   `json:"active" gorm:"default:true"`
    gorm.Model
}
  • Related