-
Notifications
You must be signed in to change notification settings - Fork 0
/
logs.go
executable file
·60 lines (48 loc) · 1.07 KB
/
logs.go
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
package actions
import (
"fmt"
"strings"
"time"
"github.com/mxk/go-sqlite/sqlite3"
"github.com/zaibon/ircbot"
db "github.com/zaibon/ircbot/database"
)
type Logger struct {
db *db.DB
}
var insertStmt *sqlite3.Stmt
func NewLogger(b *ircbot.IrcBot) *Logger {
conn, err := b.DBConnection()
if err != nil {
panic(err)
}
if err := conn.Exec(`CREATE TABLE IF NOT EXISTS logs(
id INTEGER CONSTRAINT line_PK PRIMARY KEY,
nick STRING,
message TEXT,
channel STRING,
timestamp INTEGER)`); err != nil {
panic(err)
}
insertStmt, err = conn.Prepare("INSERT INTO logs (nick,message,channel,timestamp) VALUES ($nick,$message,$channel,$timestamp)")
if err != nil {
panic(err)
}
return &Logger{
db: conn,
}
}
func (l *Logger) Command() []string {
return []string{
"PRIVMSG",
}
}
func (l *Logger) Usage() string {
return ""
}
func (l *Logger) Do(b *ircbot.IrcBot, m *ircbot.IrcMsg) {
msg := strings.Join(m.Trailing, " ")
if err := insertStmt.Exec(m.Nick(), msg, m.Channel(), time.Now()); err != nil {
fmt.Printf("DATABASE error execute stmt : %s\n", err)
}
}