archived

type Account struct {
	DomainEntity
	Email        string `gorm:"type:varchar(255)"`
	FullName     string `gorm:"type:varchar(255)"`
	UserName     string `gorm:"type:varchar(255)"`
	AvatarUrl    string `gorm:"type:varchar(255)"`
	Organization string `gorm:"type:varchar(255)"`
	CreatedDate  *time.Time
	Status       int
}

type Blueprint struct {
	Name       string
	Tasks      datatypes.JSON
	Enable     bool
	CronConfig string
	Model
}

type Board struct {
	DomainEntity
	Name        string `gorm:"type:varchar(255)"`
	Description string
	Url         string `gorm:"type:varchar(255)"`
	CreatedDate *time.Time
}

type BoardIssue struct {
	BoardId string `gorm:"primaryKey;type:varchar(255)"`
	IssueId string `gorm:"primaryKey;type:varchar(255)"`
	NoPKModel
}

type BoardRepo struct {
	BoardId string `gorm:"primaryKey;type:varchar(255)"`
	RepoId  string `gorm:"primaryKey;type:varchar(255)"`
}

type BoardSprint struct {
	NoPKModel
	BoardId  string `gorm:"primaryKey;type:varchar(255)"`
	SprintId string `gorm:"primaryKey;type:varchar(255)"`
}

type CicdDeploymentCommit struct {
	DomainEntity
	CicdScopeId                   string `gorm:"index;type:varchar(255)"`
	CicdDeploymentId              string `gorm:"type:varchar(255)"` // if it is converted from a cicd_pipeline_commit
	Name                          string `gorm:"type:varchar(255)"`
	Result                        string `gorm:"type:varchar(100)"`
	Status                        string `gorm:"type:varchar(100)"`
	Environment                   string `gorm:"type:varchar(255)"`
	CreatedDate                   time.Time
	StartedDate                   *time.Time
	FinishedDate                  *time.Time
	DurationSec                   *uint64
	CommitSha                     string `gorm:"primaryKey;type:varchar(255)"`
	RefName                       string `gorm:"type:varchar(255)"`
	RepoId                        string `gorm:"type:varchar(255)"`
	RepoUrl                       string `gorm:"index;not null"`
	PrevSuccessDeploymentCommitId string `gorm:"type:varchar(255)"`
}

type CicdScope struct {
	DomainEntity
	Name        string `gorm:"type:varchar(255)"`
	Description string
	Url         string `gorm:"type:varchar(255)"`
	CreatedDate *time.Time
	UpdatedDate *time.Time
}

type CollectorLatestState struct {
	CreatedAt          time.Time `json:"createdAt"`
	UpdatedAt          time.Time `json:"updatedAt"`
	RawDataParams      string    `gorm:"primaryKey;column:raw_data_params;type:varchar(255);index" json:"raw_data_params"`
	RawDataTable       string    `gorm:"primaryKey;column:raw_data_table;type:varchar(255)" json:"raw_data_table"`
	CreatedDateAfter   *time.Time
	LatestSuccessStart *time.Time
}

type Commit struct {
	NoPKModel
	Sha            string `json:"sha" gorm:"primaryKey;type:varchar(40);comment:commit hash"`
	Additions      int    `json:"additions" gorm:"comment:Added lines of code"`
	Deletions      int    `json:"deletions" gorm:"comment:Deleted lines of code"`
	DevEq          int    `json:"deveq" gorm:"comment:Merico developer equivalent from analysis engine"`
	Message        string
	AuthorName     string `gorm:"type:varchar(255)"`
	AuthorEmail    string `gorm:"type:varchar(255)"`
	AuthoredDate   time.Time
	AuthorId       string `gorm:"type:varchar(255)"`
	CommitterName  string `gorm:"type:varchar(255)"`
	CommitterEmail string `gorm:"type:varchar(255)"`
	CommittedDate  time.Time
	CommitterId    string `gorm:"index;type:varchar(255)"`
}

type CommitFile struct {
	NoPKModel
	CommitSha string `gorm:"primaryKey;type:varchar(40)"`
	FilePath  string `gorm:"primaryKey;type:varchar(255)"`
	Additions int
	Deletions int
}

