197 lines
3.4 KiB
SQL
197 lines
3.4 KiB
SQL
-- 创建测试教师数据
|
||
-- 用于测试游客模式下的教师列表和筛选功能
|
||
|
||
-- 先检查是否已有数据
|
||
SELECT COUNT(*) as teacher_count FROM teacher WHERE status = 1;
|
||
|
||
-- 插入测试教师数据
|
||
INSERT INTO teacher (
|
||
name,
|
||
real_name,
|
||
teacher_name,
|
||
phone,
|
||
status,
|
||
subjects,
|
||
service_area,
|
||
grades,
|
||
introduction,
|
||
teaching_years,
|
||
hourly_rate,
|
||
rating,
|
||
student_count,
|
||
user_id,
|
||
create_time,
|
||
update_time
|
||
) VALUES
|
||
-- 教师1：孙全能（全科）
|
||
(
|
||
'孙全能',
|
||
'孙全能',
|
||
'孙全能',
|
||
'13800138001',
|
||
1,
|
||
'语文,数学,英语',
|
||
'朝阳区',
|
||
'1-3年级,4-6年级',
|
||
'全科辅导专家，8年教学经验，擅长综合提升学生成绩',
|
||
8,
|
||
160,
|
||
4.8,
|
||
156,
|
||
-1001,
|
||
NOW(),
|
||
NOW()
|
||
),
|
||
-- 教师2：周博学（理科）
|
||
(
|
||
'周博学',
|
||
'周博学',
|
||
'周博学',
|
||
'13800138002',
|
||
1,
|
||
'数学,物理,化学',
|
||
'海淀区',
|
||
'初中,高中',
|
||
'理科专家，12年教学经验，擅长数理化综合辅导',
|
||
12,
|
||
170,
|
||
4.9,
|
||
203,
|
||
-1002,
|
||
NOW(),
|
||
NOW()
|
||
),
|
||
-- 教师3：吴艺术（艺术）
|
||
(
|
||
'吴艺术',
|
||
'吴艺术',
|
||
'吴艺术',
|
||
'13800138003',
|
||
1,
|
||
'美术,书法',
|
||
'西城区',
|
||
'1-3年级,4-6年级,初中',
|
||
'艺术专业，6年教学经验，培养学生艺术素养',
|
||
6,
|
||
180,
|
||
4.7,
|
||
89,
|
||
-1003,
|
||
NOW(),
|
||
NOW()
|
||
),
|
||
-- 教师4：郑音乐（音乐）
|
||
(
|
||
'郑音乐',
|
||
'郑音乐',
|
||
'郑音乐',
|
||
'13800138004',
|
||
1,
|
||
'音乐,钢琴,声乐',
|
||
'东城区',
|
||
'1-3年级,4-6年级',
|
||
'音乐教育专业，10年教学经验，多名学生考级通过',
|
||
10,
|
||
190,
|
||
4.8,
|
||
134,
|
||
-1004,
|
||
NOW(),
|
||
NOW()
|
||
),
|
||
-- 教师5：李英语（英语专家）
|
||
(
|
||
'李英语',
|
||
'李英语',
|
||
'李英语',
|
||
'13800138005',
|
||
1,
|
||
'英语',
|
||
'朝阳区',
|
||
'初中,高中',
|
||
'英语专业八级，15年教学经验，擅长口语和写作',
|
||
15,
|
||
200,
|
||
4.9,
|
||
267,
|
||
-1005,
|
||
NOW(),
|
||
NOW()
|
||
),
|
||
-- 教师6：张数学（数学专家）
|
||
(
|
||
'张数学',
|
||
'张数学',
|
||
'张数学',
|
||
'13800138006',
|
||
1,
|
||
'数学',
|
||
'海淀区',
|
||
'1-3年级,4-6年级,初中',
|
||
'数学竞赛教练，10年教学经验，多名学生获奖',
|
||
10,
|
||
180,
|
||
4.8,
|
||
178,
|
||
-1006,
|
||
NOW(),
|
||
NOW()
|
||
),
|
||
-- 教师7：王语文（语文专家）
|
||
(
|
||
'王语文',
|
||
'王语文',
|
||
'王语文',
|
||
'13800138007',
|
||
1,
|
||
'语文,作文',
|
||
'西城区',
|
||
'4-6年级,初中,高中',
|
||
'语文高级教师，20年教学经验，擅长阅读理解和作文',
|
||
20,
|
||
190,
|
||
4.9,
|
||
312,
|
||
-1007,
|
||
NOW(),
|
||
NOW()
|
||
),
|
||
-- 教师8：赵物理（物理专家）
|
||
(
|
||
'赵物理',
|
||
'赵物理',
|
||
'赵物理',
|
||
'13800138008',
|
||
1,
|
||
'物理',
|
||
'东城区',
|
||
'初中,高中',
|
||
'物理竞赛教练，12年教学经验，擅长实验和解题技巧',
|
||
12,
|
||
185,
|
||
4.8,
|
||
198,
|
||
-1008,
|
||
NOW(),
|
||
NOW()
|
||
);
|
||
|
||
-- 验证插入结果
|
||
SELECT
|
||
id,
|
||
name,
|
||
subjects,
|
||
service_area,
|
||
grades,
|
||
hourly_rate,
|
||
rating,
|
||
student_count
|
||
FROM teacher
|
||
WHERE status = 1
|
||
ORDER BY create_time DESC;
|
||
|
||
-- 检查筛选选项数据
|
||
SELECT DISTINCT subjects FROM teacher WHERE status = 1;
|
||
SELECT DISTINCT service_area FROM teacher WHERE status = 1;
|
||
SELECT DISTINCT grades FROM teacher WHERE status = 1;
|