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()