CodeChain-io / CodeChain-io/codechain-indexer
Make the AggsUTXOs table migration script insert rows that have 0 quantity value
- 主要语言
- TypeScript
- 星标
- 21
- 派生
- 15
- PR 合并指标
- 30 天内没有已合并 PR
描述
Here is the AggsUTXOs table's migration script.
```
INSERT INTO "AggsUTXOs"("assetType", "address", "totalAssetQuantity", "utxoQuantity", "createdAt", "updatedAt")
SELECT "assetType", "address", SUM("quantity") as "totalAssetQuantity", COUNT(*) as "utxoQuantity", NOW(), NOW()
FROM "UTXOs" WHERE "usedBlockNumber" IS NULL GROUP BY "assetType", "address"
```
To ignore used UTXOs, the migration script filters the used UTXOs using the where clause. If a user sent all assets they have to another user, the quantity column value of the AggsUTXOs table's row will be zero. The migration script above does not insert the row that has the zero value in the quantity column.
This behavior is subtle. And can be ignored.
贡献指南
这个仓库没有索引到贡献指南
调研方向
包含所示 AggsUTXOs INSERT 的迁移文件是起点;检查 WHERE 子句和聚合如何处理数量为 0 的数据。更新迁移,使其插入相关的数量为 0 的 AggsUTXOs 行,然后使用与报告案例匹配的数据进行验证。
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- sql, typescript
- 领域
- databases
- Issue 类型
- 缺陷
- 难度
- 2/5
- 预计耗时
- 1-3 小时
- 活跃度
- 停滞
- 描述清晰度
- 基本清楚
- 新手友好度
- 45/100