Skip to content

Instantly share code, notes, and snippets.

View dapi's full-sized avatar
🌴
Open for offers

Danil Pismenny dapi

🌴
Open for offers
View GitHub Profile
{
"from_block": 1,
"to_block": 1000000,
"logs": [
{
"address": [
45480608,
28155531,
65552029,
28455280,
{
"from_block": 1,
"to_block": 1000000,
"logs": [
{
"address": [
20059476,
29444609,
26851445,
44362257,
@dapi
dapi / 1.sql
Created April 14, 2025 09:02
transaction_log_v2s
Table "public.transaction_log_v2s"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
-----------------------------+---------------------+-----------+----------+---------------------------+----------+-------------+--------------+-------------
block_number | integer | | not null | | plain | | |
transaction_id | smallint | | not null | | plain | | |
log_index | smallint | | not null | | plain | | |
transaction_from_address_id | integer | | not null | | plain | | |
transaction_to_address_id | integer
@dapi
dapi / 1.sql
Created April 14, 2025 08:59
transaction_logs
You are now connected to database "cocodrilo_development" as user "danil".
cocodrilo_development=# \d+ transaction_logs;
Table "public.transaction_logs"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
----------------+---------+-----------+----------+-------------+----------+-------------+--------------+-------------
block_number | integer | | not null | | plain | | |
transaction_id | integer | | not null | | plain | | |
log_index | integer | | not null | | plain | | |
tags | jsonb | | not null | '[]'::jsonb | extended | | |
Indexes:
--- BLOCK
Payload: {
"from_block":10000000,
"to_block":10120011,
"include_all_blocks":true,
"field_selection":{
"block":[
"number",
"hash",
struct Query {
/// Блок, с которого начинается запрос
/// Если не указан, запрос выполняется с самого начала доступных данных
from_block: Optional<u64>,
/// Блок, на котором заканчивается запрос (не включительно)
/// Если не указан, запрос выполняется до конца доступных данных
to_block: Optional<u64>,
/// Критерии выбора логов (отношение ИЛИ между выборками)
logs: Array<LogSelection>,
/// Критерии выбора транзакций (отношение ИЛИ между выборками)
{
"items": [
{
"address": "0x5b5f4a883626e75f29060c4ffde0057dd3a57f62",
"block_number": 21109626,
"created_at": "2025-03-24T11:12:01Z",
"creator": "0x5b91252310ba565ac03fcdd2625ed6705919de09",
"decimals": 18,
"id": "0195c7d7-e4c6-767c-9c6e-99ec34733e55",
"image_path": "",
@dapi
dapi / pairs.json
Created March 25, 2025 17:07
pairs json
{
"items":[
{
"address":"0xdc165262e216bd970204e1ff21c5ac2e28da5e9a",
"block_number":133474103,
"created_at":"2025-03-21T08:49:43Z",
"creator":"0xf338ec6fab2658c12582b4fed083bded20e4c7ee",
"factory_id":"0191fc54-dd8d-7a07-b173-f333da60d34d",
"id":"0195b990-6dce-792b-a0f5-a579840ff8d5",
"network":"NETWORK_OPTIMISM",
/exchanges
/routes?from=0x0b2c639c533813f4aa9d7837caf62653d097ff85&to=0x94b008aa00579c1307b0ef2c499ad98a8ce58e58&limit=6&network=NETWORK_OPTIMISM
/routes?from=0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270&to=0x3c499c542cef5e3811e1192ce70d8cc03d5c3359&limit=6&network=NETWORK_POLYGON
/routes?from=0x3c499c542cef5e3811e1192ce70d8cc03d5c3359&to=0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270&limit=6&network=NETWORK_POLYGON
/routes?from=0x3c499c542cef5e3811e1192ce70d8cc03d5c3359&to=0xc2132d05d31c914a87c6611c10748aeb04b58e8f&limit=6&network=NETWORK_POLYGON
/routes?from=0x4200000000000000000000000000000000000006&to=0x0b2c639c533813f4aa9d7837caf62653d097ff85&limit=6&network=NETWORK_OPTIMISM
/routes?from=0x55d398326f99059ff775485246999027b3197955&to=0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d&limit=6&network=NETWORK_BINANCE
/routes?from=0x55d398326f99059ff775485246999027b3197955&to=0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c&limit=6&network=NETWORK_BINANCE
/routes?from=0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d&to=0x55d398326f99
#!/usr/bin/env bash
echo "This app setup app and build environment variables for frontend applications in SafeBlock"