func (q DbQueryer) MustRunSelectCommand(selectCommand *MysqlAst.SelectCommand) (mapValue []map[string]string) {
output, paramList := selectCommand.GetPrepareParameter()
list, error := q.Query(output, paramList...)
if error != nil {
panic(error)
}
return list
}
func (page *KmgPage) runSelectCommand(selectCommand *MysqlAst.SelectCommand) *KmgPage {
if page.BaseUrl == "" {
panic("runSelectCommand need baseUrl parameter")
}
output, parameterList := selectCommand.GetPrepareParameter()
countData, err := kmgSql.QueryOne("SELECT COUNT(*) AS c FROM ("+output+") as View", parameterList...)
if err != nil {
panic(err)
}
page.TotalItem, err = strconv.Atoi(countData["c"])
if err != nil {
panic(err)
}
dataSelect := selectCommand.Copy()
dataSelect = dataSelect.Limit(strconv.Itoa(page.GetMysqlOffset()) + "," + strconv.Itoa(page.ItemPerPage))
page.Data = kmgSql.MustRunSelectCommand(dataSelect)
return page
}
