Files

48 lines
1.1 KiB
SQL

DROP PROCEDURE IF EXISTS `UpdateHotBitcoinAddressUnspentTotals`
#
DROP PROCEDURE IF EXISTS `UpdateHotBitcoinAddressUnspentTotal`
#
CREATE PROCEDURE `UpdateHotBitcoinAddressUnspentTotal` (
IN hotBitcoinAddressId INTEGER
)
BEGIN
UPDATE HotBitcoinAddresses
INNER JOIN
(
SELECT HotBitcoinAddressId, SUM(AmountSatoshis) AS UnspentAmountSum
FROM HotBitcoinAddressUnspents
GROUP BY HotBitcoinAddressId
) innerSelection ON HotBitcoinAddresses.HotBitcoinAddressId = innerSelection.HotBitcoinAddressId
SET HotBitcoinAddresses.BalanceSatoshis = innerSelection.UnspentAmountSum
WHERE HotBitcoinAddresses.HotBitcoinAddressId=hotBitcoinAddressId;
END
#
CREATE PROCEDURE `UpdateHotBitcoinAddressUnspentTotals` ()
BEGIN
UPDATE HotBitcoinAddresses
INNER JOIN
(
SELECT HotBitcoinAddressId, SUM(AmountSatoshis) AS UnspentAmountSum
FROM HotBitcoinAddressUnspents
GROUP BY HotBitcoinAddressId
) innerSelection ON HotBitcoinAddresses.HotBitcoinAddressId = innerSelection.HotBitcoinAddressId
SET HotBitcoinAddresses.BalanceSatoshis = innerSelection.UnspentAmountSum;
END