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
}