1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
|
package scrobbler
import (
"database/sql"
"log"
"time"
"golang.fcuny.net/mpd-stats/internal/mpd"
)
type Scrobbler struct {
player *mpd.Player
db *sql.DB
}
func NewScrobbler(net string, addr string, dbpath string) (*Scrobbler, error) {
p, err := mpd.NewPlayer(net, addr)
if err != nil {
return nil, err
}
db, err := opendatabase(dbpath)
if err != nil {
return nil, err
}
s := Scrobbler{
player: p,
db: db,
}
return &s, nil
}
func (s *Scrobbler) Close() error {
return s.player.Close()
}
func (s *Scrobbler) Run() error {
var (
currentRecord *Record
previousRecord *Record
)
for {
e := <-s.player.Watcher.Event
if e == mpd.SubSystemPlayer {
status, err := s.player.Client.Status()
if err != nil {
log.Printf("could not read the status: %v", err)
}
if status["state"] == "stop" {
if currentRecord != nil {
if err := s.update(currentRecord); err != nil {
log.Printf("failed to update record %s: %s", currentRecord.Id, err)
}
currentRecord = nil
}
continue
}
attrs, err := s.player.Client.CurrentSong()
if err != nil {
log.Printf("could not get current song: %v", err)
}
if currentRecord == nil {
currentRecord, err = NewRecord(attrs)
if err != nil {
log.Printf("could not create a log: %v", err)
}
previousRecord = currentRecord
if err := s.save(currentRecord); err != nil {
log.Printf("failed to insert record %s: %s", currentRecord.Id, err)
}
continue
}
if !currentRecord.EqualAttrs(attrs) {
currentRecord, err = NewRecord(attrs)
if err != nil {
log.Printf("could not create a log: %v", err)
}
}
if currentRecord.Id != previousRecord.Id {
if err := s.update(previousRecord); err != nil {
log.Printf("failed to update record %s: %s", previousRecord.Id, err)
}
previousRecord = currentRecord
s.save(currentRecord)
}
}
}
}
func (s *Scrobbler) save(record *Record) error {
_, err := s.db.Exec("insert into records(id, title, artist, album, duration, playtime, time) values(?, ?, ?, ?, ?, 0, ?)",
record.Id,
record.Title,
record.Artist,
record.Album,
int(record.Duration.Seconds()),
record.Timestamp,
)
return err
}
func (s *Scrobbler) update(record *Record) error {
tnow := time.Now()
playtime := tnow.Sub(record.Timestamp).Seconds()
_, err := s.db.Exec("update records set playtime = ? where id = ?",
int(playtime),
record.Id,
)
return err
}
|
