def sequencing_hook(self, db_session, parent_block_data, parent_sequenced_block_data):
for account_index_audit in AccountIndexAudit.query(db_session).filter_by(
block_id=self.block.id
).order_by('event_idx'):
if account_index_audit.type_id == settings.ACCOUNT_INDEX_AUDIT_TYPE_NEW:
# Check if account index already exists
account_index = AccountIndex.query(db_session).filter_by(
id=account_index_audit.account_index_id
).first()
if not account_index:
account_index = AccountIndex(
id=account_index_audit.account_index_id,
created_at_block=self.block.id
)
account_index.account_id = account_index_audit.account_id
account_index.short_address = ss58_encode_account_index(
account_index_audit.account_index_id,
settings.SUBSTRATE_ADDRESS_TYPE
)
account_index.updated_at_block = self.block.id
account_index.save(db_session)
# Update index in corresponding account
account = Account.query(db_session).get(account_index.account_id)
if account:
account.index_address = account_index.short_address
account.save(db_session)
elif account_index_audit.type_id == settings.ACCOUNT_INDEX_AUDIT_TYPE_REAPED:
if account_index_audit.account_index_id:
account_index_list = AccountIndex.query(db_session).filter_by(
id=account_index_audit.account_index_id
)
else:
account_index_list = AccountIndex.query(db_session).filter_by(
account_id=account_index_audit.account_id
)
for account_index in account_index_list:
account_index.account_id = None
account_index.is_reclaimable = True
account_index.updated_at_block = self.block.id
account_index.save(db_session)
def sequencing_hook(self, db_session, parent_block_data, parent_sequenced_block_data):
for account_index_audit in AccountIndexAudit.query(db_session).filter_by(
block_id=self.block.id
).order_by('event_idx'):
if account_index_audit.type_id == ACCOUNT_INDEX_AUDIT_TYPE_NEW:
account_index = AccountIndex(
id=account_index_audit.account_index_id,
account_id=account_index_audit.account_id,
short_address=ss58_encode_account_index(
account_index_audit.account_index_id,
SUBSTRATE_ADDRESS_TYPE
),
created_at_block=self.block.id,
updated_at_block=self.block.id
)
account_index.save(db_session)
elif account_index_audit.type_id == ACCOUNT_INDEX_AUDIT_TYPE_REAPED:
for account_index in AccountIndex.query(db_session).filter_by(
account_id=account_index_audit.account_id
):
account_index.account_id = None
account_index.is_reclaimable = True
account_index.updated_at_block = self.block.id
def sequencing_hook(self, db_session, parent_block_data,
parent_sequenced_block_data):
#print('start add_block Process block processors {} =='.format("Process block AccountIndexBlockProcessor "))
for account_index_audit in AccountIndexAudit.query(
db_session).filter_by(
block_id=self.block.id).order_by('event_idx'):
if account_index_audit.type_id == ACCOUNT_INDEX_AUDIT_TYPE_NEW:
account_index = AccountIndex(
id=account_index_audit.account_index_id,
account_id=account_index_audit.account_id,
short_address=bech32.encode(
HRP,
bytes().fromhex(account_index_audit.account_index_id)),
created_at_block=self.block.id,
updated_at_block=self.block.id)
account_index.save(db_session)
elif account_index_audit.type_id == ACCOUNT_INDEX_AUDIT_TYPE_REAPED:
for account_index in AccountIndex.query(db_session).filter_by(
account_id=account_index_audit.account_id):
account_index.account_id = None
account_index.is_reclaimable = True
account_index.updated_at_block = self.block.id
def get_relationships(self, include_list, item):
relationships = {}
if 'recent_extrinsics' in include_list:
relationships['recent_extrinsics'] = Extrinsic.query(self.session).filter_by(
address=item.id).order_by(Extrinsic.block_id.desc())[:10]
if 'indices' in include_list:
relationships['indices'] = AccountIndex.query(self.session).filter_by(
account_id=item.id).order_by(AccountIndex.updated_at_block.desc())
return relationships
def sequencing_hook(self, db_session, parent_block_data,
parent_sequenced_block_data):
for account_audit in AccountAudit.query(db_session).filter_by(
block_id=self.block.id).order_by('event_idx'):
try:
account = Account.query(db_session).filter_by(
id=account_audit.account_id).one()
if account_audit.type_id == ACCOUNT_AUDIT_TYPE_REAPED:
account.count_reaped += 1
account.is_reaped = True
elif account_audit.type_id == ACCOUNT_AUDIT_TYPE_NEW:
account.is_reaped = False
account.updated_at_block = self.block.id
except NoResultFound:
account = Account(id=account_audit.account_id,
address=ss58_encode(account_audit.account_id,
SUBSTRATE_ADDRESS_TYPE),
hash_blake2b=blake2_256(
binascii.unhexlify(
account_audit.account_id)),
created_at_block=self.block.id,
updated_at_block=self.block.id,
balance=0)
# Retrieve index in corresponding account
account_index = AccountIndex.query(db_session).filter_by(
account_id=account.id).first()
if account_index:
account.index_address = account_index.short_address
account.save(db_session)
# # If reaped but does not exist, create new account for now
# if account_audit.type_id != ACCOUNT_AUDIT_TYPE_NEW:
# account.is_reaped = True
# account.count_reaped = 1
account.save(db_session)
def get_relationships(self, include_list, item):
relationships = {}
if 'recent_extrinsics' in include_list:
relationships['recent_extrinsics'] = Extrinsic.query(
self.session).filter_by(address=item.id).order_by(
Extrinsic.block_id.desc())[:10]
if 'indices' in include_list:
relationships['indices'] = AccountIndex.query(
self.session).filter_by(account_id=item.id).order_by(
AccountIndex.updated_at_block.desc())
if 'rewards' in include_list:
relationships['rewards'] = Block.query(self.session).filter_by(
coinbase=bech32.encode(HRP,
bytes().fromhex(item.id))).order_by(
Block.id.desc())
# Block.query(self.session).order_by(Block.id.desc()
# count = self.session.query(func.count(Block.id)).filter(Block.coinbase == item_id).scalar()
return relationships
def get_item(self, item_id):
return AccountIndex.query(
self.session).filter_by(short_address=item_id).first()
def get_query(self):
return AccountIndex.query(self.session).order_by(
AccountIndex.updated_at_block.desc())
def sequencing_hook(self, db_session, parent_block_data, parent_sequenced_block_data):
for account_audit in AccountAudit.query(db_session).filter_by(block_id=self.block.id).order_by('event_idx'):
try:
account = Account.query(db_session).filter_by(id=account_audit.account_id).one()
if account_audit.type_id == settings.ACCOUNT_AUDIT_TYPE_REAPED:
account.count_reaped += 1
account.is_reaped = True
elif account_audit.type_id == settings.ACCOUNT_AUDIT_TYPE_NEW:
account.is_reaped = False
account.updated_at_block = self.block.id
except NoResultFound:
account = Account(
id=account_audit.account_id,
address=ss58_encode(account_audit.account_id, settings.SUBSTRATE_ADDRESS_TYPE),
hash_blake2b=blake2_256(binascii.unhexlify(account_audit.account_id)),
is_treasury=(account_audit.data or {}).get('is_treasury', False),
is_sudo=(account_audit.data or {}).get('is_sudo', False),
was_sudo=(account_audit.data or {}).get('is_sudo', False),
created_at_block=self.block.id,
updated_at_block=self.block.id
)
# Retrieve index in corresponding account
account_index = AccountIndex.query(db_session).filter_by(account_id=account.id).first()
if account_index:
account.index_address = account_index.short_address
# Retrieve and set initial balance
try:
account_info_data = self.substrate.get_runtime_state(
module='System',
storage_function='Account',
params=['0x{}'.format(account.id)],
block_hash=self.block.hash
).get('result')
if account_info_data:
account.balance_free = account_info_data["data"]["free"]
account.balance_reserved = account_info_data["data"]["reserved"]
account.balance_total = account_info_data["data"]["free"] + account_info_data["data"]["reserved"]
account.nonce = account_info_data["nonce"]
except ValueError:
pass
# # If reaped but does not exist, create new account for now
# if account_audit.type_id != ACCOUNT_AUDIT_TYPE_NEW:
# account.is_reaped = True
# account.count_reaped = 1
account.save(db_session)
# Until SUDO and batch calls are processed separately we need to do a safety check to be sure we include all
# accounts that have activity (lookup in account_index) in current block
# TODO implement calls
for search_index in db_session.query(SearchIndex.account_id).filter(
SearchIndex.block_id == self.block.id,
SearchIndex.account_id.notin_(db_session.query(Account.id))
).distinct():
account = Account(
id=search_index.account_id,
address=ss58_encode(search_index.account_id, settings.SUBSTRATE_ADDRESS_TYPE),
hash_blake2b=blake2_256(binascii.unhexlify(search_index.account_id)),
created_at_block=self.block.id,
updated_at_block=self.block.id
)
try:
account_info_data = self.substrate.get_runtime_state(
module='System',
storage_function='Account',
params=['0x{}'.format(account.id)],
block_hash=self.block.hash
).get('result')
if account_info_data:
account.balance_free = account_info_data["data"]["free"]
account.balance_reserved = account_info_data["data"]["reserved"]
account.balance_total = account_info_data["data"]["free"] + account_info_data["data"]["reserved"]
account.nonce = account_info_data["nonce"]
except ValueError:
pass
account.save(db_session)
