database

type DB struct {
	*gorm.DB
}

type Delivery struct {
	ID          string `gorm:"primaryKey"`
	ProductID   string `gorm:"index"`
	ExternalID  string
	Name        string
	PublishedAt *time.Time
	ExpiresAt   *time.Time
	CreatedAt   time.Time

	Product Product `gorm:"foreignKey:ProductID"`
	Files   []File  `gorm:"foreignKey:DeliveryID"`
}

type DownloadEntry struct {
	ID            uint   `gorm:"primaryKey"`
	FileID        string `gorm:"index"`
	Status        string
	Progress      int64
	TotalBytes    int64
	LocalPath     string
	LocalChecksum string
	ErrorMessage  string
	StartedAt     *time.Time
	CompletedAt   *time.Time
	CreatedAt     time.Time

	File File `gorm:"foreignKey:FileID"`
}

type File struct {
	ID                string `gorm:"primaryKey"`
	DeliveryID        string `gorm:"index"`
	ProductID         string `gorm:"index"`
	SourceID          string `gorm:"index"`
	ExternalID        string
	FileName          string
	FileSize          int64
	ExpectedChecksum  string
	ChecksumAlgorithm string
	DownloadURI       string
	ReleasedAt        *time.Time
	Skipped           bool `gorm:"default:false"`
	CreatedAt         time.Time
	UpdatedAt         time.Time

	Delivery        Delivery        `gorm:"foreignKey:DeliveryID"`
	DownloadEntries []DownloadEntry `gorm:"foreignKey:FileID"`
}

type Product struct {
	ID               string `gorm:"primaryKey"`
	SourceID         string `gorm:"index"`
	ExternalID       string
	Name             string
	Description      string
	AutoDownload     bool `gorm:"default:false"`
	CheckWindowStart string
	CheckWindowEnd   string
	LastCheckedAt    *time.Time
	CreatedAt        time.Time
	UpdatedAt        time.Time

	Source     Source     `gorm:"foreignKey:SourceID"`
	Deliveries []Delivery `gorm:"foreignKey:ProductID"`
}

type Setting struct {
	Key   string `gorm:"primaryKey"`
	Value string
}

type Source struct {
	ID             string `gorm:"primaryKey"`
	Name           string
	Enabled        bool `gorm:"default:false"`
	CredentialsEnc []byte
	LastSyncAt     *time.Time
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type Webhook struct {
	ID        uint `gorm:"primaryKey"`
	Name      string
	URL       string
	Events    string
	Headers   []byte
	Enabled   bool `gorm:"default:true"`
	CreatedAt time.Time
	UpdatedAt time.Time
}