func TestPostgresStorageGetByRange(t *testing.T) {
db, _ := NewPostgresStorage()
//setup - start this test with a clean events table
_, err := db.connection().Exec(`truncate histri.events restart identity`)
event1, _ := histri.NewEventWithTimeStr(
"2010-01-05T10:00:00.001Z",
"off",
"abc121",
map[string]interface{}{
"a": 1,
"b": 2,
},
)
event2, _ := histri.NewEventWithTimeStr(
"2010-01-07T10:00:00.001Z",
"on",
"abc122",
map[string]interface{}{
"a": 1,
"b": 2,
},
)
event3, _ := histri.NewEventWithTimeStr(
"2010-01-09T10:00:00.001Z",
"on",
"abc123",
map[string]interface{}{
"a": 1,
"b": 2,
},
)
db.Insert(event1)
db.Insert(event2)
db.Insert(event3)
start, _ := histri.ParseTimeStr("2010-01-07T00:00:00.000Z")
end, _ := histri.ParseTimeStr("2010-01-10T00:00:00.000Z")
retrievedRange, err := db.ByTimeRange(start, end)
if err != nil {
t.Errorf("Could not get ByTimeRange. Error: %q", err)
}
if len(retrievedRange) != 2 {
t.Errorf("Expect range of 2, got %d", len(retrievedRange))
}
}
func TestPostgresStorageInsertWithTimeStr(t *testing.T) {
db, _ := NewPostgresStorage()
timeString := "Fri, 06 Dec 2013 01:00:00 CST"
event, err := histri.NewEventWithTimeStr(
timeString,
"earthquake",
"abc123",
map[string]interface{}{
"a": 1,
"b": "b",
},
)
//fmt.Println(event.TimeUtc)
if err != nil {
t.Error("Could not create Event with TimeStr")
}
err = db.Insert(event)
if err != nil {
t.Errorf("Could not Insert with time from string. Error: %q",
err.Error())
}
}