models

type BaseModel struct {
	DB                    *sqlx.DB
	SupportsJSONFunctions bool
}

type DBGetFilter struct {
	// ID specifies a unique job identifier to filter by.
	// If provided, the query typically returns a single match.
	ID string

	// Keyword specifies a search term for partial matching.
	// This is usually applied against the job name or ID (e.g., "backup" matches "db-backup-01").
	Keyword string

	// Limit restricts the maximum number of records returned by the query.
	// A value of 0 typically implies no limit or uses the system default.
	Limit int

	// SortDesc determines the sorting order of the results based on the timestamp.
	// If true, results are ordered descending (newest first). If false, they are ordered ascending (oldest first).
	SortDesc bool

	// Offset specifies the number of records to skip before starting to return results.
	// Used in conjunction with Limit for pagination.
	Offset int
}

type JobFilter struct {
	// ActiveOnly filters results to include only active jobs.
	// Cannot be combined with FinishOnly.
	ActiveOnly bool

	// FinishOnly filters results to include only finished jobs whether job is success or failed.
	// Cannot be combined with ActiveOnly.
	FinishOnly bool

	// MetadataFilter allows filtering jobs based on their metadata.
	// Keys are metadata field names, and values are the desired values.
	MetadataFilter map[string]string

	// GeneralKeywordSearch applies to JobFilter.ID OR JobFilter.Keyword
	GeneralKeywordSearch string

	// HideCommand prevents the command from being exposed in the job response.
	HideCommand bool `json:"hide_command,omitempty"`

	DBGetFilter
}

type JobModel struct {
	ID        string    `db:"id"`
	JobName   string    `db:"job_name"`
	Command   string    `db:"command"` // JSON string representation of []string
	Status    int       `db:"status"`  // Integer cast from JobStatusEnum
	ExitCode  int       `db:"exit_code"`
	Metadata  string    `db:"metadata"` // JSON string representation of PayloadRegularMetadata
	PID       int       `db:"pid"`
	CreatedAt time.Time `db:"created_at"` // Generated automatically (current_timestamp)
	UpdatedAt time.Time `db:"updated_at"` // Generated automatically (TRIGGER jobs_update_updated_at)
	BaseModel
}