diff options
Diffstat (limited to 'sqlite3_test.go')
| -rw-r--r-- | sqlite3_test.go | 17 |
1 files changed, 15 insertions, 2 deletions
diff --git a/sqlite3_test.go b/sqlite3_test.go index 3529fe7..5cd61c3 100644 --- a/sqlite3_test.go +++ b/sqlite3_test.go @@ -267,6 +267,12 @@ func TestTimestamp(t *testing.T) { t.Fatal("Failed to insert nonsense:", err) } + timestamp4 := time.Date(2012, time.April, 6, 23, 22, 0, 0, time.FixedZone("TEST", -7*3600)) + _, err = db.Exec("INSERT INTO foo(id, ts) VALUES(4, ?)", timestamp4) + if err != nil { + t.Fatal("Failed to insert timestamp:", err) + } + rows, err := db.Query("SELECT id, ts FROM foo ORDER BY id ASC") if err != nil { t.Fatal("Unable to query foo table:", err) @@ -303,10 +309,17 @@ func TestTimestamp(t *testing.T) { t.Errorf("Value for id 3 should be the zero time, not %v", ts) } } + + if id == 4 { + seen += 1 + if !timestamp4.Equal(ts) { + t.Errorf("Value for id 4 should be %v, not %v", timestamp4, ts) + } + } } - if seen != 3 { - t.Error("Expected to see three timestamps") + if seen != 4 { + t.Error("Expected to see four timestamps") } } |