#!/usr/bin/env python3
"""Test the binary's SQLite API and the interpreter-only execution path."""

import argparse
import os
from pathlib import Path
import subprocess
import tempfile


ROOT = Path(__file__).resolve().parents[1]

INSERT = """\
exec PRAGMA journal_mode=WAL;
exec CREATE TABLE items(i INTEGER, r REAL, s TEXT, b BLOB, n TEXT);
prepare INSERT INTO items VALUES (?1, ?2, ?3, ?4, ?5);
bind-int 1 -9223372036854775808
bind-double 2 1.25
bind-text 3 two words
bind-blob 4 00ff
bind-null 5
step
changes
last-rowid
finalize
exec BEGIN; DELETE FROM items;
autocommit
exec ROLLBACK;
autocommit
close
"""

READ = """\
exec PRAGMA integrity_check;
prepare SELECT * FROM items; -- trailing comment
columns
step
step
reset
clear-bindings
step
finalize
prepare SELECT ?1;
bind-blob 1
step
finalize
"""


def run(binary, args, text="", interpret=False):
    env = dict(os.environ, CGRAAL_INTERPRET="1" if interpret else "0", CGRAAL_TRACE="0")
    return subprocess.run([str(binary), *args], input=text, encoding="utf-8",
                          capture_output=True, env=env, timeout=60)


def verify(result, expected_status, expected_stdout, stderr_contains=""):
    if (result.returncode != expected_status or result.stdout != expected_stdout
            or stderr_contains not in result.stderr):
        raise SystemExit(f"exit={result.returncode}\nstdout={result.stdout!r}\nstderr={result.stderr}")


def main():
    parser = argparse.ArgumentParser(description=__doc__)
    parser.add_argument("exe", nargs="?", type=Path, default=ROOT / "dist" / "sqlite-api-shell")
    args = parser.parse_args()
    binary = args.exe.resolve(strict=True)
    verify(run(binary, ["--version"], interpret=True), 0, "3.54.1\n")
    with tempfile.TemporaryDirectory(prefix="sqlite-api-check-") as directory:
        database = str(Path(directory) / "database with spaces.db")
        verify(run(binary, [database], INSERT, interpret=True), 0,
               "ROW\t\"wal\"\nOK\n" + "OK\n" * 7 +
               "DONE\n1\n1\nOK\nOK\n0\nOK\n1\nOK\n")
        row = 'ROW\tINTEGER -9223372036854775808\tREAL 1.25\tTEXT "two words"\tBLOB 00ff\tNULL\n'
        verify(run(binary, [database], READ), 0,
               'ROW\t"ok"\nOK\nOK\nCOLUMNS\t"i"\t"r"\t"s"\t"b"\t"n"\n'
               + row + "DONE\nOK\nOK\n" + row + "OK\nOK\nOK\nROW\tBLOB \nOK\n")
        verify(run(binary, [database], "prepare SELECT 1; SELECT 2;\nchanges\n"),
               1, "", "prepare requires exactly one SQL statement")
        verify(run(binary, [database], "prepare SELECT ?1;\nbind-blob 1 z1\nstep\n"),
               1, "OK\n", "bind-blob requires hexadecimal digits")
    print("SQLite API shell checks passed")


if __name__ == "__main__":
    main()
