webdav/sync/go/pkg/mod/github.com/exfly/beego@v1.12.0-export-init/orm - 志元云盘

File OriginalPic	EditTime	Size
cmd.go	2024-09-19 10:33:27	5.84 KB
cmd_utils.go	2024-09-19 10:33:27	7.56 KB
db.go	2024-09-19 10:33:27	44.86 KB
db_alias.go	2024-09-19 10:33:27	9.03 KB
db_mysql.go	2024-09-19 10:33:27	4.93 KB
db_oracle.go	2024-09-19 10:33:27	3.64 KB
db_postgres.go	2024-09-19 10:33:27	5.13 KB
db_sqlite.go	2024-09-19 10:33:27	3.91 KB
db_tables.go	2024-09-19 10:33:27	9.59 KB
db_tidb.go	2024-09-19 10:33:27	1.83 KB
db_utils.go	2024-09-19 10:33:27	4.25 KB
models.go	2024-09-19 10:33:27	2.46 KB
models_boot.go	2024-09-19 10:33:27	9.18 KB
models_fields.go	2024-09-19 10:33:27	17.47 KB
models_info_f.go	2024-09-19 10:33:27	11.51 KB
models_info_m.go	2024-09-19 10:33:27	3.5 KB
models_test.go	2024-09-19 10:33:27	11.26 KB
models_utils.go	2024-09-19 10:33:27	5.77 KB
orm.go	2024-09-19 10:33:27	13.8 KB
orm_conds.go	2024-09-19 10:33:27	4.11 KB
orm_log.go	2024-09-19 10:33:27	5.82 KB
orm_object.go	2024-09-19 10:33:27	2.14 KB
orm_querym2m.go	2024-09-19 10:33:27	3.7 KB
orm_queryset.go	2024-09-19 10:33:27	7.21 KB
orm_raw.go	2024-09-19 10:33:27	18.51 KB
orm_test.go	2024-09-19 10:33:27	69.01 KB
qb.go	2024-09-19 10:33:27	2.03 KB
qb_mysql.go	2024-09-19 10:33:27	5.01 KB
qb_tidb.go	2024-09-19 10:33:27	4.93 KB
README.md	2024-09-19 10:33:27	2.89 KB
types.go	2024-09-19 10:33:27	17.67 KB
utils.go	2024-09-19 10:33:27	6.92 KB
utils_test.go	2024-09-19 10:33:27	1.99 KB

# beego orm

[![Build Status](https://drone.io/github.com/astaxie/beego/status.png)](https://drone.io/github.com/astaxie/beego/latest)

A powerful orm framework for go.

It is heavily influenced by Django ORM, SQLAlchemy.

**Support Database:**

* MySQL: [github.com/go-sql-driver/mysql](https://github.com/go-sql-driver/mysql)
* PostgreSQL: [github.com/lib/pq](https://github.com/lib/pq)
* Sqlite3: [github.com/mattn/go-sqlite3](https://github.com/mattn/go-sqlite3)

Passed all test, but need more feedback.

**Features:**

* full go type support
* easy for usage, simple CRUD operation
* auto join with relation table
* cross DataBase compatible query
* Raw SQL query / mapper without orm model
* full test keep stable and strong

more features please read the docs

**Install:**

go get github.com/astaxie/beego/orm

## Changelog

* 2013-08-19: support table auto create
* 2013-08-13: update test for database types
* 2013-08-13: go type support, such as int8, uint8, byte, rune
* 2013-08-13: date / datetime timezone support very well

## Quick Start

#### Simple Usage

```go
package main

import (
	"fmt"
	"github.com/astaxie/beego/orm"
	_ "github.com/go-sql-driver/mysql" // import your used driver
)

// Model Struct
type User struct {
	Id   int    `orm:"auto"`
	Name string `orm:"size(100)"`
}

func init() {
	// register model
	orm.RegisterModel(new(User))

// set default database
	orm.RegisterDataBase("default", "mysql", "root:root@/my_db?charset=utf8", 30)
	
	// create table
	orm.RunSyncdb("default", false, true)	
}

func main() {
	o := orm.NewOrm()

user := User{Name: "slene"}

// insert
	id, err := o.Insert(&user)

// update
	user.Name = "astaxie"
	num, err := o.Update(&user)

// read one
	u := User{Id: user.Id}
	err = o.Read(&u)

// delete
	num, err = o.Delete(&u)	
}
```

#### Next with relation

```go
type Post struct {
	Id    int    `orm:"auto"`
	Title string `orm:"size(100)"`
	User  *User  `orm:"rel(fk)"`
}

var posts []*Post
qs := o.QueryTable("post")
num, err := qs.Filter("User__Name", "slene").All(&posts)
```

#### Use Raw sql

If you don't like ORM，use Raw SQL to query / mapping without ORM setting

```go
var maps []Params
num, err := o.Raw("SELECT id FROM user WHERE name = ?", "slene").Values(&maps)
if num > 0 {
	fmt.Println(maps[0]["id"])
}
```

#### Transaction

```go
o.Begin()
...
user := User{Name: "slene"}
id, err := o.Insert(&user)
if err == nil {
	o.Commit()
} else {
	o.Rollback()
}

```

#### Debug Log Queries

In development env, you can simple use

```go
func main() {
	orm.Debug = true
...
```

enable log queries.

output include all queries, such as exec / prepare / transaction.

like this:

```go
[ORM] - 2013-08-09 13:18:16 - [Queries/default] - [    db.Exec /     0.4ms] - [INSERT INTO `user` (`name`) VALUES (?)] - `slene`
...
```

note: not recommend use this in product env.

## Docs

more details and examples in docs and test

[documents](http://beego.me/docs/mvc/model/overview.md)

云盘

Home / 志元云盘 / webdav / sync / go / pkg / mod / github.com / exfly / [email protected] / orm