feat: track historical power events

[sameh-farouk]

What's Changed:

• Track Historical PowerStateChanged events
• Track Historical PowerTargetChnaged events
• New PostgreSQL DB tables power_target_report and power_state_report. please see the DB migration file for new available tables/columns.

Related issues:

133

query MyQuery {
  powerTargetReports(limit: 5) {
    nodeID
    newPowerTarget
    id
    farmID
    block
    timestamp
  }
}

{
  "data": {
    "powerTargetReports": [
      {
        "nodeID": 73,
        "newPowerTarget": "Up",
        "id": "0004432042-000007-31075",
        "farmID": 57,
        "block": 4432042,
        "timestamp": "1675849968"
      },
      {
        "nodeID": 73,
        "newPowerTarget": "Up",
        "id": "0004432085-000002-020ca",
        "farmID": 57,
        "block": 4432085,
        "timestamp": "1675850226"
      },
      {
        "nodeID": 73,
        "newPowerTarget": "Up",
        "id": "0004432130-000007-171db",
        "farmID": 57,
        "block": 4432130,
        "timestamp": "1675850496"
      },
      {
        "nodeID": 73,
        "newPowerTarget": "Up",
        "id": "0004432167-000006-251d8",
        "farmID": 57,
        "block": 4432167,
        "timestamp": "1675850718"
      },
      {
        "nodeID": 73,
        "newPowerTarget": "Down",
        "id": "0004432192-000002-d9064",
        "farmID": 57,
        "block": 4432192,
        "timestamp": "1675850868"
      }
    ]
  }
}

query MyQuery {
  powerStateReports(limit: 5) {
    block
    id
    farmID
    newPowerStatus
    nodeID
    timestamp
  }
}

{
  "data": {
    "powerStateReports": [
      {
        "block": 4536854,
        "id": "0004536854-000002-394b1",
        "farmID": 53,
        "newPowerStatus": "Down",
        "nodeID": 76,
        "timestamp": "1676479614"
      },
      {
        "block": 4536909,
        "id": "0004536909-000002-5347e",
        "farmID": 53,
        "newPowerStatus": "Down",
        "nodeID": 77,
        "timestamp": "1676479944"
      },
      {
        "block": 4537230,
        "id": "0004537230-000002-abb0e",
        "farmID": 53,
        "newPowerStatus": "Down",
        "nodeID": 77,
        "timestamp": "1676481870"
      },
      {
        "block": 4537284,
        "id": "0004537284-000002-caf31",
        "farmID": 53,
        "newPowerStatus": "Down",
        "nodeID": 78,
        "timestamp": "1676482194"
      },
      {
        "block": 4537605,
        "id": "0004537605-000002-a888a",
        "farmID": 53,
        "newPowerStatus": "Down",
        "nodeID": 78,
        "timestamp": "1676484120"
      }
    ]
  }
}