Test Index Contributor backend script

[ladissi]

Overview

Test index contributor query code that identified which organizations are index contributors by creating a test repository and organization where we can toggle the civictechindex topic tag. Additionally verify why all results are not showing up in UI.

Action Items

• [x] verify script logic in fact pulls projects with the civictechindex topic tag
• [x] check why script results yield a higher count of orgs than what are shown on the website

Resources/Instructions

[fyliu]

For the issue of the script yielding more orgs than the website shows, it's because some orgs are not yet marked as approved in the backend django admin.

Here's a screenshot of my local environment where I changed all 13 cti contributor orgs to approved. This is the same number found by the script.

click to expand


[fyliu]

I have completed testing the script logic. Here are my steps and observations:

1. Created a test org (with name added) and test repo with topic tag civictechindex
   click to expand

2. Ran script

Observed: the test org was added by the script

click to expand

``` ==========Script Start========== Creating a set of organizations that have the topic tag -> topic:civictechindex Successfully retrieved the following org -> dict_keys(['OpenOakland', 'Code for PDX', 'Hack for LA', 'Civic Tech Index', 'EnCiv', 'Code for Chapel Hill', 'Code for Tulsa', 'Yale OpenLab', 'Code for Kansas City', '100 Automations', 'BetaNYC', 'Code for Buffalo', "Hack for LA's Sandbox", 'Civic Tech Test Org']) Find civic tech organizations and update their cti_contributor column value Find and Update Complete Add new organizations to database -> {'Civic Tech Test Org': Organization(login="civictechtestorg")} Add new organizations complete ==========Script End============ ```

3. Approved the test org in the backend
   click to expand

Observed: test org was added to the frontend as a cti contributor. 14 total

click to expand


4. Removed the topic tag from the test repo and ran script again
   click to expand

==========Script Start==========
Creating a set of organizations that have the topic tag -> topic:civictechindex
Successfully retrieved the following org -> dict_keys(['OpenOakland', 'Code for PDX', 'Hack for LA', 'Civic Tech Index', 'EnCiv', 'Code for Chapel Hill', 'Code for Tulsa', 'Yale OpenLab', 'Code for Kansas City', '100 Automations', 'BetaNYC', 'Code for Buffalo', "Hack for LA's Sandbox"])
Find civic tech organizations and update their cti_contributor column value
Find and Update Complete
==========Script End============

5. Refreshed backend admin panel

Observed: the test org was removed from the backend and frontend 13 total Update: the organization was not removed from the database, but only hidden because of the view filter being applied showing only CTI CONTRIBUTORS.

click to expand

 

[fyliu]

To answer the questions we had during the meeting:

1. The script updates the CTI Contributor flag for existing organization in the database when projects belonging to organizations add and remove the civictechindex tag.
2. The script adds an organization with the CTI Contributor flag set to true when it find a new one in the github search that's not already in the database.
3. Once added, organizations are not removed from the database. Their CTI Contributor flag get updated to false if they remove the civictechindex tag from all their projects.

[kevindphan]

Kevin and Levi will talk about this further in depth.