unsupported type TypeJSON

[zzerjae]

Hello, Thanks for creating this tool.

For team with DBA, these tool seems to be of great help.

I have the following schema and I'm running into a problem.

create table outbox
(
    id             bigint auto_increment
        primary key,
    aggregate_type varchar(255) not null,
    aggregate_id   varchar(255) not null,
    type           varchar(255) not null,
    payload        json         not null
);

when I tried

go run ariga.io/entimport/cmd/entimport -dialect mysql -dsn "root:root@tcp(localhost:3306)/db"

exit status 1 with

2021/10/26 10:46:12 entimport: schema writing failed - schemast: unsupported type TypeJSON

Am I using it wrong? Or is it a bug?

Mysql: mysql 8
go: 1.17.0
entimport: v0.0.0-20211024085919-20c40b8b2009

[zeevmoney]

Hi @zzerjae 👋🏻
Thanks for reaching out.

Your usage is correct, the error message is related to the fact that I didn't implement all field types yet (JSON in your case).
entimport is missing some field types, because of the underlying schemaast package.

I have plans to add the rest of the field types in the recent future, but please feel free to ping me on ent Slack channel if you'd like to contribute.

[zzerjae]

Thanks for the quick and kind feedback, @zeevmoney !

I'll consider whether I can contribute. Thank you.

[till]

Is this a similar "error", or well, unsupported field type? (type postgres, field is a varchar)

2022/06/07 14:51:06 entimport: schema import failed - entimport: unsupported type &{<nil> "varchar[]"}