Skip to content

Instantly share code, notes, and snippets.

View bogdan's full-sized avatar
💭
Developing everything, fixing everything, delivering everything

Bogdan Gusiev bogdan

💭
Developing everything, fixing everything, delivering everything
View GitHub Profile
This file has been truncated, but you can view the full file.
Timing is on.
id | created_at | updated_at | user_id | ownership_pending | owner_address | name | parent_id | node | resolver |
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
--------+----------------------------+----------------------------+---------+-------------------+--------------------------------------------+---------------------------------------+-----------+--------------------------------------------------------------------+--------
type State =
| 'New'
| 'Purchased'
// Minting tx is pending
| 'Minting'
| 'MintedOnZilliqa'
| 'MintedOnPolygon'
| 'MintedOnEthereum'
// In transition from L2 to L1
| 'WithdrawingFromPolygon'
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-
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
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)) {
Timing is on.
owner_address | count
--------------------------------------------+-------
0xee89375f8eb351fe4cdb26f20d6c418808e323ff | 29965
0x43f62b887b6ef682de8e91024ea38c435802cab8 | 20245
0x6726e1f7635f1f29b57c181038da9885108c8aa2 | 4996
0x1bac387dfaec0dffa781c2d0f8c6ac1d295dde7e | 4742
0xd5ce099b9aed1169c919c684e795fa63037be198 | 4616
0xba4487f6abd9b3d7e92f47a94cf7e5b6cff5ae33 | 4304
Timing is on.
owner_address | count
--------------------------------------------+-------
0x42740d63644db0a8dd8d369d2cb1316d97494de6 | 115
0x0f383f044049fb8e47cce4d93427c09fd5599053 | 93
0xed3db829bc6ea2351d76c6910900f6ca838b8118 | 53
0xaae44b4138b21bb145a98bd0984caad9fbdec555 | 53
0x18080140dff147854275f9c2d24e32982e788029 | 45
0x03f70ddc0b33ee2a561018a5c4c8423c9d0ea27c | 35
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'
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