Golang orm.ColValue函数代码示例

// IncreasePullCount ...
func IncreasePullCount(name string) (err error) {
	o := GetOrmer()
	num, err := o.QueryTable("repository").Filter("name", name).Update(
		orm.Params{
			"pull_count":  orm.ColValue(orm.ColAdd, 1),
			"update_time": time.Now(),
		})
	if num == 0 {
		err = fmt.Errorf("Failed to increase repository pull count with name: %s %s", name, err.Error())
	}
	return err
}

func (self *NovelCollectModel) PutCollect(novelid int) (map[string]interface{}, error) {
	o := orm.NewOrm()
	_, err := o.QueryTable("novel").Filter("id", novelid).Update(orm.Params{
		"novelcollect": orm.ColValue(orm.ColAdd, 1),
	})
	if err != nil {
		return nil, err
	}
	ret := map[string]interface{}{
		"novelid": novelid,
	}
	return ret, nil
}

func (m *Post) Delete() error {
	if m.Tags != "" {
		o := orm.NewOrm()
		oldtags := strings.Split(strings.Trim(m.Tags, ","), ",")
		//标签统计-1
		o.QueryTable(&Tag{}).Filter("name__in", oldtags).Update(orm.Params{"count": orm.ColValue(orm.Col_Minus, 1)})
		//删掉tag_post表的记录
		o.QueryTable(&TagPost{}).Filter("postid", m.Id).Delete()
	}
	if _, err := orm.NewOrm().Delete(m); err != nil {
		return err
	}
	return nil
}

//根据id获取文章 todo 点击量模型未构建 返回改文章对应的标签
func GetArticleById(id interface{}) (Article, error) {
	article := Article{}
	o := orm.NewOrm()
	err := o.QueryTable("article").Filter("Id", id).RelatedSel().One(&article)

	if err == nil {
		o.QueryTable("article").Filter("Id", id).Update(orm.Params{
			"Views": orm.ColValue(orm.Col_Add, 1),
		})
		//查询该文章对应的标签
		//		var tags []*Tag
		//		_, err = o.QueryTable("tag").Filter("Articles__Article__Id", id).All(&tags)
		//		article.Tags = tags
	}

	return article, err
}

func PostBrowsersAdd(uid int, ip string, post *models.Post) {
	var key string
	if uid == 0 {
		key = ip
	} else {
		key = utils.ToStr(uid)
	}
	key = fmt.Sprintf("PCA.%d.%s", post.Id, key)
	if setting.Cache.Get(key) != nil {
		return
	}
	_, err := models.Posts().Filter("Id", post.Id).Update(orm.Params{
		"Browsers": orm.ColValue(orm.Col_Add, 1),
	})
	if err != nil {
		beego.Error("PostCounterAdd ", err)
	}
	setting.Cache.Put(key, true, 60)
}

func (this *CommentModel) AddComment(comment *Comment) (int64, error) {
	o := ORM()
	o.Begin()
	comment_id, err := o.Insert(comment)
	if err == nil {
		// adding comment count of the post
		_, err := o.QueryTable(TABLE_NAME_POST).Filter("PostId", comment.Post.PostId).Update(orm.Params{
			"CommentCount": orm.ColValue(orm.ColAdd, 1),
		})
		if err != nil {
			// error adding count
			o.Rollback()
		} else {
			o.Commit()
		}
	} else {
		// error adding comment
		o.Rollback()
	}
	return comment_id, err
}

func UpdateBet(uId int, uName string, uAvtar string, horseId int, money int) int {
	configure := new(Configure)
	configure = GetStatus()
	if configure.CValue != "1" {
		return -1100
	}

	o := orm.NewOrm()
	var bet Bet
	bet.Uid = uId

	err := o.Read(&bet, "Uid")
	if err == orm.ErrNoRows {
		bet.Uname = uName
		bet.Uavtar = uAvtar
		bet.Horseid = horseId
		bet.Money = money

		_, err = o.Insert(&bet)
		if err != nil {
			beego.Error(err)
			return -1
		}
	} else if err == nil {
		bet.Money = money
		_, err = o.QueryTable("bet").Filter("Uid", uId).Update(orm.Params{
			"money": orm.ColValue(orm.Col_Add, money),
		})
		if err != nil {
			beego.Error(err)
			return -2
		}
	} else {
		beego.Error(err)
		return -3
	}
	return 1
}

