google/uuid

`IsZero()` and `ToNullUUID` Helper Functions

falsaffa opened this issue · 3 comments

Summary

Suggest adding a couple helper functions.

IsZero

IsZero() allows uuid to support the Nullable interface and interface better with existing code. It can be as simple as:

func (u UUID) IsZero() bool {
    return u == Nil
}

This is particularly important when interfacing UUID with the existing ORM libraries. Heck, IsZero() is even used by the reflect package too!

ToNullUUID

Another helper function that is used by this null package (and is quite convenient) are to-null values from the original primitives. So in the case of uuid.UUID and uuuid.NullUUID, adding the following helper function.

func ToNullUUID[T uuid.UUID | uuid.NullUUID](id T) uuid.NullUUID {
	if v, ok := any(id).(uuid.UUID); ok {
		if v == uuid.Nil {
			return uuid.NullUUID{}
		}

		return uuid.NullUUID{v, true}
	} else if v, ok := any(id).(uuid.NullUUID); ok {
		return v
	} else {
		panic("this should not happen")
	}
}

That way we don't have to write the following code:

id := uuid.New()

// If you know that id is not nil
nullVal := uuid.NullUUID{id, true}

// if you don't know whether or not id is nil.
nullVal := uuid.NullUUID{id, id == uuid.Nil}

// And if you want to use named struct fields
nullVal := uuid.NullUUID{UUID: id, Valid: id == uuid.Nil}

// What it looks like with the helper function
nullVal := uuid.ToNullUUID(id)

This is particularly useful when combined with existing libraries such as ORMs. Casting to uuid.NullUUID is common.

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.