Function TestCreateModuleEponymousOnly

sqlite3_opt_vtable_test.go:589–622

(t *testing.T)

}

func TestCreateModuleEponymousOnly(t *testing.T) {
	tempFilename := TempFilename(t)
	defer os.Remove(tempFilename)
	intarray := []int{1, 2, 3}
	sql.Register("sqlite3_TestCreateModuleEponymousOnly", &SQLiteDriver{
		ConnectHook: func(conn *SQLiteConn) error {
			return conn.CreateModule("test", testModuleEponymousOnly{t, intarray})
		},
	})
	db, err := sql.Open("sqlite3_TestCreateModuleEponymousOnly", tempFilename)
	if err != nil {
		t.Fatalf("could not open db: %v", err)
	}

	var i, value int
	rows, err := db.Query("SELECT rowid, * FROM test")
	if err != nil {
		t.Fatalf("couldn't select from virtual table: %v", err)
	}
	for rows.Next() {
		err := rows.Scan(&i, &value)
		if err != nil {
			t.Fatal(err)
		}
		if intarray[i] != value {
			t.Fatalf("want %v but %v", intarray[i], value)
		}
	}

	_, err = db.Exec("DROP TABLE test")
	if err != nil {
		t.Logf("couldn't drop virtual table: %v", err)
	}
}