Repository navigation
Expand file tree
/
Copy pathsqlite3_nocurrenttime_test.go
More file actions
70 lines (63 loc) · 1.84 KB
/
Copy pathsqlite3_nocurrenttime_test.go
File metadata and controls
70 lines (63 loc) · 1.84 KB
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
//go:build cgo
package sqlite3
import (
"database/sql"
"path/filepath"
"testing"
)
func TestNoCurrentTimeVFS(t *testing.T) {
path := filepath.Join(t.TempDir(), "nocurrenttime.db")
db, err := sql.Open("sqlite3", "file:"+path+"?vfs=nocurrenttime&_journal_mode=WAL")
if err != nil {
t.Fatal(err)
}
defer db.Close()
// Files are read and written as with the default VFS.
if _, err := db.Exec("CREATE TABLE t (v TEXT); INSERT INTO t VALUES (date('2000-01-02'))"); err != nil {
t.Fatal(err)
}
var v string
if err := db.QueryRow("SELECT v FROM t").Scan(&v); err != nil || v != "2000-01-02" {
t.Fatalf("read back %q, err %v", v, err)
}
for _, q := range []struct {
query string
args []any
}{
{"SELECT date('now')", nil},
{"SELECT date(?)", []any{"now"}},
{"SELECT date('n' || 'ow')", nil},
{"SELECT datetime()", nil},
{"SELECT julianday('now')", nil},
{"SELECT unixepoch()", nil},
{"SELECT strftime('%Y')", nil},
{"SELECT CURRENT_TIMESTAMP", nil},
} {
var got sql.NullString
if err := db.QueryRow(q.query, q.args...).Scan(&got); err != nil {
t.Errorf("%s: %v", q.query, err)
} else if got.Valid {
t.Errorf("%s: got the current time %q, want NULL", q.query, got.String)
}
}
plain, err := sql.Open("sqlite3", ":memory:")
if err != nil {
t.Fatal(err)
}
defer plain.Close()
var now sql.NullString
if err := plain.QueryRow("SELECT date('now')").Scan(&now); err != nil || !now.Valid {
t.Fatalf("the default VFS has no current time: %q, err %v", now.String, err)
}
}
func TestMoreThanOneVFS(t *testing.T) {
// SQLite would open this with the last one, the default VFS.
db, err := sql.Open("sqlite3", "file:"+filepath.Join(t.TempDir(), "two.db")+"?vfs=nocurrenttime&vfs=unix")
if err != nil {
t.Fatal(err)
}
defer db.Close()
if err := db.Ping(); err == nil {
t.Fatal("opened a database with two vfs parameters")
}
}