Page MenuHomec4science

get_repo_info.sh
No OneTemporary

File Metadata

Created
Tue, Apr 30, 11:41

get_repo_info.sh

#!/bin/bash
REPO_ID=$1
DB="phabricator_repository"
HOST="c4science-db01"
SQL="select r.name, concat('@', u.userName), e.email from phabricator_repository.repository_transaction as t, phabricator_repository.repository as r, phabricator_user.user_externalaccount as e, phabricator_user.user as u where e.username is not NULL and u.phid=e.userPHID and e.userPHID=t.authorPHID and r.phid=t.objectPHID and r.id=$REPO_ID and t.transactionType='core:create' limit 1;"
ssh -n $HOST "mysql -B -e \"$SQL\" $DB"

Event Timeline