models

type CategoryTag struct {
	ID           int            `json:"id"`
	Value        string         `json:"value"`
	SpecificTags []*SpecificTag `json:"specificTags,omitempty"`
}

type Compliance struct {
	ReportID            int             `json:"reportId"`
	ParagraphID         int             `json:"paragraphId,omitempty"`
	PrimaryCompliance   string          `json:"primaryCompliance"`
	OperationCompliance string          `json:"operationalCompliance"`
	SecondaryCompliance string          `json:"secondaryCompliance"`
	Pages               json.RawMessage `json:"pages"`
}

type DB struct {
	*sql.DB
}

type Datastore interface {
	AllParagraphs(lang interface{}) ([]*Paragraph, error)
	GetParagraph(lang interface{}, paragraph Paragraph) (*Paragraph, error)
	GetParagraphsBySpecificTag(lang interface{}, specificTag SpecificTag) ([]*Paragraph, error)
	GetParagraphsByCategoryTag(lang interface{}, categoryTag CategoryTag) ([]*Paragraph, error)
	AllCompliances(lang interface{}) ([]*Compliance, error)
	//GetCompliance(lang interface{}, compliance Compliance) (*Compliance, error)
	GetCompliancesByParagraph(lang interface{}, paragraph Paragraph) ([]*Compliance, error)
	GetCompliancesByReport(lang interface{}, report Report) ([]*Compliance, error)
	AllReports(lang interface{}) ([]*Report, error)
	GetReport(lang interface{}, report Report) (*Report, error)
	AllCategoryTags(lang interface{}) ([]*CategoryTag, error)
	GetCategoryTag(lang interface{}, categoryTag CategoryTag) (*CategoryTag, error)
	GetCategoryTagsByParagraph(lang interface{}, paragraph Paragraph) ([]*CategoryTag, error)
	AllSpecificTags(lang interface{}) ([]*SpecificTag, error)
	GetSpecificTag(lang interface{}, specificTag SpecificTag) (*SpecificTag, error)
	GetSpecificTagsByParagraph(lang interface{}, paragraph Paragraph) ([]*SpecificTag, error)
}

type Paragraph struct {
	UUID            string `json:"-"`
	ID              int    `json:"id"`
	ParagraphNumber int    `json:"paragraphNumber"`
	ParagraphTitle  string `json:"paragraphTitle"`
	ParagraphText   string `json:"paragraphText"`
}

type Report struct {
	UUID        string `json:"-"`
	ID          int    `json:"id"`
	ReportName  string `json:"reportName"`
	ReportTitle string `json:"reportTitle"`
	PublishDate string `json:"publishDate"`
	PeriodBegin string `json:"periodBegin"`
	PeriodEnd   string `json:"periodEnd"`
}

type SOP struct {
	UUID          string `json:"-"`
	ID            string `json:"id"`
	Name          string `json:"name"`
	Title         string `json:"title"`
	Current       bool   `json:"current"`
	EffectiveDate string `json:"effective_date"`
	ReviewDate    string `json:"review_date"`
	ReplacesDate  string `json:"replaces_date"`
}

type SpecificTag struct {
	ID         int    `json:"id"`
	Value      string `json:"value"`
	CategoryID int    `json:"categoryId,omitempty"`
}