Method GetBlockList

api/models/blocks.go:33–77

GetBlockList get a list of blocks with height in [from, to).

(since, page, size int)

// GetBlockList get a list of blocks with height in [from, to).
func (m *BlocksModel) GetBlockList(since, page, size int) (blocks []*Block, pagination *Pagination, err error) {
	var (
		querySQL = `
		SELECT
			height,
			hash,
			timestamp,
			version,
			producer,
			merkle_root,
			parent,
			tx_count
		FROM
			indexed_blocks
		`
		countSQL = buildCountSQL(querySQL)
		conds    []string
		args     []interface{}
	)

	pagination = NewPagination(page, size)
	if since > 0 {
		conds = append(conds, "height < ?")
		args = append(args, since)
	}

	querySQL, countSQL = buildSQLWithConds(querySQL, countSQL, conds)

	count, err := chaindb.SelectInt(countSQL, args...)
	if err != nil {
		return nil, pagination, err
	}
	pagination.SetTotal(int(count))
	blocks = make([]*Block, 0)
	if pagination.Offset() > pagination.Total {
		return blocks, pagination, nil
	}

	querySQL += " ORDER BY height DESC"
	querySQL += " LIMIT ? OFFSET ?"
	args = append(args, pagination.Limit(), pagination.Offset())

	_, err = chaindb.Select(&blocks, querySQL, args...)
	return blocks, pagination, err
}

// GetBlockByHeight get a block by its height.
func (m *BlocksModel) GetBlockByHeight(height int) (block *Block, err error) {