RE: Part 26: Retrieving Data From The STEEM Blockchain And Storing Into A MySQL Database by zipsardinia

View this thread on: hive.blog | peakd.com | ecency.com

Viewing a response to: @steempytutorials/part-26-retrieving-data-from-the-steem-blockchain-and-storing-into-a-mysql-database

utopian-io · @zipsardinia · Jul 7 '18 (edited)

$0.43

Hello Friend. I started the tutorial. I also imported my account, everything worked. Since I have steempy set nodes https://rpc.steemviz.com
How can I set the default node again? Thanks!
WARNING:root:Retry in 1s -- RPCErrorRecoverable: non-200 response: 502 from rpc.steemviz.com
WARNING:root:Retry in 2s -- RPCErrorRecoverable: non-200 response: 502 from rpc.steemviz.com
WARNING:root:Retry in 3s -- RPCErrorRecoverable: non-200 response: 502 from rpc.steemviz.com
.....
ERROR:root:Failed after 10 attempts -- RPCErrorRecoverable: non-200 response: 502 from rpc.steemviz.com
Traceback (most recent call last):
  File "/home/mfrau/anaconda3/bin/steempy", line 11, in "<"module">"
    sys.exit(legacyentry())
  File "/home/mfrau/anaconda3/lib/python3.6/site-packages/steem/cli.py", line 776, in legacyentry
    steem = stm.Steem(no_broadcast=args.no_broadcast, **options)
  File "/home/mfrau/anaconda3/lib/python3.6/site-packages/steem/steem.py", line 59, in __init__
    steemd_instance=self.steemd, no_broadcast=no_broadcast, **kwargs)
  File "/home/mfrau/anaconda3/lib/python3.6/site-packages/steem/commit.py", line 96, in __init__
    self.wallet = Wallet(self.steemd, **kwargs)
  File "/home/mfrau/anaconda3/lib/python3.6/site-packages/steem/wallet.py", line 61, in __init__
    self.prefix = self.steemd.chain_params["prefix"]
  File "/home/mfrau/anaconda3/lib/python3.6/site-packages/steem/steemd.py", line 65, in chain_params
    props = self.get_dynamic_global_properties()
  File "/home/mfrau/anaconda3/lib/python3.6/site-packages/steem/steemd.py", line 419, in get_dynamic_global_properties
    return self.call('get_dynamic_global_properties', api='database_api')
  File "/home/mfrau/anaconda3/lib/python3.6/site-packages/steembase/http_client.py", line 288, in call
    raise e
  File "/home/mfrau/anaconda3/lib/python3.6/site-packages/steembase/http_client.py", line 246, in call
    % (response.status, self.hostname))
steembase.exceptions.RPCErrorRecoverable: non-200 response: 502 from rpc.steemviz.com

👍 raised2b, loreennaa, nolnocluap, raviraj, steembusiness, sanjeevm, futile, kdee916, rampagejr, bestboom, jigstrike, annadoll, laraventure, berbo, kennybll, thenativeguy

`author`	zipsardinia
`permlink`	re-steempytutorials-part-26-retrieving-data-from-the-steem-blockchain-and-storing-into-a-mysql-database-20180707t084438558z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"links":["https://rpc.steemviz.com"],"app":"steemit/0.1"}
`created`	2018-07-07 08:44:39
`last_update`	2018-07-07 08:47:09
`depth`	1
`children`	4
`last_payout`	2018-07-14 08:44:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.334 HBD
`curator_payout_value`	0.099 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	2,018
`author_reputation`	5,608,798,363,039
`root_title`	"Part 26: Retrieving Data From The STEEM Blockchain And Storing Into A MySQL Database"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	0
`post_id`	63,755,810
`net_rshares`	217,218,127,523
`author_curate_reward`	""

properties (23)vote details (16)

