database

type DB struct {
	*gorm.DB
}

type EnvStatus string

type Environment struct {
	ID             uuid.UUID `gorm:"type:uuid;default:gen_random_uuid();primaryKey"`
	CreatedAt      time.Time
	UpdatedAt      time.Time
	DeletedAt      gorm.DeletedAt `gorm:"index"`
	Owner          string
	BranchOwner    string
	Repo           string
	Branch         sql.NullString
	PullRequest    sql.NullInt32
	Author         string
	Status         EnvStatus
	DegradedReason json.RawMessage `gorm:"type:jsonb"`
	Services       []Service       `gorm:"foreignKey:EnvironmentID"`
	GHCommentID    int64           `gorm:"column:gh_comment_id"`
	BuildTool      string
}

type FindEnvironmentsOptions struct {
	IncludeDeleted bool
}

type MarketplaceEvent struct {
	ID        string `gorm:"primaryKey"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`
	Owner     string
	Action    string
}

type Service struct {
	ID            string `gorm:"primaryKey"`
	Name          string
	EnvironmentID uuid.UUID `gorm:"type:uuid;index"`
	Url           string
	Image         string
	Build         string
	BuildStatus   string
	Index         int
	PublicPort    string
	InternalPorts pq.StringArray `gorm:"type:text[]"`
	CreatedAt     time.Time
	UpdatedAt     time.Time
	DeletedAt     gorm.DeletedAt `gorm:"index"`
}