Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am holgerd77 on github.
  • I am holgerd77 (https://keybase.io/holgerd77) on keybase.
  • I have a public key whose fingerprint is C4BF EF8B AE8E D0AD 7389 2974 18E1 3335 5A8A 2F45

To claim this, I am signing this object:

@holgerd77
holgerd77 / get_farmsubsidy_data.sh
Last active August 29, 2015 14:01 — forked from stefanw/get_farmsubsidy_data.sh
Fixes for Farmsubsidy data files
# Fixes for Farmsubsidy data
# Order of countries is taken form the website:
# http://farmsubsidy.openspending.org/countries/
set -x verbose
#wget -O AT.zip "http://data.farmsubsidy.org/web/at20130501.zip"
#unzip -d AT AT.zip
# Generic fixes/helpers
# HTML encoding fix
sed 's/\&ouml;/ö/g; s/&Ouml;/Ö/g; s/&uuml;/ü/g; s/&Uuml;/Ü/g; s/&auml;/ä/g; s/&Auml;/Ä/g; s/&szlig;/ß/g; s/&quot;/"/g; s/&lt;/</g; s/&gt;/>/g; s/&amp;/\&/g; s/&#[0-9]*;//g' [COUNTRY_CODE]/recipient_bad.txt > [COUNTRY_CODE]/recipient.txt
@holgerd77
holgerd77 / fs_split.sh
Created November 27, 2014 12:07
Farmsubsidy data (recipient, payment) CSV split script
#!/bin/bash
#Usage : ./split.sh COUNTRY_CODE FILE_TYPE_WITHOUT_ENDING LINES_PER_FILE
#Author : Holger Drewes
#Last edit : 2014-11-27
echo -e "Script for splitting payment or recipient files into chunks"
echo -e "***********************************************************\n"
#Check for number of arguments
if [ "$#" -ne 3 ]; then
echo "Usage: $0 COUNTRY_CODE FILE_TYPE_WITHOUT_ENDING LINES_PER_FILE"
@holgerd77
holgerd77 / send_folder_to_s3.py
Created May 4, 2015 12:40
Script for Farmsubsidy to send folders with exported flat CSV files to S3 bucket
#Taken from: https://gist.github.com/SavvyGuard/6115006
#Usage: python send_folder_to_s3 COUNTRY_DIRNAME
#Dependencies: boto
import boto
import boto.s3
import os.path
import sys
# Fill these in - you get them when you sign up for S3
@holgerd77
holgerd77 / BlockchainTests_noGST_2017-09-20.txt
Created September 20, 2017 17:24
BlockchainTests_noGST_2017-09-20.txt
> [email protected] testBlockchain /Users/hdrewes/Documents/DEV/EthereumJS/ethereumjs-vm
> node --stack-size=1500 ./tests/tester -b --excludeDir='GeneralStateTests'
TAP version 13
# BlockchainTests
# file: BlockGasLimit2p63m1 test: BlockGasLimit2p63m1_Byzantium
ok 1 correct pre stateRoot
ok 2 correct genesis RLP
ok 3 last block hash
@holgerd77
holgerd77 / pyethereum_CreateCollisionEmpty_d2g0v0_StackTrace_2017-11-10.txt
Created November 10, 2017 14:56
pyethereum - Stack Trace for CreateCollisionEmpty - d2g0v0 - 2017-11-10 (failing in ethereumjs)
Checking for values: g 600000 v 0 d 0x0000000000000000000000003000000000000000000000000000000000000000 (indexes g 0 v 0 d 2)
DEBUG:eth.pb.tx TX NEW txdict={'nonce': 0, 'hash': '0x868beab17e801e5beaf68bc9233a5a8bc736daa39aa46da956f9887f1d10416e', 'sender': '0xa94f5374fce5edbc8e2a8697c15331677e6ebf0b', 'startgas': 600000, 'value': 0, 'to': '0x1a00000000000000000000000000000000000000', 's': 10066249554982021582834830964774847325135560337123958209132799759329933227148L, 'r': 60026381854559856462917477462139528776309580871168955053321074866071770826177L, 'v': 27, 'data': '0x0000000000000000000000003000000000000000000000000000000000000000', 'gasprice': 1}
DEBUG:eth.pb.msg MSG APPLY sender=a94f5374fce5edbc8e2a8697c15331677e6ebf0b pre_storage={'nonce': '0', 'balance': '0', 'storage': {}, 'code': '0x6000600060006000600060003562013880f1'} gas=578808 value=0 to=1a00000000000000000000000000000000000000 depth=0 static=False data=0000000000000000000000003000000000000000000000000000000000000000
TRACE:eth.vm.op vm gas=578808
@holgerd77
holgerd77 / ethereumjs-blockchain_test_getHead.js
Created May 23, 2018 11:16
ethereumjs-blockchain - test getHead() for a reopened block-containing leveldown DB instance
'use strict'
const test = require('tape')
const Blockchain = require('..')
const Block = require('ethereumjs-block')
const async = require('async')
const ethUtil = require('ethereumjs-util')
const levelup = require('levelup')
const leveldown = require('leveldown')
const memdown = require('memdown')
@holgerd77
holgerd77 / test.ts
Created October 5, 2022 11:05
Ethers State Manager Consecutive Mainnet Block Test
import { Chain, Common, Hardfork } from '@ethereumjs/common'
import { Account, Address, bigIntToHex, bufferToBigInt, bufferToHex } from '@ethereumjs/util'
import { VM } from '@ethereumjs/vm'
import { JsonRpcProvider } from '@ethersproject/providers'
import { EthersStateManager } from '../src/ethersStateManager'
const run = async () => {
const infura = 'https://mainnet.infura.io/v3/[YOUR-INFURA-KEY]'
const provider = new JsonRpcProvider(infura)
@holgerd77
holgerd77 / shandong-6101-trace
Created October 28, 2022 10:21
Shandong Block 6101 VM Trace - 2022-10-28
➜ net-env-cli DEBUG=vm:* ts-node shandong-ethers-state-manager-trace.ts
vm:block ---------------------------------------------------------------------------------------------------- +0ms
vm:block Running block hash=382c720b54a97bcb9388f5d1e422205c5174fd6d0f0fe431005dd32cd3928093 number=6101 hardfork=merge +0ms
vm:state ---------------------------------------------------------------------------------------------------- +0ms
vm:state message checkpoint +0ms
vm:block block checkpoint +1ms
vm:block Validate block +0ms
vm:block Apply transactions +28ms
vm:state ---------------------------------------------------------------------------------------------------- +28ms
vm:state message checkpoint +0ms
@holgerd77
holgerd77 / tape_vitest_regex.txt
Last active June 14, 2023 09:43
JavaScript Tape -> Vitest Test Runner Transition - RegEx Cheat Sheet
Tape -> Vitest Regex Expressions
--------------------------------
import * as tape from 'tape' // No regex
import { assert, describe, it } from 'vitest'
import type * as tape from 'tape' // No regex
import { assert, describe, it } from 'vitest'
**********************************