type CommitParent struct {
	CommitSha       string `json:"commitSha" gorm:"primaryKey;type:varchar(40);comment:commit hash"`
	ParentCommitSha string `json:"parentCommitSha" gorm:"primaryKey;type:varchar(40);comment:parent commit hash"`
}

type CqFileMetrics struct {
	DomainEntity
	ProjectKey                          string `gorm:"index;type:varchar(255)"` //domain project key
	FileName                            string `gorm:"type:varchar(255)"`
	FilePath                            string
	FileLanguage                        string `gorm:"type:varchar(20)"`
	CodeSmells                          int
	SqaleIndex                          int
	SqaleRating                         float64
	Bugs                                int
	ReliabilityRating                   string `gorm:"type:varchar(20)"`
	Vulnerabilities                     int
	SecurityRating                      string `gorm:"type:varchar(20)"`
	SecurityHotspots                    int
	SecurityHotspotsReviewed            float64
	SecurityReviewRating                string `gorm:"type:varchar(20)"`
	Ncloc                               int
	Coverage                            float64
	UncoveredLines                      int
	LinesToCover                        int
	DuplicatedLinesDensity              float64
	DuplicatedBlocks                    int
	DuplicatedFiles                     int
	DuplicatedLines                     int
	EffortToReachMaintainabilityRatingA int
	Complexity                          int
	CognitiveComplexity                 int
	NumOfLines                          int
}

type CqIssue struct {
	DomainEntity
	Rule                     string `gorm:"type:varchar(255)"`
	Severity                 string `gorm:"type:varchar(100)"`
	Component                string `gorm:"type:varchar(255)"`
	ProjectKey               string `gorm:"index;type:varchar(100)"` //domain project key
	Line                     int
	Status                   string `gorm:"type:varchar(20)"`
	Message                  string
	Debt                     int
	Effort                   int
	CommitAuthorEmail        string `json:"author" gorm:"type:varchar(255)"`
	Assignee                 string `json:"assignee" gorm:"type:varchar(255)"`
	Hash                     string `gorm:"type:varchar(100)"`
	Tags                     string
	Type                     string `gorm:"type:varchar(100)"`
	Scope                    string `gorm:"type:varchar(255)"`
	StartLine                int    `json:"startLine"`
	EndLine                  int    `json:"endLine"`
	StartOffset              int    `json:"startOffset"`
	EndOffset                int    `json:"endOffset"`
	VulnerabilityProbability string `gorm:"type:varchar(100)"`
	SecurityCategory         string `gorm:"type:varchar(100)"`
	CreatedDate              *api.Iso8601Time
	UpdatedDate              *api.Iso8601Time
}

type CqIssueCodeBlock struct {
	DomainEntity
	IssueKey    string `json:"key" gorm:"index"`
	Component   string `gorm:"index"`
	StartLine   int
	EndLine     int
	StartOffset int
	EndOffset   int
	Msg         string
}

type CqProject struct {
	DomainEntity
	Name             string `gorm:"type:varchar(255)"`
	Qualifier        string `gorm:"type:varchar(255)"`
	Visibility       string `gorm:"type:varchar(64)"`
	LastAnalysisDate *api.Iso8601Time
	CommitSha        string `gorm:"type:varchar(128)"`
}

type DomainEntity struct {
	Id string `json:"id" gorm:"primaryKey;type:varchar(255);comment:This key is generated based on details from the original plugin"` // format: <Plugin>:<Entity>:<PK0>:<PK1>
	NoPKModel
}

type GenericModel[T string | constraints.Unsigned] struct {
	ID        T         `gorm:"primaryKey" json:"id"`
	CreatedAt time.Time `json:"createdAt"`
	UpdatedAt time.Time `json:"updatedAt"`
}

