engine-deprecated icon indicating copy to clipboard operation
engine-deprecated copied to clipboard

Include link to SQL Querying Examples & Syntax Reference

Open ricardobaeta opened this issue 7 years ago • 2 comments

I would be pretty happy if a SQL Query Examples URL could be included on the cli output when running srcd sql --help. It would look something like:

Run a SQL query over the analyzed repositories.

Examples:
  https://docs.sourced.tech/gitbase/using-gitbase/examples

Usage:
  srcd sql [flags]

Flags:
  -h, --help   help for sql

Global Flags:
      --config string   config file (default is $HOME/.srcd.yaml)
  -v, --verbose         if true, log all of the things

We have this reference pretty visible on the web sql and I believe that being on the cli shouldn't degrade this specific usability detail

Moreover, I think it would be great to have some feedforward on SQL Syntax errors, like:

rpc error: code = Unknown desc = SQL query failed: Error 1105: unknown error: syntax error at position 10
SQL Syntax Reference https://sql.syntax.reference/

ricardobaeta avatar Nov 05 '18 20:11 ricardobaeta

@smola shall we move this issue to engine?

ajnavarro avatar Dec 12 '18 14:12 ajnavarro

@ajnavarro Transferred.

cc @campoy

smola avatar Dec 12 '18 16:12 smola