sqlite3

#!/bin/bash

. /opt/cs50/lib/cli

# If data is coming from stdin (pipe or redirection)
if [[ -p /dev/stdin || ! -t 0 ]]; then
    /usr/local/bin/sqlite3 -nullvalue NULL -table "$@" < /dev/stdin
    exit $?
fi

# If no command-line argument
if [[ $# -eq 0 ]]; then
    if ! _sure "Are you sure you want to run \`sqlite3\` without a command-line argument (e.g., the filename of a database)?"; then
        exit 1
    fi

# If one command-line argument
elif [[ $# -eq 1 ]] && [[ ! "$1" =~ ^- ]]; then
    if [[ ! -f "$1" ]]; then
        if [[ ! "$1" =~ \.db$ ]]; then
            if ! _sure "Are you sure you want to create \`$1\`? SQLite filenames usually end in \`.db\`."; then
                exit 1
            fi
        else
            if ! _sure "Are you sure you want to create \`$1\`?"; then
                exit 1
            fi
        fi
        /usr/local/bin/sqlite3 "$@" "VACUUM;" # https://stackoverflow.com/a/51455470
    fi
fi

/usr/local/bin/sqlite3 -nullvalue NULL -table "$@"