Skip to content

插件优化建议 #57

Description

@longrbl

目前插件的功能是非常不错。我还是想提几个优化点

1 生成器的结构体可以选择是否进行内存对齐,可以优化的内存性能
2 pgsql数据库时,无法把字段备注也拷贝到结构体对应字段

假如增加上面几个点我感觉目前的插件会更完美。

另外发现针对pgslq 还差一点点意思

简单sql


CREATE TABLE "public"."test_s" (
  "id" int4 NOT NULL DEFAULT nextval('test_s_id_seq'::regclass),
  "title" varchar(255) COLLATE "pg_catalog"."default",
  CONSTRAINT "test_s_pkey" PRIMARY KEY ("id")
)
;

ALTER TABLE "public"."test_s" 
  OWNER TO "postgres";

COMMENT ON COLUMN "public"."test_s"."id" IS '数据库备注';

COMMENT ON COLUMN "public"."test_s"."title" IS '备注信息';

得到的结果是(错误的结构)

type "testS" struct {
	"id" string `json:""id""`
	"title" string `json:""title""`
}

pgsql转的结构体明显不对,pgsql的版本17版本, 另外上面原始pgsql 完全复制给插件是无法识别 只能拷贝下面这个,这样就导致pgsql时 字段的备注信息不见了

CREATE TABLE "public"."test_s" (
  "id" int4 NOT NULL DEFAULT nextval('test_s_id_seq'::regclass),
  "title" varchar(255) COLLATE "pg_catalog"."default",
  CONSTRAINT "test_s_pkey" PRIMARY KEY ("id")
)
;


Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions