Golang beego/orm

 

code:

package main

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

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

func init() {
   orm.RegisterModel(new(User))
   orm.RegisterDataBase("default", "mysql", "username:pwd@tcp(***.***.***.***:3306)/pomelo?charset=utf8",30)
   orm.RunSyncdb("default", false, true)
}

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

   user := User{ Name: "Michael"}

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

   if err != nil {
       fmt.Println(err.Error())
       return
   }

   fmt.Println("id=", id);

}

　　

 

 

package main

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

type User struct {
   Id          int
   Name        string
   Profile     *Profile    `orm:"rel(one)"` // OneToOne relation
   Post        []*Post     `orm:"reverse(many)"` // 设置一对多的反向关系
}

type Profile struct {
   Id          int
   Age         int16
   User        *User   `orm:"reverse(one)"` // 设置一对一反向关系(可选)
}

type Post struct {
   Id    int
   Title string
   User  *User  `orm:"rel(fk)"`    //设置一对多关系
   Tags  []*Tag `orm:"rel(m2m)"`
}

type Tag struct {
   Id    int
   Name  string
   Posts []*Post `orm:"reverse(many)"`
}


func init() {
   orm.RegisterModel(new(User), new(Post), new(Profile), new(Tag))

   orm.RegisterDataBase("default", "mysql", "username:pwd@tcp(xxx.xxx.xxx.xxx:3306)/pomelo?charset=utf8",30)
   orm.RunSyncdb("default", false, true)
}

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

   profile := new(Profile)
   profile.Age = 30

   user := new(User)
   user.Profile = profile
   user.Name = "slene"

   fmt.Println(o.Insert(profile))
   fmt.Println(o.Insert(user))
}

 

log:

create table `user` 
    -- --------------------------------------------------
    --  Table Structure for `main.User`
    -- --------------------------------------------------
    CREATE TABLE IF NOT EXISTS `user` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(255) NOT NULL DEFAULT '' ,
        `profile_id` integer NOT NULL UNIQUE
    ) ENGINE=InnoDB;

create table `post` 
    -- --------------------------------------------------
    --  Table Structure for `main.Post`
    -- --------------------------------------------------
    CREATE TABLE IF NOT EXISTS `post` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `title` varchar(255) NOT NULL DEFAULT '' ,
        `user_id` integer NOT NULL
    ) ENGINE=InnoDB;

create table `profile` 
    -- --------------------------------------------------
    --  Table Structure for `main.Profile`
    -- --------------------------------------------------
    CREATE TABLE IF NOT EXISTS `profile` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `age` smallint NOT NULL DEFAULT 0 
    ) ENGINE=InnoDB;

create table `tag` 
    -- --------------------------------------------------
    --  Table Structure for `main.Tag`
    -- --------------------------------------------------
    CREATE TABLE IF NOT EXISTS `tag` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(255) NOT NULL DEFAULT '' 
    ) ENGINE=InnoDB;

create table `post_tags` 
    -- --------------------------------------------------
    --  Table Structure for `main.PostTags`
    -- --------------------------------------------------
    CREATE TABLE IF NOT EXISTS `post_tags` (
        `id` bigint AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `post_id` integer NOT NULL,
        `tag_id` integer NOT NULL
    ) ENGINE=InnoDB;

1 <nil>
1 <nil>

Process finished with exit code 0