-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlite_test.go
113 lines (107 loc) · 2.23 KB
/
sqlite_test.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
package main
import (
"context"
"strconv"
"testing"
"time"
)
func mustParseTime(s string) time.Time {
t, err := time.Parse("2006-01-02 15:04:05", s)
if err != nil {
panic(err)
}
return t
}
func TestSqllite(t *testing.T) {
dbfile := "/tmp/feed.db"
s, err := newSQLite(dbfile)
if err != nil {
t.Fatalf("open storage with %s failed: %v", dbfile, err)
}
feeds := []*Feed{
{
"1",
"a@example.com",
"https://foo.com/index.rss",
"hello foo",
"a hello message",
"hello, my dear friend",
"https://foo.com/1",
"2023-07-22 07:00:00",
"",
"2023-07-22 07:00:00",
"foo",
mustParseTime("2023-07-22 07:00:00"),
},
{
"2",
"b@example.com",
"https://foo.com/index.rss",
"hello foo",
"a hello message",
"hello, my dear friend",
"https://foo.com/1",
"2023-07-22 08:00:00",
"",
"2023-07-22 08:00:00",
"foo",
mustParseTime("2023-07-22 08:00:00"),
},
{
"nack",
"b@example.com",
"https://foo.com/index.rss",
"hello foo",
"a hello message",
"hello, my dear friend",
"https://foo.com/1",
"2023-07-22 09:00:00",
"",
"2023-07-22 09:00:00",
"foo",
mustParseTime("2023-07-22 09:00:00"),
},
}
ctx := context.Background()
ses, err := s.NewSession(ctx)
if err != nil {
t.Fatal(err)
}
ses, err = ses.Begin()
if err != nil {
t.Fatal(err)
}
defer ses.Rollback()
if err := s.SaveFeeds(ses, feeds...); err != nil {
t.Fatal(err)
}
ackAt := mustParseTime("2023-07-22 09:00:00")
for _, it := range feeds {
if it.Id == "nack" {
continue
}
if err := s.AckFeeds(ses, ackAt, it.Id); err != nil {
t.Fatal(err)
}
}
cases := []struct {
email string
site string
expectedWaterMark time.Time
}{
{"a@example.com", "https://foo.com/index.rss", mustParseTime("2023-07-22 07:00:00")},
{"b@example.com", "https://foo.com/index.rss", mustParseTime("2023-07-22 08:00:00")},
{"c@example.com", "https://foo.com/index.rss", time.Time{}},
}
for i, c := range cases {
t.Run(strconv.Itoa(i), func(t *testing.T) {
got, err := s.GetLatestFeedWaterMark(ses, c.email, c.site)
if err != nil {
t.Fatal(err)
}
if got != c.expectedWaterMark {
t.Fatalf("expected %v, got %v", c.expectedWaterMark, got)
}
})
}
}