本文整理匯總了Golang中github.com/QLeelulu/goku.MysqlDB.Count方法的典型用法代碼示例。如果您正苦於以下問題：Golang MysqlDB.Count方法的具體用法？Golang MysqlDB.Count怎麽用？Golang MysqlDB.Count使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類github.com/QLeelulu/goku.MysqlDB的用法示例。
在下文中一共展示了MysqlDB.Count方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Golang代碼示例。
示例1: User_GetList
// 獲取用戶列表.
// @page: 從1開始的頁數
// @return: users, total-count, err
func User_GetList(page, pagesize int, order string) ([]User, int64, error) {
var db *goku.MysqlDB = GetDB()
defer db.Close()
page, pagesize = utils.PageCheck(page, pagesize)
qi := goku.SqlQueryInfo{}
qi.Limit = pagesize
qi.Offset = pagesize * page
if order == "" {
qi.Order = "id desc"
} else {
qi.Order = order
}
var users []User
err := db.GetStructs(&users, qi)
if err != nil {
goku.Logger().Errorln(err.Error())
return nil, 0, err
}
total, err := db.Count("user", "")
if err != nil {
goku.Logger().Errorln(err.Error())
}
return users, total, nil
}示例2: Comment_GetByPage
// @page: 從1開始
// @return: comments, total-count, err
func Comment_GetByPage(page, pagesize int, order string) ([]Comment, int64, error) {
var db *goku.MysqlDB = GetDB()
defer db.Close()
page, pagesize = utils.PageCheck(page, pagesize)
qi := goku.SqlQueryInfo{}
qi.Limit = pagesize
qi.Offset = page * pagesize
if order == "" {
qi.Order = "id desc"
} else {
qi.Order = order
}
var comments []Comment
err := db.GetStructs(&comments, qi)
if err != nil {
goku.Logger().Errorln(err.Error())
return nil, 0, err
}
total, err := db.Count("comment", "")
if err != nil {
goku.Logger().Errorln(err.Error())
}
return comments, total, nil
}示例3: admin_index
func admin_index(ctx *goku.HttpContext) goku.ActionResulter {
var db *goku.MysqlDB = models.GetDB()
defer db.Close()
linkCount, err := db.Count("link", "")
if err != nil {
ctx.ViewData["errorMsg"] = err.Error()
return ctx.Render("error", nil)
}
ctx.ViewData["linkCount"] = linkCount
userCount, err := db.Count("user", "")
if err != nil {
ctx.ViewData["errorMsg"] = err.Error()
return ctx.Render("error", nil)
}
ctx.ViewData["userCount"] = userCount
topicCount, err := db.Count("topic", "")
if err != nil {
ctx.ViewData["errorMsg"] = err.Error()
return ctx.Render("error", nil)
}
ctx.ViewData["topicCount"] = topicCount
commentCount, err := db.Count("comment", "")
if err != nil {
ctx.ViewData["errorMsg"] = err.Error()
return ctx.Render("error", nil)
}
ctx.ViewData["commentCount"] = commentCount
return ctx.View(nil)
}示例4: CommentForUser_GetByPage
// 獲取收到的評論列表
// @page: 從1開始
// @return: comments, total-count, err
func CommentForUser_GetByPage(userId int64, page, pagesize int, order string) ([]Comment, int64, error) {
var db *goku.MysqlDB = GetDB()
defer db.Close()
page, pagesize = utils.PageCheck(page, pagesize)
qi := goku.SqlQueryInfo{}
qi.Limit = pagesize
qi.Offset = page * pagesize
qi.Where = "cfu.user_id=?"
qi.Join = " cfu INNER JOIN `comment` c ON cfu.comment_id=c.id"
qi.Fields = `c.id, c.user_id, c.link_id, c.parent_path, c.children_count, c.top_parent_id,
c.parent_id, c.deep, c.status, c.content, c.create_time, c.vote_up, c.vote_down, c.reddit_score`
if order == "" {
qi.Order = "create_time desc"
} else {
qi.Order = order
}
qi.Params = []interface{}{userId}
rows, err := db.Select("comment_for_user", qi)
if err != nil {
goku.Logger().Errorln(err.Error())
return nil, 0, err
}
defer rows.Close()
comments := make([]Comment, 0)
for rows.Next() {
c := Comment{}
err = rows.Scan(&c.Id, &c.UserId, &c.LinkId, &c.ParentPath, &c.ChildrenCount,
&c.TopParentId, &c.ParentId, &c.Deep, &c.Status, &c.Content,
&c.CreateTime, &c.VoteUp, &c.VoteDown, &c.RedditScore)
if err != nil {
goku.Logger().Errorln(err.Error())
return nil, 0, err
}
comments = append(comments, c)
}
total, err := db.Count("comment_for_user", "user_id=?", userId)
if err != nil {
goku.Logger().Errorln(err.Error())
}
return comments, total, nil
}