From 01f6b8dea6892010060c4b27d3b068dd3db080e3 Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Wed, 11 Mar 2015 15:29:16 +0100 Subject: added the first testcase --- sqlQueries_test.go | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 sqlQueries_test.go (limited to 'sqlQueries_test.go') diff --git a/sqlQueries_test.go b/sqlQueries_test.go new file mode 100644 index 0000000..6ab904e --- /dev/null +++ b/sqlQueries_test.go @@ -0,0 +1,32 @@ +package main + +import ( + "database/sql" + _ "github.com/go-sql-driver/mysql" + "testing" + "time" +) + +func TestDataFetching(t *testing.T) { + //initialize db + db, err := sql.Open("mysql", "test:test@/test") + if err != nil { + t.Fatal("Failed to connect to db") + return + } + defer db.Close() + + //fetch the data from the db + rDat, err := fetchRawData(db, time.Now()) + if err != nil { + t.Fatal(err) + } + + if len(rDat) != 5 { + t.Fatal("did not fetch data as it should") + } + if rDat[2].ipSrc != "8.8.8.8" { + t.Fatal("contents of ip in data is incorrect") + } + //TODO add more tests +} -- cgit v1.1