def historical_update(blockheight):
""" Very long running task. Fills out the network difficulty values for all
blocks before the site was running. """
def add_one_minute_diff(diff, time):
try:
m = OneMinuteType(typ='netdiff', value=diff, time=time)
db.session.add(m)
db.session.commit()
except sqlalchemy.exc.IntegrityError:
db.session.rollback()
slc = OneMinuteType.query.with_lockmode('update').filter_by(
time=time, typ='netdiff').one()
# just average the diff of two blocks that occured in the same second..
slc.value = (diff + slc.value) / 2
db.session.commit()
for ht in xrange(blockheight, 0, -1):
hsh = coinserv.getblockhash(ht)
info = coinserv.getblock(hsh)
add_one_minute_diff(info['difficulty'] * 1000,
datetime.datetime.utcfromtimestamp(info['time']))
current_app.logger.info("Processed block height {}".format(ht))
db.session.commit()
OneMinuteType.compress()
db.session.commit()
FiveMinuteType.compress()
db.session.commit()
def historical_update(blockheight):
""" Very long running task. Fills out the network difficulty values for all
blocks before the site was running. """
def add_one_minute_diff(diff, time):
try:
m = OneMinuteType(typ='netdiff', value=diff, time=time)
db.session.add(m)
db.session.commit()
except sqlalchemy.exc.IntegrityError:
db.session.rollback()
slc = OneMinuteType.query.with_lockmode('update').filter_by(
time=time, typ='netdiff').one()
# just average the diff of two blocks that occured in the same second..
slc.value = (diff + slc.value) / 2
db.session.commit()
for ht in xrange(blockheight, 0, -1):
hsh = coinserv.getblockhash(ht)
info = coinserv.getblock(hsh)
add_one_minute_diff(info['difficulty'] * 1000,
datetime.datetime.utcfromtimestamp(info['time']))
current_app.logger.info("Processed block height {}".format(ht))
db.session.commit()
OneMinuteType.compress()
db.session.commit()
FiveMinuteType.compress()
db.session.commit()
def compress_minute():
""" Compresses OneMinute records (for temp, hashrate, shares, rejects) to
FiveMinute """
OneMinuteShare.compress()
OneMinuteReject.compress()
OneMinuteTemperature.compress()
OneMinuteHashrate.compress()
OneMinuteType.compress()
db.session.commit()
def compress_minute():
""" Compresses OneMinute records (for temp, hashrate, shares, rejects) to
FiveMinute """
OneMinuteShare.compress()
OneMinuteReject.compress()
OneMinuteTemperature.compress()
OneMinuteHashrate.compress()
OneMinuteType.compress()
db.session.commit()
def compress_minute(self):
""" Compresses OneMinute records (for temp, hashrate, shares, rejects) to
FiveMinute """
try:
OneMinuteShare.compress()
OneMinuteReject.compress()
OneMinuteTemperature.compress()
OneMinuteHashrate.compress()
OneMinuteType.compress()
db.session.commit()
except Exception:
logger.error("Unhandled exception in compress_minute", exc_info=True)
db.session.rollback()
