models

Documentation

Index

• type Activity
• type DB
  • func InitDB(dbPath string) (*DB, error)
  • func (db *DB) CheckDuplicateRequest(mediaType string, tmdbID, tvdbID *int) (bool, error)
  • func (db *DB) CreateRequest(req *Request) (int64, error)
  • func (db *DB) GetActivity(limit int) ([]Activity, error)
  • func (db *DB) GetAllSettings() (map[string]string, error)
  • func (db *DB) GetApprovedRequests() ([]Request, error)
  • func (db *DB) GetRequest(id int) (*Request, error)
  • func (db *DB) GetRequestedIDs(mediaType string) (map[int]bool, error)
  • func (db *DB) GetRequests(status, mediaType string) ([]Request, error)
  • func (db *DB) GetSetting(key string) string
  • func (db *DB) GetStats() (map[string]int, error)
  • func (db *DB) LogActivity(action string, details map[string]interface{}) error
  • func (db *DB) SetSetting(key, value string) error
  • func (db *DB) SetSettingIfNotExists(key, value string) error
  • func (db *DB) UpdateRequestArrID(id, arrID int) error
  • func (db *DB) UpdateRequestStatus(id int, status, adminNotes string) error
• type Request

Types

type Activity

type Activity struct {
	ID        int       `json:"id"`
	Action    string    `json:"action"`
	Details   *string   `json:"details"`
	CreatedAt time.Time `json:"created_at"`
}

type DB

type DB struct {
	*sql.DB
	// contains filtered or unexported fields
}

func InitDB

func InitDB(dbPath string) (*DB, error)

func (*DB) CheckDuplicateRequest

func (db *DB) CheckDuplicateRequest(mediaType string, tmdbID, tvdbID *int) (bool, error)

func (*DB) CreateRequest

func (db *DB) CreateRequest(req *Request) (int64, error)

Request functions

func (*DB) GetActivity

func (db *DB) GetActivity(limit int) ([]Activity, error)

func (*DB) GetAllSettings

func (db *DB) GetAllSettings() (map[string]string, error)

func (*DB) GetApprovedRequests

func (db *DB) GetApprovedRequests() ([]Request, error)

func (*DB) GetRequest

func (db *DB) GetRequest(id int) (*Request, error)

func (*DB) GetRequestedIDs

func (db *DB) GetRequestedIDs(mediaType string) (map[int]bool, error)

func (*DB) GetRequests

func (db *DB) GetRequests(status, mediaType string) ([]Request, error)

func (*DB) GetSetting

func (db *DB) GetSetting(key string) string

Settings functions

func (*DB) GetStats

func (db *DB) GetStats() (map[string]int, error)

Stats

func (*DB) LogActivity

func (db *DB) LogActivity(action string, details map[string]interface{}) error

Activity log

func (*DB) SetSetting

func (db *DB) SetSetting(key, value string) error

func (*DB) SetSettingIfNotExists

func (db *DB) SetSettingIfNotExists(key, value string) error

func (*DB) UpdateRequestArrID

func (db *DB) UpdateRequestArrID(id, arrID int) error

func (*DB) UpdateRequestStatus

func (db *DB) UpdateRequestStatus(id int, status, adminNotes string) error

type Request

type Request struct {
	ID             int        `json:"id"`
	RequesterName  string     `json:"requester_name"`
	RequesterEmail *string    `json:"requester_email"`
	MediaType      string     `json:"media_type"`
	TmdbID         *int       `json:"tmdb_id"`
	TvdbID         *int       `json:"tvdb_id"`
	ImdbID         *string    `json:"imdb_id"`
	Title          string     `json:"title"`
	Year           *int       `json:"year"`
	Poster         *string    `json:"poster"`
	Status         string     `json:"status"`
	AdminNotes     *string    `json:"admin_notes"`
	ArrID          *int       `json:"arr_id"`
	CreatedAt      time.Time  `json:"created_at"`
	UpdatedAt      time.Time  `json:"updated_at"`
	NotifiedAt     *time.Time `json:"notified_at"`
}