summaryrefslogtreecommitdiffstats
path: root/Documentation/pgm-gsql.txt
blob: 938aafd2e0bec4650e3c92a3eae8a66596c26fda (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
gsql
====

NAME
----
gsql - Administrative interface to idle database

SYNOPSIS
--------
[verse]
'java' -jar gerrit.war 'gsql' -d <SITE_PATH>

DESCRIPTION
-----------
Interactive query support against the configured SQL database.
All SQL statements are supported, including SELECT, UPDATE, INSERT,
DELETE and ALTER.

This command is primarily intended to access a local H2 database
which is not currently open by a Gerrit daemon.  To access an open
database use link:cmd-gsql.html[gerrit gsql] over SSH.

OPTIONS
-------

-d::
\--site-path::
	Location of the gerrit.config file, and all other per-site
	configuration data, supporting libaries and log files.

CONTEXT
-------
This command can only be run on a server which has direct
connectivity to the metadata database, and local access to the
managed Git repositories.

EXAMPLES
--------
To manually correct a user's SSH user name:

====
	$ java -jar gerrit.war 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
====

GERRIT
------
Part of link:index.html[Gerrit Code Review]