NAME
gerrit gsql - Administrative interface to active database
SYNOPSIS
ssh -p <port> <host> gerrit gsql [--format {PRETTY | JSON | JSON_SINGLE}] [-c QUERY]
DESCRIPTION
Provides interactive query support directly against the underlying SQL database used by the host Gerrit server. All SQL statements are supported, including SELECT, UPDATE, INSERT, DELETE and ALTER.
OPTIONS
- --format
-
Set the format records are output in. In PRETTY (the default) records are displayed in a tabular output suitable for reading by a human on a sufficiently wide terminal. In JSON mode records are output as JSON objects using the column names as the property names, one object per line. In JSON_SINGLE mode the whole result set is output as a single JSON object.
- -c
-
Execute the single query statement supplied, and then exit.
ACCESS
Caller must have been granted the Access Database global capability.
SCRIPTING
Intended for interactive use only, unless format is JSON, or JSON_SINGLE.
EXAMPLES
To manually correct a user’s SSH user name:
$ ssh -p 29418 review.example.com gerrit gsql Welcome to Gerrit Code Review v2.0.25 (PostgreSQL 8.3.8) Type '\h' for help. Type '\r' to clear the buffer. gerrit> update accounts set ssh_user_name = 'alice' where account_id=1; UPDATE 1; 1 ms gerrit> \q Bye $ ssh -p 29418 review.example.com gerrit flush-caches --cache sshkeys --cache accounts
Part of Gerrit Code Review