db

type APIKey struct {
	gorm.Model

	Value string
}

type Configuration struct {
	UseCases []UseCaseConfiguration
}

type Credential struct {
	gorm.Model

	Username    string
	Password    string
	AccessToken string
}

type Deployment struct {
	gorm.Model

	Canonical   string `gorm:"uniqueIndex"`
	Type        uint
	Instances   []Instance `gorm:"foreignKey:DeploymentCanonical;references:Canonical"`
	CallbackURL string
}

type Instance struct {
	gorm.Model

	DeploymentCanonical string
	URL                 string `gorm:"uniqueIndex"`
	State               uint
	AdminCredentialID   *uint
	AdminCredential     Credential
	UserCredentialID    *uint
	UserCredential      Credential
}

type PluginInformation struct {
	gorm.Model

	Name    string
	Version string
}

type Querier interface {
	// Configuration CRUD operations
	GetConfiguration(ctx context.Context) (*Configuration, error)
	GetUseCaseConfiguration(ctx context.Context, uc string) (*UseCaseConfiguration, error)
	GetServiceConfiguration(ctx context.Context, uc string, service uint) (*ServiceConfiguration, error)
	CreateUseCaseConfiguration(ctx context.Context, newUC UseCaseConfiguration) (*UseCaseConfiguration, error)
	CreateServiceConfiguration(ctx context.Context, newS ServiceConfiguration) (*ServiceConfiguration, error)
	UpdateConfiguration(ctx context.Context, updatedC Configuration) error
	UpdateUseCaseConfiguration(ctx context.Context, updatedUC UseCaseConfiguration) error
	UpdateServiceConfiguration(ctx context.Context, updatedS ServiceConfiguration) error
	DeleteUseCaseConfiguration(ctx context.Context, uc string) error
	DeleteServiceConfiguration(ctx context.Context, uc string, service uint) error

	// Deployment operations
	GetAllDeployments(ctx context.Context) ([]*Deployment, error)
	GetDeploymentByCanonical(ctx context.Context, can string) (*Deployment, error)
	CreateDeployment(ctx context.Context, newD Deployment) (*Deployment, error)
	UpdateDeployment(ctx context.Context, updatedD Deployment) error
	DeleteDeployment(ctx context.Context, can string) error

	// Instances operations
	BatchCreateInstances(ctx context.Context, instances []Instance) error
	UpdateInstance(ctx context.Context, updatedI Instance) error
}

type ServiceConfiguration struct {
	gorm.Model

	UseCase string
	Type    uint
	Version string
	Plugins []PluginInformation `gorm:"many2many:service_configuration_plugins;"`
}

type UseCaseConfiguration struct {
	gorm.Model

	Name     string                 `gorm:"uniqueIndex"`
	Services []ServiceConfiguration `gorm:"foreignKey:UseCase;references:Name"`
}