def populate_search_block_id(store):
store.log.info("Calculating block.search_block_id")
for block_id, height, prev_id in store.selectall("""
SELECT block_id, block_height, prev_block_id
FROM block
WHERE block_height IS NOT NULL
ORDER BY block_height"""):
height = int(height)
search_id = None
if prev_id is not None:
prev_id = int(prev_id)
search_height = util.get_search_height(height)
if search_height is not None:
search_id = store.get_block_id_at_height(search_height, prev_id)
store.sql("UPDATE block SET search_block_id = ? WHERE block_id = ?",
(search_id, block_id))
store.cache_block(int(block_id), height, prev_id, search_id)
store.commit()
def populate_search_block_id(store):
store.log.info("Calculating block.search_block_id")
for block_id, height, prev_id in store.selectall("""
SELECT block_id, block_height, prev_block_id
FROM block
WHERE block_height IS NOT NULL
ORDER BY block_height"""):
height = int(height)
search_id = None
if prev_id is not None:
prev_id = int(prev_id)
search_height = util.get_search_height(height)
if search_height is not None:
search_id = store.get_block_id_at_height(search_height, prev_id)
store.sql("UPDATE block SET search_block_id = ? WHERE block_id = ?",
(search_id, block_id))
store.cache_block(int(block_id), height, prev_id, search_id)
store.commit()
