models

type JiraBoard struct {
	models.NoPKModel
	SourceId  uint64 `gorm:"primaryKey"`
	BoardId   uint64 `gorm:"primaryKey"`
	ProjectId uint
	Name      string
	Self      string
	Type      string
}

type JiraBoardIssue struct {
	SourceId uint64 `gorm:"primaryKey"`
	BoardId  uint64 `gorm:"primaryKey"`
	IssueId  uint64 `gorm:"primaryKey"`
}

type JiraBoardSprint struct {
	SourceId uint64 `gorm:"primaryKey"`
	BoardId  uint64 `gorm:"primaryKey"`
	SprintId uint64 `gorm:"primaryKey"`
}

type JiraChangelog struct {
	models.NoPKModel

	// collected fields
	SourceId          uint64 `gorm:"primaryKey"`
	ChangelogId       uint64 `gorm:"primarykey"`
	IssueId           uint64 `gorm:"index"`
	AuthorAccountId   string
	AuthorDisplayName string
	AuthorActive      bool
	Created           time.Time
}

type JiraChangelogItem struct {
	models.NoPKModel

	// collected fields
	SourceId    uint64 `gorm:"primaryKey"`
	ChangelogId uint64 `gorm:"primaryKey"`
	Field       string `gorm:"primaryKey"`
	FieldType   string
	FieldId     string
	From        string
	FromString  string
	To          string
	ToString    string
}

type JiraIssue struct {
	models.NoPKModel

	// collected fields
	SourceId                 uint64 `gorm:"primaryKey"`
	IssueId                  uint64 `gorm:"primarykey"`
	ProjectId                uint64
	Self                     string
	Key                      string
	Summary                  string
	Type                     string
	EpicKey                  string
	StatusName               string
	StatusKey                string
	StatusCategory           string
	StoryPoint               float64
	OriginalEstimateMinutes  int64 // user input?
	AggregateEstimateMinutes int64 // sum up of all subtasks?
	RemainingEstimateMinutes int64 // could it be negative value?
	CreatorAccountId         string
	CreatorAccountType       string
	CreatorDisplayName       string
	AssigneeAccountId        string // latest assignee
	AssigneeAccountType      string
	AssigneeDisplayName      string
	PriorityId               uint64
	PriorityName             string
	ParentId                 uint64
	ParentKey                string
	SprintId                 uint64 // latest sprint, issue might cross multiple sprints, would be addressed by #514
	SprintName               string
	ResolutionDate           sql.NullTime
	Created                  time.Time
	Updated                  time.Time

	// enriched fields
	// RequirementAnalsyisLeadTime uint
	// DesignLeadTime              uint
	// DevelopmentLeadTime         uint
	// TestLeadTime                uint
	// DeliveryLeadTime            uint
	SpentMinutes    int64
	LeadTimeMinutes uint
	StdStoryPoint   uint
	StdType         string
	StdStatus       string

	// internal status tracking
	ChangelogUpdated sql.NullTime
}

type JiraIssueStatusMapping struct {
	SourceID       uint64 `gorm:"primaryKey" json:"jiraSourceId" validate:"required"`
	UserType       string `gorm:"type:varchar(50);primaryKey" json:"userType" validate:"required"`
	UserStatus     string `gorm:"type:varchar(50);primaryKey" json:"userStatus" validate:"required"`
	StandardStatus string `gorm:"type:varchar(50)" json:"standardStatus" validate:"required"`
}

type JiraIssueTypeMapping struct {
	SourceID     uint64 `gorm:"primaryKey" json:"jiraSourceId" validate:"required"`
	UserType     string `gorm:"type:varchar(50);primaryKey" json:"userType" validate:"required"`
	StandardType string `gorm:"type:varchar(50)" json:"standardType" validate:"required"`
}

type JiraProject struct {
	models.NoPKModel

	// collected fields
	SourceId uint64 `gorm:"primarykey"`
	Id       string `gorm:"primaryKey"`
	Key      string
	Name     string
}

type JiraSource struct {
	models.Model
	Name                  string  `gorm:"type:varchar(100);uniqueIndex" json:"name" validate:"required"`
	Endpoint              string  `json:"endpoint" validate:"required"`
	BasicAuthEncoded      string  `json:"basicAuthEncoded" validate:"required"`
	EpicKeyField          string  `gorm:"type:varchar(50);" json:"epicKeyField"`
	StoryPointField       string  `gorm:"type:varchar(50);" json:"storyPointField"`
	StoryPointCoefficient float64 `json:"storyPointCoefficient"`
}

type JiraSourceDetail struct {
	JiraSource
	TypeMappings map[string]map[string]interface{} `json:"typeMappings"`
}

type JiraSprint struct {
	models.NoPKModel
	SourceId      uint64 `gorm:"primaryKey"`
	SprintId      uint64 `gorm:"primaryKey"`
	Self          string
	State         string
	Name          string
	StartDate     *time.Time
	EndDate       *time.Time
	CompleteDate  *time.Time
	OriginBoardID uint64
}

type JiraSprintIssue struct {
	SourceId uint64 `gorm:"primaryKey"`
	SprintId uint64 `gorm:"primaryKey"`
	IssueId  uint64 `gorm:"primaryKey"`
}

type JiraUser struct {
	models.NoPKModel

	// collected fields
	SourceId    uint64 `gorm:"primarykey"`
	AccountId   string `gorm:"primaryKey"`
	AccountType string
	Name        string
	Email       string
	AvatarUrl   string
	Timezone    string
}