seed.sql

INSERT INTO Users (FullName, Email, PasswordHash, Role)
VALUES
('Lynus Lim', 'lynus@example.com', 'hashed_password_123', 'Admin'),
('Ariel Tan', 'ariel@example.com', 'hashed_password_456', 'User'),
('Falak A.', 'falak@example.com', 'hashed_password_789', 'User');

INSERT INTO Dashboards (Name, Description, IsPrivate)
VALUES
('EGRA Team Project', 'EGRA Dashboard for collaboration for work projects.', 1),
('Holiday Planning', 'Dashboard used to plan our holiday in December!', 1),
('Daily Task Manager', 'Keep track of daily tasks and provide suggestions on how to improve', 1),
('Gaming Checklist', 'Dashboard to check for optimizations for gaming performance', 0),
('Dashmi Task Board', 'Dashmi task board with Alison for weekend planning', 1),
('Assignment 1 FSDP', 'Dashboard to help provide help for Full Stack Development Assignment 1', 0),
('Dashboard 7', 'This dashboard is used for interesting purposes', 1);

-- Admin = Admin role (was previously Owner), Regular User = Viewer
INSERT INTO UserDashboards (UserId, DashboardId, Role)
VALUES
(1, 1, 'Admin'),
(1, 2, 'Admin'),
(1, 3, 'Admin'),
(1, 4, 'Admin'),
(1, 5, 'Admin'),
(1, 6, 'Admin'),
(1, 7, 'Admin'),
(2, 1, 'Editor'),
(2, 2, 'Viewer'),
(3, 3, 'Viewer');

-- Create standard boards for all dashboards (To Do, In Progress, Completed, Error)
INSERT INTO Boards (DashboardId, Position, Name)
VALUES
-- Dashboard 1: EGRA Team Project
(1, 0, 'To Do'),
(1, 1, 'In Progress'),
(1, 2, 'Completed'),
(1, 3, 'Error'),
-- Dashboard 2: Holiday Planning
(2, 0, 'To Do'),
(2, 1, 'In Progress'),
(2, 2, 'Completed'),
(2, 3, 'Error'),
-- Dashboard 3: Daily Task Manager
(3, 0, 'To Do'),
(3, 1, 'In Progress'),
(3, 2, 'Completed'),
(3, 3, 'Error'),
-- Dashboard 4: Gaming Checklist
(4, 0, 'To Do'),
(4, 1, 'In Progress'),
(4, 2, 'Completed'),
(4, 3, 'Error'),
-- Dashboard 5: Dashmi Task Board
(5, 0, 'To Do'),
(5, 1, 'In Progress'),
(5, 2, 'Completed'),
(5, 3, 'Error'),
-- Dashboard 6: Assignment 1 FSDP
(6, 0, 'To Do'),
(6, 1, 'In Progress'),
(6, 2, 'Completed'),
(6, 3, 'Error'),
-- Dashboard 7
(7, 0, 'To Do'),
(7, 1, 'In Progress'),
(7, 2, 'Completed'),
(7, 3, 'Error');

--  #region Kanban Board
-- To Do Board (Dashboard 1)
INSERT INTO Tasks (
    BoardId, Position, Title, Description, CreatedBy,
    AssignedAgent, Skills, Category, Status, EstimatedDuration, 
    AgentMatchScore, AgentProgress, Dependencies
)
VALUES
(1, 0, 'Set up project structure', 'Initialize folder structure and configs.', 1,
 'Ollama', 'setup,config', 'Setup', 'Pending', '2h', 85, 0, NULL),
(1, 1, 'Define requirements', 'Collect and draft initial requirements.', 1,
 'Ollama', 'analysis,writing', 'Documentation', 'Pending', '4h', 78, 0, NULL);

-- In Progress Board (Dashboard 1)
INSERT INTO Tasks (
    BoardId, Position, Title, Description, CreatedBy,
    AssignedAgent, Skills, Category, Status, EstimatedDuration, 
    AgentMatchScore, AgentProgress, Dependencies
)
VALUES
(2, 0, 'Create database schema', 'Design SQL schema and relationships.', 1,
 'Ollama', 'sql,db-design', 'Development', 'In Progress', '3h', 90, 45, '100');

-- Completed Board (Dashboard 1)
INSERT INTO Tasks(
    BoardId, Position, Title, Description, CreatedBy,
    AssignedAgent, Skills, Category, Status, EstimatedDuration,
    AgentMatchScore, AgentProgress, Dependencies
)
VALUES
(3, 0, 'Create wireframes', 'Initial UI/UX wireframes completed.', 2,
 NULL, NULL, 'Design', 'Done', '1h', NULL, 100, NULL);

-- #endregion Kanban Board