Example #1
0
func GetUsers(db *sql.DB, pk int) []models.User {
	// Generates a list of all the users (not admin).
	// It will be in the left-hand side of main table.
	rows, err := db.Query(qGetUsers)

	if err != nil {
		log.Fatal(err)
	}

	var U models.User
	users := make([]models.User, 0)
	place := 1
	// Calculating place out of db.

	for rows.Next() {
		err := rows.Scan(&U.Firstname, &U.Lastname, &U.Pk, &U.Points, &U.Correct)
		U.Place = place
		U.LoggedIn = U.Pk == pk
		place += 1

		if err == nil {
			users = append(users, U)
		} else {
			log.Println(err)
		}
	}
	return users
}