#!/bin/sh
set -e

exec 3>&2
run() { echo "+ $*" >&3; "$@"; }

# Write to and read back from a SQLite database file via sqlite_scanner.
tmp="${AUTOPKGTEST_TMP:-$(mktemp -d)}"
[ -z "${AUTOPKGTEST_TMP:-}" ] && trap 'rm -rf "$tmp"' EXIT

file="$tmp/test.sqlite3"

run duckdb -c "LOAD sqlite_scanner;
  ATTACH '$file' AS sq (TYPE sqlite);
  CREATE TABLE sq.people AS SELECT 'Alice' AS name, 30 AS age;"

result=$(run duckdb -c "LOAD sqlite_scanner;
  ATTACH '$file' AS sq (TYPE sqlite);
  SELECT name FROM sq.people;")
echo "$result" | grep -q "Alice"
