func (this *IndexController) Get() {
ExecutionsTableHeader := models.GetExectutionTableHeader()
// Calculate pages.
// pagenum := 20
// pn, err := strconv.Atoi(this.Input().Get("p"))
// maxPageNum := int(models.GetExecutionCount()/int64(pagenum)) + 1
// if err != nil || pn > maxPageNum {
// pn = 1
// }
// if pn < 10 {
// this.Data["Prev"] = 1
// } else {
// this.Data["Prev"] = pn - 10
// }
// if pn > maxPageNum-10 {
// this.Data["Next"] = maxPageNum
// } else {
// this.Data["Next"] = pn + 10
// }
// // Get TestPlans
// testplans := make(map[int]string)
// res := models.GetAllTestPlans("v_testlink_testexecution_tree")
// for key, item := range res {
// testplans[key] = string(item["TestPlan"])
// }
// this.Data["TestPlans"] = testplans
// // Calculate page list.
// this.Data["PageList"] = calPageList(pn, maxPageNum)
// // 100, (page-1)*100
// testexecution_tree, err := models.GetAllExecutions(pagenum, (pn-1)*pagenum)
// if err != nil {
// beego.Debug(fmt.Sprintf("Failed to get reports from db: %v\n", err))
// } else {
// beego.Debug("Success!!!")
// }
this.Data["TableHeader"] = ExecutionsTableHeader
// this.Data["TestExecutionTree"] = testexecution_tree
this.Data["Website"] = "goTestLinkReport.org"
this.Data["Email"] = "*****@*****.**"
this.TplNames = "index.tpl"
this.Redirect("/getlastexecution", 302)
}
func (this *ReportController) Get() {
ExecutionsTableHeader := models.GetExectutionTableHeader()
ExecutionsTableHeader = []string{
// "TestPlan",
"Platform",
"ToadModule",
"SubModule",
"Testcase_id",
"TestCase",
"Status",
"Build",
"LasTimeRun",
"Notes",
"Tester",
// "TestSuite",
}
expiration := int64(60 * 60)
spec := redis.DefaultSpec().Db(0)
client, err := redis.NewSynchClientWithSpec(spec)
if err != nil {
fmt.Println("Failed to create the client: ", err)
return
}
key_tp := "testplan"
value_tp, err := client.Get(key_tp)
if err != nil {
fmt.Println("Failed to get value: ", err)
return
}
testplan := this.Input().Get("testplan")
fmt.Println("..." + testplan)
var tp []TestPlan
if value_tp == nil {
fmt.Println("The plan is not exists. We will query it from mysql and then store them in redis.")
// Get TestPlans
testplans := make(map[int]string)
res := models.GetAllTestPlans("V_testlink_testexecution_tree")
for key, item := range res {
testplans[key] = string(item["TestPlan"])
}
res = models.GetAllTestPlansAndCount()
for _, item := range res {
name := string(item["TestPlan"])
count, _ := strconv.Atoi(string(item["COUNT(*)"]))
bActive := false
if testplan != "" && testplan == name {
bActive = true
}
tp = append(tp, TestPlan{
Name: name,
Count: count,
Active: bActive,
})
}
value, err := json.Marshal(tp)
if err != nil {
fmt.Println("Failed to marshal: ", err)
}
client.Set(key_tp, value)
client.Expire(key_tp, expiration)
} else {
fmt.Println("The plan is exists. We will unmarshal them.")
// var temp planinfo
err := json.Unmarshal(value_tp, &tp)
if err != nil {
fmt.Println("Failed to unmarshal: ", err)
return
}
for _, item := range tp {
// bActive := false
if testplan != "" && testplan == item.Name {
// bActive = true
item.Active = true
}
}
}
// var executions []*V_testlink_testexecution_tree
executions := []models.V_testlink_testexecution_tree{}
if testplan != "" {
key := testplan
value, err := client.Get(key)
if err != nil {
fmt.Println("Failed to get value: ", err)
return
}
if value == nil {
fmt.Println("The plan is not exists. We will query it from mysql and then store them in redis.")
// Get Executions
maxTPNum := 10000
testexecution_where, err := models.GetAllExecutionsWhere(testplan)
tpCount := len(testexecution_where)
if err != nil || tpCount > maxTPNum {
testplan = ""
}
executions = testexecution_where
value, err := json.Marshal(testexecution_where)
if err != nil {
fmt.Println("Failed to marshal: ", err)
}
client.Set(key, value)
client.Expire(key, expiration)
} else {
fmt.Println("The plan is exists. We will unmarshal them.")
// var temp planinfo
err := json.Unmarshal(value, &executions)
if err != nil {
fmt.Println("Failed to unmarshal: ", err)
return
}
}
}
this.Data["TestPlans"] = tp
this.Data["TableHeader"] = ExecutionsTableHeader
this.Data["TestExecutionTree"] = executions
this.Data["Website"] = "goTestLinkReport.org"
this.Data["Email"] = "*****@*****.**"
this.TplNames = "report.tpl"
}
