Migrate core data fetching from RPCs to The Graph subgraph

[ECWireless]

Things to Try to Include in Current Subgraph

api/l1delegator/[address].tsx

• bondingManagerAddress
• roundsManagerAddress
• currentRound
• pendingStake
• pendingFees
• delegator
• lock
• transcoderStatus

EDIT: DON'T WORRY ABOUT THIS AS IT PERTAINS TO MAINNET

pages/migrate/broadcaster.tsx

• submissionPrice
• getMigrateSenderParams

EDIT: DON'T WORRY ABOUT THIS AS IT THESE PAGES ARE PLANNED TO BE REMOVED

pages/migrate/orchestrator.tsx

• getMigrateDelegatorParams

EDIT: DON'T WORRY ABOUT THIS AS IT THESE PAGES ARE PLANNED TO BE REMOVED

lib/api/contracts.ts

• getContract -> may be worth adding something like a protocol AddressBook schema to the subgraph

api/current-round.tsx

• currentRound -> https://github.com/livepeer/subgraph/blob/main/schema.graphql#L34
• currentRoundStartBlock -> https://github.com/livepeer/subgraph/blob/main/schema.graphql#L151
• currentRoundInitialized -> https://github.com/livepeer/subgraph/blob/main/schema.graphql#L147

api/pending-stake.tsx

• currentRound -> https://github.com/livepeer/subgraph/blob/main/schema.graphql#L34
• pendingStake
• pendingFees

api/treasury/proposal/[proposalId]/state.tsx

• clock -> What does this number refer to?
• proposalSnapshot -> What does this number refer to?
• getPastTotalSupply -> What does this number refer to?
• proposalVotes -> part of feat(treasury): index governor votes and tallies subgraph#175
• state -> What does this number refer to?
• quorum -> Unsure where to get this
• quota -> Unsure where to get this

api/treasury/proposal/[proposalId]/votes.tsx

• clock -> What does this number refer to?
• proposalSnapshot -> What does this number refer to?
• getVotes -> Likely can't get this from subgraph
• getPastVotes -> Part of feat(treasury): index governor votes and tallies subgraph#175
• hasVoted -> Part of feat(treasury): index governor votes and tallies subgraph#175
• delegatedAt -> https://github.com/livepeer/subgraph/blob/main/schema.graphql#L189

api/treasury/votes/[address].tsx

• proposalThreshold -> What does this number refer to?
• getPastVotes -> Part of feat(treasury): index governor votes and tallies subgraph#175
• delegates -> Likely https://github.com/livepeer/subgraph/blob/main/schema.graphql#L189

api/treasury/votes/[address]/registered.tsx

• getDelegator -> https://github.com/livepeer/subgraph/blob/main/schema.graphql#L189 and https://github.com/livepeer/subgraph/blob/main/schema.graphql#L205
• hasCheckpoint -> Not positive, but believe it's this: https://github.com/livepeer/subgraph/blob/main/schema.graphql#L104

---

Also resolve this security issue: https://github.com/livepeer/explorer/security/advisories/GHSA-34gq-95m4-v244

[ECWireless]

Best Candidates for RPC -> The Graph

@rickstaa

New AddressBook Entity Type

• For core contract addresses
• These contracts:

LivepeerTokenFaucet
BondingManager
RoundsManager
Minter
MerkleSnapshot
ServiceRegistry
TicketBroker
LivepeerGovernor
Treasury
BondingVotes

• Honestly, not a priority. But would mean slightly less RPC calls

Pending Stake and Fees

• pendingStake
• pendingFees
• Could probably be added to the Delegator entity type

More Treasury Data

api/treasury/proposal/[proposalId]/state.tsx

• clock -> What does this number refer to?
• proposalSnapshot -> What does this number refer to?
• getPastTotalSupply -> What does this number refer to?
• proposalVotes -> part of feat(treasury): index governor votes and tallies subgraph#175
• state -> What does this number refer to?
• quorum -> Unsure where to get this
• quota -> Unsure where to get this

api/treasury/proposal/[proposalId]/votes.tsx

• clock -> What does this number refer to?
• proposalSnapshot -> What does this number refer to?
• getVotes -> Likely can't get this from subgraph
• getPastVotes -> Part of feat(treasury): index governor votes and tallies subgraph#175
• hasVoted -> Part of feat(treasury): index governor votes and tallies subgraph#175
• delegatedAt -> https://github.com/livepeer/subgraph/blob/main/schema.graphql#L189

api/treasury/votes/[address].tsx

• proposalThreshold -> What does this number refer to?
• getPastVotes -> Part of feat(treasury): index governor votes and tallies subgraph#175
• delegates -> Likely https://github.com/livepeer/subgraph/blob/main/schema.graphql#L189

api/treasury/votes/[address]/registered.tsx

• getDelegator -> https://github.com/livepeer/subgraph/blob/main/schema.graphql#L189 and https://github.com/livepeer/subgraph/blob/main/schema.graphql#L205
• hasCheckpoint -> Not positive, but believe it's this: https://github.com/livepeer/subgraph/blob/main/schema.graphql#L104