#!/usr/bin/env python3
"""
Seed historical trades from the 0x01fe user session into the database.
These trades happened before the DB was created, so they need to be inserted manually.

Run on Pi: python3 scripts/seed_historical.py
"""

import sys
sys.path.insert(0, "backend")

from db import init_db, record_trade, save_market, resolve_market

init_db()

# Market 846131349d1d5c8c — Resolved YES, strike $70,461.01
save_market("0x846131349d1d5c8c", 70461010000, 1773998400, 1773998700)
resolve_market("0x846131349d1d5c8c", "YES", 70513000000)

# Market 3719a07b3a41acbc — Resolved NO, strike $70,682.12
save_market("0x3719a07b3a41acbc", 70682120000, 1773999300, 1773999600)
resolve_market("0x3719a07b3a41acbc", "NO", 70637000000)

# Historical trades from 0x01fe session
# Market 846131349d1d5c8c (YES won)
trades_846 = [
    # (buyer, seller, price, size) — buyer=buys YES, seller=sells YES (gets NO)
    ("0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", "0x4f020878617eb003311e596069980fc7c23d97b6", 756898, 1321181),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 745979, 1662587),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 726969, 2000000),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 706388, 1303731),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 697312, 2000000),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 672468, 959306),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 668386, 2000000),
    ("0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", "0x4f020878617eb003311e596069980fc7c23d97b6", 562577, 1777534),
]

for buyer, seller, price, size in trades_846:
    record_trade(
        buyer=buyer, seller=seller, outcome=0, price=price, size=size,
        market_id="0x846131349d1d5c8c", timestamp=1773998500,
    )

# Market 3719a07b3a41acbc (NO won)
trades_3719 = [
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 145303, 865191),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 135224, 1134809),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 201058, 680919),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 149681, 2000000),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 119233, 461173),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 121770, 2000000),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 116420, 2000000),
    ("0x4f020878617eb003311e596069980fc7c23d97b6", "0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", 150074, 2000000),
    ("0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", "0x4f020878617eb003311e596069980fc7c23d97b6", 345411, 789462),
    ("0x01fe330f1a3732ff527e2e8618e3f4b0aa1e220c", "0x4f020878617eb003311e596069980fc7c23d97b6", 351379, 2000000),
]

for buyer, seller, price, size in trades_3719:
    record_trade(
        buyer=buyer, seller=seller, outcome=0, price=price, size=size,
        market_id="0x3719a07b3a41acbc", timestamp=1773999400,
    )

print("Seeded 18 historical trades + 2 resolved markets")
print("Leaderboard should now show correct PnL for 0x4f02 and 0x01fe")