| 1 | #!/usr/bin/env bash |
| 2 | set -euo pipefail |
| 3 | |
| 4 | CH_HOST="${CH_HOST:-clickhouse}" |
| 5 | CH_USER="${CH_USER:-default}" |
| 6 | CH_PASSWORD="${CH_PASSWORD:-netdata}" |
| 7 | |
| 8 | clickhouse-client --host "$CH_HOST" --user "$CH_USER" --password "$CH_PASSWORD" --query "CREATE DATABASE IF NOT EXISTS netdata" |
| 9 | clickhouse-client --host "$CH_HOST" --user "$CH_USER" --password "$CH_PASSWORD" --query "CREATE TABLE IF NOT EXISTS netdata.test (id UInt64, value String) ENGINE=MergeTree() ORDER BY id" |
| 10 | clickhouse-client --host "$CH_HOST" --user "$CH_USER" --password "$CH_PASSWORD" --query "INSERT INTO netdata.test VALUES (1,'a'), (2,'b'), (3,'c')" |
| 11 | clickhouse-client --host "$CH_HOST" --user "$CH_USER" --password "$CH_PASSWORD" --query "SELECT count() FROM netdata.test" |
| 12 | clickhouse-client --host "$CH_HOST" --user "$CH_USER" --password "$CH_PASSWORD" --query "SELECT * FROM netdata.test WHERE id > 0" |
| 13 | |
| 14 | sleep 1 |