Error - unable to generate code for table: %s, primary key column: [%d] %s has unsupported type: %s / %s

[shinsuny]

gen --version
v0.9.27 (08/04/2020)

I am trying like:

gen --sqltype=mysql \
   	--connstr "correct_conn_str" \
   	--database some_db  \
   	--gorm \
   	--guregu \
   	--out ./out \
   	--generate-dao \
   	--overwrite

Then getting:

Error - unable to generate code for table: %s, primary key column: [%d] %s has unsupported type: %s / %s

Yes, my primary key column is a varbinary

Is there a way to fix this?
Thanks

[smallnest]

gen doesn't know how to map varbinary to a go type.

Maybe you should define your mapping.json just like:

{
      "sql_type": "date",
      "go_type": "time.Time",
      "json_type": "Text",
      "protobuf_type": "google.protobuf.Timestamp",
      "guregu_type": "*models.Time",
      "go_nullable_type": "time.Time",
      "swagger_type": "time.Time"
    }

[shinsuny]

@smallnest

After doing more research, it seems gen understands varbinary and converts it to []byte but problem occurred (Error thrown) when varbinary is a primary key.

[smallnest]

what error? paste the error stack please

[shinsuny]

I am getting like(As in the first comment)
Error - unable to generate code for table: %s, primary key column: [%d] %s has unsupported type: %s / %s

Sorry, I don't have stack ATM.

[smallnest]

I have added some code to support varbinary but have not test with a mysql database.