func (maker *courseMaker) Destroy(course *Course) error { query, _, err := sq. Delete("course"). Where(sq.Eq{"ID": course.ID}). ToSql() if err != nil { return err } _, err = util.PrepAndExec(query, maker, course.ID) if err != nil { return err } return nil }
func (maker *userMaker) Create(user *User) error { query := fmt.Sprintf(queries["create_user"], user.InsertColumns()) result, err := util.PrepAndExec(query, maker, user.FirstName, user.LastName, user.Username, string(user.Password), user.Status) if err != nil { return err } id, err := result.LastInsertId() if err != nil { return err } user.ID = id return nil }
func (maker *courseMaker) UpdateCourse(course *Course) error { query, _, err := sq. Update("course"). Set("name", course.Name). Where(sq.Eq{"id": course.ID}). ToSql() if err != nil { return err } _, err = util.PrepAndExec(query, maker, course.Name, course.ID) if err != nil { return err } return nil }
func (maker *studentMaker) Create(student *Student) error { // TODO make UserStore.Create private. UserStore.Create(&student.User) query := queries["create_student"] result, err := util.PrepAndExec(query, maker, student.User.ID) if err != nil { return err } id, err := result.LastInsertId() if err != nil { return err } student.ID = id return nil }
func (maker *AssignmentMaker) CreateAssignment(assig *Assignment) error { query, _, err := sq. Insert("assignment").Columns("student_id", "teacher_id"). Values(assig.StudentID, assig.TeacherID). ToSql() if err != nil { return err } result, err := util.PrepAndExec(query, maker, assig.StudentID, assig.TeacherID) if err != nil { return err } id, err := result.LastInsertId() if err != nil { return err } assig.ID = id return nil }
func (maker *teacherMaker) Create(teacher *Teacher) error { UserStore.Create(&teacher.User) query, _, err := sq. Insert("teacher").Columns("user_id").Values("user_id"). ToSql() if err != nil { return err } result, err := util.PrepAndExec(query, maker, teacher.User.ID) if err != nil { return err } id, err := result.LastInsertId() if err != nil { return err } teacher.ID = id return nil }