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
|
package backend
import (
"context"
"database/sql"
"fmt"
"log/slog"
"net/http"
"regexp"
"strings"
)
var trimRefererReg = regexp.MustCompile(`https?://([a-z-0-9.]+(:\d+)?)/.*`)
func getDB(ctx context.Context) *sql.DB {
return ctx.Value(dbKey).(*sql.DB)
}
func UpdateStats(ctx context.Context, r *http.Request) error {
target := r.URL.Path
if strings.HasPrefix(target, "/assets") || strings.HasPrefix(target, "/static") {
return nil
}
ref := r.Header.Get("Referer")
if ref == "" {
return nil
}
subs := trimRefererReg.FindStringSubmatch(ref)
if len(subs) < 2 {
return nil
}
ref = subs[1]
if ref == ctx.Value(configKey).(*Config).Domain || ref == fmt.Sprintf("localhost:%d", 8000) {
ref = subs[0][strings.Index(subs[0], ref)+len(ref):]
if ref == target {
return nil
}
}
db := getDB(ctx)
rows, err := db.QueryContext(ctx, "SELECT id, visit FROM stats WHERE origin = ? AND target = ?", ref, target)
if err != nil {
return err
}
defer func() {
if err == nil {
slog.Debug("stats updated")
}
}()
if !rows.Next() {
_, err = db.ExecContext(ctx, "INSERT INTO stats (origin, target, visit) VALUES (?, ?, 1)", ref, target)
return err
}
var id uint
var nb uint
err = rows.Scan(&id, &nb)
if err != nil {
return err
}
err = rows.Close()
if err != nil {
return err
}
_, err = db.ExecContext(ctx, "UPDATE stats SET visit = ? WHERE id = ?", nb+1, id)
return err
}
|
