db

type Album struct {
	AlbumID                 int64
	SubsonicAlbumID         sql.NullString
	AlbumName               string
	AlbumYear               int64
	ArtistID                int64
	SubsonicAlbumCoverArtID string
}

type Artist struct {
	ArtistID                 int64
	SubsonicArtistID         sql.NullString
	ArtistName               string
	SubsonicArtistCoverArtID string
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type ExtendedAlbum struct {
	AlbumID                  int64
	SubsonicAlbumID          sql.NullString
	AlbumName                string
	AlbumYear                int64
	ArtistID                 int64
	SubsonicAlbumCoverArtID  string
	SubsonicArtistID         sql.NullString
	ArtistName               string
	SubsonicArtistCoverArtID string
}

type ExtendedSong struct {
	SongID                   int64
	SubsonicSongID           sql.NullString
	LocalPath                sql.NullString
	Title                    string
	Artist                   string
	Duration                 int64
	Track                    int64
	DiscNumber               int64
	Suffix                   string
	ArtistID                 int64
	AlbumID                  int64
	SubsonicSongCoverArtID   string
	SubsonicAlbumID          sql.NullString
	AlbumName                string
	AlbumYear                int64
	SubsonicAlbumCoverArtID  string
	SubsonicArtistID         sql.NullString
	ArtistName               string
	SubsonicArtistCoverArtID string
}

type InsertOrUpdateSubsonicAlbumsParams struct {
	SubsonicAlbumID         sql.NullString
	AlbumName               string
	AlbumYear               int64
	SubsonicArtistID        sql.NullString
	SubsonicAlbumCoverArtID string
}

type InsertOrUpdateSubsonicArtistParams struct {
	SubsonicArtistID         sql.NullString
	ArtistName               string
	SubsonicArtistCoverArtID string
}

type InsertOrUpdateSubsonicSongParams struct {
	SubsonicSongID     sql.NullString
	SubsonicID         sql.NullString
	LocalPath          sql.NullString
	Title              string
	Artist             string
	Duration           int64
	Track              int64
	DiscNumber         int64
	Suffix             string
	SubsonicArtistID   sql.NullString
	SubsonicAlbumID    sql.NullString
	SubsonicCoverArtID string
}

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

type Song struct {
	SongID                 int64
	SubsonicSongID         sql.NullString
	LocalPath              sql.NullString
	Title                  string
	Artist                 string
	Duration               int64
	Track                  int64
	DiscNumber             int64
	Suffix                 string
	ArtistID               int64
	AlbumID                int64
	SubsonicSongCoverArtID string
}