12345678910111213141516171819202122 |
- # Query for Gerrit Code Review gsql to produce the .git/gerrit_committers
- # file for a project. Needing to do this manually is a horrible hack.
-
- SELECT a.account_id,
- u.external_id,
- a.full_name,
- b.email_address,
- r.added_on,
- r.removed_on
- FROM accounts a,
- account_external_ids b,
- account_groups g,
- account_group_members_audit r,
- account_external_ids u
- WHERE a.account_id = b.account_id
- AND b.email_address IS NOT NULL
- AND r.account_id = a.account_id
- AND r.group_id = g.group_id
- AND u.account_id = a.account_id
- AND u.external_id like 'username:%'
- AND g.name = 'technology.jgit-committers'
- ORDER BY a.full_name, r.added_on;
|