- On the
prodnode run:helm install devstats-prod-reports ./devstats-helm --set skipSecrets=1,skipPVs=1,skipBackupsPV=1,skipVacuum=1,skipBackups=1,skipBootstrap=1,skipProvisions=1,skipCrons=1,skipAffiliations=1,skipGrafanas=1,skipServices=1,skipPostgres=1,skipIngress=1,skipStatic=1,skipAPI=1,skipNamespaces=1,reportsPod=1,namespace='devstats-prod'. - On the
testnode run:helm install devstats-test-reports ./devstats-helm --set skipSecrets=1,skipPVs=1,skipBackupsPV=1,skipVacuum=1,skipBackups=1,skipBootstrap=1,skipProvisions=1,skipCrons=1,skipAffiliations=1,skipGrafanas=1,skipServices=1,skipPostgres=1,skipIngress=1,skipStatic=1,skipAPI=1,skipNamespaces=1,reportsPod=1,projectsOverride='+cncf\,+opencontainers\,+istio\,+knative\,+zephyr\,+linux\,+rkt\,+sam\,+azf\,+riff\,+fn\,+openwhisk\,+openfaas\,+cii\,+prestodb\,+godotengine'. - Shell into reporting pod:
../devstats-k8s-lf/util/pod_shell.sh devstats-reportsork exec -itn devstats-prod devstats-reports -- bashfrom a different namespace (likedevstats-test). - Generate data for all time for a given project(s):
TASKS='unknown_contributors' ONLY='keylime tuf' ./affs/all_tasks.sh. - Generate data for recent 3 months for all projects:
TASKS='unknown_contributors' ONLY='allprj' ./affs/all_tasks_recent.sh '3 months'. - Delete reporting pod:
helm delete devstats-prod-reports. User devstats URL forprodandteststatsfortest. - Go to
cncf/gitdm:src:wget https://devstats.cncf.io/backups/keylime_unknown_contributors.csv - Go to
cncf/gitdm:src:wget https://teststats.cncf.io/backups/allprj_unknown_contributors_recent.csv - Check for forbidden SHAs:
./check_shas keylime_unknown_contributors.csv. - Check for forbidden SHAs:
./check_shas allprj_unknown_contributors_recent.csv. - Generate a task file:
PG_PASS=... ./unknown_committers.rb keylime_unknown_contributors.csv; mv task.csv keylime_task.csv. - Generate a task file:
PG_PASS=... ./unknown_committers.rb allprj_unknown_contributors_recent.csv; mv task.csv allprj_task.csv. - Merge multiple tasks:
./csv_merge.rb commits task.csv *_task.csv - Upload
task.csvto a Google Sheet.