본문으로 건너뛰기

gorm

설치​

go get -u gorm.io/gorm
go get -u gorm.io/driver/mysql
go get -u gorm.io/driver/postgres

Database​

Schema​

Tag​


  • ;: 구분자
  • column:<name>
  • type:<columnDefinition>: Tag로 선언할 수 없는 것은 <type>을 사용하여 선언할 수 있습니다
  • serializer:<serializer>
  • size:<size>
  • primaryKey : PRIMARY KEY
  • unique: UNIQUE KEY
  • default:<value>: DEFAULT <value>
  • precision:<precision>
  • scale:<scale>
  • not null: NOT NULL
  • autoIncrement: AUTO_INCREMENT
  • autoIncrementIncrement:<step>
  • embedded
  • embeddedPrefix:<prefix>
  • autoCreateTime:milli|nano: CreatedAt을 unix 시간으로 저장할 때 사용합니다
  • autoUpdateTime:milli|nano: UpdatedAt을 unix 시간으로 저장할 때 사용합니다
  • index[:<config>[,<config>]]
  • uniqueIndex
  • check:<condition>
  • <-[:create|update|false]: 쓰기 권한
  • ->[:false]: 읽기 권한
  • -[:migration|all]
  • comment:<comment>


  • foreignKey:<key>
  • references:<key>
  • polymorphic:<key>
  • polymorphicValue:<value>
  • many2many:<joinTable>
  • joinForeignKey:<key>
  • joinReferences:<key>
  • constraint:<constraint>[,<constraint>]
    • OnUpdate:<action>
    • OnDelete:<action>

Example​

CREATE TABLE accounts (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    email VARCHAR(255) NOT NULL,
    phone_number VARCHAR(20) NOT NULL DEFAULT '',
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY ('account_id'),
    UNIQUE KEY 'email' ('email')
);
type Account struct {
	ID          uint64    `gorm:"not null;autoIncrement;primaryKey"`
	Email       string    `gorm:"size:255;not null;unique"`
	PhoneNumber string    `gorm:"size:20;not null;default:''"`
	CreatedAt   time.Time `gorm:"type:TIMESTAMP;not null;default:CURRENT_TIMESTAMP"`
	UpdatedAt   time.Time `gorm:"type:TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;not null;default:CURRENT_TIMESTAMP"`
}

Transaction​