xorm多表Join查询

package main

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

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"`
}

//go_delinfo 存储 go_member里面 member_del 所对应的状态解释信息
type Delinfo struct {
Del_id int64 `xorm:"int(10) pk not null autoincr 'del_id'"`
Del_info string `xorm:"char(50) not null"`
}

type MemberDelinfoOne struct {
Member `xorm:"extends"`
Delinfo `xorm:"extends"`
}

type MemberDelinfoTwo struct {
Member `xorm:"extends"`
Del_info string
}

func (MemberDelinfoOne) TableName() string {
return "member"
}

func (MemberDelinfoTwo) TableName() string {
return "member"
}

var (
engine *xorm.Engine
)

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)
}

memberone := make([]MemberDelinfoOne, 0)
errone := engine.Table("go_member").Join("INNER", "go_delinfo", "go_delinfo.del_id = go_member.member_del").Find(&memberone)
if errone != nil {
panic(errone)
}
fmt.Println("查询出go_delinfo对应信息的全部字段: \n",memberone,"\n\n")

membertwo := make([]MemberDelinfoTwo, 0)
errtwo := engine.Table("go_member").Join("INNER", "go_delinfo", "go_delinfo.del_id = go_member.member_del").Find(&membertwo)
if errtwo != nil {
panic(errtwo)
}
fmt.Println("查询出go_delinfo对应信息的指定字段: \n",membertwo)
}

 

 

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