Later I will try if I can do a SPARQL query for the exact number.
I'm working on some instrumentation via SPARQL queries. The first out of the starting gate is daily emissions, a reasonably straightforward figure to obtain, all that's needed is the height of the next block minted after a given midnight.
Preliminary results, which are probably also exposing gaps in the mapping to RDF, I haven't yet had time to create a cross-referencing function which will identify any gaps but that's the next task. Also, it seems I've inadvertently swapped the axis labels.
The data has been committed to the docs subdirectory of the master branch in ODS spreadsheet format
https://github.com/slimcoin-project/Slimcoin/blob/master/doc/emissions.ods(Oh, BTW, ditto for an editable version of the Slimcoin white paper in ODT:
https://github.com/slimcoin-project/Slimcoin/blob/master/doc/slimcoin-white-paper.odt)
I use the Python script included below to generate and pose the SPARQL queries of Fuseki, persisting the results in comma-separated format:
def test_get_emissions(self):
# unittests already imported
import json
import requests
import datetime
# switch endpoint
testnet = True
# template SPARQL query returning the block height of the next minted
# block after {timestamp}
querytmpl = \
'''?query=PREFIX+ccy%3A+%3Chttp%3A%2F%2Fpurl.org%2Fnet%2F''' \
'''bel-epa%2Fccy%23%3E%0ASELECT+%3Fheight+%3Fdt%0AWHERE+%''' \
'''7B%0A++%3Fblock+ccy%3Aheight+%3Fheight+.%0A++%3Fblock+''' \
'''ccy%3Atime+%3Fdt.+%0A++FILTER(%3Fdt+%3C+{timestamp})%0''' \
'''A%7D%0AORDER+BY+DESC(%3Fdt)+LIMIT+1'''
url = '''http://localhost:3030/{}/sparql'''.format(
'slmtchain' if testnet else 'slmchain')
# Initialise the starting date
ptr = psz = datetime.date(year=2017, month=4, day=15) if testnet \
else datetime.date(year=2014, month=5, day=28)
# Create a day incrementer
nextday = datetime.timedelta(days=1)
# Save results in comma-separated format
with open('/tmp/{}-emissions.csv'.format(
'testnet' if testnet else 'mainnet'), 'w') as fp:
# create day range to drive iteration
for day in range(0, (datetime.date.today() - psz).days):
# Blurt progress
if day % 100 == 0:
print(day)
# Increment the date pointer by one day
ptr += nextday
# Create timestamp from date pointer
ts = int(datetime.datetime.strptime(
'{}-{}-{}T00:00:00.000Z'.format(
ptr.year, ptr.month, ptr.day),
'%Y-%m-%dT%H:%M:%S.%fZ').timestamp())
# Execute the SPARQL query
res = requests.get(url + querytmpl.format(
timestamp=ts)
).content.decode('utf-8')
# Marshal and persist the results for the given day
resd = json.loads(res)
height = resd['results']['bindings'][0]['height']['value']
bdate = resd['results']['bindings'][0]['dt']['value']
datum = '''"{t}",{h},{d}\n'''.format(t=ptr, h=height, d=bdate)
fp.write(datum)
fp.close()
When rapid prototyping, I habitually work in a test environment (I *know* that's not what is meant by TDD) because I appreciate a controlled, standard environment which, not entirely co-incidentally, allows me just to hit ^B in Sublime text to run the test and see the output in the results buffer.
Note, results are written to '/tmp/
', just a serving suggestion.
Cheers
Graham
.
