30秒内查到ETH上所有类似的合约

有时候需要查找ETH上面 与 某个合约类似的所有合约
本工具利用了 bigquery-public-data.ethereum_blockchain 公开数据

具体介绍 ethereum-bigquery-public-dataset-smart-contract-analytics

使用

查询链接在: https://console.cloud.google.com/bigquery?sq=348440405491:dd7234a0a453433da1596f2e57b344e4

只要把其他sql里面的 address换成你想要查找的就可以了。。。

源代码如下:

CREATE TEMPORARY FUNCTION
  jaccard (v1 ARRAY,
    v2 ARRAY)
  RETURNS FLOAT64
  LANGUAGE js AS """
  var u1 = {};
  var u2 = {};
  var uu = {};
  for (var i = 0 ; i < v1.length; i++) { u1[v1[i]] = 1; uu[v1[i]] = 1 }
  for (var i = 0 ; i  m ) {
    // Make sure n <= m, to use O(min(n,m)) space
    var c = a; a = b; b = c;
    var o = n; n = m; m = o;
  }

  var cur = [...Array(n+1).keys()];
  var o1 = [...Array(m+1).keys()];
  o1.shift();

  for (k1 in o1) {
    var i = o1[k1];
    
    var prv = cur;
    cur = [i];
    for (i in [...Array(n).keys()]) { cur.push(0); }
    
    var o2 = [...Array(n+1).keys()];
    o2.shift();
    
    for (k2 in o2) {
      var j = o2[k2];

      var add = prv[j]+1;
      var del = cur[j-1]+1;

      var chg = prv[j-1];

      if ( a[j-1] != b[i-1] ) {
        chg = chg + 1;
      }

      cur[j] = add < del ? add : del;
      cur[j] = cur[j]  0
  ORDER BY
    similarity DESC,
    address
    --, function_signature
  LIMIT
    500 )

本文作者:高金

本文地址: https://igaojin.me/2019/11/23/ETH相似合约查询/

版权声明:转载请注明出处!