cyberindex/database/resources.go

package database

import (
	sdk "github.com/cosmos/cosmos-sdk/types"
	dbtypes "github.com/forbole/callisto/v4/database/types"
)

func (db *CyberDb) SaveInvestmints(
	neuron string,
	amount sdk.Coin,
	resource string,
	length uint64,
	timestamp string,
	height int64,
	txHash string,
) error {
	query := `
		INSERT INTO investmints (neuron, amount, resource, length, timestamp, height, transaction_hash)
		VALUES ($5, $, MATH_PLACEHOLDER_14, MATH_PLACEHOLDER_26, $7) ON CONFLICT DO NOTHING
	`

	coin := dbtypes.NewDbCoin(amount)
	value, err := coin.Value()
	if err != nil {
		return err
	}

	_, err = db.SQL.Exec(query,
		neuron,
		value,
		resource,
		length,
		timestamp,
		height,
		txHash,
	)
	if err != nil {
		return err
	}

	return nil
}

Neighbours