voter	rshares	pct
loreennaa	24,571,581,690	61%
nolnocluap	22,419,710,086	32%
sanjeevm	15,357,584,677	18%
steembusiness	19,058,297,042	35%
raised2b	29,241,891,516	14%
raviraj	20,808,623,790	99%
annadoll	7,573,438,540	65%
kdee916	11,837,643,245	100%
thenativeguy	5,905,174,415	100%
kennybll	6,890,083,421	65%
laraventure	7,526,756,527	30%
jigstrike	7,573,785,007	38%
berbo	6,899,311,188	100%
rampagejr	9,400,174,857	95%
bestboom	8,180,960,505	39%
futile	13,973,111,017	15%

@juliank · Jul 7 '18

You can manually set the nodes in the code as following:

>nodes = ['https://api.steemit.com',
                      'https://rpc.buildteam.io',
                      'https://rpc.steemviz.com']
   steem = Steem(nodes=self.nodes)

properties (22)

`author`	juliank
`permlink`	re-zipsardinia-re-steempytutorials-part-26-retrieving-data-from-the-steem-blockchain-and-storing-into-a-mysql-database-20180707t093549155z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"links":["https://api.steemit.com","https://rpc.buildteam.io","https://rpc.steemviz.com"],"app":"steemit/0.1"}
`created`	2018-07-07 09:35:48
`last_update`	2018-07-07 09:35:48
`depth`	2
`children`	2
`last_payout`	2018-07-14 09:35:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	229
`author_reputation`	117,823,071,447,502
`root_title`	"Part 26: Retrieving Data From The STEEM Blockchain And Storing Into A MySQL Database"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	63,760,036
`net_rshares`	0

@zipsardinia · Jul 7 '18

>>> nodes=['https://api.steemit.com']
>>> from steem import Steem
>>> steem = Steem(nodes=self.nodes)
Traceback (most recent call last):
  File "<"stdin">", line 1, in "<"module">"
NameError: name 'self' is not defined

properties (22)

`author`	zipsardinia
`permlink`	re-juliank-re-zipsardinia-re-steempytutorials-part-26-retrieving-data-from-the-steem-blockchain-and-storing-into-a-mysql-database-20180707t100252431z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"links":["https://api.steemit.com"],"app":"steemit/0.1"}
`created`	2018-07-07 10:02:54
`last_update`	2018-07-07 10:02:54
`depth`	3
`children`	1
`last_payout`	2018-07-14 10:02:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	218
`author_reputation`	5,608,798,363,039
`root_title`	"Part 26: Retrieving Data From The STEEM Blockchain And Storing Into A MySQL Database"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	0
`post_id`	63,762,337
`net_rshares`	0

@steempytutorials · Jul 7 '18

$0.02

Sorry:

>nodes = ['https://api.steemit.com',
'https://rpc.buildteam.io',
'https://rpc.steemviz.com']
steem = Steem(nodes=nodes)

or within the class:

>self.nodes = ['https://api.steemit.com',
'https://rpc.buildteam.io',
'https://rpc.steemviz.com']
self.steem = Steem(nodes=self.nodes)

👍 zipsardinia

`author`	steempytutorials
`permlink`	re-zipsardinia-re-juliank-re-zipsardinia-re-steempytutorials-part-26-retrieving-data-from-the-steem-blockchain-and-storing-into-a-mysql-database-20180707t105650923z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"links":["https://api.steemit.com","https://rpc.buildteam.io","https://rpc.steemviz.com"],"app":"steemit/0.1"}
`created`	2018-07-07 10:56:51
`last_update`	2018-07-07 10:56:51
`depth`	4
`children`	0
`last_payout`	2018-07-14 10:56:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.016 HBD
`curator_payout_value`	0.005 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	285
`author_reputation`	31,094,047,689,691
`root_title`	"Part 26: Retrieving Data From The STEEM Blockchain And Storing Into A MySQL Database"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	63,766,998
`net_rshares`	11,335,602,978
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
zipsardinia	0 B		11,335,602,978	100%

@zipsardinia · Jul 7 '18

not work too: 
> steempy set nodes ''

properties (22)