-
Notifications
You must be signed in to change notification settings - Fork 0
/
homescriptUrlCache.go
125 lines (118 loc) · 3.3 KB
/
homescriptUrlCache.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
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
package database
import (
"database/sql"
"unicode/utf8"
)
// Creates the table which hold the cached Homescript URLs
func createHomescriptUrlCacheTable() error {
if _, err := db.Exec(`
CREATE TABLE
IF NOT EXISTS
homescriptUrlCache(
Url VARCHAR(100),
LastCheck DATETIME DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY(Url)
)
`); err != nil {
log.Error("Failed to create homescriptUrlCache table: ", err.Error())
return err
}
return nil
}
// Adds a new entry into the cache
// If the entry already exists, it is updated
func AddHomescriptUrlCacheEntry(url string) error {
if utf8.RuneCountInString(url) > 100 {
// URLs longer than 100 characters cannot be cached and must therefore be omitted
return nil
}
query, err := db.Prepare(`
INSERT INTO
homescriptUrlCache(
Url,
LastCheck
)
VALUES(?, DEFAULT)
ON DUPLICATE KEY
UPDATE
LastCheck=VALUES(LastCheck)
`)
if err != nil {
log.Error("Failed to add or update Homescript URL cache entry: preparing query failed: ", err.Error())
return err
}
defer query.Close()
if _, err := query.Exec(url); err != nil {
log.Error("Failed to add or update Homescript URL cache entry: execution query failed: ", err.Error())
return err
}
return nil
}
// Returns all cache entries younger than 12 hours (cache invalidation time)
// => This means this function will return only valid cache-entries
func GetValidHomescriptUrlCacheEntries() ([]string, error) {
res, err := db.Query(`
SELECT Url
FROM homescriptUrlCache
WHERE LastCheck > NOW() - INTERVAL 12 HOUR
`)
if err != nil {
log.Error("Failed to list valid Homescript URL cache entries: executing query failed: ", err.Error())
return nil, err
}
results := make([]string, 0)
for res.Next() {
var currentResult string
if err := res.Scan(¤tResult); err != nil {
log.Error("Failed to list valid Homescript URL cache entries: scanning result failed: ", err.Error())
return nil, err
}
results = append(results, currentResult)
}
return results, nil
}
// Returns a boolean indicating whether a specified entry exists and if it is still valid
func IsHomescriptUrlCached(urlToGet string) (bool, error) {
query, err := db.Prepare(`
SELECT 1
FROM homescriptUrlCache
WHERE LastCheck > NOW() - INTERVAL 12 HOUR
AND Url=?
LIMIT 1
`)
if err != nil {
log.Error("Failed to check if HMS url cache entry exists: preparing query failed: ", err.Error())
return false, err
}
defer query.Close()
blackHole := 0
if err := query.QueryRow(urlToGet).Scan(&blackHole); err != nil {
if err == sql.ErrNoRows {
return false, nil
}
log.Error("Failed to check if HMS url cache entry exists: executing query failed: ", err.Error())
return false, err
}
return true, nil
}
// Deletes all cache entries which are older than 12 hours (cache invalidation time)
func FlushHomescriptUrlCache() error {
if _, err := db.Exec(`
DELETE FROM homescriptUrlCache
WHERE LastCheck < NOW() - INTERVAL 12 HOUR
`); err != nil {
log.Error("Failed to flush Homescript URL cache: executing query failed: ", err.Error())
return err
}
return nil
}
// Deletes all cache entries, regardless of their age
func PurgeHomescriptUrlCache() error {
if _, err := db.Exec(`
DELETE FROM homescriptUrlCache
`); err != nil {
log.Error("Failed to purge Homescript URL cache: executing query failed: ", err.Error())
return err
}
return nil
}