-- $1 user_guid
-- $2 network
-- $3 asset
-- $4 direction
-- $5 count_limit
-- $6 amount_limit
-- $7 amount_minimum
INSERT INTO stably.limit_user (
user_guid,
network,
asset,
direction,
count_limit,
amount_limit,
amount_minimum
)
VALUES (
$1::UUID,
$2::VARCHAR,
$3::VARCHAR,
$4::VARCHAR,
$5::INT,
$6::NUMERIC,
$7::NUMERIC
)
ON CONFLICT (user_guid, network, direction)
DO UPDATE SET
asset = EXCLUDED.asset,
direction = EXCLUDED.direction,
count_limit = EXCLUDED.count_limit,
amount_limit = EXCLUDED.amount_limit,
amount_minimum = EXCLUDED.amount_minimum;
-- $1 user_guid
-- $2 network
-- $3 asset
-- $4 direction
-- $5 count_limit
-- $6 amount_limit
-- $7 amount_minimum
INSERT INTO stably.limit_user (
user_guid,
network,
asset,
direction,
count_limit,
amount_limit,
amount_minimum
)
VALUES (
$1::UUID,
$2::VARCHAR,
$3::VARCHAR,
$4::VARCHAR,
$5::INT,
$6::NUMERIC,
$7::NUMERIC
)
ON CONFLICT (user_guid, network, direction)
DO UPDATE SET
asset = EXCLUDED.asset,
direction = EXCLUDED.direction,
count_limit = EXCLUDED.count_limit,
amount_limit = EXCLUDED.amount_limit,
amount_minimum = EXCLUDED.amount_minimum;