Tables:
CREATE TABLE IF NOT EXISTS eth.filter_criteria (
id BIGSERIAL PRIMARY KEY,
contract VARCHAR(66),
topic0 VARCHAR(66),
topic1 VARCHAR(66),
topic2 VARCHAR(66),
topic3 VARCHAR(66),
Ian Norden i-norden
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "encoding/json" | |
| "flag" | |
| "fmt" | |
| "github.com/gorilla/websocket" | |
| "log" | |
| "net/url" | |
| "os" |
i-norden
/ gist:a70f45f971c03ecb13dd79ac78dd86a2
Created
September 26, 2024 18:43
Example query to p2p-sentry
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| iannorden@Ians-MacBook-Pro-3 cmd % curl --location 'localhost:8338/' \ | |
| --header 'Content-Type: application/json' \ | |
| --data '{ | |
| "jsonrpc":"2.0", | |
| "method":"sentry_latestPayload", | |
| "params":[], | |
| "id":1 | |
| }' | |
| {"jsonrpc":"2.0","id":1,"result":{"version":2,"blockHeight":125888680,"blockHash":"0xb1a998915c5610b6870e31d9bc0e537905789b63824fbfb00b017312da69d00b","signature":"erXIyNQTZtixSlXWZ3lZp+JFLySDHy9U8VcbhQxEngROlX0ctsDrxhHagRCZn1PnJ9W9lgfUWpVP0F572K9r6AA=","payloadBytes":"BTICoaISOpf1VW1hnZ1+bt1W2iyqmNdCZHaA1u1CsMxNX2lvI5k91tvOMwXVXAiBpL12waklfiHXcQ5k12F6JEIAAAAAAAAAAAAAAAAAAAAAAAARTRjPYsMq4CejW0FV+VPdvw0H1G6ElkMHaQ/YHuRU6m0KRMWYbcjZcOPtLN3q4ma0QY1QPhFSdz9wdjB4rRgKnVBUKYpAEABBwRYqgmYIAABwAQALBCwEAFEGAMJEVAdEBaiYoDAUJBAAKEYRFYqwAAFGJVeAQzIKAgIEQIgkAEMAALAMJoBEGiAIAAlhOEgAAKAEh0FEiFYAAAGUIgBCHRAgAEgGBAAkjBBQhAEBHGEAgAQDATSEAFKAgBSICAIgFgSEAhmAIBgIISAAoWAoKAAVxImAIQAoioVIChIGBBACAJACFKAQCkKCARWgAIQCoIAhAAmQJC2gAw1QAzCXlMEgCUIAAoAVADuCTgEKJKTgxAClBKAAQAWAQAIACCAH5hQqCAKVEgByCQQBJKgwIACoQwUH |
i-norden
/ gist:c169ce6e6ddbf809acaf1ea0634cdbc7
Created
October 29, 2023 23:40
Filecoin `trace_block` example
This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Query: | |
| curl https://endpoint/rpc/v1 \ | |
| -X POST \ | |
| -H "Content-Type: application/json" \ | |
| --data '{"method":"trace_block","params":["0x325AA0"],"id":1,"jsonrpc":"2.0"}' | |
| Response: | |
| {"jsonrpc":"2.0","result":[{"action":{"callType":"call","from":"0xff0000000000000000000000000000000020beeb","to":"0xff0000000000000000000000000000000020bef1","gas":"0x46fd720","input":"0x868e10c40000000000000000000000000000000000000000000000000000000000000007000000000000000000000000000000000000000000000000000000000000005100000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000789821a000246eb5907809385720a694959ac8a66d4b867ef38f66426bd9ba80c9fa049fb57d5db12beab5a8de65e33dfcc544f03fa5f4165461f96d09e9ef3b9413f5b25c9a48e2407a807c7bc6def9e9f5307d25dac022e873ddf363c8e4c1d4a67b08a5ce36ae96a7c055a49addd5113ad89eb6d1f4f63fb21ae3e3543aef2380b7796ff82b1edfdd45c3194fe1f4bc2ebbbcbf921204dd7d7a9aea10e8a84ff2e3913d9f0cc6815725ba387f01f25af19be462e5a043b4075cd8d9363d38d6a6dfb5 |
i-norden
/ gist:ee83aa7fbe13c80c36c193e62241a62a
Created
October 29, 2023 23:30
Filecoin `trace_replayBlockTransactions` example
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Query: | |
| curl https://endpoint/rpc/v1 \ | |
| -X POST \ | |
| -H "Content-Type: application/json" \ | |
| --data '{"method":"trace_replayBlockTransactions","params":["0x325AA0",["trace"]],"id":1,"jsonrpc":"2.0"}' | |
| Response: | |
| {"jsonrpc":"2.0","result":[{"output":"0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000","stateDiff":null,"trace":[{"action":{"callType":"call","from":"0xff0000000000000000000000000000000020beeb","to":"0xff0000000000000000000000000000000020bef1","gas":"0x46fd720","input":"0x868e10c40000000000000000000000000000000000000000000000000000000000000007000000000000000000000000000000000000000000000000000000000000005100000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000789821a000246eb5907809385720a694959ac8a66d4b867ef38f66426bd9ba80c9fa0 |
i-norden
/ gist:325560c772c05ff5bc814d49b8b430c4
Last active
October 11, 2023 16:31
`eth_getTransactionReceipt` for `0x67e59d73c92fa1c0cfc666038fc52a7264135d9d5b66434a77fcef548c383113` response
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"jsonrpc":"2.0","result":{"transactionHash":"0x67e59d73c92fa1c0cfc666038fc52a7264135d9d5b66434a77fcef548c383113","transactionIndex":"0x6b","blockHash":"0x736b7ad9d63d6f30f9edabbf2e5fed800da918953eb320e2a5596156539d142c","blockNumber":"0x28f1ef","from":"0xe64b83f4ba26d5edc0d7ade7b82ef733bbbd16c5","to":"0xf7ceaa5da7305b87361f9db6a300bd6d74c674d2","root":"0x0000000000000000000000000000000000000000000000000000000000000000","status":"0x1","contractAddress":null,"cumulativeGasUsed":"0x0","gasUsed":"0x36bd6aa","effectiveGasPrice":"0xbac57f3b","logsBloom":"0xffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff |
i-norden
/ message_to_tx_hash.go
Last active
October 4, 2023 05:28
Get "Ethereum" transaction hash from Filecoin message CBOR
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "bytes" | |
| "github.com/filecoin-project/lotus/chain/types" | |
| "github.com/filecoin-project/lotus/chain/types/ethtypes" | |
| ) | |
| func main() { |
i-norden
/ gist:72f322afa9f07de0df3e340782ce1d1d
Last active
October 6, 2023 15:21
Example tables and pseudo-query
i-norden
/ gist:d400a303df29f81d130b9881b8d227d3
Created
August 21, 2023 18:26
curl -X POST 'xxxx' -H 'Content-Type: application/javascript' --data '{"jsonrpc":"2.0","method":"eth_getBlockByNumber","params":["2683348", true],"id":83}'
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"jsonrpc":"2.0","result":{"hash":"0x320cb5e1e7f1e5a6cc8466ab09c67aa8092d9adf3b6f28f71a61f8ec4465223b","parentHash":"0x79baafbbca65835a326dd2ef3d67d06827498dbab4fce0b69f845901abef4cbd","sha3Uncles":"0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347","miner":"0x0000000000000000000000000000000000000000","stateRoot":"0x0000000000000000000000000000000000000000000000000000000000000000","transactionsRoot":"0x0000000000000000000000000000000000000000000000000000000000000000","receiptsRoot":"0x0000000000000000000000000000000000000000000000000000000000000000","logsBloom":"0xffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff |
i-norden
/ gist:fd5ed2f0243154971f3d38d54e7df3fa
Created
August 21, 2023 17:20
curl -X POST 'xxxx' -H 'Content-Type: application/javascript' --data '{"jsonrpc":"2.0","id":1,"method":"Filecoin.ChainGetMessage","params":[{ "/": "bafy2bzacebc7qs5qmrkzanyoxhmqbs2gqt4newkl5p4wpyjo2im5brpkta4hk" }]}'
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"jsonrpc":"2.0","result":{"Version":0,"To":"f410f4qzbkdgoshatvcd7pwbwsi6vlf5n3drr3oa4sxy","From":"f410fxdgzhsb2s5detv3ldqm7gepwhhtce4v4r3rghrq","Nonce":19,"Value":"0","GasLimit":500000000,"GasFeeCap":"1600000000","GasPremium":"1600000000","Method":3844450837,"Params":"WSzECcXqvgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAALIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAdAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABOgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADMOp2hLCDIDKgYDr8NRf20EU2/RR48xxeZcePoDl7e1I+WOlQanqm7JZv8q87pU9uvpr+lGkeqYeFJRKAwjYwV3Uc1yFO5kcAfUBAYqQllJx8xP3kfAezgJEc8fFsVjIhAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAOAAAAAAAAAAAAAAAAAAAA |
i-norden
/ gist:76ae9a43509f02bf7befe2b1bac9fcd9
Last active
August 21, 2023 17:17
curl -X POST 'xxxx' -H 'Content-Type: application/javascript' --data '{"jsonrpc":"2.0","id":1,"method":"Filecoin.ChainReadObj","params":[{ "/": "bafy2bzacebc7qs5qmrkzanyoxhmqbs2gqt4newkl5p4wpyjo2im5brpkta4hk" }]}'
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"jsonrpc":"2.0","result":"gooAVgQK5DIVDM6RwTqIf32DaSPVWXrdjjFWBAq4zZPIOpdGSddrHBnzEfY55iJyvBNAGh3NZQBFAF9eEABFAF9eEAAa5SWqFVksx1ksxAnF6r4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACyAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAbgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAToAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAkAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAzDqdoSwgyAyoGA6/DUX9tBFNv0UePMcXmXHj6A5e3tSPljpUGp6puyWb/KvO6VPbr6a/pRpHqmHhSUSgMI2MFd1HNchTuZHAH1AQGKkJZScfMT95HwHs4CRHPHxbFYyIQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAtkZXBsb3lUb2tlbgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAALZGVwbG95VG9rZW4AAAAAAAAAAAAAAAAAA |
NewerOlder