failed to generate code by goctl with ddl

[alexcdever]

I wrote an init.sql:

CREATE database if not exists blog default charset utf8mb4 collate utf8MB4_general_ci;
use blog;
CREATE TABLE post
(
    id           bigint auto_increment primary key NOT NULL,
    title        varchar(255)                      NOT NULL,
    draft        boolean                           NOT NULL,
    content      text                              not null,
    filename     varchar(255)                      NOT NULL,
    md5          CHAR(32)                          NOT NULL,
    created_date date                              not null,
    created_time time                              not null,
    updated_date date                              not null,
    updated_time time                              not null
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;
CREATE TABLE tag
(
    id           bigint auto_increment PRIMARY KEY NOT NULL,
    tag          varchar(255)                      NOT NULL,
    created_date date                              not null,
    created_time time                              not null,
    updated_date date                              not null,
    updated_time time                              not null
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;
CREATE TABLE category
(
    id           bigint auto_increment PRIMARY KEY NOT NULL,
    category     varchar(255)                      NOT NULL,
    created_date date                              not null,
    created_time time                              not null,
    updated_date date                              not null,
    updated_time time                              not null
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;
CREATE TABLE article
(
    id           bigint auto_increment PRIMARY KEY NOT NULL,
    post_id      bigint                            NOT NULL,
    created_date date                              not null,
    created_time time                              not null,
    updated_date date                              not null,
    updated_time time                              not null
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;
CREATE TABLE rel_post_tag
(
    id           bigint auto_increment PRIMARY KEY NOT NULL,
    post_id      bigint                            NOT NULL,
    tag_id       bigint                            NOT NULL,
    state        int                               NOT NULL default 0,
    created_date date                              not null,
    created_time time                              not null,
    updated_date date                              not null,
    updated_time time                              not null
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;
CREATE TABLE rel_post_category
(
    id           bigint auto_increment PRIMARY KEY NOT NULL,
    post_id      bigint                            NOT NULL,
    category_id  bigint                            NOT NULL,
    state        int                               NOT NULL default 0,
    created_date date                              not null,
    created_time time                              not null,
    updated_date date                              not null,
    updated_time time                              not null
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

And then I execute goctl model mysql ddl -src blog/model/init.sql -dir blog/model -c for generating code. But the command reported:

$ goctl model mysql ddl -src blog/model/init.sql -dir blog/model -c                 
[convertColumns]: The column "id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "title" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "draft" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "content" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "filename" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "md5" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "tag" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "category" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "post_id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "post_id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "tag_id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "post_id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "category_id" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "created_time" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_date" is recommended to add constraint `DEFAULT`
[convertColumns]: The column "updated_time" is recommended to add constraint `DEFAULT`
Error: table post: missing primary key
Usage:
  goctl model mysql ddl [flags]

Flags:
      --branch string     The branch of the remote repo, it does work with --remote
  -c, --cache             Generate code with cache [optional]
      --database string   The name of database [optional]
  -d, --dir string        The target dir
  -h, --help              help for ddl
      --home string       The goctl home path of the template, --home and --remote cannot be set at the same time, if they are, --remote has higher priority
      --idea              For idea plugin [optional]
      --remote string     The remote git repo of the template, --home and --remote cannot be set at the same time, if they are, --remote has higher priority
                                The git repo directory must be consistent with the https://github.com/zeromicro/go-zero-template directory structure
  -s, --src string        The path or path globbing patterns of the ddl
      --style string      The file naming format, see [https://github.com/zeromicro/go-zero/tree/master/tools/goctl/config/readme.md]

table post: missing primary key

Can someone tell me where is the wrong?

[yguilai]

if your fields have a NOT NULL constraint, it recommend to add constraint DEFAULT. Like your field ' rel_post_category.state'. By the way, Primary key wont need NOT NULL constraint

[alexcdever]

I found out the reason: goctl can't match the primary key keyword in the column definition. It worked when I used primary key (id)

[alexcdever]

goctl can't match the primary key keyword in the column definition. It worked when I used the primary key (id)