bvcodeverse1/test_users.sql at main · BV-CodeVerse/bvcodeverse1 · GitHub

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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
-- Test data for user_profiles table
INSERT INTO user_profiles (
  user_id,
  full_name,
  phone,
  location,
  bio,
  github,
  linkedin,
  college,
  year,
  branch,
  skills,
  created_at,
  updated_at
) VALUES
(
  'test-user-1',
  'Arjun Sharma',
  '+91-9876543210',
  'Mumbai, Maharashtra',
  'Full-stack developer passionate about React and Node.js. Love building scalable web applications.',
  'https://github.com/arjunsharma',
  'https://linkedin.com/in/arjunsharma',
  'Bharati Vidyapeeth College of Engineering',
  '3rd Year',
  'Computer Science Engineering',
  '["React", "Node.js", "JavaScript", "Python", "MongoDB"]',
  NOW(),
  NOW()
),
(
  'test-user-2',
  'Priya Patel',
  '+91-9876543211',
  'Pune, Maharashtra',
  'UI/UX Designer and Frontend Developer. Creating beautiful and user-friendly interfaces.',
  'https://github.com/priyapatel',
  'https://linkedin.com/in/priyapatel',
  'Bharati Vidyapeeth College of Engineering',
  '2nd Year',
  'Information Technology',
  '["UI/UX Design", "React", "Figma", "CSS", "JavaScript"]',
  NOW(),
  NOW()
),
(
  'test-user-3',
  'Rahul Singh',
  '+91-9876543212',
  'Delhi, India',
  'Machine Learning enthusiast and Python developer. Working on AI projects.',
  'https://github.com/rahulsingh',
  'https://linkedin.com/in/rahulsingh',
  'Bharati Vidyapeeth College of Engineering',
  '4th Year',
  'Computer Science Engineering',
  '["Python", "Machine Learning", "TensorFlow", "Data Science", "AI"]',
  NOW(),
  NOW()
),
(
  'test-user-4',
  'Sneha Gupta',
  '+91-9876543213',
  'Bangalore, Karnataka',
  'Mobile app developer specializing in React Native and Flutter.',
  'https://github.com/snehagupta',
  'https://linkedin.com/in/snehagupta',
  'Bharati Vidyapeeth College of Engineering',
  '3rd Year',
  'Computer Science Engineering',
  '["React Native", "Flutter", "Dart", "JavaScript", "Firebase"]',
  NOW(),
  NOW()
),
(
  'test-user-5',
  'Vikash Kumar',
  '+91-9876543214',
  'Hyderabad, Telangana',
  'DevOps engineer and cloud enthusiast. Love automating everything!',
  'https://github.com/vikashkumar',
  'https://linkedin.com/in/vikashkumar',
  'Bharati Vidyapeeth College of Engineering',
  '4th Year',
  'Information Technology',
  '["DevOps", "AWS", "Docker", "Kubernetes", "CI/CD"]',
  NOW(),
  NOW()
);

-- Test data for user_stats table
INSERT INTO user_stats (
  user_id,
  total_points,
  rank,
  level,
  projects_completed,
  contests_won,
  badges_earned,
  streak_days,
  next_level_points,
  created_at,
  updated_at
) VALUES
(
  'test-user-1',
  1250,
  1,
  'Senior Developer',
  15,
  3,
  8,
  45,
  1500
),
(
  'test-user-2',
  890,
  2,
  'Intermediate',
  12,
  2,
  6,
  30,
  1000
),
(
  'test-user-3',
  1450,
  1,
  'Expert',
  18,
  4,
  10,
  60,
  2000
),
(
  'test-user-4',
  720,
  3,
  'Intermediate',
  10,
  1,
  5,
  25,
  1000
),
(
  'test-user-5',
  980,
  2,
  'Advanced',
  14,
  2,
  7,
  35,
  1000
);