type Issue struct {
	DomainEntity
	Url                     string `gorm:"type:varchar(255)"`
	IconURL                 string `gorm:"type:varchar(255);column:icon_url"`
	IssueKey                string `gorm:"type:varchar(255)"`
	Title                   string
	Description             string
	EpicKey                 string `gorm:"type:varchar(255)"`
	Type                    string `gorm:"type:varchar(100)"`
	Status                  string `gorm:"type:varchar(100)"`
	OriginalStatus          string `gorm:"type:varchar(100)"`
	StoryPoint              int64
	ResolutionDate          *time.Time
	CreatedDate             *time.Time
	UpdatedDate             *time.Time
	LeadTimeMinutes         uint
	ParentIssueId           string `gorm:"type:varchar(255)"`
	Priority                string `gorm:"type:varchar(255)"`
	OriginalEstimateMinutes int64
	TimeSpentMinutes        int64
	TimeRemainingMinutes    int64
	CreatorId               string `gorm:"type:varchar(255)"`
	CreatorName             string `gorm:"type:varchar(255)"`
	AssigneeId              string `gorm:"type:varchar(255)"`
	AssigneeName            string `gorm:"type:varchar(255)"`
	Severity                string `gorm:"type:varchar(255)"`
	Component               string `gorm:"type:varchar(255)"`
}

type IssueChangelogs struct {
	DomainEntity

	// collected fields
	IssueId           string `gorm:"index;type:varchar(255)"`
	AuthorId          string `gorm:"type:varchar(255)"`
	AuthorName        string `gorm:"type:varchar(255)"`
	FieldId           string `gorm:"type:varchar(255)"`
	FieldName         string `gorm:"type:varchar(255)"`
	OriginalFromValue string
	OriginalToValue   string
	FromValue         string
	ToValue           string
	CreatedDate       time.Time
}

type IssueComment struct {
	DomainEntity
	IssueId     string `gorm:"index"`
	Body        string
	UserId      string `gorm:"type:varchar(255)"`
	CreatedDate time.Time
}

type IssueCommit struct {
	NoPKModel
	IssueId   string `gorm:"primaryKey;type:varchar(255)"`
	CommitSha string `gorm:"primaryKey;type:varchar(255)"`
}

type IssueLabel struct {
	IssueId   string `json:"id" gorm:"primaryKey;type:varchar(255);comment:This key is generated based on details from the original plugin"` // format: <Plugin>:<Entity>:<PK0>:<PK1>
	LabelName string `gorm:"primaryKey;type:varchar(255)"`
	NoPKModel
}

type IssueRepoCommit struct {
	NoPKModel
	IssueId   string `gorm:"primaryKey;type:varchar(255)"`
	RepoUrl   string `gorm:"primaryKey;type:varchar(255)"`
	CommitSha string `gorm:"primaryKey;type:varchar(255)"`
}

type IssueWorklog struct {
	DomainEntity
	AuthorId         string `gorm:"type:varchar(255)"`
	Comment          string
	TimeSpentMinutes int
	LoggedDate       *time.Time
	StartedDate      *time.Time
	IssueId          string `gorm:"index;type:varchar(255)"`
}

type Model struct {
	ID        uint64    `gorm:"primaryKey" json:"id"`
	CreatedAt time.Time `json:"createdAt"`
	UpdatedAt time.Time `json:"updatedAt"`
}

type NoPKModel struct {
	CreatedAt time.Time `json:"createdAt"`
	UpdatedAt time.Time `json:"updatedAt"`
	RawDataOrigin
}

type Note struct {
	DomainEntity
	PrId        string `gorm:"index;comment:References the pull request for this note;type:varchar(100)"`
	Type        string `gorm:"type:varchar(100)"`
	Author      string `gorm:"type:varchar(255)"`
	Body        string
	Resolvable  bool `gorm:"comment:Is or is not a review comment"`
	IsSystem    bool `gorm:"comment:Is or is not auto-generated vs. human generated"`
	CreatedDate time.Time
}

type Notification struct {
	Model
	Type         NotificationType
	Endpoint     string
	Nonce        string
	ResponseCode int
	Response     string
	Data         string
}

type NotificationType string

type Pipeline struct {
	Model
	Name        string `json:"name" gorm:"index"`
	BlueprintId uint64
	Tasks       datatypes.JSON
	TotalTasks  int
	// Deprecated
	FinishedTasks int
	BeganAt       *time.Time
	FinishedAt    *time.Time `gorm:"index"`
	Status        string
	Message       string
	SpentSeconds  int
	Step          int
}

type ProjectIssueMetric struct {
	DomainEntity
	ProjectName  string `gorm:"primaryKey;type:varchar(100)"`
	DeploymentId string
}

