blob: 97ce90e3d59bd678518ca40d6b5dae26c3a2cbee (
plain)
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
|
package store
import (
"database/sql"
"path/filepath"
"testing"
_ "github.com/mattn/go-sqlite3"
)
// newAvailabilityTestStore creates a Store backed by a fresh temp sqlite DB
// with just the availability_blocks table.
func newAvailabilityTestStore(t *testing.T) *Store {
t.Helper()
dbPath := filepath.Join(t.TempDir(), "test.db")
db, err := sql.Open("sqlite3", dbPath)
if err != nil {
t.Fatal(err)
}
t.Cleanup(func() { db.Close() })
if _, err := db.Exec(`
CREATE TABLE availability_blocks (
id TEXT PRIMARY KEY,
weekday INTEGER NOT NULL,
start_time TEXT NOT NULL,
end_time TEXT NOT NULL,
label TEXT DEFAULT ''
)
`); err != nil {
t.Fatal(err)
}
return &Store{db: db}
}
|
