Skip to content

update API tp fix new substreams change #80

update API tp fix new substreams change

update API tp fix new substreams change #80

Triggered via push May 28, 2024 15:13
Status Failure
Total duration 15s
Artifacts

bun-test.yml

on: push
build-and-test
6s
build-and-test
Fit to window
Zoom out
Zoom in

Annotations

10 errors and 1 warning
error: expect(received).toContain(expected): src/queries.spec.ts#L40
Expected to contain: "SELECT*FROMContracts" Received: "SELECTContracts.address,Contracts.name,Contracts.symbol,Contracts.decimals,Contracts.block_number,toDateTime(toUnixTimestamp(Contracts.timestamp)*1000)astimestampFROMContractsWHERE(address=='dac17f958d2ee523a2206206994597c13d831ec7')ORDERBYblock_numberDESCLIMIT1" at /home/runner/work/substreams-erc20-api/substreams-erc20-api/src/queries.spec.ts:40:5
error: expect(received).toContain(expected): src/queries.spec.ts#L66
Expected to contain: "WHERE(chain=='eth'ANDaddress=='dac17f958d2ee523a2206206994597c13d831ec7'ANDLOWER(symbol)=='usdt'ANDLOWER(name)=='tetherusd'ANDtoUnixTimestamp(timestamp)>=1697587200ANDtoUnixTimestamp(timestamp)<=1697587100)" Received: "SELECTContracts.address,Contracts.name,Contracts.symbol,Contracts.decimals,Contracts.block_number,toDateTime(toUnixTimestamp(Contracts.timestamp)*1000)astimestampFROMContractsWHERE(address=='dac17f958d2ee523a2206206994597c13d831ec7'ANDLOWER(symbol)=='usdt'ANDLOWER(name)=='tetherusd'ANDtoUnixTimestamp(timestamp)>=1697587200ANDtoUnixTimestamp(timestamp)<=1697587100)ORDERBYblock_numberDESCLIMIT1" at /home/runner/work/substreams-erc20-api/substreams-erc20-api/src/queries.spec.ts:66:5
error: expect(received).toContain(expected): src/queries.spec.ts#L111
Expected to contain: "SELECTTotalSupply.addressasaddress,TotalSupply.supplyassupply,TotalSupply.block_number,TotalSupply.chainaschain,Contracts.nameasname,Contracts.symbolassymbol,Contracts.decimalsasdecimals,TotalSupply.timestamp" Received: "SELECTTotalSupply.addressasaddress,TotalSupply.supplyassupply,TotalSupply.block_number,Contracts.nameasname,Contracts.symbolassymbol,Contracts.decimalsasdecimals,toUnixTimestamp(TotalSupply.timestamp)*1000astimestampFROMTotalSupplyLEFTJOINContractsONContracts.address=TotalSupply.addressWHERE(TotalSupply.address=='dac17f958d2ee523a2206206994597c13d831ec7')ORDERBYblock_numberDESCLIMIT1" at /home/runner/work/substreams-erc20-api/substreams-erc20-api/src/queries.spec.ts:111:5
error: expect(received).toContain(expected): src/queries.spec.ts#L154
Expected to contain: "WHERE(TotalSupply.chain=='eth'ANDTotalSupply.address=='dac17f958d2ee523a2206206994597c13d831ec7'ANDtoUnixTimestamp(timestamp)>=1697587200ANDtoUnixTimestamp(timestamp)<=1697587100ANDLOWER(symbol)=='usdt'ANDLOWER(name)=='tetherusd')" Received: "SELECTTotalSupply.addressasaddress,TotalSupply.supplyassupply,TotalSupply.block_number,Contracts.nameasname,Contracts.symbolassymbol,Contracts.decimalsasdecimals,toUnixTimestamp(TotalSupply.timestamp)*1000astimestampFROMTotalSupplyLEFTJOINContractsONContracts.address=TotalSupply.addressWHERE(TotalSupply.address=='dac17f958d2ee523a2206206994597c13d831ec7'ANDtoUnixTimestamp(timestamp)>=1697587200ANDtoUnixTimestamp(timestamp)<=1697587100ANDLOWER(symbol)=='usdt'ANDLOWER(name)=='tetherusd')ORDERBYblock_numberDESCLIMIT1" at /home/runner/work/substreams-erc20-api/substreams-erc20-api/src/queries.spec.ts:154:5
error: expect(received).toContain(expected): src/queries.spec.ts#L167
Expected to contain: "SELECTcontractascontract,ownerasowner,newBalanceasbalance,toDateTime(timestamp)astimestamp,transactionastransaction_id,chainaschain,block_number" Received: "SELECTcontractascontract,ownerasowner,new_balanceasbalance,toDateTime(toUnixTimestamp(timestamp)*1000)astimestamp,transaction_id,block_numasblock_number,FROMmv_balance_changes_ownerWHERE(owner=='dac17f958d2ee523a2206206994597c13d831ec7'ANDcontract=='dac17f958d2ee523a2206206994597c13d831ec7')ORDERBYtimestampDESCLIMIT1" at /home/runner/work/substreams-erc20-api/substreams-erc20-api/src/queries.spec.ts:167:5
error: expect(received).toContain(expected): src/queries.spec.ts#L237
Expected to contain: "WHERE(chain=='eth'ANDowner=='dac17f958d2ee523a2206206994597c13d831ec7'ANDtoUnixTimestamp(timestamp)>=1697587200ANDtoUnixTimestamp(timestamp)<=1697587100)" Received: "SELECTowner,contract,toDateTime(toUnixTimestamp(last_value(timestamp))*1000)AStimestamp,last_value(new_balance)ASbalanceFROMmv_balance_changes_contractWHERE(owner=='dac17f958d2ee523a2206206994597c13d831ec7'ANDtoUnixTimestamp(timestamp)>=1697587200ANDtoUnixTimestamp(timestamp)<=1697587100)GROUPBY(contract,owner)ORDERBYtimestampDESCLIMIT1" at /home/runner/work/substreams-erc20-api/substreams-erc20-api/src/queries.spec.ts:237:5
error: expect(received).toContain(expected): src/queries.spec.ts#L252
Expected to contain: "SELECTaddress,from,to,valueasamount,transactionastransaction_id,block_number,timestamp,chain" Received: "SELECTaddress,from,to,valueasamount,transactionastransaction_id,block_number,toDateTime(toUnixTimestamp(timestamp)*1000)astimestampFROMmv_transfers_contractWHERE(address=='dac17f958d2ee523a2206206994597c13d831ec7')ORDERBYtimestampDESCLIMIT100" at /home/runner/work/substreams-erc20-api/substreams-erc20-api/src/queries.spec.ts:252:5
error: expect(received).toContain(expected): src/queries.spec.ts#L300
Expected to contain: "SELECTowner,newBalanceASbalance,block_number,toDateTime(timestamp)AStimestamp" Received: "SELECTowner,new_balanceASbalance,block_numasblock_number,toDateTime(toUnixTimestamp(timestamp)*1000)AStimestampFROMmv_balance_changes_contractWHERE(contract=='dac17f958d2ee523a2206206994597c13d831ec7'ANDCAST(balanceasint)>0)ORDERBYtimestampDESCLIMIT100" at /home/runner/work/substreams-erc20-api/substreams-erc20-api/src/queries.spec.ts:300:5
error: expect(received).toBe(expected): src/queries.spec.ts#L327
Expected: "SELECT DISTINCT chain FROM module_hashes" Received: "ETH" at /home/runner/work/substreams-erc20-api/substreams-erc20-api/src/queries.spec.ts:327:5
build-and-test
Process completed with exit code 1.
build-and-test
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.