miohtama

-- Get all approve() transaction
--  Web3.utils.keccak256("approve(address,uint256)").slice(0, 10);
-- '0x095ea7b3'
WITH txdata as (
    SELECT tx.hash as txid, tx.block_timestamp as block_timestamp, cast(tx.receipt_gas_used as numeric) * cast(tx.gas_price as numeric) as cost FROM
        bigquery-public-data.crypto_ethereum.transactions as tx
    where 
        tx.input 
    LIKE  "0x095ea7b3%") 
SELECT (SUM(cost) / POWER(10, 18)) as eth_cost from txdata;

miohtama

class LiquidityChanged(TransactionEvent):
    """A sampled liquidity at any moment."""
    __tablename__ = "liquidity"
    delta0 = sa.Column(Int257, nullable=False, index=False)

miohtama

"""A stateful event scanner for Ethereum-based blockchains using web3.py.

With the stateful mechanism, you can do one batch scan or incremental scans,
where events are added where the scanner left last time.

Copyright 2021 Mikko Ohtamaa, https://twitter.com/moo9000, licensed under MIT
"""

import datetime
import time

miohtama

--  Web3.utils.keccak256("approve(address,uint256)").slice(0, 10);
-- '0x095ea7b3'
WITH txdata as (
    SELECT tx.hash as txid, cast(tx.receipt_gas_used as numeric) * cast(tx.gas_price as numeric) as cost FROM
        bigquery-public-data.crypto_ethereum.transactions as tx
    where 
        tx.input 
    LIKE  "0x095ea7b3%") 
SELECT (SUM(cost) / POWER(10, 18)) as eth_cost from txdata;

miohtama

#!/bin/sh
#
# This is a faux solc stub that runs a dockerized solc
#

VERSION=$SOLC_VERSION

# Docker complains about abs paths
ME=`dirname "$0"`
ME=`realpath $ME`

miohtama

Completed the exercise.

Added a sign up component.

Time spent: 4 hours.

miohtama

Instructions for QA

Preconditions

• Software to be installed in the machine:
  • Latest NodeJS
  • Web Browser, evergreen preffered: Google Chrome, Firefox, Brave, Edge
  • Git

Setup

Clone the repo

miohtama

import { Component, OnInit, Input, ViewChild, Output, EventEmitter } from '@angular/core';
import { Web3Service, WalletState, WalletType } from '../web3.service';
import Web3 from 'web3';
import { waitTransaction, isSuccessfulTransaction } from '../transactionwait';
import { isRequired, checkRequired } from '../requiredInput';
import { EthereumProgressBarComponent } from '../ethereum-progress-bar/ethereum-progress-bar.component';
import { Subscription } from 'rxjs';
import { NGXLogger } from 'ngx-logger';

// Called before creating a tranaction.

miohtama

// https://github.com/microsoft/vscode-recipes/tree/master/debugging-jest-tests
{
    "version": "0.2.0",
    "configurations": [
        {
            "type": "node",
            "request": "launch",
            "name": "Jest All",
            "program": "${workspaceFolder}/node_modules/.bin/jest",
            "args": [

miohtama

{
    "version": "0.2.0",
    "configurations": [
        {
            "type": "node",
            "request": "launch",
            "name": "Launch user.e2e test",
            "runtimeExecutable": "npm",
            "cwd": "${workspaceFolder}",
            "runtimeArgs": [