25 lines
528 B
Bash
25 lines
528 B
Bash
#!/bin/bash
|
|
Delete() {
|
|
#Delete table < where_key where_operator where_value
|
|
# [where_key where_operator where_value
|
|
# […]]
|
|
local \
|
|
table="$1" \
|
|
key \
|
|
operator \
|
|
value \
|
|
where_statement \
|
|
results
|
|
while read key operator value
|
|
do
|
|
(( ${#where_statement} )) && where_statement+=( "AND" )
|
|
if [[ $value == NULL ]]
|
|
then
|
|
where_statement+=( "$key is NULL" )
|
|
else
|
|
where_statement+=( "$key $operator "'"'"${value//\"/\"\"}"'"' )
|
|
fi
|
|
done
|
|
echo "DELETE from $table WHERE ${where_statement[@]};" >&3
|
|
}
|