type ProjectMapping struct {
	ProjectName string `gorm:"primaryKey;type:varchar(255)"`
	Table       string `gorm:"primaryKey;type:varchar(255)"`
	RowId       string `gorm:"primaryKey;type:varchar(255)"`
	NoPKModel
}

type ProjectPrMetric struct {
	DomainEntity
	ProjectName    string `gorm:"primaryKey;type:varchar(100)"`
	FirstCommitSha string
	PrCodingTime   *int64
	FirstReviewId  string
	PrPickupTime   *int64
	PrReviewTime   *int64
	DeploymentId   string
	PrDeployTime   *int64
	PrCycleTime    *int64
}

type PullRequest struct {
	DomainEntity
	BaseRepoId  string `gorm:"index"`
	HeadRepoId  string `gorm:"index"`
	Status      string `gorm:"type:varchar(100);comment:open/closed or other"`
	Title       string
	Description string
	Url         string `gorm:"type:varchar(255)"`
	AuthorName  string `gorm:"type:varchar(100)"`
	//User		   domainUser.User `gorm:"foreignKey:AuthorId"`
	AuthorId       string `gorm:"type:varchar(100)"`
	ParentPrId     string `gorm:"index;type:varchar(100)"`
	PullRequestKey int
	CreatedDate    time.Time
	MergedDate     *time.Time
	ClosedDate     *time.Time
	Type           string `gorm:"type:varchar(100)"`
	Component      string `gorm:"type:varchar(100)"`
	MergeCommitSha string `gorm:"type:varchar(40)"`
	HeadRef        string `gorm:"type:varchar(255)"`
	BaseRef        string `gorm:"type:varchar(255)"`
	BaseCommitSha  string `gorm:"type:varchar(40)"`
	HeadCommitSha  string `gorm:"type:varchar(40)"`
}

type PullRequestComment struct {
	DomainEntity
	PullRequestId string `gorm:"index"`
	Body          string
	UserId        string `gorm:"type:varchar(255)"`
	CreatedDate   time.Time
	CommitSha     string `gorm:"type:varchar(255)"`
	Position      int
	Type          string `gorm:"type:varchar(255)"`
	ReviewId      string `gorm:"type:varchar(255)"`
	Status        string `gorm:"type:varchar(255)"`
}

type PullRequestCommit struct {
	CommitSha     string `gorm:"primaryKey;type:varchar(40)"`
	PullRequestId string `json:"id" gorm:"primaryKey;type:varchar(255);comment:This key is generated based on details from the original plugin"` // format: <Plugin>:<Entity>:<PK0>:<PK1>
	NoPKModel
}

type PullRequestIssue struct {
	PullRequestId     string `json:"id" gorm:"primaryKey;type:varchar(255);comment:This key is generated based on details from the original plugin"` // format: <Plugin>:<Entity>:<PK0>:<PK1>
	IssueId           string `gorm:"primaryKey;type:varchar(255)"`
	PullRequestNumber int
	IssueNumber       int
	NoPKModel
}

type PullRequestLabel struct {
	PullRequestId string `json:"id" gorm:"primaryKey;type:varchar(255);comment:This key is generated based on details from the original plugin"` // format: <Plugin>:<Entity>:<PK0>:<PK1>
	LabelName     string `gorm:"primaryKey;type:varchar(255)"`
	NoPKModel
}

type RawDataOrigin struct {
	// can be used for flushing outdated records from table
	RawDataParams string `gorm:"column:_raw_data_params;type:varchar(255);index" json:"_raw_data_params"`
	RawDataTable  string `gorm:"column:_raw_data_table;type:varchar(255)" json:"_raw_data_table"`
	// can be used for debugging
	RawDataId uint64 `gorm:"column:_raw_data_id" json:"_raw_data_id"`
	// we can store record index into this field, which is helpful for debugging
	RawDataRemark string `gorm:"column:_raw_data_remark" json:"_raw_data_remark"`
}

type Ref struct {
	DomainEntity
	RepoId      string `gorm:"type:varchar(255)"`
	Name        string `gorm:"type:varchar(255)"`
	CommitSha   string `gorm:"type:varchar(40)"`
	IsDefault   bool
	RefType     string `gorm:"type:varchar(255)"`
	CreatedDate *time.Time
}

