526互联

go-zero 生成model

发布时间 2023-09-12 14:45:27作者: lisus2000

1.准备MYSQL文件

 

CREATE TABLE user (
      id bigint AUTO_INCREMENT,
      name varchar(255) NULL COMMENT 'The username',
      password varchar(255) NOT NULL DEFAULT '' COMMENT 'The user password',
      mobile varchar(255) NOT NULL DEFAULT '' COMMENT 'The mobile phone number',
      gender char(10) NOT NULL DEFAULT 'male' COMMENT 'gender,male|female|unknown',
      nickname varchar(255) NULL DEFAULT '' COMMENT 'The nickname',
      type tinyint(1) NULL DEFAULT 0 COMMENT 'The user type, 0:normal,1:vip, for test golang keyword',
      create_at timestamp NULL,
      update_at timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      UNIQUE mobile_index (mobile),
      UNIQUE name_index (name),
      PRIMARY KEY (id)
) ENGINE = InnoDB COLLATE utf8mb4_general_ci COMMENT 'user table';
将这个内容改到user-model的SQL目录下，如下图所示

 进入到这个目录，运行如下命令

 

 

 

goctl model mysql ddl --src user.sql --dir .    

goctl model指令如下

 

 最终生成的文件如下