database

type Album struct {
	Id       string
	ArtistId string
	Name     string
	CoverArt sql.NullString
}

type Artist struct {
	Id      string         `json:"id"`
	Name    string         `json:"name"`
	Picture sql.NullString `json:"picture"`
}

type Connection interface {
	Query(query string, args ...any) (*sql.Rows, error)
	QueryRow(query string, args ...any) *sql.Row
	Exec(query string, args ...any) (sql.Result, error)
}

type CreateAlbumParams struct {
	ArtistId string
	Name     string
	CoverArt sql.NullString
}

type CreateArtistParams struct {
	Name    string
	Picture sql.NullString
}

type CreateTrackParams struct {
	AlbumId  string
	ArtistId string

	Title string

	CoverArt sql.NullString

	TrackNumber sql.NullInt64
	Duration    sql.NullInt64
	Year        sql.NullInt64

	OriginalFile   string
	TranscodedFile string
}

type Database struct {
	RawConn *sql.DB
	Conn    Connection
}

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

type Track struct {
	Id       string
	AlbumId  string
	ArtistId string

	Title string

	CoverArt sql.NullString

	TrackNumber sql.NullInt64
	Duration    sql.NullInt64
	Year        sql.NullInt64

	OriginalFile   string
	TranscodedFile string
}