type RefsCommitsDiff struct {
	NewRefId        string `gorm:"primaryKey;type:varchar(255)"`
	OldRefId        string `gorm:"primaryKey;type:varchar(255)"`
	CommitSha       string `gorm:"primaryKey;type:varchar(40)"`
	NewRefCommitSha string `gorm:"type:varchar(40)"`
	OldRefCommitSha string `gorm:"type:varchar(40)"`
	SortingIndex    int
}

type RefsIssuesDiffs struct {
	NewRefId        string `gorm:"primaryKey;type:varchar(255)"`
	OldRefId        string `gorm:"primaryKey;type:varchar(255)"`
	NewRefCommitSha string `gorm:"type:varchar(40)"`
	OldRefCommitSha string `gorm:"type:varchar(40)"`
	IssueNumber     string `gorm:"type:varchar(255)"`
	IssueId         string `gorm:"primaryKey;type:varchar(255)"`
	NoPKModel
}

type RefsPrCherrypick struct {
	RepoName               string `gorm:"type:varchar(255)"`
	ParentPrKey            int
	CherrypickBaseBranches string `gorm:"type:varchar(255)"`
	CherrypickPrKeys       string `gorm:"type:varchar(255)"`
	ParentPrUrl            string `gorm:"type:varchar(255)"`
	ParentPrId             string `` // format: <Plugin>:<Entity>:<PK0>:<PK1>
	/* 127-byte string literal not displayed */
	NoPKModel
}

type Repo struct {
	DomainEntity
	Name        string     `json:"name"`
	Url         string     `json:"url"`
	Description string     `json:"description"`
	OwnerId     string     `json:"ownerId" gorm:"type:varchar(255)"`
	Language    string     `json:"language" gorm:"type:varchar(255)"`
	ForkedFrom  string     `json:"forkedFrom"`
	CreatedDate time.Time  `json:"createdDate"`
	UpdatedDate *time.Time `json:"updatedDate"`
	Deleted     bool       `json:"deleted"`
}

type RepoCommit struct {
	RepoId    string `json:"repoId" gorm:"primaryKey;type:varchar(255)"`
	CommitSha string `json:"commitSha" gorm:"primaryKey;type:varchar(40)"`
	NoPKModel
}

type RepoLanguage struct {
	RepoId   string `json:"repoId" gorm:"index;type:varchar(255)"`
	Language string `json:"language" gorm:"type:varchar(255)"`
	Bytes    int
}

type ScopeConfig struct {
	Model
	Entities []string `gorm:"type:json;serializer:json" json:"entities" mapstructure:"entities"`
}

type Sprint struct {
	DomainEntity
	Name            string `gorm:"type:varchar(255)"`
	Url             string `gorm:"type:varchar(255)"`
	Status          string `gorm:"type:varchar(100)"`
	StartedDate     *time.Time
	EndedDate       *time.Time
	CompletedDate   *time.Time
	OriginalBoardID string `gorm:"type:varchar(255)"`
}

type SprintIssue struct {
	NoPKModel
	SprintId string `gorm:"primaryKey;type:varchar(255)"`
	IssueId  string `gorm:"primaryKey;type:varchar(255)"`
}

type Task struct {
	Model
	Plugin        string `gorm:"index"`
	Options       datatypes.JSON
	Status        string
	Message       string
	Progress      float32
	FailedSubTask string
	PipelineId    uint64 `gorm:"index"`
	PipelineRow   int
	PipelineCol   int
	BeganAt       *time.Time
	FinishedAt    *time.Time `gorm:"index"`
	SpentSeconds  int
}

type Team struct {
	DomainEntity
	Name         string `gorm:"type:varchar(255)"`
	Alias        string `gorm:"type:varchar(255)"`
	ParentId     string `gorm:"type:varchar(255)"`
	SortingIndex int
}

type TeamUser struct {
	TeamId string `gorm:"primaryKey;type:varchar(255)"`
	UserId string `gorm:"primaryKey;type:varchar(255)"`
	NoPKModel
}

type User struct {
	DomainEntity
	Email string `gorm:"type:varchar(255)"`
	Name  string `gorm:"type:varchar(255)"`
}

type UserAccount struct {
	UserId    string `gorm:"type:varchar(255)"`
	AccountId string `gorm:"primaryKey;type:varchar(255)"`
	NoPKModel
}