db

type DB interface {
	CreateTFProvider(e *TFProvider) (uuid.UUID, error)
	CreateTFResourceType(e *TFResourceType) (uuid.UUID, error)
	CreateTFResourceAttribute(e *TFResourceAttribute) (uuid.UUID, error)
	CreateTFResourceAttributesMapping(e *TFResourceAttributesMapping) (uuid.UUID, error)
	CreateTFModule(e *TFModule) (uuid.UUID, error)
	CreateTFModuleAttribute(e *TFModuleAttribute) (uuid.UUID, error)
	CreateTaxonomy(e *Taxonomy) (uuid.UUID, error)
	CreateDependencyInterface(e *Dependency) (uuid.UUID, error)
	CreateDependencyAttribute(e *DependencyAttribute) (uuid.UUID, error)
	CreatePlatform(p *Platform) (uuid.UUID, error)
	CreatePlatformComponents(p *PlatformComponent) (uuid.UUID, error)

	// GetOrCreateTFProvider finds and updates `e` and if the record doesn't exists, it creates a new record `e` and updates ID.
	GetOrCreateTFProvider(e *TFProvider) (id uuid.UUID, isNew bool, err error)

	GetTFProvider(e *TFProvider, where *TFProvider) error
	GetTFResourceType(e *TFResourceType, where *TFResourceType) error
	GetTFResourceAttribute(e *TFResourceAttribute, where *TFResourceAttribute) error

	// QueryTFModules list terraform modules
	QueryTFModules(filterOps ...FilterOption) (result TFModules, err error)
	// QueryTFModuleAttributes list terraform module attributes
	QueryTFModuleAttributes(filterOps ...FilterOption) (result TFModuleAttributes, err error)

	QueryDependencies(filterOps ...FilterOption) (result Dependencies, err error)
	QueryTaxonomies(filterOps ...FilterOption) (result Taxonomies, err error)
	QueryPlatforms(filterOps ...FilterOption) (result Platforms, err error)
	QueryPlatformComponents(filterOps ...FilterOption) (result PlatformComponents, err error)

	Fetchdeps() []DependencyResult
	ExecuteSQLStatement(statement string) error

	CreateRelease(e *FarmRelease) (uuid.UUID, error)
	FindReleaseByRepo(e *FarmRelease, repo string) error
}

type Dependencies []Dependency

type Dependency struct {
	Model

	TaxonomyID  *uuid.UUID `gorm:"default:null"` // Given taxonomy's uncertain presence in YAML, setting TaxonomyID default as NULL accommodates potential absence of taxonomy data.
	InterfaceID string     `gorm:"unique"`
	Title       string     `gorm:"default:null"`
	Description string     `gorm:"default:null"`
	ExtendsID   string     `gorm:"-"` //This is yet to be finalized

	Attributes DependencyAttributes `gorm:"foreignKey:DependencyID"`
	Taxonomy   *Taxonomy            `gorm:"foreignKey:TaxonomyID"`
}

type DependencyAttribute struct {
	Model

	DependencyID uuid.UUID        `gorm:"uniqueIndex:dependency_attribute_unique"`
	Name         string           `gorm:"uniqueIndex:dependency_attribute_unique"`
	Schema       *jsonschema.Node `gorm:"type:jsonb"`
	Computed     bool             `gorm:"uniqueIndex:dependency_attribute_unique"` // true means output, false means input

	Dependency *Dependency `gorm:"foreignKey:DependencyID"`
}

type DependencyAttributeMappings struct {
	Model

	DependencyAttributeID uuid.UUID `gorm:"uniqueIndex:dependency_attribute_mapping_unique"`
	ResourceAttributeID   uuid.UUID `gorm:"uniqueIndex:dependency_attribute_mapping_unique"`
}

type DependencyAttributes []DependencyAttribute

type DependencyResult struct {
	DependencyID uuid.UUID
	InterfaceID  string
	Name         string
	Schema       *jsonschema.Node
	Computed     bool
}

type FarmRelease struct {
	Model
	Tag  string
	Repo string `gorm:"unique"`
}

type FilterOption func(*gorm.DB) *gorm.DB

type Model struct {
	ID        uuid.UUID `gorm:"type:uuid;primarykey"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`
}

type Platform struct {
	Model

	Title         string
	Description   string
	RepoURL       string              `gorm:"uniqueIndex:platform_ref_unique"`
	RepoDirectory string              `gorm:"uniqueIndex:platform_ref_unique"`
	CommitSHA     string              `gorm:"uniqueIndex:platform_ref_unique"`
	RefLabel      string              // can be tag/branch/commit that user wrote in the yaml. example v0.1 or main.
	LabelType     terrpb.GitLabelEnum // 1=branch, 2=tag, 3=commit

	Components []PlatformComponent `gorm:"foreignKey:PlatformID"`
}

