Example #1
0
func ListTasks() ([]icarus.TaskData, error) {
	InitStorage()
	rows, err := db.Query("SELECT task.id, task.handle, user.userid, user.password FROM task INNER JOIN user ON task.id = user.task_id")
	if err != nil {
		log.Warnf("storage.GetAllTasks(): Failed to fetch from database: %s.", err.Error())
		return nil, err
	}
	defer rows.Close()

	res := make([]icarus.TaskData, 0)
	for rows.Next() {
		var entry icarus.TaskData
		entry.Courses = make([]icarus.CourseData, 0)
		err = rows.Scan(&entry.ID, &entry.Handle, &entry.User.UserID, &entry.User.Password)
		if err != nil {
			log.Warnf("storage.GetAllTasks(): Failed to fetch a task: %s.", err.Error())
			continue
		}

		rowsCourse, err := db.Query("SELECT course.name, course.desc, course.token FROM course WHERE course.task_id = ?", entry.ID)
		if err != nil {
			log.Warnf("storage.GetAllTasks(): Task %d: Failed to fetch courses: %s.", entry.ID, err.Error())
			continue
		}
		func(r *sql.Rows) {
			defer r.Close()
			for r.Next() {
				var cs icarus.CourseData
				err = r.Scan(&cs.Name, &cs.Desc, &cs.Token)
				if err != nil {
					log.Warnf("storage.GetAllTasks(): Task %d: Failed to fetch a course: %s.", entry.ID, err.Error())
					continue
				}
				entry.Courses = append(entry.Courses, cs)
			}
		}(rowsCourse)

		res = append(res, entry)
	}
	return res, nil
}
Example #2
0
func CreateTask(taskdata icarus.TaskData) (ID int, t *task.Task, err error) {
	mu.Lock()
	defer mu.Unlock()

	ID, err = storage.CreateTask(taskdata)
	if err != nil {
		return
	}
	taskdata.ID = ID

	t, err = addTask(taskdata)
	return
}