Skip to content

Instantly share code, notes, and snippets.

@chinaestone
Created May 25, 2015 13:08
Show Gist options
  • Save chinaestone/8edddb5263cb2a4b7c7f to your computer and use it in GitHub Desktop.
Save chinaestone/8edddb5263cb2a4b7c7f to your computer and use it in GitHub Desktop.
beego orm execute raw sql for mysql
package main
//import (
// "fmt"
// "os"
// "text/template"
//)
//func main() {
// s1, _ := template.ParseFiles("index.tmpl")
// s1.ExecuteTemplate(os.Stdout, "header", nil)
// fmt.Println()
// s1.ExecuteTemplate(os.Stdout, "content", nil)
// fmt.Println()
// s1.ExecuteTemplate(os.Stdout, "footer", nil)
// fmt.Println()
// s1.Execute(os.Stdout, nil)
//}
import (
"fmt"
"github.com/astaxie/beego/orm"
// "github.com/astaxie/beego"
_ "github.com/go-sql-driver/mysql"
)
func init() {
orm.RegisterDriver("mysql",orm.DR_MySQL)
orm.RegisterDataBase("default","mysql","root:654321@tcp(192.168.0.200:3306)/mydb?charset=utf8")
}
func main() {
o := orm.NewOrm()
o.Using("default")
var aa []orm.Params
var r orm.RawSeter
r = o.Raw("desc user")
res,err := r.Values(&aa)
if err != nil {
fmt.Println(err)
return
}
fmt.Println(res)
for index, value := range aa {
index = index >> 2;
// fmt.Printf("arr[%d]=%d \n", index, value)
fmt.Println(value)
}
//// ctVersion := new(models.CtVersion)
//// ctVersion.FileName = "sss"
//// ctVersion.MainVersion = 5000
//// ctVersion.SubVersion = 6000
//// fmt.Println(o.Insert(ctVersion))
// var versions []orm.Params
// num, err := o.Raw("desc node").Exec()
// if err == nil {
// fmt.Println(versions)
// xx,err := num.RowsAffected()
// if err==nil {
// fmt.Println(" err ",err)
// return
// }
// fmt.Println("user nums: ",xx)
//// for k,v := range versions {
//// fmt.Println(k)
////// fmt.Println(v.FileName)
//// }
// }
// fmt.Println(err)
//// o.Raw()
}
@Ashutosh-730
Copy link

at line 29: this is giving error : orm.DR_MySQL

may be that is outdated.
use this.
orm.RegisterDriver("mysql", orm.DRMySQL)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment