Ejemplo n.º 1
0
//Defense get the defense of a student
func (s *Store) Defense(student string) (schema.Defense, error) {
	d := schema.Defense{}
	st := s.stmt(selectDefense)
	var grade sql.NullInt64
	err := st.QueryRow(student).Scan(
		&d.SessionId,
		&grade,
		&d.Public,
		&d.Local,
		&d.Time,
		&d.Room,
	)
	if err == sql.ErrNoRows {
		return d, schema.ErrUnknownDefense
	}
	if err != nil {
		return d, err
	}
	d.Grade = nullableInt(grade, -1)

	ints, err := s.Internship(student)
	if err != nil {
		return d, err
	}
	d.Student = ints.Convention.Student
	return d, err
}
Ejemplo n.º 2
0
func (s *Store) defenses() (map[string]schema.Defense, error) {
	defs := make(map[string]schema.Defense)
	st := s.stmt(selectDefenses)
	rows, err := st.Query()
	if err != nil {
		return defs, err
	}
	defer rows.Close()
	for rows.Next() {
		d := schema.Defense{}
		var s string
		var grade sql.NullInt64
		err = rows.Scan(
			&s,
			&d.Time,
			&d.SessionId,
			&grade,
			&d.Public,
			&d.Local,
		)
		d.Grade = nullableInt(grade, -1)
		if err != nil {
			return defs, err
		}
		defs[s] = d
	}
	return defs, nil
}
Ejemplo n.º 3
0
func (s *Store) DefenseSession(room, id string) (schema.DefenseSession, error) {
	st := s.stmt(defenseSession)
	rows, err := st.Query(room, id)
	if err != nil {
		return schema.DefenseSession{}, err
	}
	defer rows.Close()
	if !rows.Next() {
		return schema.DefenseSession{}, schema.ErrUnknownDefense
	}
	session, err := scanDefenseSession(rows)
	if err != nil {
		return session, err
	}
	//jury
	st = s.stmt(selectJury)
	rows2, err := st.Query(room, id)
	if err != nil {
		return session, err
	}
	defer rows2.Close()
	for rows2.Next() {
		var last pq.NullTime
		u := schema.User{Person: schema.Person{}}
		var role string
		err := rows2.Scan(&u.Person.Firstname,
			&u.Person.Lastname,
			&u.Person.Tel,
			&u.Person.Email,
			&role,
			&last)
		u.Role = schema.Role(role)
		u.LastVisit = nullableTime(last)
		if err != nil {
			return session, err
		}
		session.Juries = append(session.Juries, u)
	}
	//students
	st = s.stmt(selectStudentInDefenseSession)
	rows3, err := st.Query(room, id)
	if err != nil {
		return session, err
	}
	defer rows3.Close()
	for rows3.Next() {

		var student string
		var grade sql.NullInt64
		def := schema.Defense{}
		err = rows3.Scan(&student, &grade, &def.Public, &def.Local, &def.Time)

		if err != nil {
			return session, err
		}
		ints, err := s.Internship(student)
		if err != nil {
			return session, err
		}
		if grade.Valid {
			def.Grade = int(grade.Int64)
		}
		def.Student = ints.Convention.Student
		def.Company = ints.Convention.Company
		session.Defenses = append(session.Defenses, def)
	}
	return session, err
}