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())
	}
}