promethus/seed_data.sql at main · AlphaSudo/promethus · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
INSERT INTO account_projections (account_id, owner_id, balance, currency, status, account_type, version, created_at, updated_at)
VALUES ('a1b2c3d4-e5f6-7890-a1b2-c3d4e5f6a1b2', 'e6760ac6-5501-4ef9-93ed-947ec9654fdc', 1250.00, 'USD', 'ACTIVE', 'SAVINGS', 2, NOW(), NOW())
ON CONFLICT (account_id) DO UPDATE SET balance = 1250.00, version = 2;

INSERT INTO events (event_id, aggregate_id, aggregate_type, event_type, event_data, version, occurred_at)
VALUES ('77777777-7777-7777-7777-777777777777', 'a1b2c3d4-e5f6-7890-a1b2-c3d4e5f6a1b2', 'Account', 'AccountCreatedEvent',
'{"eventId": "77777777-7777-7777-7777-777777777777", "occurredAt": "2026-02-13T10:00:00Z", "version": 1, "aggregateId": "a1b2c3d4-e5f6-7890-a1b2-c3d4e5f6a1b2", "ownerId": "e6760ac6-5501-4ef9-93ed-947ec9654fdc", "currency": "USD", "accountType": "SAVINGS"}'::jsonb, 1, '2026-02-13T10:00:00Z')
ON CONFLICT DO NOTHING;

INSERT INTO events (event_id, aggregate_id, aggregate_type, event_type, event_data, version, occurred_at)
VALUES ('88888888-8888-8888-8888-888888888888', 'a1b2c3d4-e5f6-7890-a1b2-c3d4e5f6a1b2', 'Account', 'MoneyDepositedEvent',
'{"eventId": "88888888-8888-8888-8888-888888888888", "occurredAt": "2026-02-13T11:00:00Z", "version": 1, "aggregateId": "a1b2c3d4-e5f6-7890-a1b2-c3d4e5f6a1b2", "amount": 1500.00, "currencyCode": "USD", "transactionId": "tx-salary", "description": "Monthly Salary"}'::jsonb, 2, '2026-02-13T11:00:00Z')
ON CONFLICT DO NOTHING;

INSERT INTO events (event_id, aggregate_id, aggregate_type, event_type, event_data, version, occurred_at)
VALUES ('99999999-9999-9999-9999-999999999999', 'a1b2c3d4-e5f6-7890-a1b2-c3d4e5f6a1b2', 'Account', 'MoneyWithdrawnEvent',
'{"eventId": "99999999-9999-9999-9999-999999999999", "occurredAt": "2026-02-13T12:00:00Z", "version": 1, "aggregateId": "a1b2c3d4-e5f6-7890-a1b2-c3d4e5f6a1b2", "amount": 250.00, "currencyCode": "USD", "transactionId": "tx-rent", "description": "Rent Payment"}'::jsonb, 3, '2026-02-13T12:00:00Z')
ON CONFLICT DO NOTHING;