func (this *GetLastExecutionController) Get() {
fmt.Println("In GetLastExecutionController()...")
var ExecutionsTableHeader = []string{
// "TestPlan",
"Platform",
"ToadModule",
"SubModule",
"Testcase_id",
"TestCase",
"Status",
"Build",
"LasTimeRun",
"Notes",
"Tester",
// "TestSuite",
}
expiration := int64(12 * 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("GetExecution of TestPlan: " + 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 res []TestPlan
err := json.Unmarshal(value_tp, &res)
if err != nil {
fmt.Println("Failed to unmarshal: ", err)
return
}
for _, item := range res {
bActive := false
if testplan != "" && testplan == item.Name {
bActive = true
}
tp = append(tp, TestPlan{
Name: item.Name,
Count: item.Count,
Active: bActive,
})
}
}
this.Data["TestPlans"] = tp
this.Data["TableHeader"] = ExecutionsTableHeader
this.Data["Website"] = "goTestLinkReport.org"
this.Data["Email"] = "*****@*****.**"
this.TplNames = "getlastexecution_test.tpl"
}
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 testplan 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")
res := models.GetAllTestPlanNames()
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 testplan 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 executions 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 executions 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"
}