Beego exper表达式

package controllers

import (
	"BeegoStudy/models"
	"fmt"

	"github.com/astaxie/beego"
	"github.com/astaxie/beego/orm"
)

type ExperController struct {
	beego.Controller
}

func (exper *ExperController) Get() {
	//表查询 exper表达式使用
	o := orm.NewOrm()
	qs := o.QueryTable(new(models.Users))

	//1.查询相等
	user := models.Users{}
	qs.Filter("age", 18).One(&user)
	fmt.Printf("user: %v\n", user)

	//2.查询大于__gt
	qs.Filter("age__gt", 18).One(&user)
	fmt.Printf("user: %v\n", user)

	//3.查询小于__lt
	qs.Filter("age__gt", 18).One(&user)
	fmt.Printf("user: %v\n", user)

	//4.查询包含(区分大小写)
	qs.Filter("name__contains", "国").One(&user)
	fmt.Printf("user: %v\n", user)

	//5.查询包含(忽略大小写)
	qs.Filter("name__icontains", "国").One(&user)
	fmt.Printf("user: %v\n", user)

	//6.查询以xx开头
	qs.Filter("name__startswith", "谢").One(&user)

	//7.查询以xx结尾
	qs.Filter("name__endswith", "光").One(&user)

	//8.查询为null的
	qs.Filter("address__isnull", true).One(&user)

	//9.查询在某个范围内的
	qs.Filter("age__in", 18, 19, 20).One(&user)

	exper.Data["json"] = user
	exper.ServeJSON()

}