db

Documentation

Index

• type DB
  • func Connect(cfg *config.Config) (*DB, error)
  • func (db *DB) AddPhotoToAlbum(photoID, albumID string) error
  • func (db *DB) Driver() string
  • func (db *DB) GetAlbums() ([]models.Album, error)
  • func (db *DB) GetAlbumsWithPhotoCounts() ([]models.AlbumWithPhotoCount, error)
  • func (db *DB) GetPhotoByID(id string) (*models.PhotoWithSizeVariants, error)
  • func (db *DB) GetPhotosNeedingMetadata(albumID *string, limit, offset int) ([]models.PhotoWithSizeVariants, error)
  • func (db *DB) Health() error
  • func (db *DB) UpdatePhoto(id string, update models.PhotoUpdate) error

Types

type DB

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

func Connect

func Connect(cfg *config.Config) (*DB, error)

func (*DB) AddPhotoToAlbum

func (db *DB) AddPhotoToAlbum(photoID, albumID string) error

AddPhotoToAlbum adds a photo to an album without removing existing memberships.

func (*DB) Driver

func (db *DB) Driver() string

func (*DB) GetAlbums

func (db *DB) GetAlbums() ([]models.Album, error)

func (*DB) GetAlbumsWithPhotoCounts

func (db *DB) GetAlbumsWithPhotoCounts() ([]models.AlbumWithPhotoCount, error)

func (*DB) GetPhotoByID

func (db *DB) GetPhotoByID(id string) (*models.PhotoWithSizeVariants, error)

func (*DB) GetPhotosNeedingMetadata

func (db *DB) GetPhotosNeedingMetadata(albumID *string, limit, offset int) ([]models.PhotoWithSizeVariants, error)

func (*DB) Health

func (db *DB) Health() error

func (*DB) UpdatePhoto

func (db *DB) UpdatePhoto(id string, update models.PhotoUpdate) error