-- Insert wine
INSERT INTO wines (id, winery, name, year, image_name, origin)
VALUES (2, 'Château Margaux', 'Grand Vin', 2016, 'margaux_2015.jpg',
        ARRAY['France', 'Bordeaux', 'Margaux']);

-- Insert wine details
INSERT INTO wine_details (wine_id, description, color, size, classification, blend, sweetness, alcohol)
VALUES (2,
        'A remarkable vintage showcasing the epitome of Margaux''s terroir with exceptional balance and complexity.',
        'red',
        '0.75',
        'Premier Cru',
        ARRAY['Cabernet Sauvignon', 'Merlot', 'Petit Verdot', 'Cabernet Franc'],
        'dry',
        13.5);

-- Insert wine analytics
INSERT INTO wine_analytics (wine_id, critic_score, avarage_retail_price)
VALUES (2, 98, 860.00);

-- Insert tokens for the wine
INSERT INTO tokens (id, collection_id, wine_id, creator, owner, minted_at, minted_tx, burned)
VALUES
    (4, 1, 2,
     '0x2234567890123456789012345678901234567890',
     '0x4234567890123456789012345678901234567890',
     1699891200,
     '0xabcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234',
     false),
    (5, 1, 2,
     '0x2234567890123456789012345678901234567890',
     '0x5234567890123456789012345678901234567890',
     1699891200,
     '0xefef5678efef5678efef5678efef5678efef5678efef5678efef5678efef5678',
     false),
    (6, 1, 2,
     '0x2234567890123456789012345678901234567890',
     '0x5234567890123456789012345678901234567890',
     1699891200,
     '0xefef5678efef5678efef5678efef5678efef5678efef5678efef5678efef5678',
     true); -- Burned

-- Insert token metadata
INSERT INTO token_metadata (token_id, collection_id, meta_uri)
VALUES
    (4, 1, 'ipfs://QmAbC123...1'),
    (5, 1, 'ipfs://QmAbC123...2'),
    (6, 1, 'ipfs://QmAbC123...2');

-- Insert orders for first token
INSERT INTO orders (id, seller, buyer, collection_id, token_id, price, payment_token, duration, expire_at)
VALUES
    (8,
     '0x4234567890123456789012345678901234567890',
     '0x6234567890123456789012345678901234567890',
     1, 4, 900.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1700496000),
    (9,
     '0x4234567890123456789012345678901234567890',
     NULL,
     1, 4, 950.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701100800), -- November 27, 2024
    (10,
     '0x4234567890123456789012345678901234567890',
     NULL,
     1, 4, 1000.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701705600); -- December 4, 2024

INSERT INTO order_statuses (order_id, state, timestamp)
VALUES
    (8, 1, 1699891200), -- Created
    (8, 3, 1699977600), -- Confirmed
    (8, 7, 1699891200), -- Fulfilled

    (9, 1, 1699977600), -- Created
    (9, 3, 1700064000), -- Confirmed

    (10, 1, 1700150400); -- Created

-- Insert orders for second token
INSERT INTO orders (id, seller, buyer, collection_id, token_id, price, payment_token, duration, expire_at)
VALUES
    (11,
     '0x5234567890123456789012345678901234567890',
     '0x7234567890123456789012345678901234567890',
     1, 5, 880.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1700496000),
    (12,
     '0x5234567890123456789012345678901234567890',
     NULL,
     1, 5, 920.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701100800),
    (13,
     '0x5234567890123456789012345678901234567890',
     NULL,
     1, 5, 975.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701705600);

INSERT INTO order_statuses (order_id, state, timestamp)
VALUES
    (11, 1, 1699891200), -- Created
    (11, 3, 1699977600), -- Confirmed
    (11, 7, 1699891200), -- Fulfilled

    (12, 1, 1699977600), -- Created
    (12, 3, 1700064000), -- Confirmed

    (13, 1, 1700150400); -- Created

-- Insert orders for third(burned) token
INSERT INTO orders (id, seller, buyer, collection_id, token_id, price, payment_token, duration, expire_at)
VALUES
    (14,
     '0x5234567890123456789012345678901234567890',
     NULL,
     1, 6, 69.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701705600);

INSERT INTO order_statuses (order_id, state, timestamp)
VALUES
    (14, 1, 1699977600), -- Created
    (14, 3, 1700064000); -- Confirmed