github.com/gogf/gf@v1.16.9/.example/database/gdb/mysql/gdb_issue_278.go (about)

     1  package main
     2  
     3  import (
     4  	"fmt"
     5  
     6  	"github.com/gogf/gf/frame/g"
     7  )
     8  
     9  var (
    10  	tableName = "orders"
    11  	dao       = g.DB().Table(tableName).Safe()
    12  )
    13  
    14  type OrderServiceEntity struct {
    15  	GoodsPrice float64 `json:"goods_price" gvalid:"required"`
    16  	PayTo      int8    `json:"payTo" gvalid:"required"`
    17  	PayStatus  int8    `json:"payStatus" `
    18  	CreateTime string  `json:"createTime" `
    19  	AppId      string  `json:"appId" gvalid:"required"`
    20  	PayUser    string  `json:"pay_user" gvalid:"required"`
    21  	QrUrl      string  `json:"qr_url" `
    22  }
    23  
    24  type Create struct {
    25  	Id         int64   `json:"id" gconv:"id"`
    26  	GoodsPrice float64 `json:"goodsPrice" gconv:"goods_price"`
    27  	PayTo      int8    `json:"payTo" gconv:"pay_to"`
    28  	PayStatus  int8    `json:"payStatus" gconv:"pay_status"`
    29  	CreateTime string  `json:"createTime" gconv:"create_time"`
    30  	UserId     int     `json:"user_id" `
    31  	PayUser    string  `json:"pay_user" `
    32  	QrUrl      string  `json:"qr_url" `
    33  }
    34  
    35  func main() {
    36  	g.DB().SetDebug(true)
    37  	userInfo := Create{
    38  		Id: 3,
    39  	}
    40  	orderService := OrderServiceEntity{
    41  		GoodsPrice: 0.1,
    42  		PayTo:      1,
    43  	}
    44  	size, err := dao.Where("user_id", userInfo.Id).
    45  		And("goods_price", float64(100.10)).
    46  		And("pay_status", 0).
    47  		And("pay_to", orderService.PayTo).Count()
    48  	fmt.Println(err)
    49  	fmt.Println(size)
    50  }