Function fetchTransactionPrecisionFromDB

model/model.go:263–304

fetchTransactionPrecisionFromDB is a placeholder for fetching precision from the database. In a real application, this would query your database. It returns the precision, a boolean indicating if found, and an error.

(db *sql.DB, transactionID string)

// In a real application, this would query your database.
// It returns the precision, a boolean indicating if found, and an error.
func fetchTransactionPrecisionFromDB(db *sql.DB, transactionID string) (float64, bool, error) {
	// Check cache first
	if precision, found := precisionCache[transactionID]; found {
		logrus.WithFields(logrus.Fields{
			"transaction_id": transactionID,
			"precision":      precision,
		}).Debug("cache hit for transaction precision")
		return precision, true, nil
	}

	var precision float64
	// First try to find precision by transaction_id
	query := `
		SELECT precision
		FROM ledgerforge.transactions
		WHERE transaction_id = $1
		OR parent_transaction = $1
		LIMIT 1`
	err := db.QueryRow(query, transactionID).Scan(&precision)
	if err == sql.ErrNoRows {
		return 0, false, nil
	}
	if err != nil {
		logrus.WithError(err).WithField("transaction_id", transactionID).Error("error querying precision")
		return 0, false, err
	}
	if precision <= 0 { // Or any other validation for valid precision
		logrus.WithFields(logrus.Fields{
			"transaction_id": transactionID,
			"precision":      precision,
		}).Warn("invalid precision found in DB")
		return 0, false, nil // Treat invalid precision as not found for fallback logic
	}

	// Store in cache
	precisionCache[transactionID] = precision
	logrus.WithFields(logrus.Fields{
		"transaction_id": transactionID,
		"precision":      precision,
	}).Debug("cache miss, fetched precision from DB and cached")
	return precision, true, nil
}

// ApplyPrecisionWithDBLookup attempts to fetch precision from the database
// and then applies it to the transaction. Falls back to transaction-defined