- Make sure that the current JSON is imported into
allprjdatabase right before generating a new task. You can edit the cron-job and only specify to import JSON without regenerating TSDB. - 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\,+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'. - Generate data for new/first-time committers 2 months for Prometheus projects:
ONLY='prometheus' TASKS='unknown_committers' ./affs/all_tasks_new.sh '2 months'. - Generate data for new/first-time contributors for the last 6 months for 'All CNCF' project:
ONLY='allprj' TASKS='unknown_contributors' ./affs/all_tasks_new.sh '6 months'. - Delete reporting pod:
helm delete devstats-prod-reports. UsedevstatsURL forprodandteststatsfortest. - Go to
cncf/gitdm:src:wget https://devstats.cncf.io/backups/keylime_unknown_contributors.csv,wget https://devstats.cncf.io/backups/allprj_unknown_contributors_new.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.