Skip to content

Instantly share code, notes, and snippets.

Avatar

Bogdan Gusiev bogdan

View GitHub Profile
View 1543.dbout
This file has been truncated, but you can view the full file.
Timing is on.
View 1491.dbout
Timing is on.
id | created_at | updated_at | user_id | ownership_pending | owner_address | name | parent_id | node | resolver | resolution | registry_type | recent_event_id | reverse
--------+----------------------------+----------------------------+---------+-------------------+--------------------------------------------+---------------------------------------+-----------+--------------------------------------------------------------------+--------
View state.ts
type State =
| 'New'
| 'Purchased'
// Minting tx is pending
| 'Minting'
| 'MintedOnZilliqa'
| 'MintedOnPolygon'
| 'MintedOnEthereum'
// In transition from L2 to L1
| 'WithdrawingFromPolygon'
View 277.dbout
Timing is on.
id | hash | status | created_at | updated_at
---------+--------------------------------------------------------------------+----------+----------------------------+----------------------------
2400062 | 0x473a3c541dd6d438a79ac04b6c58dc086670608a73963f6df707e08785fa6b1c | Mirrored | 2022-05-04 12:13:07.247814 | 2022-05-04 12:16:00.880239
2400061 | 0xbf608e703eb9951e503f2bd4fe5d73f900524191854cf48287b36759ca6b2036 | Mirrored | 2022-05-04 12:13:07.205598 | 2022-05-04 12:16:00.880239
2400035 | 0xb693fb9da79ecab745d0c9290ae7590bd8a68a0f6ee61542763f05ef20ed741a | Mirrored | 2022-05-04 12:06:09.749526 | 2022-05-04 12:09:00.872812
2400034 | 0x16365bc395e33599653ee0d8a70265386e9bb17a2b0dc11db2236bc599044ab0 | Mirrored | 2022-05-04 12:06:09.707763 | 2022-05-04 12:09:00.872812
2399993 | 0x28aed4c8c4b518c5a88502d95d81e9e14c33237ebb3a1fa9123b0469fe85d887 | Mirrored | 2022-05-04 11:50:07.454769 | 2022-
View 86.dbout
Timing is on.
date | all_txs | set_resolver
------------+---------+--------------
2022-04-28 | 1 | 0
2022-04-27 | 3 | 0
2022-04-26 | 76 | 0
2022-04-23 | 7 | 0
2022-04-22 | 56 | 0
2022-04-21 | 14 | 0
View gist:ac75bef59ff4579fc88ce769ecc7db12
backend/lib/routes/domain/claim-signature/get.ts|7 col 3| isEvmDomain,
backend/lib/routes/domain/claim-signature/get.ts|33 col 8| if (!isEvmDomain(domain.name)) {
backend/lib/routes/resellers/v1/TxsController.ts|67 col 3| isEvmDomain,
backend/lib/routes/resellers/v1/TxsController.ts|244 col 10| if (!isEvmDomain(domainName)) {
client/actions/transactionActions.ts|11 col 21| import {Blockchain, isEvmDomain, isZilDomain} from '@shared/blockchain';
client/actions/transactionActions.ts|110 col 26| if (!rawTransaction && isEvmDomain(domain)) {
client/components/guest-manage/SelfManageDomain.tsx|34 col 9| import {isEvmDomain, isZilDomain} from '@shared/blockchain';
client/components/guest-manage/SelfManageDomain.tsx|194 col 9| if (isEvmDomain(domain)) {
client/components/manage-new/ManagePages.tsx|38 col 21| import {Blockchain, isEvmDomain, isZilDomain} from '@shared/blockchain';
client/components/manage-new/ManagePages.tsx|255 col 9| if (isEvmDomain(domainName)) {
View 32.dbout
Timing is on.
owner_address | count
--------------------------------------------+-------
0xee89375f8eb351fe4cdb26f20d6c418808e323ff | 29965
0x43f62b887b6ef682de8e91024ea38c435802cab8 | 20245
0x6726e1f7635f1f29b57c181038da9885108c8aa2 | 4996
0x1bac387dfaec0dffa781c2d0f8c6ac1d295dde7e | 4742
0xd5ce099b9aed1169c919c684e795fa63037be198 | 4616
0xba4487f6abd9b3d7e92f47a94cf7e5b6cff5ae33 | 4304
View 22.dbout
Timing is on.
owner_address | count
--------------------------------------------+-------
0x42740d63644db0a8dd8d369d2cb1316d97494de6 | 115
0x0f383f044049fb8e47cce4d93427c09fd5599053 | 93
0xed3db829bc6ea2351d76c6910900f6ca838b8118 | 53
0xaae44b4138b21bb145a98bd0984caad9fbdec555 | 53
0x18080140dff147854275f9c2d24e32982e788029 | 45
0x03f70ddc0b33ee2a561018a5c4c8423c9d0ea27c | 35
View 84.dbout
select
d.name,
d.owner_address,
e.node,
count(*) total,
count(distinct e.blockchain) bchains
from crypto_registry_events e, domains d
where 1=1
and e.node = d.node
and e.type = 'NewURI'
View tmp.ts
type DomainName = string;
type TokenId = string;
type Options = {
// TODO find a better name
location?: string
}
interface Resolution {
reverseTokenId(address: string, options?: Options): TokenId
reverse(address: string, options?: Options): DomainName