Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

postgres

package

Go to main page

Versions in this module

v0

v0.4.4

Apr 23, 2025

v0.4.3

Apr 21, 2025

v0.4.2

Apr 12, 2025

v0.4.1

Apr 12, 2025

Changes in this version

type DB

+ func (d *DB) GetAlbumImage(ctx context.Context, id uuid.UUID) ([]byte, error)

+ func (d *DB) GetArtistImage(ctx context.Context, id uuid.UUID) ([]byte, error)

+ func (d *DB) GetPlayedAlbumImage(ctx context.Context, id uuid.UUID) ([]byte, error)

+ func (d *DB) GetPlaylistImage(ctx context.Context, id uuid.UUID) ([]byte, error)

+ func (d *DB) ImportStreamingPlaylist(ctx context.Context, playlist *streaming.PlaylistFull, title string) error

v0.3.2

Mar 17, 2025

v0.3.1

Mar 16, 2025

v0.3.0

Mar 15, 2025

Changes in this version

type DB

+ func (d *DB) Image(ctx context.Context, id uuid.UUID) (io.ReadCloser, error)

v0.2.1

Feb 25, 2025

Changes in this version

+ type Option func(*DB)

v0.2.0

Feb 23, 2025

Changes in this version

+ func Generate(host, user, database string) error

+ type DB struct

+ func Init(ctx context.Context, opts Opts, logger *slog.Logger) (*DB, error)

+ func (d *DB) AddPlayedAlbum(ctx context.Context, album unification.AlbumFull) error

+ func (d *DB) AddPlaylist(ctx context.Context, title, description string) error

+ func (d *DB) AddStreamingAlbum(ctx context.Context, album *streaming.AlbumFull) error

+ func (d *DB) AddStreamingArtist(ctx context.Context, artist *streaming.Artist) error

+ func (d *DB) AddStreamingTrackToPlaylist(ctx context.Context, playlistID uuid.UUID, track *streaming.Track) error

+ func (d *DB) AddTrackToPlaylist(ctx context.Context, playlistID uuid.UUID, trackID uuid.UUID) error

+ func (d *DB) DeleteFileTrack(ctx context.Context, id uuid.UUID) error

+ func (d *DB) GetAlbumFull(ctx context.Context, id uuid.UUID) (library.AlbumFull, error)

+ func (d *DB) GetAllFileTracks(ctx context.Context) ([]library.Track, error)

+ func (d *DB) GetArtistFull(ctx context.Context, id uuid.UUID) (library.ArtistFull, error)

+ func (d *DB) GetFileTrack(ctx context.Context, path string) (library.Track, error)

+ func (d *DB) GetLastRun(ctx context.Context) (time.Time, error)

+ func (d *DB) GetPlaylistFull(ctx context.Context, id uuid.UUID) (library.PlaylistFull, error)

+ func (d *DB) GetStreamingAlbum(ctx context.Context, id string) (library.Album, error)

+ func (d *DB) GetStreamingAlbumFull(ctx context.Context, id string) (library.AlbumFull, error)

+ func (d *DB) GetStreamingArtist(ctx context.Context, id string) (library.Artist, error)

+ func (d *DB) GetStreamingArtistFull(ctx context.Context, id string) (library.ArtistFull, error)

+ func (d *DB) GetTrack(ctx context.Context, id uuid.UUID) (library.Track, error)

+ func (d *DB) ListAlbums(ctx context.Context, opt library.ListOpt) ([]library.AlbumWithArtists, error)

+ func (d *DB) ListArtists(ctx context.Context, opt library.ListOpt) ([]library.Artist, error)

+ func (d *DB) ListPlayedAlbums(ctx context.Context, opt library.ListOpt) ([]library.PlayedAlbum, error)

+ func (d *DB) ListPlaylists(ctx context.Context, opt library.ListOpt) ([]library.Playlist, error)

+ func (d *DB) Search(ctx context.Context, query string, limit int) (library.SearchRes, error)

+ func (d *DB) SetLastRun(ctx context.Context, time time.Time) error

+ func (d *DB) SyncFileTrack(ctx context.Context, track files.TrackFull) error

+ type Opts struct

+ Database string

+ Host string

+ Password string

+ Port int

+ User string