models

type Asset struct {
	ID      uuid.UUID `gorm:"column:id;primaryKey;" json:"id" binding:"required"`
	Service string    `gorm:"column:service;not null" json:"service" binding:"required"`

	Digest string `gorm:"column:digest;index,not null;uniqueIndex" json:"digest" binding:"required"`
	Size   int64  `gorm:"column:size;not null" json:"size" binding:"required"`

	UploadUUID  string `gorm:"column:upload_uuid;uniqueIndex;not null" json:"upload_uuid" binding:"required"`
	UploadRange string `gorm:"column:upload_range;not null" json:"upload_range" binding:"required"`

	CreatedAt time.Time `gorm:"column:created_at" json:"created_at"`
	UpdatedAt time.Time `gorm:"column:updated_at" json:"updated_at"`
}

type Package[MetaType any] struct {
	ID      uuid.UUID `gorm:"column:id;primaryKey;" json:"id" binding:"required"`
	Name    string    `gorm:"column:name;uniqueIndex:name_auth_service;not null" json:"name" binding:"required"`
	Service string    `gorm:"column:service;uniqueIndex:name_auth_service;not null" json:"service" binding:"required"`

	// AuthId is used to identify the owner of the package tied to the authentication process
	AuthId    string `gorm:"column:auth_id;not null" json:"auth_id" binding:"required"`
	Namespace string `gorm:"column:namespace;uniqueIndex:name_auth_service;not null" json:"namespace" binding:"required"`
	IsPublic  bool   `gorm:"column:is_public;not null;default:false" json:"is_public" binding:"required"`

	LatestVersion string                     `gorm:"column:latest_version" json:"latest_version"`
	Versions      []PackageVersion[MetaType] `gorm:"foreignKey:PackageId;references:ID;constraint:OnDelete:CASCADE;" json:"versions"`
	CreatedAt     time.Time                  `gorm:"column:created_at" json:"created_at"`
	UpdatedAt     time.Time                  `gorm:"column:updated_at" json:"updated_at"`
}

type PackageVersion[MetaType any] struct {
	ID        uuid.UUID `gorm:"column:id;primaryKey;" json:"id" binding:"required"`
	Service   string    `gorm:"column:service;not null" json:"service" binding:"required"`
	AuthId    string    `gorm:"column:auth_id;index;not null" json:"auth_id" binding:"required"`
	Namespace string    `gorm:"column:namespace;index;not null" json:"namespace" binding:"required"`

	Digest string `gorm:"column:digest;index" json:"digest"`
	Size   int64  `gorm:"column:size;not null" json:"size" binding:"required"`

	PackageId uuid.UUID `gorm:"column:package_id;uniqueIndex:pkg_id_version;uniqueIndex:pkg_id_tag;" json:"package_id" binding:"required"`

	Version string `gorm:"column:version;not null;uniqueIndex:pkg_id_version" json:"version" binding:"required"`
	Tag     string `gorm:"column:tag;uniqueIndex:pkg_id_tag" json:"tag"`

	Metadata datatypes.JSONType[MetaType] `gorm:"column:metadata" json:"metadata"`

	CreatedAt time.Time `gorm:"column:created_at" json:"created_at"`
	UpdatedAt time.Time `gorm:"column:updated_at" json:"updated_at"`

	AssetIds string `gorm:"column:asset_ids" json:"asset_ids"`
}