在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称:xorm开源软件地址:https://gitee.com/lunny/xorm开源软件介绍:xormxorm是一个简单而强大的Go语言ORM库. 通过它可以使数据库操作非常简便。 注意最新的版本有不兼容的更新,您必须使用 特性
驱动支持目前支持的Go数据库驱动和对应的数据库如下:
更新日志
安装推荐使用 gopm 进行安装: gopm get github.com/go-xorm/xorm 或者您也可以使用go工具进行安装: 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 案例讨论请加入QQ群:280360085 进行讨论。 贡献如果您也想为Xorm贡献您的力量,请查看 CONTRIBUTING LICENSEBSD Licensehttp://creativecommons.org/licenses/BSD/ |
请发表评论