Add Base contracts to OSS Directory

[ccerv1]

Here is a great initial source of contracts that includes all RetroPGF3 projects on Base we can start with

[ethzoomer]

Where should they be added? Into the project yaml files formatted like this: ?

- address: "0x..." tags: - contract networks: - base

[ryscheng]

I'd suggest down-scoping this to a 1, just testing with a couple of projects

[ccerv1]

Super easy to identify tagged deployers on other chains with a query like this:

WITH deployers AS (
  SELECT DISTINCT
    artifact_source_id,
    project_name 
  FROM `oso.artifacts_by_project_v1`
  WHERE artifact_type = 'DEPLOYER' 
)

SELECT
  deployers.project_name,
  b.deployer_address,
  COUNT(DISTINCT b.contract_address) AS count_contracts
FROM deployers
JOIN `oso.stg_base__deployers` b
  ON deployers.artifact_source_id = b.deployer_address
GROUP BY 1,2
ORDER BY 3 DESC

Will test a few projects now...

[ccerv1]

Currently blocked on #1428

[ccerv1]

opensource-observer/oss-directory#286