# Relational pipes

# Copyright © 2019 František Kučera (Frantovo.cz, GlobalCode.info)

#

# This program is free software: you can redistribute it and/or modify

# it under the terms of the GNU General Public License as published by

# the Free Software Foundation, version 3 of the License.

#

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with this program. If not, see <http://www.gnu.org/licenses/>.

_relpipe_tr_sql_completion_dsn() {

	if type relpipe-out-nullbyte &> /dev/null; then

		relpipe-tr-sql --list-data-sources true | relpipe-out-nullbyte | while read -r -d '' name; do read -r -d '' description; echo $name; done

	fi

}

_relpipe_tr_sql_completion() {

	local w0 w1 w2

	COMPREPLY=()

	w0=${COMP_WORDS[COMP_CWORD]}

	w1=${COMP_WORDS[COMP_CWORD-1]}

	w2=${COMP_WORDS[COMP_CWORD-2]}

	DATA_TYPE=(

		"string"

		"integer"

		"boolean"

	)

	BOOLEAN_VALUES=(

		"true"

		"false"

	)

	DATA_SOURCE_STRING=(

		"Driver=SQLite3;Database=file::memory:"

		"Driver=SQLite3;Database=file:temp-relpipe.sqlite"

		"Driver=SQLite3;Database=file:/tmp/relpipe.sqlite"

	)

	if   [[ "$w1" == "--relation"      && "x$w0" == "x" ]];    then COMPREPLY=("''")

	elif [[ "$w2" == "--relation"      && "x$w0" == "x" ]];    then COMPREPLY=('"SELECT * FROM "')

	elif [[ "$w1" == "--type-cast"     && "x$w0" == "x" ]];    then COMPREPLY=("''")

	elif [[ "$w2" == "--type-cast"                      ]];    then COMPREPLY=($(compgen -W "${DATA_TYPE[*]}" -- "$w0"))

	elif [[ "$w1" == "--list-data-sources"              ]];    then COMPREPLY=($(compgen -W "${BOOLEAN_VALUES[*]}" -- "$w0"))

	elif [[ "$w1" == "--parameter"     && "x$w0" == "x" ]];    then COMPREPLY=("''")

	elif [[ "$w1" == "--copy"          && "x$w0" == "x" ]];    then COMPREPLY=("'.+'")

	elif [[ "$w1" == "--copy-renamed"  && "x$w0" == "x" ]];    then COMPREPLY=("'.+'")

	elif [[ "$w2" == "--copy-renamed"  && "x$w0" == "x" ]];    then COMPREPLY=("'copy_of_\$0'")

	elif [[ "$w1" == "--data-source-name"               ]];    then COMPREPLY=($(compgen -W "$(_relpipe_tr_sql_completion_dsn)" -- "$w0"))

	elif [[ "$w1" == "--data-source-string"             ]];    then COMPREPLY=($(compgen -W "${DATA_SOURCE_STRING[*]}" -- "$w0"))

	else

		OPTIONS=(

			"--relation"

			"--type-cast"

			"--parameter"

			"--copy"

			"--copy-renamed"

			"--list-data-sources"

			"--data-source-name"

			"--data-source-string"

		)

		COMPREPLY=($(compgen -W "${OPTIONS[*]}" -- "$w0"))

	fi

}

complete -F _relpipe_tr_sql_completion relpipe-tr-sql

complete -F _relpipe_tr_sql_completion relpipe-in-sql