data/reads.jsjavascript
import { musclePriority } from './musclePriority.js'

/**
 * The app's reads, given the json-fs-query `query` and `quote` to run them with: Node's (workoutQueries.js, for the
 * API server and the tests) or the browser build's (browserReads.js, for the page, which reads database/ from its own
 * origin over fetch()). Reads need no server; only writes do.
 * @param {{query: Function, quote: Function}} jsonFsQuery
 * @returns {{quoteId: Function, getMusclePriority: Function, getExercisesForMuscle: Function, getLastSession: Function}}
 */
export const createReads = ({ query, quote }) => {
  /**
   * An id as a query value: quoted, since ids are strings and a generated one (a UUID such as
   * 'aca3a0b4-5539-...') reads as subtraction when it isn't. A missing id stays missing, so the query still fails on it.
   * @param id
   * @returns {string|undefined|null}
   */
  const quoteId = id => id === undefined || id === null ? id : quote(String(id))

  /**
   * Rank every muscle by how much it needs attention right now, from a real read of the database.
   * @param today - injectable for testing; defaults to the real current time
   */
  const getMusclePriority = async (today = new Date()) => {
    const [muscles] = await query('read muscles')
    const joinQueryString = 'read workouts.muscles' +
      ' on workouts.exercise_id = exercises._id' +
      ' and on exercises._id = exercise_muscle.exercise_id' +
      ' and on exercise_muscle.muscle_id = muscles._id' +
      ' merge muscles._id with exercise_muscle.muscle_id'
    const [workoutsWithMuscles] = await query(joinQueryString)
    return musclePriority(muscles, workoutsWithMuscles, today)
  }

  /**
   * Every exercise linked to a given muscle, via exercise_muscle.
   * @param muscleId
   */
  const getExercisesForMuscle = async (muscleId) => {
    const queryString = 'read exercise_muscle.exercises' +
      ' on exercise_muscle.exercise_id = exercises._id' +
      ` where muscle_id = ${quoteId(muscleId)}`
    const [rows] = await query(queryString)
    return rows.map(row => row.exercises[0])
  }

  /**
   * The most recently logged workout for a given exercise, or null if it's never been logged.
   * @param exerciseId
   */
  const getLastSession = async (exerciseId) => {
    const queryString = `read workouts where exercise_id = ${quoteId(exerciseId)} sort date desc limit 1`
    const [rows] = await query(queryString)
    return rows[0] ?? null
  }

  return { quoteId, getMusclePriority, getExercisesForMuscle, getLastSession }
}