Relation with custom column name cause a panic because it doesn't find that column name

[mxmaxime]

Hi,
FYI I use bun to query an existing database, no way to change things on it.

• version: latest

Here's a little example:

type BlablaModel struct {
  ID uint64 `bun:"SomeId,pk"`
  Stuff []*StuffModel `bun:"rel:has-many,join:SomeId=id"`
}

And I get this error:

A panic occurred and has been caught: bun: BlablaModel has-many Stuff: BlablaModel must have column SomeId

The panic raise is coming from schema/table.go#632

It might be linked of some case sensitivity? Idk, I dug but I didn't find the root cause.
I saw your kind warning here but.. I need that column to contains those case-sensitive str.
Do you have an idea?
Thanks!

[vmihailenco]

Try join:some_id=id and make sure you have column with the name some_id.

[mxmaxime]

but what if I don't have a column some_id in the db and I can't actually add this column in the schema?

[vmihailenco]

Then this is not a has-many relation and you should not use rel:has-many,join:SomeId=id. It is hard to tell what you are trying to achieve.

[mxmaxime]

Well, it's a has-many relation ship.
But, the actual column name on the left side is SomeId on the database and I can't change it.

The table looks like:

CREATE TABLE BlablaModel
(
    SomeId INT PRIMARY KEY NOT NULL,
....
)

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.