problem when table has FK to itself

[volatiletech]

problem when table has FK to itself

[aarondl]

Hi there @ryanbarry

The problem here is that we treat _id suffixes specially. When we generate a foreign key "lookup" helper, we typically take the foreign key name and drop _id off of it. It's a convention noted in the
pro tips section of the readme. However I guess it sort of becomes a requirement when the foreign key is on the same table :(

We could consider _uuid to the list of things that we drop, but then maybe someone else will come along with another prefix. Anyway, changing your column name to _id should fix the issue. And we'll see what we do about this in the long term.

Thanks for using sqlboiler!

[nullbio]

Hi @ryanbarry, is there a particular reason you are not using your unique uuid as your primary key, opposed to the serial id, or vice versa?

[nullbio]

@ryanbarry we've added uuid to the trim suffixes in the dev branch. Once these are merged into master (hopefully today) then you should not need to change any code, as long as you update your sqlboiler and regenerate.

[ryanbarry]

this is awesome, i really appreciate the quick turnaround! reason for having serial id & unique uuid is to expose uuid as an external identifier while keeping the serial id as internal to our datastore, while keeping querying simple. thanks again 😃

[nullbio]

Hey @ryanbarry, 2.0.1 has been released which includes the fixes for the issues you were having. Thanks.