Index democracy proposals

[stephanie-olp]

Right now we only have the ongoing democracy proposals.
We would like to have all proposals, the ongoing, the one that passed but also the one that got canceled

[silva-fj]

We have some data available (here) with the following query:

query DemocracyProposalsQuery {
  substrateDemocracyProposals(limit: 10, where: {network_eq: polkadot}) {
    id
    rootAccount
    proposalIndex
    date
    blockNumber
    amount
    account {
      id
    }
  }
}

Notes on the things we can improve and missing data:

• It is a bit hard to understand what some fields represent without looking into the code, for example rootAccount (which is the address hex string of the extrinsic's signer) and account with an Id which is the public address of the extrinsic's signer). In the context of a proposal this is the proposer.
• We can rename amount with lockedAmount or deposit to make it a bit more explicit.
• We can also add some more info like the MetaCall info (method, section, meta and args) which helps to add more context
• We could also add at least a count of accounts that have Endorsed/seconded the proposal.
• We can also add a status field (for example when the proposal moves to Referendum, was rejected, etc), we should also keep record of the dates the status was changed

[silva-fj]

@geastwood FYI

[stephanie-olp]

Data that need to be indexed (can change) :

• Proposal ID
• Title of the proposal (if there is one)
• Type of action (module)
• Proposal Description (if there is one)
• Proposal hash
• Date of creation
• Date of the last update
• Proposal author
• Proposal status
• Deposit
• Number of people who endorsed that proposal and who they are
• Link to Polkassembly discussion

[stephanie-olp]