Consider implementing has many relation on the BlockEvent model to list BlockEventAttributes

[pharr117]

The first implementation of the BlockEventAttribute model has implemented a belongs to relation on the BlockEvent table. We should consider moving to a has_many relation from BlockEvents -> BlockEventAttributes. This may make insert much faster and reduce the amount of preprocessing needed on the BlockEventAttribute table during batch insert here:

cosmos-indexer/db/events.go

Lines 108 to 136 in 45f92b6

	var allAttributes []models.BlockEventAttribute
	for index := range blockDBWrapper.BeginBlockEvents {
	currAttributes := blockDBWrapper.BeginBlockEvents[index].Attributes
	for attrIndex := range currAttributes {
	currAttributes[attrIndex].BlockEventID = blockDBWrapper.BeginBlockEvents[index].BlockEvent.ID
	currAttributes[attrIndex].BlockEvent = blockDBWrapper.BeginBlockEvents[index].BlockEvent
	currAttributes[attrIndex].BlockEventAttributeKey = blockDBWrapper.UniqueBlockEventAttributeKeys[currAttributes[attrIndex].BlockEventAttributeKey.Key]
	}
	allAttributes = append(allAttributes, currAttributes...)
	}
	for index := range blockDBWrapper.EndBlockEvents {
	currAttributes := blockDBWrapper.EndBlockEvents[index].Attributes
	for attrIndex := range currAttributes {
	currAttributes[attrIndex].BlockEventID = blockDBWrapper.EndBlockEvents[index].BlockEvent.ID
	currAttributes[attrIndex].BlockEvent = blockDBWrapper.EndBlockEvents[index].BlockEvent
	currAttributes[attrIndex].BlockEventAttributeKey = blockDBWrapper.UniqueBlockEventAttributeKeys[currAttributes[attrIndex].BlockEventAttributeKey.Key]
	}
	allAttributes = append(allAttributes, currAttributes...)
	}
	if len(allAttributes) != 0 {
	if err := dbTransaction.Clauses(clause.OnConflict{DoNothing: true}).Create(&allAttributes).Error; err != nil {
	config.Log.Error("Error creating begin block event attributes.", err)
	return nil
	}
	}
	}

Its possible this could become a one-liner by passing in the attributes as an array. We would probably still need to pre-process the AttributeKeys and apply them to the items.