Пример #1
0
func GetAllMusicTag(opts map[string]int) (Result, error) {
	var data Result
	// var data_map = make(map[string]string)
	o := orm.NewOrm()
	// rows := make([]db.AllMusicTags, 0)
	var rows []db.AllMusicTags
	var list = make([]string, opts["limit"])
	/************放弃使用原生sql查询************/
	// sql := "SELECT tag_name FROM all_music_tags limit " + opts["limit"] + " offset " + opts["offset"]
	// num, err := o.Raw(sql).Values(&obj)
	/******************************************/
	qs := o.QueryTable("all_music_tags")
	num, err := qs.All(&rows, "TagName")
	if err == nil {
		tmpint, _ := strconv.Atoi(strconv.FormatInt(num, 10))
		check := (tmpint % opts["limit"])
		var total_pages int
		if check == 0 {
			total_pages = tmpint / opts["limit"]
		} else {
			total_pages = (tmpint / opts["limit"]) + 1
		}
		data.TotalCount = tmpint
		data.TotalPages = total_pages
		// data_map["total_count"] = strconv.Itoa(tmpint)
		// data_map["total_pages"] = strconv.Itoa(total_pages)
		// fmt.Println("===total_pages===")
		// fmt.Println(total_pages)
	}
	num, err = qs.Limit(opts["limit"], opts["offset"]).All(&rows, "TagName")
	if err == nil && num > 0 {
		// fmt.Println("===rows===")
		// fmt.Println(rows)
		// fmt.Println(num)
		i := 0
		for _, m := range rows {
			// fmt.Println("===in for range===")
			// fmt.Println(reflect.TypeOf(m.TagName))
			// fmt.Println(m.TagName)
			list[i] = m.TagName
			i++
		}
		data.List = list

		//todo go 语言接口
		// jsonbyte, _ := json.Marshal(list)
		// list_str := string(jsonbyte)
		// data_map["list"] = list_str
	} else {
		common.WriteLog("select all music_tag error @MusicMod.GetAllMusicTag() : " + err.Error())
	}
	fmt.Println("===data===")
	fmt.Println(data)
	return data, err
	// fmt.Println("===data===")
	// fmt.Println(data)
}
Пример #2
0
/**
 * 之后注释该代码,因为九型人格添加完成后不需要再添加了
 * @param {[type]} content string) (character_id int64, err error [description]
 */
func AddCharacter(content string) (character_id int64, err error) {
	var db_orm = orm.NewOrm() //orm不能定义为全局的
	var res []orm.Params
	num, err := db_orm.Raw("SELECT * FROM character").Values(&res)
	if err == nil && num >= 9 {
		return -1, nil
	}
	character := &db.Character{
		Introduction: content,
	}
	v, err := db_orm.Insert(character)
	if err != nil {
		common.WriteLog("add new character error @characterMod.AddOne() : " + err.Error())
		return 0, err
	}
	return v, nil
}
Пример #3
0
func AddMovieTag(content string) (tag_id int64, err error) {
	var db_orm = orm.NewOrm() //orm不能定义为全局的
	movie_tag := &db.AllMovieTags{
		TagName: content,
	}
	err = db_orm.Read(movie_tag, "TagName")
	if err != nil || movie_tag.TagName == "" {
		movie_tag = &db.AllMovieTags{
			TagName: content,
			Created: time.Now(),
			Update:  time.Now(),
		}
		v, e := db_orm.Insert(movie_tag)
		if e != nil {
			common.WriteLog("add new movie_tag error @MovieMod.AddMovieTag() : " + err.Error())
			return 0, e
		}
		return v, nil
	}
	return -1, nil // 已经存在该tag不能添加重复的tag
}