halink0803

import { ethereum } from '@graphprotocol/graph-ts';
import { PubSub }  from '@google-cloud/pubsub';
import { Block } from '../../generated/schema';


export function handleBlock(block: ethereum.Block): void {
  let id = block.hash.toHex()
  let blockEntity = new Block(id)
  blockEntity.number = block.number
  blockEntity.timestamp = block.timestamp

halink0803

package main

import (
	"context"
	"encoding/json"
	"log"
	"os"
	"sort"
	"time"

halink0803

1. install rename

brew install rename (osx)
sudo pacman -S perl-rename (arch linux)

2. rename

halink0803

// Find all \n without precede by \n and followed by \n

(?<!\n)\n(?!\n)

halink0803

[
    {
        "timestamp": 1618410797000,
        "block_number": 6560905,
        "tx_hash": "0x74d75409850edbcde10de7a36ba4fa71e5b796065cf670d0302883b8005f3433",
        "token_info": {
            "src_addr": "0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee",
            "src_symbol": "BNB",
            "dst_addr": "0x55d398326f99059ff775485246999027b3197955",
            "dst_symbol": "USDT"

halink0803

	CREATE OR REPLACE FUNCTION get_erc20_transfer(text, text, integer, integer) RETURNS text AS 
$$
DECLARE
query_final text;
wallet ALIAS FOR $1;
token ALIAS FOR $2;
from_time ALIAS FOR $3;
to_time ALIAS FOR $4;
BEGIN

halink0803

#!/bin/bash

find ~/Library/Group\ Containers/ -type d -name OfficeFileCache -exec rm -r {} +

halink0803

CREATE CONTINUOUS QUERY "wallet_fee" ON "trade_logs"
RESAMPLE EVERY 1h FOR 1d
BEGIN
    SELECT SUM("amount") as "sum_amount"
    INTO "hourly_wallet_fees"
    FROM "wallet_fees"
    GROUP BY "reserve_addr", "wallet_addr", time(1h)
END

CREATE CONTINUOUS QUERY "wallet_fee_1d" ON "trade_logs"

halink0803

From device

1. Go to chrome://settings/people.
2. Click turn off sync data.
3. At the pop up, check into Clear bookmark, history, password and more from this device.
4. Click turn off.

=> all your synced data will be cleared from the device.

From cloud

halink0803

err = db.View(func(tx *bolt.Tx) error {
        return tx.ForEach(func(name []byte, _ *bolt.Bucket) error {
            fmt.Println(string(name))
            return nil
        })
    })