Delegation Information Corrected @justyy

justyy (82)in Witness Activities • yesterday (edited)

Yesterday, I mentioned that the delegation records are not correct as some information were outdated or missing: see this post.

There was a bug of the code, with processing multiple delegation records in a single block. I think previously, only the first transaction in a block was captured. This was fixed, however the data was not fixed.

I wrote a script today, to manually update the database. I fetch the information using steemchiller's API, and then I got a list of delegators which need updating. Then I fetch the API to check the delegatees (reverse check), to update the database.

Before fixing - there were only 525 delegators (I manually added 2 to verify).

After fixing (565 delegators) - so there are 40 delegators which got missing from the database:

REPLACE INTO daili VALUES ('abcallen', 'justyy', 538.3120117236208, 907920.958534, '2022-06-28 03:14:12');
REPLACE INTO daili VALUES ('lucienyong', 'justyy', 109.61957514777205, 184885.173607, '2022-02-27 14:12:39');
REPLACE INTO daili VALUES ('smt-wherein', 'justyy', 10.859106293235829, 18315.047695, '2022-02-21 13:16:45');
REPLACE INTO daili VALUES ('livingfeel', 'justyy', 65.79389873068867, 110968.468376, '2021-11-01 16:02:21');
REPLACE INTO daili VALUES ('koei', 'justyy', 2.193144334799558, 3698.973185, '2021-11-01 14:13:51');
REPLACE INTO daili VALUES ('ipay.pemaki', 'justyy', 22.37358331507708, 37735.448334, '2021-04-09 07:46:18');
REPLACE INTO daili VALUES ('misohan', 'justyy', 111.86977976890087, 188680.383666, '2021-04-09 03:57:12');
REPLACE INTO daili VALUES ('luciferkim', 'justyy', 111.86979701595092, 188680.412755, '2021-04-09 03:55:39');
REPLACE INTO daili VALUES ('llllyyyyllll', 'justyy', 22.38604666047955, 37756.468911, '2021-04-02 00:10:39');
REPLACE INTO daili VALUES ('luoyanliang', 'justyy', 5.597675347558861, 9441.079879, '2021-04-01 23:55:42');
REPLACE INTO daili VALUES ('sanakhan1920', 'justyy', 5.602438392395463, 9449.113265, '2021-03-24 21:05:21');
REPLACE INTO daili VALUES ('waiwan', 'justyy', 112.05635143054803, 188995.055345, '2021-03-24 05:36:27');
REPLACE INTO daili VALUES ('mudassir55', 'justyy', 11.206386384635133, 18900.772584, '2021-03-23 14:20:27');
REPLACE INTO daili VALUES ('talalala', 'justyy', 22.41331316544876, 37802.456508, '2021-03-23 08:51:18');
REPLACE INTO daili VALUES ('sanjayarik', 'justyy', 1.1297149153471047, 1905.385368, '2021-01-08 00:55:27');
REPLACE INTO daili VALUES ('kgsupport', 'justyy', 11.659151548259763, 19664.409494, '2020-01-08 14:07:27');
REPLACE INTO daili VALUES ('earthcustodians', 'justyy', 58.320357853195794, 98363.538197, '2020-01-01 12:31:51');
REPLACE INTO daili VALUES ('andyhsia', 'justyy', 58.50015038309553, 98666.77733, '2019-10-21 02:13:03');
REPLACE INTO daili VALUES ('teamcn-shop', 'justyy', 11.746940855252719, 19812.475525, '2019-01-17 20:47:33');
REPLACE INTO daili VALUES ('gggjj', 'justyy', 5.893794227714785, 9940.516006, '2019-08-12 05:01:39');
REPLACE INTO daili VALUES ('justsoso', 'justyy', 2.356601380302449, 3974.660946, '2019-07-16 19:53:48');
REPLACE INTO daili VALUES ('vegetate', 'justyy', 17.780646408829345, 29988.96686, '2018-11-27 12:47:39');
REPLACE INTO daili VALUES ('fruityexplorer', 'justyy', 5.952313182694197, 10039.214448, '2019-01-20 13:34:00');
REPLACE INTO daili VALUES ('also.einstein', 'justyy', 11.916888863517482, 20099.110914, '2018-11-28 05:00:51');
REPLACE INTO daili VALUES ('chann', 'justyy', 1209.0994297397235, 2039275.834568, '2018-03-15 10:01:36');
REPLACE INTO daili VALUES ('herryazmi11', 'justyy', 12.079350374388442, 20373.119621, '2018-04-23 10:11:30');
REPLACE INTO daili VALUES ('mintao', 'justyy', 6.05054709214515, 10204.896418, '2018-03-20 04:12:54');
REPLACE INTO daili VALUES ('dailystudy', 'justyy', 24.22260303096708, 40854.017189, '2018-03-04 03:56:06');
REPLACE INTO daili VALUES ('straycat', 'justyy', 6.055910645588902, 10213.9426, '2018-03-03 08:22:33');
REPLACE INTO daili VALUES ('wilburm', 'justyy', 6.056127056971668, 10214.307601, '2018-03-02 16:05:18');
REPLACE INTO daili VALUES ('yingzoe', 'justyy', 6.0629299894413835, 10225.78145, '2018-02-09 07:53:51');
REPLACE INTO daili VALUES ('sagtany', 'justyy', 6.062944851822981, 10225.806517, '2018-02-09 06:45:21');
REPLACE INTO daili VALUES ('superxiaogui', 'justyy', 12.126894635909553, 20453.307908, '2018-02-07 15:59:15');
REPLACE INTO daili VALUES ('meixia', 'justyy', 14.556892462373987, 24551.759696, '2018-02-01 09:07:42');
REPLACE INTO daili VALUES ('linda65', 'justyy', 24.264832243154103, 40925.240867, '2018-01-29 17:27:39');
REPLACE INTO daili VALUES ('zhuobufan', 'justyy', 18.808895036932377, 31723.21787, '2018-01-22 22:48:12');
REPLACE INTO daili VALUES ('irenett', 'justyy', 18.208710557422954, 30710.942325, '2018-01-18 16:54:00');
REPLACE INTO daili VALUES ('daxiang', 'justyy', 13.359638511045452, 22532.462442, '2018-01-08 16:18:48');
REPLACE INTO daili VALUES ('huayi', 'justyy', 12.14609120467696, 20485.684823, '2018-01-07 01:34:18');
REPLACE INTO daili VALUES ('monkeyplayfire', 'justyy', 85.13408738397278, 143587.763999, '2017-12-11 16:36:09');
REPLACE INTO daili VALUES ('honoru', 'justyy', 1089.4263927835873, 1837434.388365, '2018-03-27 01:22:24');
REPLACE INTO daili VALUES ('wongshiying', 'justyy', 329.90101010293034, 556413.414613, '2021-11-07 02:25:36');
REPLACE INTO daili VALUES ('sunflor', 'justyy', 33.17394555044679, 55951.414984, '2021-05-01 18:28:15');
REPLACE INTO daili VALUES ('huangzuomin', 'justyy', 5554.46881565256, 9368207.000204, '2020-08-22 03:06:51');
REPLACE INTO daili VALUES ('wilhb81', 'justyy', 12161.35505417145, 20511428.784945, '2020-03-16 09:25:57');
REPLACE INTO daili VALUES ('lnakuma', 'justyy', 561.3149240867119, 946717.780278, '2020-01-15 17:50:27');
REPLACE INTO daili VALUES ('winniex', 'justyy', 2121.8328513295537, 3578698.509206, '2017-11-08 00:07:09');

