Skip to content

Instantly share code, notes, and snippets.

@HAOYUatHZ

HAOYUatHZ/GetBalances

Last active September 17, 2018 12:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save HAOYUatHZ/9e35925b62c0f6df639b924b77d32103 to your computer and use it in GitHub Desktop.
Save HAOYUatHZ/9e35925b62c0f6df639b924b77d32103 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
GetBalances
SELECT address.wallet_id, address.id, balance.asset, balance.balance, balance.total_received, balance.total_sent FROM balance INNER JOIN address ON balance.address_id=address.id WHERE address.wallet_id="b1e0575e-0e92-4774-ac5f-fd6091738ad6";
INSERT INTO balance(address_id,asset) VALUES(3,"0xfffe");
@HAOYUatHZ
Copy link
Author

+--------------------------------------+----+--------+---------+----------------+------------+
| wallet_id | id | asset | balance | total_received | total_sent |
+--------------------------------------+----+--------+---------+----------------+------------+
| b1e0575e-0e92-4774-ac5f-fd6091738ad6 | 3 | 0xfffe | 0 | 0 | 0 |
| b1e0575e-0e92-4774-ac5f-fd6091738ad6 | 3 | 0xffff | 0 | 0 | 0 |
| b1e0575e-0e92-4774-ac5f-fd6091738ad6 | 4 | 0xfffd | 0 | 0 | 0 |
| b1e0575e-0e92-4774-ac5f-fd6091738ad6 | 4 | 0xfffe | 0 | 0 | 0 |
+--------------------------------------+----+--------+---------+----------------+------------+

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment