Remove Kubecost references for the OpenCost project

[mattray]

The OpenCost project originated there, but nothing related to OpenCost has been done in those repositories since June of 2022

[lukaszgryglicki]

If we merge this, it will remove all open cost references, including past - is this what you want? If so I'll merge and regenerate data. @mattray ?

[lukaszgryglicki]

I did additional updates in post-merge (in this repo and other repos) - will now physically remove data from this org from DevStats dashboards.

[lukaszgryglicki]

Are you sure want to delete all data from kubecost org?

See - most of data comes from it, if we delete this you will be left with just 3 repos.

See stats for all current repos (data starts on 2018-11-27):

opencost=# select dup_repo_name, min(created_at) as first_event, count(*) as events from gha_events group by 1 order by 2;
               dup_repo_name                |     first_event     | events 
--------------------------------------------+---------------------+--------
 kubecost/cost-analyzer                     | 2018-11-21 07:01:29 |   1107
 kubecost/cost-analyzer-helm-chart          | 2018-11-23 14:09:58 |  27523
 kubecost/cost-model                        | 2019-03-27 21:49:05 |  12330
 kubecost/docs                              | 2019-04-18 17:52:49 |  11183
 kubecost/conntrack-parser                  | 2019-07-13 20:52:41 |      8
 kubecost/blog                              | 2019-08-04 22:59:48 |   1108
 kubecost/staging-repo                      | 2020-03-06 00:30:29 |    202
 kubecost/cluster-turndown                  | 2020-03-23 20:38:19 |    689
 kubecost/cloudformation                    | 2020-10-28 01:05:30 |    143
 kubecost/partner-charts                    | 2020-11-13 23:31:45 |     29
 kubecost/rancher-helm-chart                | 2020-12-08 17:35:21 |     25
 kubecost/etl-backup                        | 2020-12-09 03:59:50 |     29
 kubecost/kubectl-cost                      | 2021-03-29 18:27:20 |   1829
 kubecost/kubecost-lens-extension           | 2021-05-30 00:27:20 |    161
 kubecost/kubecost-ssp-addon                | 2021-12-09 23:30:49 |     13
 kubecost/integrations                      | 2022-01-13 22:12:51 |      3
 kubecost/kubernetes-hackfest               | 2022-02-03 20:41:51 |      8
 kubecost/azure-hackfest-lab                | 2022-03-23 17:50:07 |     13
 kubecost/events                            | 2022-03-29 20:46:05 |    110
 kubecost/kubecost-eks-blueprints-addon     | 2022-04-12 22:12:49 |     20
 kubecost/poc-common-configurations         | 2022-04-29 18:55:39 |   1006
 kubecost/opencost                          | 2022-06-02 03:37:41 |   1682
 kubecost/opencost-website                  | 2022-06-02 15:38:03 |    630
 kubecost/style-changes                     | 2022-07-11 14:11:36 |      3
 kubecost/Thomas-Test                       | 2022-07-15 01:08:43 |      5
 opencost/opencost                          | 2022-07-15 01:45:05 |  13407
 kubecost/openshift-helm-chart              | 2022-08-11 16:41:24 |    277
 kubecost/gcp-marketplace-community         | 2022-10-11 23:39:02 |     10
 kubecost/gcp-marketplace                   | 2022-10-20 15:19:18 |     49
 opencost/opencost-website                  | 2022-11-23 12:58:43 |   1185
 opencost/opencost-helm-chart               | 2022-12-13 05:49:32 |   1547
 kubecost/kubecost-grafana-json-integration | 2023-02-23 12:30:33 |     50
 kubecost/cost-prediction-action            | 2023-04-11 20:11:54 |     52
 kubecost/kubecost-success                  | 2023-07-27 13:33:27 |    140
 kubecost/kubecost-cloud-agent              | 2023-08-24 19:37:31 |    123
 kubecost/.github                           | 2023-09-19 15:22:23 |      6
 kubecost/feature-requests                  | 2023-09-21 14:21:03 |      2
 kubecost/features-bugs                     | 2023-10-05 15:15:02 |    154
 kubecost/golang-migrate-duckdb             | 2023-10-13 00:34:49 |      2
 kubecost/kubecost-cloud-tarballs           | 2023-11-12 13:54:17 |      4
(40 rows)

While if we delete all from kubecost org you will be left with (data starts on 2022-07-15):

opencost=# select dup_repo_name, min(created_at) as first_event, count(*) as events from gha_events where dup_repo_name like 'opencost%' group by 1 order by 2;
        dup_repo_name         |     first_event     | events 
------------------------------+---------------------+--------
 opencost/opencost            | 2022-07-15 01:45:05 |  13407
 opencost/opencost-website    | 2022-11-23 12:58:43 |   1185
 opencost/opencost-helm-chart | 2022-12-13 05:49:32 |   1547
(3 rows)

Please confiurm that you want to drop all this data from the DB and then regenerate all dashboards.

[lukaszgryglicki]

Confirmed on slack, proceeding.

[lukaszgryglicki]

Done.