Skip to content

nxthdr/chbot

Repository files navigation

chbot

Simple Discord bot to query chproxy.

Usage: chbot [OPTIONS] --user <USER> --password <PASSWORD> --token <TOKEN>

Options:
      --url <URL>                    [default: https://clickhouse.nxthdr.dev]
  -u, --user <USER>                  ClickHouse user
  -p, --password <PASSWORD>          ClickHouse password
  -t, --token <TOKEN>                Discord bot token
      --output-limit <OUTPUT_LIMIT>  Max output lines [default: 10]
  -v, --verbose...                   Increase logging verbosity
  -q, --quiet...                     Decrease logging verbosity
  -h, --help                         Print help
  -V, --version                      Print version

SQL query checks

The app will parse the SQL query and:

  • append LIMIT <output-limit> clause, overriding existing if it exceeds the limit
  • append FORMAT CSVWithNames for compatibility with the result prettifier, overriding it if necessary