database

package
v0.6.0 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Feb 29, 2024 License: MIT Imports: 9 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Album 

type Album struct {
	Id       string
	Name     string
	CoverArt string
	ArtistId string
	Path     string
}

type Artist 

type Artist struct {
	Id      string
	Name    string
	Picture string
	Path    string
}

type CreateAlbumParams 

type CreateAlbumParams struct {
	Name     string
	CoverArt string
	ArtistId string
	Path     string
}

type CreateArtistParams 

type CreateArtistParams struct {
	Name    string
	Picture string
	Path    string
}

type CreateTrackParams 

type CreateTrackParams struct {
	TrackNumber       int
	Name              string
	CoverArt          string
	Path              string
	BestQualityFile   string
	MobileQualityFile string
	AlbumId           string
	ArtistId          string
}

type Database added in v0.6.0 

type Database struct {
	// contains filtered or unexported fields
}

func New 

func New(conn *pgxpool.Pool) *Database

func (*Database) CreateAlbum added in v0.6.0 

func (db *Database) CreateAlbum(ctx context.Context, params CreateAlbumParams) (Album, error)

func (*Database) CreateArtist added in v0.6.0 

func (db *Database) CreateArtist(ctx context.Context, params CreateArtistParams) (Artist, error)

func (*Database) CreateTrack added in v0.6.0 

func (db *Database) CreateTrack(ctx context.Context, params CreateTrackParams) (Track, error)

func (*Database) Exec added in v0.6.0 

func (db *Database) Exec(ctx context.Context, s ToSQL) (pgconn.CommandTag, error)

func (*Database) GetAlbumById added in v0.6.0 

func (db *Database) GetAlbumById(ctx context.Context, id string) (Album, error)

func (*Database) GetAlbumByPath added in v0.6.0 

func (db *Database) GetAlbumByPath(ctx context.Context, path string) (Album, error)

func (*Database) GetAlbumsByArtist added in v0.6.0 

func (db *Database) GetAlbumsByArtist(ctx context.Context, artistId string) ([]Album, error)

func (*Database) GetAllAlbums added in v0.6.0 

func (db *Database) GetAllAlbums(ctx context.Context) ([]Album, error)

func (*Database) GetAllArtists added in v0.6.0 

func (db *Database) GetAllArtists(ctx context.Context) ([]Artist, error)

func (*Database) GetAllTracks added in v0.6.0 

func (db *Database) GetAllTracks(ctx context.Context) ([]Track, error)

func (*Database) GetArtistById added in v0.6.0 

func (db *Database) GetArtistById(ctx context.Context, id string) (Artist, error)

func (*Database) GetArtistByPath added in v0.6.0 

func (db *Database) GetArtistByPath(ctx context.Context, path string) (Artist, error)

func (*Database) GetTrackById added in v0.6.0 

func (db *Database) GetTrackById(ctx context.Context, id string) (Track, error)

func (*Database) GetTrackByPath added in v0.6.0 

func (db *Database) GetTrackByPath(ctx context.Context, path string) (Track, error)

func (*Database) GetTracksByAlbum added in v0.6.0 

func (db *Database) GetTracksByAlbum(ctx context.Context, albumId string) ([]Track, error)

func (*Database) Query added in v0.6.0 

func (db *Database) Query(ctx context.Context, s ToSQL) (pgx.Rows, error)

func (*Database) QueryRow added in v0.6.0 

func (db *Database) QueryRow(ctx context.Context, s ToSQL) (pgx.Row, error)

func (*Database) UpdateTrack added in v0.6.0 

func (db *Database) UpdateTrack(ctx context.Context, id, bestQualityFile, mobileQualityFile string) error

type ToSQL added in v0.6.0 

type ToSQL interface {
	ToSQL() (string, []interface{}, error)
}

type Track 

type Track struct {
	Id       string
	Number   int
	Name     string
	CoverArt string

	Path string

	BestQualityFile   string
	MobileQualityFile string

	AlbumId  string
	ArtistId string

	AlbumName  string
	ArtistName string
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.