gopm get github.com/go-xorm/xorm

go get github.com/go-xorm/xorm

engine, err := xorm.NewEngine(driverName, dataSourceName)

type User struct {    Id int64    Name string    Salt string    Age int    Passwd string `xorm:"varchar(200)"`    Created time.Time `xorm:"created"`    Updated time.Time `xorm:"updated"`}err := engine.Sync2(new(User))

results, err := engine.Query("select * from user")

affected, err := engine.Exec("update user set age = ? where name = ?", age, name)

affected, err := engine.Insert(&user)// INSERT INTO struct () values ()affected, err := engine.Insert(&user1, &user2)// INSERT INTO struct1 () values ()// INSERT INTO struct2 () values ()affected, err := engine.Insert(&users)// INSERT INTO struct () values (),(),()affected, err := engine.Insert(&user1, &users)// INSERT INTO struct1 () values ()// INSERT INTO struct2 () values (),(),()

has, err := engine.Get(&user)// SELECT * FROM user LIMIT 1has, err := engine.Where("name = ?", name).Desc("id").Get(&user)// SELECT * FROM user WHERE name = ? ORDER BY id DESC LIMIT 1

var users []Usererr := engine.Where("name = ?", name).And("age > 10").Limit(10, 0).Find(&users)// SELECT * FROM user WHERE name = ? AND age > 10 limit 0 offset 10type Detail struct {    Id int64    UserId int64 `xorm:"index"`}type UserDetail struct {    User `xorm:"extends"`    Detail `xorm:"extends"`}var users []UserDetailerr := engine.Table("user").Select("user.*, detail.*")    Join("INNER", "detail", "detail.user_id = user.id").    Where("user.name = ?", name).Limit(10, 0).    Find(&users)// SELECT user.*, detail.* FROM user INNER JOIN detail WHERE user.name = ? limit 0 offset 10

err := engine.Iterate(&User{Name:name}, func(idx int, bean interface{}) error {    user := bean.(*User)    return nil})// SELECT * FROM userrows, err := engine.Rows(&User{Name:name})// SELECT * FROM userdefer rows.Close()bean := new(Struct)for rows.Next() {    err = rows.Scan(bean)}

affected, err := engine.Id(1).Update(&user)// UPDATE user SET ... Where id = ?affected, err := engine.Update(&user, &User{Name:name})// UPDATE user SET ... Where name = ?var ids = []int64{1, 2, 3}affected, err := engine.In(ids).Update(&user)// UPDATE user SET ... Where id IN (?, ?, ?)// force update indicated columns by Colsaffected, err := engine.Id(1).Cols("age").Update(&User{Name:name, Age: 12})// UPDATE user SET age = ?, updated=? Where id = ?// force NOT update indicated columns by Omitaffected, err := engine.Id(1).Omit("name").Update(&User{Name:name, Age: 12})// UPDATE user SET age = ?, updated=? Where id = ?affected, err := engine.Id(1).AllCols().Update(&user)// UPDATE user SET name=?,age=?,salt=?,passwd=?,updated=? Where id = ?

affected, err := engine.Where(...).Delete(&user)// DELETE FROM user Where ...

counts, err := engine.Count(&user)// SELECT count(*) AS total FROM user