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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
|
package stats
import (
"database/sql"
"log"
"slices"
"strings"
"time"
"github.com/gempir/go-twitch-irc"
)
type Channel struct {
dbid int
id string
name string
emotes map[string][]Emote
db *DatabaseConnection
}
func NewChannel(id string, name string, db *DatabaseConnection) Channel {
// channel
var dbid int
if err := db.QueryRow(
"SELECT id FROM channels WHERE alias_id = ?",
id,
).Scan(&dbid); err != nil {
log.Panicf("Failed to get channel: %v\n", err)
}
c := Channel{
dbid: dbid,
id: id,
name: name,
emotes: make(map[string][]Emote),
db: db,
}
go func() {
if err := c.updateEmotes(); err != nil {
log.Fatalf("Failed to update emotes: %v\n", err)
}
}()
return c
}
func (c *Channel) updateEmotes() (err error) {
log.Printf("Fetching BetterTTV emotes for ID %s...\n", c.id)
emotes, err := GetBetterTTVEmotes(c.id)
c.emotes["betterttv"] = emotes
for _, e := range emotes {
c.db.Exec("INSERT IGNORE INTO emotes(platform, platform_id) VALUES (?, ?)", e.Id, "betterttv")
}
return
}
func (c *Channel) HandleMessageEvent(sender twitch.User, message twitch.Message) {
err := c.db.Ping()
if err != nil {
log.Panicf("Failed to ping a database connection: %v\n", err)
}
// user
var userId int64
var userName string
err = c.db.QueryRow(
"SELECT id, alias_name FROM users WHERE alias_id = ?",
sender.UserID,
).Scan(&userId, &userName)
if err == sql.ErrNoRows {
res, err := c.db.Exec("INSERT INTO users(alias_id, alias_name) VALUES (?, ?)", sender.UserID, sender.Username)
if err != nil {
log.Panicf("Error creating a new user: %v\n", err)
}
userId, _ = res.LastInsertId()
userName = sender.Username
} else if err != nil {
log.Panicf("Error getting user: %v\n", err)
}
if userName != sender.Username {
_, err = c.db.Exec("UPDATE users SET alias_name = ? WHERE id = ?", sender.Username, userId)
if err != nil {
log.Panicf("Failed to update username: %v\n", err)
}
}
parts := strings.Split(message.Text, " ")
for _, part := range parts {
part = strings.TrimSpace(part)
if len(part) == 0 {
continue
}
// word
var wordId int64
err = c.db.QueryRow(
"SELECT id FROM words WHERE name = ?",
part,
).Scan(&wordId)
if err == sql.ErrNoRows {
res, err := c.db.Exec("INSERT INTO words(name) VALUES (?)", part)
if err != nil {
log.Panicf("Error creating a new word: %v\n", err)
}
wordId, _ = res.LastInsertId()
} else if err != nil {
log.Panicf("Error getting word: %v\n", err)
}
// channel word
var cwordId int64
var usageCount int
err = c.db.QueryRow(
"SELECT id, usage_count FROM channel_words WHERE word_id = ? AND user_id = ? AND channel_id = ?",
wordId, userId, c.dbid,
).Scan(&cwordId, &usageCount)
if err == sql.ErrNoRows {
res, err := c.db.Exec("INSERT INTO channel_words(word_id, user_id, channel_id) VALUES (?, ?, ?)",
wordId,
userId,
c.dbid,
)
if err != nil {
log.Panicf("Error creating a new channel word: %v\n", err)
}
cwordId, _ = res.LastInsertId()
usageCount = 0
} else if err != nil {
log.Panicf("Error getting channel word: %v\n", err)
}
_, err := c.db.Exec(
`INSERT INTO channel_words(word_id, user_id, channel_id)
VALUES (?, ?, ?)
ON DUPLICATE KEY UPDATE
usage_count = usage_count + 1,
last_used_at = UTC_TIMESTAMP()`,
wordId,
userId,
c.dbid,
)
if err != nil {
log.Panicf("Error creating a new channel word: %vn", err)
}
}
}
func (c *Channel) Name() string {
return c.name
}
func JoinChannels(channels *[]Channel, client *twitch.Client, db *DatabaseConnection) {
for {
cc, _ := db.Query("SELECT alias_id, alias_name FROM channels WHERE opted_out_at IS NULL")
for _, c := range cc {
if slices.ContainsFunc(*channels, func(c2 Channel) bool {
return c2.name == c["alias_name"]
}) {
continue
}
log.Printf("Joining #%s...\n", c["alias_name"])
client.Join(c["alias_name"])
*channels = append(*channels, NewChannel(c["alias_id"], c["alias_name"], db))
}
for _, c := range *channels {
if !slices.ContainsFunc(cc, func(x map[string]string) bool {
return x["alias_name"] == c.name
}) {
log.Printf("Parting #%s...\n", c.name)
client.Depart(c.name)
*channels = slices.DeleteFunc(*channels, func(c2 Channel) bool {
return c2.name == c.name
})
}
}
time.Sleep(5 * time.Second)
}
}
|
