20210304000010_release_approval_ruleset_binding.go

package dbmigrations

import (
	"github.com/fullstaq-labs/sqedule/server/dbutils/gormigrate"
	"gorm.io/gorm"
)

func init() {
	registerDbMigration(&migration20210304000010)
}

var migration20210304000010 = gormigrate.Migration{
	ID: "20210304000010 Release approval ruleset binding",
	Migrate: func(tx *gorm.DB) error {
		type Organization struct {
			ID string `gorm:"type:citext; primaryKey; not null"`
		}

		type BaseModel struct {
			OrganizationID string       `gorm:"type:citext; primaryKey; not null"`
			Organization   Organization `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
		}

		type Release struct {
			BaseModel
			ApplicationID string `gorm:"type:citext; primaryKey; not null"`
			ID            uint64 `gorm:"primaryKey; not null"`
		}

		type ReviewableVersionBase struct {
			ID            uint64  `gorm:"primaryKey; autoIncrement; not null"`
			VersionNumber *uint32 `gorm:"type:int; check:(version_number > 0)"`
		}

		type ReviewableAdjustmentBase struct {
			AdjustmentNumber uint32 `gorm:"type:int; primaryKey; not null; check:(adjustment_number > 0)"`
		}

		type ApprovalRuleset struct {
			BaseModel
			ID string `gorm:"type:citext; primaryKey; not null"`
		}

		type ApprovalRulesetVersion struct {
			BaseModel
			ReviewableVersionBase
		}

		type ApprovalRulesetAdjustment struct {
			BaseModel
			ApprovalRulesetVersionID uint64 `gorm:"primaryKey; not null"`
			ReviewableAdjustmentBase
		}

		type ReleaseApprovalRulesetBinding struct {
			BaseModel

			ApplicationID string  `gorm:"type:citext; primaryKey; not null"`
			ReleaseID     uint64  `gorm:"primaryKey; not null"`
			Release       Release `gorm:"foreignKey:OrganizationID,ApplicationID,ReleaseID; references:OrganizationID,ApplicationID,ID; constraint:OnUpdate:CASCADE,OnDelete:RESTRICT"`

			ApprovalRulesetID string          `gorm:"type:citext; primaryKey; not null"`
			ApprovalRuleset   ApprovalRuleset `gorm:"foreignKey:OrganizationID,ApprovalRulesetID; references:OrganizationID,ID; constraint:OnUpdate:CASCADE,OnDelete:RESTRICT"`

			ApprovalRulesetVersionID uint64                 `gorm:"not null"`
			ApprovalRulesetVersion   ApprovalRulesetVersion `gorm:"foreignKey:OrganizationID,ApprovalRulesetVersionID; references:OrganizationID,ID; constraint:OnUpdate:CASCADE,OnDelete:RESTRICT"`

			ApprovalRulesetAdjustmentNumber uint32                    `gorm:"type:int; not null"`
			ApprovalRulesetAdjustment       ApprovalRulesetAdjustment `gorm:"foreignKey:OrganizationID,ApprovalRulesetVersionID,ApprovalRulesetAdjustmentNumber; references:OrganizationID,ApprovalRulesetVersionID,AdjustmentNumber; constraint:OnUpdate:CASCADE,OnDelete:RESTRICT"`

			Mode string `gorm:"type:approval_ruleset_binding_mode; not null"`
		}

		return tx.AutoMigrate(&ReleaseApprovalRulesetBinding{})
	},
	Rollback: func(tx *gorm.DB) error {
		return tx.Migrator().DropTable("release_approval_ruleset_bindings")
	},
}