-- Sample transaction operations data for testing refund settlement processing
-- Run this SQL after running migrations to set up test data

INSERT INTO transaction_operations (
  operation_request_id, 
  transaction_id, 
  operation_type, 
  operation_status, 
  operation_amount, 
  operation_currency, 
  operation_date, 
  metadata,
  inserted_at, 
  updated_at
) VALUES
-- Matching refund operations for the sample CSV file
('refund_1753960289065', 'TX_REFUND_001', 'REFUND', 'COMPLETED', 125.50, 'AED', '2025-01-15 10:30:00', '{"original_transaction_id": "TX_PAYMENT_001", "reason": "customer_request"}', NOW(), NOW()),
('refund_1753960289067', 'TX_REFUND_002', 'REFUND', 'COMPLETED', 75.25, 'AED', '2025-01-15 10:32:00', '{"original_transaction_id": "TX_PAYMENT_002", "reason": "duplicate_charge"}', NOW(), NOW()),
('refund_1753960289069', 'TX_REFUND_003', 'REFUND', 'COMPLETED', 300.00, 'AED', '2025-01-15 10:34:00', '{"original_transaction_id": "TX_PAYMENT_003", "reason": "service_cancellation"}', NOW(), NOW()),
-- Additional test operations
('refund_1234567890001', 'TX_REFUND_004', 'REFUND', 'PENDING', 50.00, 'AED', '2025-01-15 11:00:00', '{"original_transaction_id": "TX_PAYMENT_004", "reason": "product_return"}', NOW(), NOW()),
('payment_1234567890002', 'TX_PAYMENT_005', 'PAYMENT', 'COMPLETED', 250.00, 'AED', '2025-01-15 11:15:00', '{"payment_method": "card", "terminal_id": "TERM_001"}', NOW(), NOW());

-- Display the inserted data
SELECT 
  operation_request_id,
  transaction_id,
  operation_type,
  operation_status,
  operation_amount,
  operation_currency,
  operation_date
FROM transaction_operations
ORDER BY operation_date DESC;