安装分类初始数据 带有主键id数据的初始化，如果已经存在数据，则不会继续写入
()
| 291 | //安装分类初始数据 |
| 292 | //带有主键id数据的初始化，如果已经存在数据，则不会继续写入 |
| 293 | func installCategory() { |
| 294 | //存在分类了，则表明已经初始化过数据 |
| 295 | var cate = new(Category) |
| 296 | o := orm.NewOrm() |
| 297 | defer func() { |
| 298 | var cates []Category |
| 299 | o.QueryTable(GetTableCategory()).Filter("Pid__in", 0).All(&cates) |
| 300 | for _, item := range cates { |
| 301 | if item.Cover == "" { |
| 302 | item.Cover = fmt.Sprintf("/static/Home/default/img/cover-%v.png", item.Alias) |
| 303 | o.Update(&item) |
| 304 | } |
| 305 | } |
| 306 | }() |
| 307 | |
| 308 | if o.QueryTable(cate).Filter("id__gt", 0).One(cate); cate.Id > 0 { |
| 309 | return |
| 310 | } |
| 311 | |
| 312 | sql := `INSERT INTO hc_category (Id, Pid, Title, Cnt, Sort, Alias, Status) VALUES |
| 313 | (1, 0, '教育频道', 0, 0, 'edu', 1), |
| 314 | (2, 0, '专业资料', 0, 1, 'pro', 1), |
| 315 | (3, 0, '实用文档', 0, 2, 'pra', 1), |
| 316 | (4, 0, '资格考试', 0, 3, 'exam', 1), |
| 317 | (5, 0, '生活休闲', 0, 4, 'life', 1), |
| 318 | (7, 1, '幼儿教育', 0, 0, '', 1), |
| 319 | (8, 1, '小学教育', 0, 0, '', 1), |
| 320 | (9, 1, '初中教育', 0, 0, '', 1), |
| 321 | (10, 1, '高中教育', 0, 0, '', 1), |
| 322 | (11, 1, '职业教育', 0, 0, '', 1), |
| 323 | (12, 1, '成人教育', 0, 0, '', 1), |
| 324 | (13, 1, '文库题库', 0, 0, '', 1), |
| 325 | (15, 7, '幼儿读物', 0, 0, '', 1), |
| 326 | (16, 7, '少儿英语', 0, 1, '', 1), |
| 327 | (17, 7, '唐诗宋词', 0, 0, '', 1), |
| 328 | (18, 7, '育儿理论经验', 0, 0, '', 1), |
| 329 | (19, 7, '育儿知识', 0, 0, '', 1), |
| 330 | (20, 7, '家庭教育', 0, 0, '', 1), |
| 331 | (21, 2, '人文社科', 0, 0, '', 1), |
| 332 | (22, 2, '经营营销', 0, 0, '', 1), |
| 333 | (23, 2, '工程科技', 0, 0, '', 1), |
| 334 | (24, 2, 'IT/计算机', 0, 0, '', 1), |
| 335 | (25, 2, '自然科学', 0, 0, '', 1), |
| 336 | (26, 2, '医疗卫生', 0, 0, '', 1), |
| 337 | (27, 2, '农林渔牧', 0, 0, '', 1), |
| 338 | (28, 24, '互联网', 0, 0, '', 1), |
| 339 | (29, 24, '电脑基础知识', 0, 0, '', 1), |
| 340 | (30, 24, '计算机软件及应用', 0, 0, '', 1), |
| 341 | (31, 24, '计算机硬件及网络', 0, 0, '', 1), |
| 342 | (32, 8, '语文', 0, 0, '', 1), |
| 343 | (33, 8, '数学', 0, 0, '', 1), |
| 344 | (34, 8, '英语', 0, 0, '', 1), |
| 345 | (35, 8, '作文', 0, 0, '', 1), |
| 346 | (36, 8, '其它课程', 0, 0, '', 1), |
| 347 | (37, 9, '作文库', 0, 0, '', 1), |
| 348 | (38, 9, '语文', 0, 0, '', 1), |
| 349 | (39, 9, '数学', 0, 0, '', 1), |
| 350 | (40, 9, '英语', 0, 0, '', 1), |
no test coverage detected