//保存
func (this *ArticleController) Save() {
	var (
		id      int64  = 0
		title   string = strings.TrimSpace(this.GetString("title"))
		content string = this.GetString("content")
		tags    string = strings.TrimSpace(this.GetString("tags"))
		urlname string = strings.TrimSpace(this.GetString("urlname"))
		color   string = strings.TrimSpace(this.GetString("color"))
		cover   string = strings.TrimSpace(this.GetString("cover"))
		timestr string = strings.TrimSpace(this.GetString("posttime"))
		status  int64  = 0
		istop   int8   = 0
		urltype int8   = 0
		post    models.Post
	)

	if title == "" {
		this.showmsg("标题不能为空！")
	}

	id, _ = this.GetInt64("id")
	status, _ = this.GetInt64("status")

	if this.GetString("istop") == "1" {
		istop = 1
	}
	if this.GetString("urltype") == "1" {
		urltype = 1
	}
	if status != 1 && status != 2 {
		status = 0
	}
	if cover == "" {
		cover = "/static/upload/defaultcover.png"
	}
	addtags := make([]string, 0)
	//标签过滤
	if tags != "" {
		tagarr := strings.Split(tags, ",")
		for _, v := range tagarr {
			if tag := strings.TrimSpace(v); tag != "" {
				exists := false
				for _, vv := range addtags {
					if vv == tag {
						exists = true
						break
					}
				}
				if !exists {
					addtags = append(addtags, tag)
				}
			}
		}
	}

	if id < 1 {
		post.Userid = this.userid
		post.Author = this.username
		post.Posttime = this.getTime()
		post.Updated = this.getTime()
		post.Insert()
		models.Cache.Delete("latestblog")
	} else {
		post.Id = id
		if post.Read() != nil {
			goto RD
		}
		if post.Tags != "" {
			var tagobj models.Tag
			var tagpostobj models.TagPost
			oldtags := strings.Split(strings.Trim(post.Tags, ","), ",")
			//标签统计-1
			tagobj.Query().Filter("name__in", oldtags).Update(orm.Params{"count": orm.ColValue(orm.ColMinus, 1)})
			//删掉tag_post表的记录
			tagpostobj.Query().Filter("postid", post.Id).Delete()
		}
	}

	if len(addtags) > 0 {
		for _, v := range addtags {
			tag := models.Tag{Name: v}
			if tag.Read("Name") == orm.ErrNoRows {
				tag.Count = 1
				tag.Insert()
			} else {
				tag.Count += 1
				tag.Update("Count")
			}
			tp := models.TagPost{Tagid: tag.Id, Postid: post.Id, Poststatus: int8(status), Posttime: this.getTime()}
			tp.Insert()
		}
		post.Tags = "," + strings.Join(addtags, ",") + ","
	}
	if posttime, err := time.Parse("2006-01-02 15:04:05", timestr); err == nil {
		post.Posttime = posttime
	} else {
		post.Posttime, _ = time.Parse("2006-01-02 15:04:05", post.Posttime.Format("2006-01-02 15:04:05"))
	}
	post.Status = int8(status)
//.........这里部分代码省略.........

func AddPV(id interface{}) {
	o := orm.NewOrm()
	o.QueryTable("Topic").Filter("Id", id).Update(orm.Params{"PV": orm.ColValue(orm.Col_Add, 1)})
}

func UpdateUserCourseHour(uid int64, count int) error {
	o := orm.NewOrm()
	_, err := o.QueryTable("user").Filter("id", uid).Update(orm.Params{
		"coursehour": orm.ColValue(orm.ColAdd, count)})
	return err
}

func (this *ProjectEnvironmentController) BuildApi() {

	//projectenvid := this.Input().Get("projectenvid")
	envid := this.Input().Get("envid")
	intenvid, _ := strconv.Atoi(envid)

	rundeckbuildjobid := this.Input().Get("rundeckbuildjobid")
	//rundeckpackagejobid := this.Input().Get("rundeckpackagejobid")
	projectid := this.Input().Get("projectid")
	branchname := this.Input().Get("branchname")

	o := orm.NewOrm()

	//添加版本号数据以及更新项目版本号
	var project models.Projectinfo

	o.QueryTable("Projectinfo").Filter("Id", projectid).Update(orm.Params{
		"BuildNumber": orm.ColValue(orm.Col_Add, 1),
	})

	o.QueryTable("Projectinfo").Filter("Id", projectid).One(&project)

	now := time.Now()

	fmt.Println(now)

	var pb models.Projectbuild
	pb.Projectid = project.Id
	pb.Buildnumber = project.Buildnumber
	pb.Branchname = branchname
	pb.Created = now
	pb.Buildstatus = 1
	pb.Envid = intenvid
	id, _ := o.Insert(&pb)

	//获取项目环境信息进行编译部署
	var env models.Environmentinfo
	o.QueryTable("Environmentinfo").Filter("id", envid).One(&env)

	args := map[string]string{"BUILD_NUMBER": strconv.Itoa(project.Buildnumber), "Branch_NAME": branchname, "Repository_Path": project.Repositorypath}

	response := utility.RundeckRunJob(env.Rundeckapiurl, env.Rundeckapiauthtoken, rundeckbuildjobid, args)
	fmt.Println(response)

	//parse rundeck api xml response
	r := models.RunJobExecutions{}
	xml_err := xml.Unmarshal([]byte(response), &r)

	if xml_err != nil {
		fmt.Printf("error: %v", xml_err)
		this.Data["json"] = xml_err //url.QueryEscape(logs[0].Packagepath)
		this.ServeJson()
	}

	if r.Exs != nil {
		o.QueryTable("Projectbuild").Filter("Id", id).Update(orm.Params{
			"BuildStatus": 2,
			"ExecutionId": r.Exs[0].Id,
		})
		fmt.Println(r.Exs[0].Id)
	}
	//rundeck执行完成之后读取git hash
	dat, _ := ioutil.ReadFile("/Volumes/ftproot/mtime/upversion/MtimeGoConfigWeb/2/config-web/GitBranchHash")
	//check(err)
	fmt.Print(string(dat))

	o.QueryTable("Projectbuild").Filter("Id", id).Update(orm.Params{
		"BranchHash": string(dat),
	})

	//fmt.Println(response)

	//fmt.Println(projectenvid)
	//fmt.Println(envid)
	//fmt.Println(rundeckbuildjobid)
	//fmt.Println(rundeckpackagejobid)
	//fmt.Println(projectid)
	//fmt.Println(branchname)

	this.Data["json"] = models.BuildApiModel{models.JsonResultBaseStruct{Result: true, Message: "操作成功"}, r.Exs[0].Id}
	this.ServeJson()
}

func UpdateCourseSelected(cid int64, count int) error {
	o := orm.NewOrm()
	_, err := o.QueryTable("course").Filter("id", cid).Update(orm.Params{
		"selected": orm.ColValue(orm.ColAdd, count)})
	return err
}

func UpdateRaceRuselt(WinnerId int) int {
	configure := new(Configure)
	configure = GetStatus()
	if configure.CValue != "2" {
		return -1101
	}

	o := orm.NewOrm()

	// 事务开始
	err := o.Begin()

	winNum, err := o.QueryTable("horse").Filter("id", WinnerId).Update(orm.Params{
		"win": orm.ColValue(orm.Col_Add, 1),
	})
	if err != nil || winNum != 1 {
		beego.Error(err)
		return -1
	}

	loseNum, err := o.QueryTable("horse").Exclude("id", WinnerId).Update(orm.Params{
		"lose": orm.ColValue(orm.Col_Add, 1),
	})
	if err != nil || loseNum != 5 {
		beego.Error(err)
		return -2
	}

	if winNum == 1 && loseNum == 5 {
		err = o.Commit()
	} else {
		err = o.Rollback()
		return -3
	}

	if err != nil {
		beego.Error(err)
		return 0
	}

	// 将中奖者的记录从bet表移动到winlog表
	bets, err := GetBet(WinnerId)
	// winlogs := make([]*Winlog,0)
	if err != nil {
		beego.Error(err)
		if err != orm.ErrNoRows {
			return -5
		}
	} else {
		var winlog Winlog
		timeStr := time.Now().Format("2006-01-02 15:04:05")
		qs := o.QueryTable("winlog")
		i, _ := qs.PrepareInsert()
		for _, val := range bets {
			winlog.Uid = val.Uid
			winlog.Uname = val.Uname
			winlog.Uavtar = val.Uavtar
			winlog.Horseid = val.Horseid
			winlog.Money = val.Money
			winlog.Time = timeStr
			_, err := i.Insert(&winlog)
			if err != nil {
				beego.Error(err)
				return -4
			}
		}
		i.Close()
	}

	UpdateStatus("0")
	return 1
}