Skip to content

Instantly share code, notes, and snippets.

@lispc
lispc / row_usage.py
Created July 24, 2024 00:57
row_usage.py
import csv
import json
#psql -h XX -U XX XX -c "\copy (select index, convert_from(proof, 'UTF8')::json->>'row_usages' as row_usages from chunk where index < 3529100 and deleted_at IS NULL order by index desc limit 500) To STDOUT With CSV" > 500row.csv
# Open your file
with open('500row.csv', 'r') as file, open('output.csv', 'w', newline='') as output_file:
# Create DictReader
reader = csv.DictReader(file, fieldnames=['chunk_index', 'data'])
@lispc
lispc / .prettierrc.json
Created January 10, 2024 08:09
Created using remix-ide: Realtime Ethereum Contract Compiler and Runtime. Load this file by pasting this gists URL or ID at https://remix.ethereum.org/#version=soljson-v0.8.22+commit.4fc1097e.js&optimize=false&runs=200&gist=
{
"overrides": [
{
"files": "*.sol",
"options": {
"printWidth": 80,
"tabWidth": 4,
"useTabs": false,
"singleQuote": false,
"bracketSpacing": false
@lispc
lispc / 700lines fork.patch
Created July 28, 2022 02:45
700lines fork
diff --git a/src/evm/eei.ts b/src/evm/eei.ts
index 9793588..12d545b 100644
--- a/src/evm/eei.ts
+++ b/src/evm/eei.ts
@@ -1,5 +1,5 @@
import { debug as createDebugLogger } from 'debug'
-import { Account, Address, BN, MAX_UINT64 } from 'ethereumjs-util'
+import { Account, Address, BN, MAX_UINT64, toBuffer } from 'ethereumjs-util'
import { Block } from '@ethereumjs/block'
import Blockchain from '@ethereumjs/blockchain'
@lispc
lispc / sync_deps.sh
Created June 23, 2022 05:54
sync_deps.sh
function sync_agg() {
cd halo2-snark-aggregator
find . -name Cargo.toml | xargs gsed -i 's#^halo2_proofs = .*$#halo2_proofs = { path = "../../halo2/halo2_proofs", default-features = true }#g'
find . -name Cargo.toml | xargs gsed -i 's#^zkevm-circuits = .*$#zkevm-circuits = { path = "../../zkevm-circuits/zkevm-circuits" }#g'
find . -name Cargo.toml | xargs gsed -i 's#^eth-types = .*$#eth-types = { path = "../../zkevm-circuits/eth-types" }#g'
cd ..
}
function sync_agg_git() {
@lispc
lispc / Greeter.yul
Last active January 5, 2022 06:45
generated by running "solc -o build --asm --ir Greeter.sol"
/*=====================================================*
* WARNING *
* Solidity to Yul compilation is still EXPERIMENTAL *
* It can result in LOSS OF FUNDS or worse *
* !USE AT YOUR OWN RISK! *
*=====================================================*/
/// @use-src 0:"Greeter.sol"
object "Greeter_59" {
@lispc
lispc / gist:b0e218393eea2dab1e68294c1497b867
Last active December 27, 2023 16:17
博客来电子书自动转化简体中文-Tampermonkey
// ==UserScript==
// @name 博客来简体
// @namespace http://tampermonkey.net/
// @version 0.1
// @description 博客来电子书自动转化简体中文
// @author lispczz
// @match https://viewer-ebook.books.com.tw/viewer/epub/*
// @grant none
// ==/UserScript==

Keybase proof

I hereby claim:

  • I am lispc on github.
  • I am lispczz (https://keybase.io/lispczz) on keybase.
  • I have a public key ASAbA6xwLhete1bhdoOwyjLFqaVeIOwpYKhhb65QwKFUJgo

To claim this, I am signing this object:

@lispc
lispc / multi_sig.sh
Last active January 16, 2020 08:08
IOST multiple signature
set -eu
TEST_USER_ID="testname"
GROUP="group"
IWALLET_CMD='iwallet --chain_id 1020 -s 127.0.0.1:30002' # single node dev chain
seckey1=3MWryACc5nSxRDJCJLe9Xq2spR1j7d5wYbZ4pZN4SvfgUxhG497DQxo5ahENoCnDkLsc7haSveP1q1zkt26JWhog
pubkey1=2ott3o9CZcaoZCe4nGYo1azEfEpY4W771GBFe133WW1p
function clean_account() {
$IWALLET_CMD account del $TEST_USER_ID
function init() {
iwallet --account admin account create lispc --initial_balance 100
iwallet --account admin account create lispcc --initial_balance 100
iwallet --account lispc sys pledge 10 --gas_user lispcc
iwallet --account lispc sys pledge 10 --gas_user lispc
iwallet --account lispc sys unpledge 10 --gas_user lispc
iwallet --account lispc sys pledge 10 --gas_user lispc
}
init
curl -s -X POST --data '{"id":"gas.iost","key":"lispcgp"}' http://127.0.0.1:30001/getContractStorageFields
@lispc
lispc / multisig.sh
Last active April 3, 2019 07:48
multi sig demo for IOST
set -eu
pubkey1=2ott3o9CZcaoZCe4nGYo1azEfEpY4W771GBFe133WW1p
seckey1=3MWryACc5nSxRDJCJLe9Xq2spR1j7d5wYbZ4pZN4SvfgUxhG497DQxo5ahENoCnDkLsc7haSveP1q1zkt26JWhog
pubkey2=G7Zy3ctcByrWfzCzkijnmPXm2rxjQruttFg9FH3hJSMw
seckey2=3NdYa9gCfsRpJMzQZWXfLhKegA4kpyKjYpDLxSCv3hnSX4homFS5T91guU6TGasmrU4Cei9WsNn3hA1cFHZnxKtm
pubkey3=D4WgA3Q9EV18S78haqYpdBqJZT3TNCgkraczi8PK4TVE
seckey3=4RQrGu6ZdKdNP21jQpbMjLMRGdhSemZf1xQXVsm6wJztmWXAm828qhmae6SoQjTU1H64box1Ha2cJgTDntj7Ud2
pubkey4=HiE2gyeFeSoWzurFTWdFnNLizuigh93Jh97HisnQ2see
seckey4=3zXxqsvNTfcB3Ah9JCyX2mqYxRmMoGGu7i1jEnykkoc58ikGo6eoDXJTqpn8Yabt5mGkGd51atkzVafFyeTgwp6i