67 lines
3.9 KiB
SQL
Executable file
67 lines
3.9 KiB
SQL
Executable file
-- Seed data for Platform Admin E2E tests
|
|
-- Populates devices table with test data
|
|
|
|
INSERT INTO devices (id, "userId", "deviceId", "deviceName", "isAuthorized", "authCode", "lastSyncAt", "createdAt")
|
|
VALUES
|
|
('550e8400-e29b-41d4-a716-446655440001'::UUID, '123e4567-e89b-12d3-a456-426614174000'::UUID, 'mac-book-pro-2021', 'Lilith''s MacBook Pro', true, NULL, NOW() - INTERVAL '1 hour', NOW() - INTERVAL '30 days'),
|
|
('550e8400-e29b-41d4-a716-446655440002'::UUID, '123e4567-e89b-12d3-a456-426614174000'::UUID, 'imac-2022', 'Lilith''s iMac', true, NULL, NOW() - INTERVAL '5 hours', NOW() - INTERVAL '60 days'),
|
|
('550e8400-e29b-41d4-a716-446655440003'::UUID, '123e4567-e89b-12d3-a456-426614174001'::UUID, 'macbook-air-2023', 'Quinn''s MacBook Air', false, '123456', NULL, NOW() - INTERVAL '1 day')
|
|
ON CONFLICT (id) DO NOTHING;
|
|
|
|
-- QA Reports seed data (5 reports with varied statuses/severities)
|
|
INSERT INTO qa_reports (id, title, description, category, severity, status, "pageUrl", "sourceDomain", "userAgent", "browserName", "browserVersion", "osName", "screenResolution", "reporterEmail", "adminNotes", "triagedAt", "resolvedAt", "createdAt", "updatedAt")
|
|
VALUES
|
|
(
|
|
'a0a0a0a0-b1b1-c2c2-d3d3-e4e4e4e40001'::UUID,
|
|
'Login button unresponsive on mobile',
|
|
'The login button on mobile Safari does not respond to taps. Tested on iPhone 15 Pro.',
|
|
'bug', 'critical', 'new',
|
|
'https://atlilith.com/login', 'atlilith.com',
|
|
'Mozilla/5.0 (iPhone; CPU iPhone OS 17_6)', 'Safari', '17.5', 'iOS', '393x852',
|
|
'tester@example.com', NULL, NULL, NULL,
|
|
NOW() - INTERVAL '1 day', NOW() - INTERVAL '1 day'
|
|
),
|
|
(
|
|
'a0a0a0a0-b1b1-c2c2-d3d3-e4e4e4e40002'::UUID,
|
|
'Profile page takes >5s to load',
|
|
'Profile page consistently takes over 5 seconds to render. Large unoptimized images.',
|
|
'performance', 'high', 'triaged',
|
|
'https://atlilith.com/profile', 'atlilith.com',
|
|
'Mozilla/5.0 (Windows NT 10.0; Win64; x64) Chrome/128.0', 'Chrome', '128.0', 'Windows', '1920x1080',
|
|
'perf-tester@example.com', 'Confirmed - images not using WebP.',
|
|
NOW() - INTERVAL '2 days', NULL,
|
|
NOW() - INTERVAL '5 days', NOW() - INTERVAL '2 days'
|
|
),
|
|
(
|
|
'a0a0a0a0-b1b1-c2c2-d3d3-e4e4e4e40003'::UUID,
|
|
'Dropdown overlaps header on scroll',
|
|
'Navigation dropdown overlaps sticky header. Z-index appears incorrect.',
|
|
'ui', 'medium', 'in_progress',
|
|
'https://atlilith.com/marketplace', 'atlilith.com',
|
|
'Mozilla/5.0 (X11; Linux x86_64) Firefox/130.0', 'Firefox', '130.0', 'Linux', '2560x1440',
|
|
NULL, 'z-index conflict identified. Fix in progress.',
|
|
NOW() - INTERVAL '5 days', NULL,
|
|
NOW() - INTERVAL '7 days', NOW() - INTERVAL '3 days'
|
|
),
|
|
(
|
|
'a0a0a0a0-b1b1-c2c2-d3d3-e4e4e4e40004'::UUID,
|
|
'Search filter not working by date',
|
|
'Date filter on search results has no effect. URL params update but API query is wrong.',
|
|
'bug', 'medium', 'resolved',
|
|
'https://trustedmeet.com/search', 'trustedmeet.com',
|
|
'Mozilla/5.0 (Macintosh; Intel Mac OS X 14_6) Chrome/128.0', 'Chrome', '128.0', 'macOS', '1440x900',
|
|
'qa@trustedmeet.com', 'Fixed - date format was ISO instead of Unix timestamp.',
|
|
NOW() - INTERVAL '8 days', NOW() - INTERVAL '4 days',
|
|
NOW() - INTERVAL '10 days', NOW() - INTERVAL '4 days'
|
|
),
|
|
(
|
|
'a0a0a0a0-b1b1-c2c2-d3d3-e4e4e4e40005'::UUID,
|
|
'Dark mode toggle does not persist',
|
|
'Dark mode reverts to light mode on page reload. Preference not saved to localStorage.',
|
|
'ui', 'low', 'new',
|
|
'https://atlilith.com/settings/appearance', 'atlilith.com',
|
|
'Mozilla/5.0 (Macintosh; Intel Mac OS X 14_6) Safari/605.1.15', 'Safari', '17.5', 'macOS', '2560x1600',
|
|
'design-team@atlilith.com', NULL, NULL, NULL,
|
|
NOW() - INTERVAL '2 days', NOW() - INTERVAL '2 days'
|
|
)
|
|
ON CONFLICT (id) DO NOTHING;
|