contrib/find-duplicate-usernames.sh

#!/bin/bash
# Copyright (C) 2021 The Android Open Source Project
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
usage() {
  f="$(basename -- $0)"
  cat <<EOF
Usage:
    cd /path/to/All-Users.git
    "$f [username|gerrit|external]"

This script finds duplicate usernames only differing in case in the given
account schema ("username", "gerrit" or "external") and their respective accountIds.
EOF
  exit 1
}

if [[ "$#" -ne "1" ]] || ! [[ "$1" =~ ^(gerrit|username|external)$ ]]; then
  usage
fi

if [ -z "$(git ls-remote . refs/meta/external-ids)" ]; then
  cat <<EOF
Could not find 'refs/meta/external-ids' in the local repository.

Please fetch it using:

  git fetch "$(git remote)" refs/meta/external-ids:refs/meta/external-ids

EOF
  exit 1
fi

# 1. find lines with user name and subsequent line in external-ids notes branch
#    example output of git grep -A1 "\[externalId \"username:" refs/meta/external-ids:
#    refs/meta/external-ids:00/1d/abd037e437f71d42134e6ad532a06948a2ba:[externalId "username:johndoe"]
#    refs/meta/external-ids:00/1d/abd037e437f71d42134e6ad532a06948a2ba-      accountId = 1000815
#    --
#    refs/meta/external-ids:00/1f/0270fc2a6fc3a2439c454c8ab0c75323fdb0:[externalId "username:JohnDoe"]
#    refs/meta/external-ids:00/1f/0270fc2a6fc3a2439c454c8ab0c75323fdb0-      accountId = 1000816
#    --
# 2. remove group separators
# 3. remove line break between user name and accountId lines
# 4. unify separators to ":"
# 5. cut on ":", select username and accountId fields
# 6. sort case-insensitive
# 7. flip columns
# 8. uniq case-insensitive, only show duplicates, avoid comparing first field
# 9. flip columns back
git grep -A1 "\[externalId \"$1:" refs/meta/external-ids -- \
  | sed -E "/$1/,/accountId/!d" \
  | paste -d ' ' - - \
  | tr \"= : \
  | cut -d: --output-delimiter="" -f 5,8 \
  | sort -f \
  | sed -E "s/(.*) ([0-9]+)/\2 \1/" \
  | uniq -Di -f1 \
  | sed -E "s/([0-9]+) (.*)/\2 \1/"