database

type Commit struct {
	SHA          string `json:"sha"`
	Repo         string `json:"repo"`
	Organization string `json:"organization"`
	Date         int64  `json:"date"`
	Author       string `json:"author"`
	Committer    string `json:"committer"`
	Message      string `json:"message"`
	URL          string `json:"url"`
	ParentSHA    string `json:"parentsha"`
	ParentURL    string `json:"parenturl"`
	Additions    int    `json:"additions"`
	Deletions    int    `json:"deletions"`
	Rebase       bool   `json:"rebase"`
}

type Database interface {
	// NewPullRequest creates a new pull request for the github code db.
	NewPullRequest(*PullRequest) error

	// UpdatePullRequest updates an existing pull request row.
	UpdatePullRequest(*PullRequest) error

	// PullRequestByID returns the pull request that matches the provided id.
	PullRequestByID(id string) (*PullRequest, error)

	// PullRequestsByURL returns all pull request entries matching the url.
	PullRequestsByURL(url string) ([]*PullRequest, error)

	// MergedPullRequestsByUserDates returns all merged pull requests that match the
	// username and is in between the start and end dates (in Unix).
	MergedPullRequestsByUserDates(username string, start int64, end int64) ([]*PullRequest, error)

	// UpdatedPullRequestsByUserDates returns all updated pull requests that match the
	// username and is in between the start and end dates (in Unix).
	UpdatedPullRequestsByUserDates(username string, start int64, end int64) ([]*PullRequest, error)

	// NewPullRequestReview creates a new entry for a pull request review.
	NewPullRequestReview(*PullRequestReview) error

	// UpdatePullRequestReview updates an exisiting entry for a pull request
	// review.
	UpdatePullRequestReview(*PullRequestReview) error

	// ReviewByID returns a pull request review with a matching ID.
	ReviewByID(id int64) (*PullRequestReview, error)

	// ReviewsByUserDates retrusn all reviews from the given user between
	// the dates provided.
	ReviewsByUserDates(user string, start int64, end int64) ([]PullRequestReview, error)

	// NewCommit creates a new entry for a pull request commit.
	NewCommit(*Commit) error

	// CommitBySHA returns a commit that matches the SHA.
	CommitBySHA(sha string) (*Commit, error)

	// CommitsByUserDates returns all commits that match the
	// username and is in between the start and end dates (in Unix).
	CommitsByUserDates(username string, start int64, end int64) ([]Commit, error)

	// Setup creates the database instance and prepares it for usage.
	Setup() error

	// Close performs cleanup of the backend.
	Close() error
}

type PullRequest struct {
	ID           string
	Repo         string
	Organization string
	User         string
	URL          string
	Number       int
	UpdatedAt    int64
	ClosedAt     int64
	MergedAt     int64
	Merged       bool
	State        string
	Additions    int
	Deletions    int
	MergedBy     string
}

type PullRequestReview struct {
	PullRequestURL string
	ID             int64
	Author         string
	State          string
	SubmittedAt    int64
	CommitID       string
	Repo           string
	Number         int
	Additions      int
	Deletions      int
}