duckdb_extensions_test.go

//go:build !duckdb_use_lib && !windows

package duckdb

import (
	"testing"

	"github.com/stretchr/testify/require"
)

func TestOpenSQLite(t *testing.T) {
	db := openDbWrapper(t, `sqlite:testdata/pets.sqlite`)
	defer closeDbWrapper(t, db)

	var species string
	res := db.QueryRow(`SELECT species FROM pets WHERE id = 1`)
	require.NoError(t, res.Scan(&species))
	require.Equal(t, "Gopher", species)
}