Is there a way to add database constraints from ent?

[GV14982]

I am working on an application and I was wondering if it was possible for me to add a constraint to a schema.

For instance, here is a schema:

package schema

import (
	"entgo.io/ent"
	"entgo.io/ent/schema/edge"
	"entgo.io/ent/schema/field"
	"github.com/google/uuid"
)

// User holds the schema definition for the User entity.
type User struct {
	ent.Schema
}

// Fields of the User.
func (User) Fields() []ent.Field {
	return []ent.Field{
        field.String("first_name").NotEmpty(),
        field.String("last_name").NotEmpty(),
        field.Time("Birthday"),
        field.String("email").Nillable().Optional(),
        field.String("phone").Nillable().Optional(),
        field.String("auth_id").Nillable().Optional(),
        field.UUID("manager_id", uuid.UUID{}).Nillable().Optional(),
    }
}

// Edges of the User.
func (User) Edges() []ent.Edge {
	return []ent.Edge{
        edge.To("manager", User.Type).Unique().Field("manager_id"),
    }
}

I want to verify that the record can never have both the auth_id and a manager_id set. What would be the best way to accomplish this? Thanks :)

[a8m]

Hey, @GV14982 👋🏻
You can accomplish this by either using Hooks (application side) and/or CHECK constraints.