search

pinax-network / subgraph-antelope-transactions

Subgraph Antelope Transactions
https://thegraph.com/explorer/subgraphs/4bAe7NA8b6J14ZfZr3TXfzzjjSoGECTFuqv7CwnK1zzg?view=Query&chain=arbitrum-one
MIT License
0 stars 0 forks source link

`DbOp` not linking properly to `Action` #3

Closed DenisCarriere closed 1 week ago

DenisCarriere commented 2 weeks ago

Issue, missing DbOps in second actions

GraphQL

{
  transactions(first: 5, where: {dbOps_: {code: "eosio.token"}}) {
    hash
    index
    actions {
      account
      name
      jsonData
      ordinal
      dbOps {
        code
        scope
        tableName
        primaryKey
        newDataJson
        actionOrdinal
      }
    }
  }
}

Result

{
  "data": {
    "transactions": [
      {
        "actions": [
          {
            "account": "sportbet1bet",
            "dbOps": [],
            "id": "00068330336477b4e575b3a65da6a523806fa9fd0eab26098185bd0f9b24e51b:1",
            "jsonData": "{\"bet_id\":1392493,\"reason\":\"Win #1392493\",\"status\":6}",
            "name": "complete",
            "ordinal": "1"
          },
          {
            "account": "sportbet1bet",
            "dbOps": [],
            "id": "00068330336477b4e575b3a65da6a523806fa9fd0eab26098185bd0f9b24e51b:2",
            "jsonData": "{\"account\":\"sbetpscgm1ms\",\"bet_id\":1392493,\"msg\":\"Win #1392493\"}",
            "name": "notify",
            "ordinal": "2"
          },
          {
            "account": "eosio.token",
            "dbOps": [
              {
                "actionOrdinal": "3",
                "code": "eosio.token",
                "id": "00068330336477b4e575b3a65da6a523806fa9fd0eab26098185bd0f9b24e51b:2",
                "newDataJson": "{\"balance\":\"127992.1348 EOS\"}",
                "primaryKey": "........ehbo5",
                "scope": "sportbet1bet",
                "tableName": "accounts"
              },
              {
                "actionOrdinal": "3",
                "code": "eosio.token",
                "id": "00068330336477b4e575b3a65da6a523806fa9fd0eab26098185bd0f9b24e51b:3",
                "newDataJson": "{\"balance\":\"839.9256 EOS\"}",
                "primaryKey": "........ehbo5",
                "scope": "sbetpscgm1ms",
                "tableName": "accounts"
              }
            ],
            "id": "00068330336477b4e575b3a65da6a523806fa9fd0eab26098185bd0f9b24e51b:3",
            "jsonData": "{\"from\":\"sportbet1bet\",\"to\":\"sbetpscgm1ms\",\"quantity\":\"194.9826 EOS\",\"memo\":\"Win #1392493\"}",
            "name": "transfer",
            "ordinal": "3"
          },
          {
            "account": "eosio.token",
            "dbOps": [],
            "id": "00068330336477b4e575b3a65da6a523806fa9fd0eab26098185bd0f9b24e51b:4",
            "jsonData": "{\"from\":\"sportbet1bet\",\"to\":\"sportbetdivs\",\"quantity\":\"2.9542 EOS\",\"memo\":\"dividends\"}",
            "name": "transfer",
            "ordinal": "4"
          },
          {
            "account": "eosio.token",
            "dbOps": [],
            "id": "00068330336477b4e575b3a65da6a523806fa9fd0eab26098185bd0f9b24e51b:5",
            "jsonData": "{\"from\":\"sportbet1bet\",\"to\":\"sportbetlead\",\"quantity\":\"0.4923 EOS\",\"memo\":\"leaderboard\"}",
            "name": "transfer",
            "ordinal": "5"
          }
        ],
        "hash": "00068330336477b4e575b3a65da6a523806fa9fd0eab26098185bd0f9b24e51b",
        "index": "16"
      },
      {
        "actions": [
          {
            "account": "eosio",
            "dbOps": [
              {
                "actionOrdinal": "1",
                "code": "eosio.token",
                "id": "000786e3be4e9bd69b6a010893e0a064c2b4830fc2c89d7257dda7d3adb999f8:12",
                "newDataJson": "{\"balance\":\"306.8350 EOS\"}",
                "primaryKey": "........ehbo5",
                "scope": "sportbet1res",
                "tableName": "accounts"
              },
              {
                "actionOrdinal": "1",
                "code": "eosio.token",
                "id": "000786e3be4e9bd69b6a010893e0a064c2b4830fc2c89d7257dda7d3adb999f8:13",
                "newDataJson": "{\"balance\":\"1.2073 EOS\"}",
                "primaryKey": "........ehbo5",
                "scope": "eosio.fees",
                "tableName": "accounts"
              }
            ],
            "id": "000786e3be4e9bd69b6a010893e0a064c2b4830fc2c89d7257dda7d3adb999f8:1",
            "jsonData": "{\"cpu_frac\":290104317,\"days\":1,\"max_payment\":\"0.0019 EOS\",\"net_frac\":0,\"payer\":\"sportbet1res\",\"receiver\":\"sportbetdivs\"}",
            "name": "powerup",
            "ordinal": "1"
          },
          {
            "account": "eosio.token",
            "dbOps": [],
            "id": "000786e3be4e9bd69b6a010893e0a064c2b4830fc2c89d7257dda7d3adb999f8:2",
            "jsonData": "{\"from\":\"sportbet1res\",\"to\":\"eosio.fees\",\"quantity\":\"0.0019 EOS\",\"memo\":\"transfer from sportbet1res to eosio.fees\"}",
            "name": "transfer",
            "ordinal": "2"
          },
          {
            "account": "eosio.reserv",
            "dbOps": [],
            "id": "000786e3be4e9bd69b6a010893e0a064c2b4830fc2c89d7257dda7d3adb999f8:3",
            "jsonData": "{\"fee\":\"0.0019 EOS\",\"powup_cpu\":110766503,\"powup_net\":0}",
            "name": "powupresult",
            "ordinal": "3"
          },
          {
            "account": "eosio",
            "dbOps": [],
            "id": "000786e3be4e9bd69b6a010893e0a064c2b4830fc2c89d7257dda7d3adb999f8:4",
            "jsonData": "{\"fee\":\"0.0019 EOS\",\"memo\":\"buy powerup\",\"protocol\":\"eosio.powup\"}",
            "name": "logsystemfee",
            "ordinal": "4"
          }
        ],
        "hash": "000786e3be4e9bd69b6a010893e0a064c2b4830fc2c89d7257dda7d3adb999f8",
        "index": "11"
      },
      {
        "actions": [
          {
            "account": "eosio.token",
            "dbOps": [],
            "id": "000a39f5aa53f7ef19a6bfc540b31e77f7cda51167efbb09ec20b9e2b06a2aa8:1",
            "jsonData": "{\"from\":\"eosdididada3\",\"to\":\"mxdropeufree\",\"quantity\":\"63.9007 EOS\",\"memo\":\"500041623\"}",
            "name": "transfer",
            "ordinal": "1"
          }
        ],
        "hash": "000a39f5aa53f7ef19a6bfc540b31e77f7cda51167efbb09ec20b9e2b06a2aa8",
        "index": "9"
      },
      {
        "actions": [
          {
            "account": "eoshashlotto",
            "dbOps": [
              {
                "actionOrdinal": "1",
                "code": "eosio.token",
                "id": "000bcaae238e94f98855c23503319f5368bf6521bf1b7a55afcea27e37d1b0a8:1",
                "newDataJson": "{\"balance\":\"194917.9042 EOS\"}",
                "primaryKey": "........ehbo5",
                "scope": "eoshashhouse",
                "tableName": "accounts"
              },
              {
                "actionOrdinal": "1",
                "code": "eosio.token",
                "id": "000bcaae238e94f98855c23503319f5368bf6521bf1b7a55afcea27e37d1b0a8:2",
                "newDataJson": "{\"balance\":\"234.0273 EOS\"}",
                "primaryKey": "........ehbo5",
                "scope": "md12zsjf55gy",
                "tableName": "accounts"
              }
            ],
            "id": "000bcaae238e94f98855c23503319f5368bf6521bf1b7a55afcea27e37d1b0a8:1",
            "jsonData": "{\"amount\":\"0.0030 EOS\",\"id\":14,\"memo\":\"lotto: #28758009 md12zsjf55gy bet 14.4000 EOS on --[]-[]-[]-[024568]-[024568] result: 48090, referrer reward  0.0030 EOS\",\"to\":\"md12zsjf55gy\"}",
            "name": "asyncxfer",
            "ordinal": "1"
          },
          {
            "account": "eosio.token",
            "dbOps": [],
            "id": "000bcaae238e94f98855c23503319f5368bf6521bf1b7a55afcea27e37d1b0a8:2",
            "jsonData": "{\"from\":\"eoshashhouse\",\"to\":\"md12zsjf55gy\",\"quantity\":\"0.0030 EOS\",\"memo\":\"lotto: #28758009 md12zsjf55gy bet 14.4000 EOS on --[]-[]-[]-[024568]-[024568] result: 48090, referrer reward  0.0030 EOS\"}",
            "name": "transfer",
            "ordinal": "2"
          }
        ],
        "hash": "000bcaae238e94f98855c23503319f5368bf6521bf1b7a55afcea27e37d1b0a8",
        "index": "6"
      },
      {
        "actions": [
          {
            "account": "genialwombat",
            "dbOps": [
              {
                "actionOrdinal": "1",
                "code": "token.defi",
                "id": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb:0",
                "newDataJson": "{\"balance\":\"0.000000 BOX\"}",
                "primaryKey": "........f1bo2",
                "scope": "asuddenescap",
                "tableName": "accounts"
              },
              {
                "actionOrdinal": "1",
                "code": "token.defi",
                "id": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb:1",
                "newDataJson": "{\"balance\":\"264735.913562 BOX\"}",
                "primaryKey": "........f1bo2",
                "scope": "swap.defi",
                "tableName": "accounts"
              }
            ],
            "id": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb:1",
            "jsonData": "",
            "name": "noop",
            "ordinal": "1"
          },
          {
            "account": "token.defi",
            "dbOps": [],
            "id": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb:2",
            "jsonData": "{\"from\":\"asuddenescap\",\"memo\":\"swap,369,194\",\"quantity\":\"0.045817 BOX\",\"to\":\"swap.defi\"}",
            "name": "transfer",
            "ordinal": "2"
          },
          {
            "account": "token.defi",
            "dbOps": [],
            "id": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb:5",
            "jsonData": "{\"from\":\"swap.defi\",\"memo\":\"Defibox: swap protocol fee\",\"quantity\":\"0.000045 BOX\",\"to\":\"fees.defi\"}",
            "name": "transfer",
            "ordinal": "5"
          },
          {
            "account": "swap.defi",
            "dbOps": [
              {
                "actionOrdinal": "6",
                "code": "fees.defi",
                "id": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb:9",
                "newDataJson": "{\"contract\":\"token.defi\",\"pair_id\":194,\"quantity\":\"0.031331 BOX\"}",
                "primaryKey": "...........g2",
                "scope": "fees.defi",
                "tableName": "tokens"
              }
            ],
            "id": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb:6",
            "jsonData": "{\"fee\":\"0.000136 BOX\",\"owner\":\"asuddenescap\",\"pair_id\":194,\"quantity_in\":\"0.045817 BOX\",\"quantity_out\":\"0.0381 EOS\",\"reserve0\":\"181083.1386 EOS\",\"reserve1\":\"216928.019135 BOX\",\"trade_price\":\"0.83238661190247321\"}",
            "name": "swaplog",
            "ordinal": "6"
          },
          {
            "account": "mine2.defi",
            "dbOps": [],
            "id": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb:7",
            "jsonData": "{\"asset0\":{\"quantity\":\"0.045817 BOX\",\"contract\":\"token.defi\"},\"asset1\":{\"quantity\":\"0.0381 EOS\",\"contract\":\"eosio.token\"},\"pair_id\":194,\"to\":\"asuddenescap\"}",
            "name": "mine",
            "ordinal": "7"
          },
          {
            "account": "eosio.token",
            "dbOps": [],
            "id": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb:8",
            "jsonData": "{\"from\":\"swap.defi\",\"to\":\"asuddenescap\",\"quantity\":\"0.0381 EOS\",\"memo\":\"Defibox: swap token\"}",
            "name": "transfer",
            "ordinal": "8"
          }
        ],
        "hash": "000de251a131bbaa3f8dda8f058fc90f45a13ffe937f7289e4b9157d94b2cbfb",
        "index": "9"
      }
    ]
  }
}
DenisCarriere commented 1 week ago

Should be fixed in v0.3.4 https://github.com/pinax-network/antelope-transactions-subgraph/releases/tag/v0.3.4