index a474a524367eb213b1e8f614c3ea085b25a0fa64..b6394432d1111cd9e9aa58ee7f58a9329dcaee83 100755 (executable)
# Integration tests using simple queries.
#
-set -e
+set -ex
source "$( dirname "$0" )/test_lib.sh"
echo "$output" | grep "parse error: syntax error"
# Simple, successful commands.
-output="$( run_sysdb -H "$SOCKET_FILE" -c LIST )"
+output="$( run_sysdb -H "$SOCKET_FILE" -c 'LIST hosts' )"
echo "$output" \
| grep -F '"host1.example.com"' \
| grep -F '"host2.example.com"' \
| grep -F '"other.host.name"' \
| grep -F '"some.host.name"'
-output="$( echo 'LIST;' | run_sysdb -H "$SOCKET_FILE" )" || echo $?
+output="$( echo 'LIST hosts;' | run_sysdb -H "$SOCKET_FILE" )" || echo $?
echo "$output" \
| grep -F '"host1.example.com"' \
| grep -F '"host2.example.com"' \
| grep -F '"other.host.name"' \
| grep -F '"some.host.name"'
-output="$( run_sysdb -H "$SOCKET_FILE" -c "FETCH 'host1.example.com'" )"
+output="$( run_sysdb -H "$SOCKET_FILE" -c 'LIST services' )"
+echo "$output" \
+ | grep -F '"host1.example.com"' \
+ | grep -F '"host2.example.com"' \
+ | grep -F '"localhost"' \
+ | grep -F '"some.host.name"' \
+ | grep -F '"mock service"' \
+ | grep -F '"other service"' \
+ | grep -F '"database"' \
+ | grep -F '"example service one"' \
+ | grep -F '"example service two"' \
+ | grep -F '"example service three"'
+
+output="$( run_sysdb -H "$SOCKET_FILE" -c "FETCH host 'host1.example.com'" )"
echo "$output" \
| grep -F '"host1.example.com"' \
| grep -F '"mock service"' \
echo "$output" | grep -F 'other.host.name' && exit 1
echo "$output" | grep -F 'some.host.name' && exit 1
-(echo 'LIST;'; sleep 1; echo "FETCH 'host1.example.com'") \
+(echo 'LIST hosts;'; sleep 1; echo "FETCH host 'host1.example.com'") \
| run_sysdb -H "$SOCKET_FILE"
# When requesting information for unknown hosts, expect a non-zero exit code.
-output="$( run_sysdb -H "$SOCKET_FILE" -c "FETCH 'does.not.exist'" )" \
+output="$( run_sysdb -H "$SOCKET_FILE" -c "FETCH host 'does.not.exist'" )" \
&& exit 1
echo "$output" | grep -F 'not found'
output="$( run_sysdb -H "$SOCKET_FILE" \
- -c "LOOKUP hosts WHERE attribute.architecture = 'x42'" )"
+ -c "LOOKUP hosts MATCHING metric = 'foo/bar/qux'" )"
+echo "$output" \
+ | grep -F '"some.host.name"' \
+ | grep -F '"other.host.name"'
+echo "$output" | grep -F 'localhost' && exit 1
+echo "$output" | grep -F 'host1.example.com' && exit 1
+echo "$output" | grep -F 'host2.example.com' && exit 1
+
+output="$( run_sysdb -H "$SOCKET_FILE" \
+ -c "LOOKUP hosts MATCHING service = 'mock service'" )"
+echo "$output" \
+ | grep -F '"some.host.name"' \
+ | grep -F '"host1.example.com"' \
+ | grep -F '"host2.example.com"'
+echo "$output" | grep -F 'localhost' && exit 1
+echo "$output" | grep -F 'other.host.name' && exit 1
+
+output="$( run_sysdb -H "$SOCKET_FILE" \
+ -c "LOOKUP hosts MATCHING attribute.architecture = 'x42'" )"
echo "$output" \
| grep -F '"host1.example.com"' \
| grep -F '"host2.example.com"'
echo "$output" | grep -F 'some.host.name' && exit 1
output="$( run_sysdb -H "$SOCKET_FILE" \
- -c "LOOKUP hosts WHERE attribute.name != 'architecture'" )"
+ -c "LOOKUP hosts MATCHING attribute != 'architecture'" )"
echo "$output" \
| grep -F '"some.host.name"' \
| grep -F '"localhost"'
echo "$output" | grep -F 'host2.example.com' && exit 1
output="$( run_sysdb -H "$SOCKET_FILE" \
- -c "LOOKUP hosts WHERE service.name = 'sysdbd'" )"
+ -c "LOOKUP hosts MATCHING attribute != 'architecture'
+ FILTER :age >= 0s" )"
+echo "$output" \
+ | grep -F '"some.host.name"' \
+ | grep -F '"localhost"'
+echo "$output" | grep -F 'other.host.name' && exit 1
+echo "$output" | grep -F 'host1.example.com' && exit 1
+echo "$output" | grep -F 'host2.example.com' && exit 1
+
+output="$( run_sysdb -H "$SOCKET_FILE" \
+ -c "LOOKUP hosts MATCHING attribute != 'architecture'
+ FILTER :last_update < 2Y" )"
+echo $output | grep -E '^\[\]$'
+
+output="$( run_sysdb -H "$SOCKET_FILE" \
+ -c "LOOKUP hosts MATCHING service = 'sysdbd'" )"
echo "$output" | grep -F '"localhost"'
echo "$output" | grep -F 'some.host.name' && exit 1
echo "$output" | grep -F 'other.host.name' && exit 1
echo "$output" | grep -F 'host2.example.com' && exit 1
output="$( run_sysdb -H "$SOCKET_FILE" \
- -c "LOOKUP hosts WHERE host.name =~ 'example.com'" )"
+ -c "LOOKUP hosts MATCHING host =~ 'example.com'" )"
echo "$output" \
| grep -F '"host1.example.com"' \
| grep -F '"host2.example.com"'
# When querying hosts that don't exist, expect a zero exit code.
output="$( run_sysdb -H "$SOCKET_FILE" \
- -c "LOOKUP hosts WHERE attribute.invalid = 'none'" )"
+ -c "LOOKUP hosts MATCHING attribute.invalid = 'none'" )"
echo $output | grep -E '^\[\]$'
+run_sysdb -H "$SOCKET_FILE" \
+ -c "TIMESERIES 'invalid.host'.'invalid-metric'" && exit 1
+
+# Does not work yet since there is no fetcher plugin.
+run_sysdb -H "$SOCKET_FILE" \
+ -c "TIMESERIES 'some.host.name'.'foo/bar/qux'" && exit 1
+
stop_sysdbd