Specify VARCHAR Length On @belongsTo/hasOne

[A-Corregidor]

Hi there!

When you create some model relation field (userId), using these syntax

@belongsTo(() => User)
	userId: string;

It's created on DB like a VARCHAR(512) (at least, on MySQL).
How could I modify that length? My UUID's real length is 36

Thanks

[A-Corregidor]

Possible referenced question: #8388

[achrinza]

Hi @A-Corregidor, does #8476 (comment) help answer your question?

In this case, it should be something like this:

@belongsTo(
  () => User,
  undefined,
  {
    mysql: {
      dataType: 'varchar',
      dataLength: 36,
    },
  },
)
userId: number;

[A-Corregidor]

Hi @achrinza , it doesn't seems to work.
If i set that code and run a (soft) migration, userId keeps being a VARCHAR(512).
It works if I set it like

@belongsTo(
  () => User,
  undefined,
  {
    length: 36
  },
)
userId: number;

But then, the foreign key fails as id on User's table is VARCHAR(255) (which I would like to change too, but I don't know how) and userId is VARCHAR(36) (see #8388)

[achrinza]

Thanks for the additional information. I suspect that this is an issue with the autoupdate logic in the MySQL connector; In this case, would you like to open an issue in that GitHub repo?

I'll also put this issue in my backlog, but it'll be some time before I can get to it. Though we're also open to accepting patches from the community as well.