`IsZero()` and `ToNullUUID` Helper Functions about uuid HOT 2 OPEN

I had a similar problem in a DB (SQLite), where I have FK to UUIDs

I have a table where the FK can be NULL (not linked to any parent record), and passing a uuid.Nil caused a FK constraint violation.

It seems to me more logic that a uuid.Nil is stored as NULL in a database. But It's only my personal use case... so not sure at all.

from uuid.

Is there any plan for this feature, specifically the IsZero method?

I'm using upper/db (relevant code here), but I believe this would be similar in other ORMs. Having an IsZero() bool method would allow deferring a PK UUID to be generated at the database where that belongs:

...Insert(Resource{Code: "code"}) // ID is the zero-value of uuid.UUID

while currently, the application always needs to handle the UUID, because otherwise it is set as 00000000-0000-0000-0000-000000000000 in the database, failing the second time because it already exists:

...Insert(Resource{ID: uuid.New(), Code: "code"})

Please tell me if I can help with this, I can make a PR soon if it would be handled by a maintainer.

from uuid.