func main() {
client, err := ethclient.Dial("https://cloudflare-eth.com")
if err != nil {
log.Fatal(err)
}
fmt.Println("we have a connection")
_ = client // we'll use this in the upcoming sections
account := common.HexToAddress("0x58B7Ad14b90bb2abE6C51163aE8905b5c670B79E")
balance, err := client.BalanceAt(context.Background(), account, nil)
if err != nil {
log.Fatal(err)
}
fmt.Println(balance) // 25893180161173005034
// fmt.Println
// fmt
// }{}
}
P2PDB翻译后
select * from account where address="0x71c7656ec7ab88b098defb751b7401b5f6d8976f"
4、翻译后的SQL语句
### 查询账户
1、查询账户余额、代币余额,
select * from account where address="0x71c7656ec7ab88b098defb751b7401b5f6d8976f"
2、查询账户余额、代币余额, 增加区块筛选
select * from account where address="0x71c7656ec7ab88b098defb751b7401b5f6d8976f" and block_number=""
3、查询账户待处理余额
select * from account where address="0x71c7656ec7ab88b098defb751b7401b5f6d8976f" and PendingBalanceAt=true
### 钱包
1、创建钱包表
create table wallet
public_key varchar(255)
private_key varchar(255)
2、创建钱包地址
insert into wallet public_key="" and private_key=""
### 交易
此处省略。