xorm修改数据

package main

import (
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/go-xorm/core"
"github.com/go-xorm/xorm"
"time"
)

type Member struct {
Memberid int64 `xorm:"int(10) pk not null autoincr 'member_id'"`
Member_name string `xorm:"char(50) not null"`
Member_pwd string `xorm:"char(32) not null"`
Member_count int64 `xorm:"smallint(6) not null default 0 "`
Member_ok string `xorm:"varchar(50) not null"`
Member_del int64 `xorm:"bigint(1) not null default 0 "`
Member_email string `xorm:"varchar(40) not null"`
Member_logintime time.Time `xorm:"updated"`
Member_createtime int64 `xorm:"int(11) not null default 0"`
Member_updatetime int64 `xorm:"int(11) not null default 0"`
Member_ip string `xorm:"varchar(40) not null"`
Member_version int64 `xorm:"version"`
}

var (
engine *xorm.Engine
t = time.Now()
)

func main() {
//数据库连接参数
params := fmt.Sprintf("%s:%s@tcp(%s)/%s?charset=utf8&parseTime=true", "root", "root", "localhost:3306", "go")
var err error
//连接数据库
engine, err = xorm.NewEngine("mysql", params)
if err != nil {
panic(err)
}
//添加统一前缀
tbMapper := core.NewPrefixMapper(core.SnakeMapper{}, "go_")
engine.SetTableMapper(tbMapper)
defer engine.Close()

//打印生成的sql语句
//engine.ShowSQL(true)

//更新数据，如果要将字段的值修改为0，需要用Cols实现，Cols：指定要更新的数据，Cols和MustCols相同
cm := new(Member)
cm.Member_del = 3
cm.Member_updatetime = t.Unix()
//获取当前数据member_version在mysql中的数值(如果使用了乐观锁，必须获取要修改数据的version值)
var mv []int64
verr := engine.Table("go_member").Cols("member_version").Where("member_id = ?", 1).Find(&mv)
if verr != nil {
panic(verr)
}
//给member_version赋值
cm.Member_version = mv[0]
//进行数据修改
res, err := engine.Where("member_id = 1").Cols("member_del", "Member_updatetime").Update(cm)
if err != nil {
panic(err)
}
fmt.Println("修改了 ", res, "条数据")

am := new(Member)
am.Member_del = 4
am.Member_updatetime = t.Unix()
//获取当前数据member_version在mysql中的数值(如果使用了乐观锁，必须获取要修改数据的version值)
var amv []int64
amerr := engine.Table("go_member").Cols("member_version").Where("member_id = ?", 1).Find(&amv)
if amerr != nil {
panic(amerr)
}
//给member_version赋值
am.Member_version = amv[0]
//AllCols 更新除非 0，非空，非bool的所有字段
ares, aerr := engine.Where("member_id = ?", 1).AllCols().Update(am)
if aerr != nil {
panic(aerr)
}
fmt.Println("修改了 ", ares, "条数据")
}

 

【版权申明】未经博主同意,谢绝转载!(请尊重原创,博主保留追究权) http://www.cnblogs.com/facetwitter/p/7595526.html

 

转载于:https://www.cnblogs.com/facetwitter/p/7595526.html