get_repo_author.sh
53d586501484master

get_repo_author.sh
View Options

			#!/bin/bash

			REPO_ID=$1
			DB="phabricator_repository"
			HOST="c4science-db01"

			SQL="select u.username, u.email from phabricator_repository.repository_transaction as t, phabricator_repository.repository as r, phabricator_user.user_externalaccount as u where u.username is not NULL and u.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"