db

type DB dbstruct

type Folder struct {
	Id   int64
	Path string `sql:"size:511"`

	CreatedAt     time.Time
	MusicbrainzId sql.NullString `sql:"size:36"`
}

type Item struct {
	Id            int64
	Title         string         `sql:"size:255"`
	Artist        string         `sql:"size:255"`
	AlbumArtist   sql.NullString `sql:"size:255"`
	Album         sql.NullString `sql:"size:255" json:",string"`
	Genre         sql.NullString `sql:"size:255"` //TODO more refined genres
	TrackNumber   sql.NullString `sql:"size:16"`
	Filename      sql.NullString `sql:"size:255"`
	MusicbrainzId sql.NullString `sql:"size:36"`

	Folder   Folder
	FolderId sql.NullInt64

	CreatedAt time.Time

	// Total play score of a track.
	// Gets incremented by up to 1 each time a user listens to a track,
	// depending on how far in he listened to the track.
	// The formula for the added value is:
	//  x: amount of track listened to (0..1)
	//  tl: listened lower threshold
	//  tu: listened upper threshold
	//  add(x) = min( 1, max( 0, (x - tl) / (tu - tl) ) )
	PlayScore float32

	// Total times a track was played (including skips)
	// Track Score := (PlayScore / PlayCount)
	PlayCount uint32

	// Total times a track was played and scored as positive (x >= tl)
	ScoredCount uint32

	// Number of plays that are registered at the local scrobbler.
	//
	// When a track is listened and scored positively, this is incremented
	// and a scrobble is sent to the service.
	ScrobbleCount uint32
}

type StringType uint

type User struct {
	Id int64 `json:"-"`

	// Login name for the user. Has to be unique.
	Name string `json:"name" sql:"size:255"`

	// E-mail address. Has to be unique.
	Email string `json:"email"`

	AuthLevel core.AuthLevel `json:"auth_level"`

	// salt + pbkdf2-hashed password
	Password []byte `json:"-"`

	// Authentication token, used for sending requests
	AuthToken string `json:"auth_token"`
}