beggo操作数据库

访问方式

Get请求

http://localhost:8080/v1/user/1

func (u *UserController) Get() {
	//uid的获取方式  uid = 1
	uid := u.GetString(":uid")
	if uid != "" {
		user, err := models.GetUser(uid)
		if err != nil {
			u.Data["json"] = err.Error()
		} else {
			u.Data["json"] = user
		}
	}
	u.ServeJSON()
}

Post请求

func (u *UserController) Post() {
	var user models.User
	err := json.Unmarshal(u.Ctx.Input.RequestBody, &user)
	if err!=nil{
		fmt.Println(user)
	}
	uid := models.AddUser(user)
	u.Data["json"] = map[string]string{"uid": uid}
	u.ServeJSON()
}

put请求

func (u *UserController) Put() {
	uid := u.GetString(":uid")
	if uid != "" {
		var user models.User
		json.Unmarshal(u.Ctx.Input.RequestBody, &user)
		uu, err := models.UpdateUser(uid, &user)
		if err != nil {
			u.Data["json"] = err.Error()
		} else {
			u.Data["json"] = uu
		}
	}
	u.ServeJSON()
}

初始操作

func init() {
	orm.RegisterDriver("mysql", orm.DRMySQL)

	orm.RegisterDataBase("default", "mysql", "root:mysql123456@/test?charset=utf8")
	//注册model
	orm.RegisterModel(new(User))
	//创建表
	orm.RunSyncdb("default",false,true)
}

查询

func GetAllUsers() {
	o := orm.NewOrm()
	var users [] User
	num,_ := o.Raw("SELECT * FROM user").QueryRows(&users)

	for _,user := range users{
		fmt.Println(user,num)
	}
	//return users
}