jiagengliu

SELECT
  repo.name as repo,
  type,
  created_at,
  actor.login,
  JSON_VALUE(payload, '$.action') as action,
  -- *** PR columns
  JSON_VALUE(payload, '$.pull_request.node_id') as pr_node_id,
  JSON_VALUE(payload, '$.pull_request.state') as pr_state,
  JSON_VALUE(payload, '$.pull_request.user.login') as pr_user_login,

jiagengliu

Cardano Pool Ranking in Daedalus

DISCLAIMER: The following example is based on the Chapter 4.3 and 5.6 in latest design spec and the Ranking Specification. But it seems that the ranking mechanism specified in the Design Specification, and explained below, is not fully implemented and/or enabled or I missed some of the details of the spec (more realistic assumption). Also, I have not checked what is the difference between the design doc and the current implementation of the haskell code to check if there is any difference, or I misinterpreted some of the both sources (design doc, haskell code). Anyway, I will check the code when I have some spare time.

UPDATED 09/23/2020

Layman explanation

The pool ranking in wallet is based on the stake the user intend to delegate and the expected `