Repository navigation
Expand file tree
/
Copy pathsample_data.sql
More file actions
35 lines (31 loc) · 3.23 KB
/
Copy pathsample_data.sql
File metadata and controls
35 lines (31 loc) · 3.23 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
-- StudyFlow Sample Seed Data
USE studyflow;
-- Seed Tasks
INSERT INTO tasks (title, subject, priority, deadline, status) VALUES
('Complete Data Structures & Algorithms Assignment', 'DSA', 'high', DATE_ADD(NOW(), INTERVAL 2 DAY), 'pending'),
('Read Chapter 4 of Operating Systems Textbook', 'Computer Science', 'medium', DATE_ADD(NOW(), INTERVAL 3 DAY), 'pending'),
('Practice Python Flask REST APIs & Route Controllers', 'Python', 'high', DATE_SUB(NOW(), INTERVAL 1 DAY), 'completed'),
('Review MySQL Relational Database Indexing & Joins', 'Database Systems', 'low', DATE_ADD(NOW(), INTERVAL 5 DAY), 'pending'),
('Build Vanilla JavaScript Pomodoro Countdown Module', 'Web Development', 'medium', DATE_SUB(NOW(), INTERVAL 2 DAY), 'completed'),
('Prepare Slides for Software Architecture Seminar', 'Software Engineering', 'high', DATE_ADD(NOW(), INTERVAL 1 DAY), 'pending');
-- Seed Study Sessions
INSERT INTO study_sessions (subject, duration, completed_date) VALUES
('DSA', 50, DATE_SUB(NOW(), INTERVAL 3 DAY)),
('Python', 25, DATE_SUB(NOW(), INTERVAL 2 DAY)),
('Web Development', 75, DATE_SUB(NOW(), INTERVAL 1 DAY)),
('Computer Science', 25, NOW()),
('Database Systems', 45, NOW());
-- Seed Learning Resources
INSERT INTO resources (subject, topic, difficulty, description, url) VALUES
('Python', 'Object-Oriented Programming & Clean Architecture', 'Intermediate', 'Learn classes, inheritance, polymorphism, and modular design patterns in Python.', 'https://docs.python.org/3/tutorial/classes.html'),
('Python', 'Building REST APIs with Flask', 'Beginner', 'Step-by-step guide to routing, request handling, JSON responses, and CORS in Flask.', 'https://flask.palletsprojects.com/'),
('Java', 'Spring Boot Microservices Essentials', 'Advanced', 'Comprehensive walkthrough of dependency injection, JPA entities, and REST controllers.', 'https://spring.io/guides'),
('Java', 'Java Collections Framework Masterclass', 'Intermediate', 'Master ArrayList, HashMap, TreeSet, and LinkedList performance tradeoffs in Java.', 'https://docs.oracle.com/en/java/'),
('HTML & CSS', 'Modern CSS Grid & Flexbox Mastery', 'Beginner', 'Create fluid, responsive application layouts with CSS Grid, Flexbox, and CSS Variables.', 'https://developer.mozilla.org/en-US/docs/Web/CSS'),
('JavaScript', 'Asynchronous JS, Promises & Async/Await', 'Intermediate', 'Deep dive into event loop, fetch API, promises, and non-blocking asynchronous JavaScript.', 'https://javascript.info/async'),
('DSA', 'Binary Trees & Graph Traversal Algorithms', 'Advanced', 'Visualizing BFS, DFS, Dijkstra, and Binary Search Tree operations step-by-step.', 'https://geeksforgeeks.org/data-structures/'),
('Database Systems', 'MySQL Indexing & Performance Optimization', 'Intermediate', 'Understand B-Tree indexes, query execution plans, transactions, and ACID properties.', 'https://dev.mysql.com/doc/');
-- Seed Contact Messages
INSERT INTO contact_messages (name, email, subject, message) VALUES
('Alex Johnson', 'alex.johnson@example.com', 'Feature Request: Calendar Sync', 'I love StudyFlow! Would it be possible to add Google Calendar integration in the future?'),
('Sophia Chen', 'sophia.c@example.edu', 'Praise for Focus Zone', 'The Pomodoro timer audio alerts and automatic study session logging are game changers for my midterm prep!');