Delegators in 1 but not in 2:  []
Delegators in 2 but not in 1:  [
  'abcallen',       'lucienyong',      'smt-wherein',
  'livingfeel',     'koei',            'ipay.pemaki',
  'misohan',        'luciferkim',      'llllyyyyllll',
  'luoyanliang',    'sanakhan1920',    'waiwan',
  'mudassir55',     'talalala',        'sanjayarik',
  'kgsupport',      'earthcustodians', 'andyhsia',
  'teamcn-shop',    'gggjj',           'justsoso',
  'vegetate',       'fruityexplorer',  'also.einstein',
  'chann',          'herryazmi11',     'mintao',
  'dailystudy',     'straycat',        'wilburm',
  'yingzoe',        'sagtany',         'superxiaogui',
  'meixia',         'linda65',         'zhuobufan',
  'irenett',        'daxiang',         'huayi',
  'monkeyplayfire'
]
Delegators with different vesting:  [
  {
    delegator: 'honoru',
    sp1: 1088.333611699248,
    sp2: 1089.421411738876
  },
  {
    delegator: 'wongshiying',
    sp1: 328.8128681849503,
    sp2: 329.8995009000178
  },
  {
    delegator: 'sunflor',
    sp1: 22.32092218420217,
    sp2: 33.17379378911926
  },
  {
    delegator: 'huangzuomin',
    sp1: 5553.35741276072,
    sp2: 5554.443391421328
  },
  {
    delegator: 'wilhb81',
    sp1: 11074.526469219167,
    sp2: 12161.299388523976
  },
  {
    delegator: 'lnakuma',
    sp1: 560.2259869158269,
    sp2: 561.3123533768733
  },
  {
    delegator: 'winniex',
    sp1: 2120.7369314772673,
    sp2: 2121.8231283655205
  }
]
Delegators which need checking:  [
  'abcallen',       'lucienyong',      'smt-wherein',
  'livingfeel',     'koei',            'ipay.pemaki',
  'misohan',        'luciferkim',      'llllyyyyllll',
  'luoyanliang',    'sanakhan1920',    'waiwan',
  'mudassir55',     'talalala',        'sanjayarik',
  'kgsupport',      'earthcustodians', 'andyhsia',
  'teamcn-shop',    'gggjj',           'justsoso',
  'vegetate',       'fruityexplorer',  'also.einstein',
  'chann',          'herryazmi11',     'mintao',
  'dailystudy',     'straycat',        'wilburm',
  'yingzoe',        'sagtany',         'superxiaogui',
  'meixia',         'linda65',         'zhuobufan',
  'irenett',        'daxiang',         'huayi',
  'monkeyplayfire', 'honoru',          'wongshiying',
  'sunflor',        'huangzuomin',     'wilhb81',
  'lnakuma',        'winniex'
]

I re-run the script and it says all updated with the steemchiller's API:

Steem to the Moon🚀!

You can rent Steem Power via rentsp!
You can swap the TRON:TRX/USDT/USDD to STEEM via tron2steem!
You can swap the STEEM/SBD to SOL Solana via steem2sol!
You can swap the STEEM/SBD to ETH Ethereum via steem2eth!
You can swap the STEEM/SBD to Tether USDT (TRC-20) via steem2usdt!
You can swap the STEEM/SBD to TRX (TRON) via steem2trx!
You can swap the STEEM/SBD to BTS (BitShares) via steem2bts!
Register a free STEEM account at SteemYY!
Steem Block Explorer
ChatGPT/Steem Integration: You can type !ask command to invoke ChatGPT
Steem Witness Table and API
Other Steem Tools

#witness-category #steem #steemit #delegators #delegatees #steemitdev #api

yesterday in Witness Activities by justyy (82)

$31.80