AlbumView.kt

package com.kelsos.mbrc.content.library.albums

import androidx.room.ColumnInfo
import androidx.room.DatabaseView

@DatabaseView(
  value = """
    select distinct album.id,
                album.artist,
                album.album,
                track.album_artist,
                track.genre,
                track.sortable_year,
                album.date_added
    from album
       inner join track on album.album = track.album
       and album.artist = track.album_artist
""")
data class AlbumView(
  var id: Long,
  var artist: String,
  var album: String,
  @ColumnInfo(name = "album_artist")
  var albumArtist: String,
  var genre: String,
  @ColumnInfo(name = "sortable_year")
  var sortableYear: String,
  @ColumnInfo(name = "date_added")
  var dateAdded: Long
)

data class IndexLetter(val index:String)