Function TestSQLiteNoTruncate

output/sqlite_test.go:185–214

(t *testing.T)

}

func TestSQLiteNoTruncate(t *testing.T) {
	// Tests that running the output twice doesn't truncate the table
	// (E.g. if I want to run Baker and insert to existing files)
	fn, rm := testutil.TempFile(t)
	defer rm()

	doOneRound(t, fn, false)
	doOneRound(t, fn, false)

	conn, err := sql.Open("sqlite3", fn)
	if err != nil {
		t.Fatalf("Cannot open output sqlite3 after running writer. %s", err)
	}
	defer conn.Close()

	rows, err := conn.Query("SELECT field0, field1, field2 FROM lines")
	if err != nil {
		t.Fatalf("Cannot select data from sqlite3 after running writer. %s", err)
	}
	defer rows.Close()

	row_id := 0
	for rows.Next() {
		row_id++
	}

	if row_id != 8 {
		t.Fatalf("Expected 8 lines to be in sqlite3 file.")
	}
}

func TestSQLiteTruncate(t *testing.T) {
	// Test that, if I turn on truncating, the thing actually truncates.