Question: How to Get the height of a Block

[jvxis]

Hello,
I'd like to include the height of the block in PostgreSQL table blocks.

This is part of the code where blocks are persisted

if (share.foundBlock){
var shareId = result.rows[0].id;
db.query(
'INSERT INTO blocks(share_id, from_group, to_group, block_hash, worker, created_date, modified_date) VALUES($1, $2, $3, $4, $5, $6, $7)',
[shareId, share.job.fromGroup, share.job.toGroup, share.blockHash, share.workerAddress, new Date(), new Date()],

Thanks,
Jvx

[Lbqds]

There is no block height information in the job. You can obtain the block height in the following two ways:

1. Parse the parentHash from job.headerBlob, then query the height of the parent block from the full node using the parentHash.
2. Wait until the block is submitted, then query the block height using the share.blockHash.