model

type Account struct {
	gorm.Model
	UserID    uint
	UserName  string
	Name      string
	AvatarURL string
	Provider  string
}

type Catalog struct {
	gorm.Model
	Name       string `gorm:"uniqueIndex:uix_name_org"`
	Org        string `gorm:"uniqueIndex:uix_name_org"`
	Provider   string `gorm:"not null;default:github"`
	Type       string `gorm:"not null;default:null"`
	URL        string `gorm:"not null;default:null"`
	SSHURL     string
	Revision   string `gorm:"not null;default:null"`
	ContextDir string
	SHA        string
	Resources  []Resource
	Errors     []CatalogError
}

type CatalogError struct {
	gorm.Model
	Catalog   Catalog
	CatalogID uint
	Type      string
	Detail    string
}

type Category struct {
	gorm.Model
	Name      string      `gorm:"not null;unique"`
	Resources []*Resource `gorm:"many2many:resource_categories;"`
}

type Config struct {
	gorm.Model
	Checksum string
}

type JobState int

type Platform struct {
	gorm.Model
	Name             string             `gorm:"not null;unique"`
	ResourceVersions []*ResourceVersion `gorm:"many2many:version_platforms;constraint:OnDelete:CASCADE;"`
	Resource         []*Resource        `gorm:"many2many:resource_platforms;constraint:OnDelete:CASCADE;"`
}

type Resource struct {
	gorm.Model
	Name       string `gorm:"not null;default:null"`
	Kind       string `gorm:"not null;default:null"`
	Rating     float64
	Catalog    Catalog
	Categories []*Category `gorm:"many2many:resource_categories;constraint:OnDelete:CASCADE;"`
	CatalogID  uint
	Platforms  []*Platform       `gorm:"many2many:resource_platforms;constraint:OnDelete:CASCADE;"`
	Versions   []ResourceVersion `gorm:"constraint:OnDelete:CASCADE;"`
	Tags       []*Tag            `gorm:"many2many:resource_tags;constraint:OnDelete:CASCADE;"`
}

type ResourceCategory struct {
	ResourceID uint
	CategoryID uint
}

type ResourcePlatform struct {
	ResourceID uint
	PlatformID uint
}

type ResourceTag struct {
	ResourceID uint
	TagID      uint
}

type ResourceVersion struct {
	gorm.Model
	Version             string `gorm:"not null;default:null"`
	Description         string
	URL                 string `gorm:"not null;default:null"`
	DisplayName         string
	Deprecated          bool     `gorm:"default:false"`
	MinPipelinesVersion string   `gorm:"not null;default:null"`
	Resource            Resource `gorm:"constraint:OnDelete:CASCADE;"`
	ResourceID          uint
	Platforms           []*Platform `gorm:"many2many:version_platforms;constraint:OnDelete:CASCADE;"`
	ModifiedAt          time.Time
}

type Scope struct {
	gorm.Model
	Name string `gorm:"not null;unique"`
}

type SyncJob struct {
	gorm.Model
	Catalog   Catalog
	CatalogID uint
	Status    string
	UserID    uint
	User      User
}

type Tag struct {
	gorm.Model
	Name      string      `gorm:"not null;unique"`
	Resources []*Resource `gorm:"many2many:resource_tags;"`
}

type User struct {
	gorm.Model
	Email                string
	Type                 UserType
	AgentName            string
	RefreshTokenChecksum string
	Code                 string
	Scopes               []*Scope  `gorm:"many2many:user_scopes;"`
	Accounts             []Account `gorm:"constraint:OnDelete:CASCADE;"`
}

type UserBackup struct {
	gorm.Model
	AgentName            string
	GithubLogin          string
	GithubName           string
	Type                 UserType
	Scopes               []*Scope `gorm:"many2many:user_scopes;"`
	RefreshTokenChecksum string
	AvatarURL            string
	Code                 string
}

type UserResourceRating struct {
	gorm.Model
	UserID     uint
	User       User
	Resource   Resource `gorm:"constraint:OnDelete:CASCADE;"`
	ResourceID uint
	Rating     uint `gorm:"not null;default:null"`
}

type UserScope struct {
	UserID  uint
	ScopeID uint
}

type UserType string

type VersionPlatform struct {
	ResourceVersionID uint
	PlatformID        uint
}