func (this *TestController) List() {
sm, _ := slimmysql.NewSqlInstanceDefault()
stds, err := sm.Table("students").Select()
if err != nil {
this.Data["json"] = err.Error()
} else {
this.Data["json"] = stds
}
this.ServeJson()
}
func (this *TestController) Insert() {
sm, _ := slimmysql.NewSqlInstanceDefault()
nickname := this.Context.Request.FormValue("nickname")
id, err := sm.Table("students").Add(map[string]interface{}{
"nickname": nickname,
})
if err != nil {
this.Data["json"] = err.Error()
} else {
this.Data["json"] = "insert success,id:" + strconv.Itoa(int(id))
}
this.ServeJson()
}
func (this *TestController) Trans() {
sm, _ := slimmysql.NewSqlInstanceDefault()
sm.StartTrans()
p1, _ := sm.Table("students").Find(2)
sm.Table("students").Where("id = 2").Save(map[string]interface{}{"nickname": "BigDaddy"})
p2, _ := sm.Table("students").Find(2)
sm.Rollback()
p3, _ := sm.Table("students").Find(3)
this.ServeJson(map[string]interface{}{
"p1": p1,
"p2": p2,
"p3": p3,
})
}
func (this *TestController) Condition() {
sm, _ := slimmysql.NewSqlInstanceDefault()
condition := map[string]interface{}{
"nickname__like": "sl",
}
stds, err := sm.Table("students").Where(condition).GetField("id,nickname")
if err != nil {
this.Data["json"] = err.Error()
} else {
this.Data["json"] = map[string]interface{}{
"students": stds,
}
}
this.ServeJson()
}
func (this *TestController) Join() {
sm, _ := slimmysql.NewSqlInstanceDefault()
condition := sm.NewCondition()
condition["relation"] = "OR"
condition["age__egt"] = 20
condition["_"] = map[string]interface{}{
"gender": 1,
"nickname__like": "sl",
}
r, _ := sm.MustMaster(true).Table("students").Where(condition).Order("age desc").Select()
sql1 := sm.GetSql(true)
r2, _ := sm.Clear().MustMaster(true).Table("students").Join("INNER JOIN go_order as o on o.sid=go_students.id").Group("sid").GetField("sid,sum(price) as total,count(o.id) as count")
sql2 := sm.GetSql(true)
this.ServeJson(map[string]interface{}{
"result1": r,
"sql1": sql1,
"result2": r2,
"sql2": sql2,
})
}