type PlatformComponent struct {
	Model

	PlatformID   uuid.UUID `gorm:"uniqueIndex:platform_components_unique"`
	DependencyID uuid.UUID `gorm:"uniqueIndex:platform_components_unique"`

	Platform   Platform   `gorm:"foreignKey:PlatformID"`
	Dependency Dependency `gorm:"foreignKey:DependencyID"`
}

type PlatformComponents []PlatformComponent

type Platforms []Platform

type TFModule struct {
	Model

	ModuleName  string
	Source      string  `gorm:"uniqueIndex:module_unique"`
	Version     Version `gorm:"uniqueIndex:module_unique"`
	Namespace   string
	Description string
	TaxonomyID  *uuid.UUID `gorm:"default:null"`

	Taxonomy   *Taxonomy           `gorm:"foreignKey:TaxonomyID"`
	Attributes []TFModuleAttribute `gorm:"foreignKey:ModuleID"` // Attributes of the module
}

type TFModuleAttribute struct {
	Model

	ModuleID                       uuid.UUID `gorm:"uniqueIndex:module_attribute_unique"`
	ModuleAttributeName            string    `gorm:"uniqueIndex:module_attribute_unique"`
	Description                    string
	RelatedResourceTypeAttributeID uuid.UUID
	Optional                       bool
	Computed                       bool

	Module            *TFModule            `gorm:"foreignKey:ModuleID"`
	ResourceAttribute *TFResourceAttribute `gorm:"foreignKey:RelatedResourceTypeAttributeID"` // Resource attribute with relates to this module attribute
}

type TFModuleAttributes []TFModuleAttribute

type TFModules []TFModule

type TFProvider struct {
	Model

	Name string `gorm:"unique"`
}

type TFResourceAttribute struct {
	Model

	ResourceTypeID uuid.UUID `gorm:"uniqueIndex:resource_attribute_unique"`
	ProviderID     uuid.UUID `gorm:"uniqueIndex:resource_attribute_unique"`
	AttributePath  string    `gorm:"uniqueIndex:resource_attribute_unique"`
	DataType       string
	Description    string
	Optional       bool
	Computed       bool

	ResourceType       TFResourceType                `gorm:"foreignKey:ResourceTypeID"`
	Provider           TFProvider                    `gorm:"foreignKey:ProviderID"`
	RelatedModuleAttrs []TFModuleAttribute           `gorm:"foreignKey:RelatedResourceTypeAttributeID"` // Module attributes that relates to this resource attribute
	OutputMappings     []TFResourceAttributesMapping `gorm:"foreignKey:InputAttributeID"`               // Mappings with another resources's output attribute
	InputMappings      []TFResourceAttributesMapping `gorm:"foreignKey:OutputAttributeID"`              // Mappings with another resources's input attribute
}

type TFResourceAttributesMapping struct {
	Model

	InputAttributeID  uuid.UUID `gorm:"uniqueIndex:resource_attribute_mapping_unique"`
	OutputAttributeID uuid.UUID `gorm:"uniqueIndex:resource_attribute_mapping_unique"`

	InputAttribute  TFResourceAttribute `gorm:"foreignKey:InputAttributeID"`  // Resource input-attribute object
	OutputAttribute TFResourceAttribute `gorm:"foreignKey:OutputAttributeID"` // Resource attribute object that provides the input-attribute
}

type TFResourceType struct {
	Model

	ProviderID   uuid.UUID  `gorm:"uniqueIndex:resource_type_unique"`
	ResourceType string     `gorm:"uniqueIndex:resource_type_unique"`
	TaxonomyID   *uuid.UUID `gorm:"default:null"`

	Provider TFProvider `gorm:"foreignKey:ProviderID"`
	Taxonomy *Taxonomy  `gorm:"foreignKey:TaxonomyID"`
}

type Taxonomies []Taxonomy

type Taxonomy struct {
	Model

	Level1 string `gorm:"uniqueIndex:taxonomy_unique"`
	Level2 string `gorm:"uniqueIndex:taxonomy_unique"`
	Level3 string `gorm:"uniqueIndex:taxonomy_unique"`
	Level4 string `gorm:"uniqueIndex:taxonomy_unique"`
	Level5 string `gorm:"uniqueIndex:taxonomy_unique"`
	Level6 string `gorm:"uniqueIndex:taxonomy_unique"`
	Level7 string `gorm:"uniqueIndex:taxonomy_unique"`
}

type Version string