Source: routers/sheetMusicPart.js

  1. const express = require('express');
  2. const auth = require('../middleware/authenticator.js');
  3. const verify = require("../middleware/verifier.js");
  4. const mysql = require("../db/mysql.js");
  5. const alphaProcesser = require('../AlphaTab/ProcessAlphaTab.js');
  6. const Manipulator = require("../Parser/ParsedOutputManipulator.js");
  7. const ParserPData = require("../Parser/ParserPerformanceData.js");
  8. const ParserMeasures = require("../Parser/ParserMeasures.js");
  9. const updateExerciseTable = require("../util/updateExercise.js");
  10. const router = express.Router();
  12. /**
  13.  * @typedef {object} SheetMusicPartGetPackage
  14.  * @property {string} sheet_music The created AlphaTex isolating the user's part
  15.  * @property {string[]} part_list A list of part (i.e. track) names in the generated AlphaTex
  16.  * @property {string[]} clefs Clefs per staff
  17.  * @property {number[]} performance_expectation A 1D array of even size with the ith index as the midi value and the i+1 index as the duration of that note for i%2==0
  18.  * @property {number[]} lower_upper A 1D two valued array with the lower and upper midi values
  19.  * @property {number[]} measure_lengths A collection of the lengths of each Measure. The ith index contains the length in seconds of the i+1 Measure
  20.  * @property {string} exerciseId The ID of the exercise created
  21.  */
  23. /**
  24.  * Route for getting only the user's part from the given sheet music. Creates AlphaTex with their part isolated
  25.  * @name sheet-music-part/get
  26.  * @function
  27.  * @inner
  28.  * @param {*} req
  29.  * @param {string} req.query.sheetMusicId The sheet music ID to be accessed
  30.  * @param {*} res
  31.  * @returns {SheetMusicPartGetPackage|string} The created isolated sheet music and information about it. Otherwise, an error message if an error occured
  32.  * @async
  33.  */
  34. router.get('/', auth.token, async (req,res) => {
  35.     verify.memberOfSheetMusic(req, res).then((choirId) => {
  36.         if (choirId === null) {
  37.             res.status(403).send('Unauthorized');
  38.         } else {
  39.             let sheetMusicId = req.query.sheetMusicId;
  40.             const errorMessage = "Unable to get single part from sheet music";
  41.             if (sheetMusicId) {
  42.                 mysql.getClient().then((client) => {
  43.                     client.query("SELECT hex(member_id) AS member_id FROM tma.member WHERE person_id=? AND choir_id=unhex(?)", [res.locals.uid, choirId], function(error, results, fields) {
  44.                         if (error) {
  45.                             res.status(503).send(errorMessage);
  46.                         } else if (results.length === 0) {
  47.                             res.status(204).send(errorMessage);
  48.                         } else {
  49.                             let memberId = results[0]["member_id"];
  50.                             client.query("SELECT part FROM tma.member_sheet_music_part WHERE member_id=unhex(?) AND sheet_music_id=unhex(?)", [memberId, sheetMusicId], function(error, results, fields) {
  51.                                 if (error) {
  52.                                     res.status(503).send(errorMessage);
  53.                                 } else if (results.length === 0) {
  54.                                     res.status(204).send(errorMessage);
  55.                                 } else {
  56.                                     let partName = results[0]["part"];
  57.                                     client.query("SELECT performance_data FROM tma.sheet_music WHERE sheet_music_id = unhex(?)", [sheetMusicId], function(error, results, fields) {
  58.                                         if (error) {
  59.                                             res.status(503).send(errorMessage);
  60.                                         } else {
  61.                                             let performanceData = JSON.parse(results[0]['performance_data']);
  62.                                             const measureParser = new ParserMeasures(performanceData);
  63.                                             let measureEnd = measureParser.manipulator.getMeasureEnd(partName, 1);
  64.     
  65.                                             let trackIndex = measureParser.manipulator.getTrackIndexByName(partName);
  66.     
  67.                                             if (measureEnd === null) {
  68.                                                 res.status(400).send(errorMessage);
  69.                                             } else {
  70.                                                 let {lyricText, alphaTex} = measureParser.measuresToAlphaTex([1, measureEnd, "all"], trackIndex + 1, 1, false);
  71.     
  72.                                                 let exercisePerformanceData = alphaProcesser.process(alphaTex, {0:lyricText});
  73.                                                 let partNames = ParserPData.getPartNames(exercisePerformanceData.mainObj);
  74.                                                 let clefs = ParserPData.getClefs(exercisePerformanceData.mainObj);
  75.     
  76.                                                 let noteStream = ParserPData.getNoteStream(exercisePerformanceData.mainObj, partName);
  77.                                                 let lowerAndUpper = ParserPData.getLowerAndUpper(noteStream);
  78.                                                 let manipulator = new Manipulator(exercisePerformanceData.mainObj);
  79.                                                 let measureLengths = manipulator.getMeasureTimeLength(partName);
  80.     
  81.                                                 let retObj = {
  82.                                                     "sheet_music": alphaTex,
  83.                                                     "part_list": partNames,
  84.                                                     clefs,
  85.                                                     "performance_expectation": noteStream,
  86.                                                     "lower_upper": lowerAndUpper,
  87.                                                     "measure_lengths": measureLengths,
  88.                                                 };
  89.     
  90.                                                 updateExerciseTable(sheetMusicId, trackIndex + 1, 0, 1, measureEnd, false).then((exerciseId) => {
  91.                                                     retObj.exerciseId = exerciseId;
  92.                                                     res.status(200).json(retObj);
  93.                                                 });
  94.                                             }
  95.                                         }
  96.                                     });
  97.                                 }
  98.                             });
  99.                         }
  100.                     });
  101.                 });
  102.             } else {
  103.                 res.status(400).send(errorMessage);
  104.             }
  105.         }
  106.     }).catch((error) => {
  107.         res.status(403).send('Unauthorized');
  108.     });
  109. });
  111. /**
  112.  * Route for assigning a part to a user for a piece of sheet music
  113.  * @name sheet-music-part/post
  114.  * @function
  115.  * @inner
  116.  * @param {*} req
  117.  * @param {string} req.body.memberId The member ID to be accessed
  118.  * @param {string} req.body.sheetMusicId The sheet music ID for the part
  119.  * @param {string} req.body.part The part to be assigned to the member
  120.  * @param {*} res
  121.  * @returns {string} An error message if an error occured
  122.  * @async
  123.  */
  124. router.post('/', auth.token, async (req,res) => {
  125.     verify.userIsMember(req, res).then((isMember) => {
  126.         if (!isMember) {
  127.             res.status(403).send('Unauthorized');
  128.         } else {
  129.             verify.memberOfSheetMusic(req, res).then((choirId) => {
  130.                 if (choirId === null) {
  131.                     res.status(403).send('Unauthorized');
  132.                 } else {
  133.                     let sheetMusicId = req.body.sheetMusicId;
  134.                     let part = req.body.part;
  135.                     let memberId = req.body.memberId;
  136.                     const errorMessage = "Unable to add part for member in sheet music";
  137.                     if (sheetMusicId && part && memberId) {
  138.                         mysql.getClient().then((client) => {
  139.                             client.beginTransaction(function(error) {
  140.                                 client.query("INSERT INTO tma.member_sheet_music_part (member_id, sheet_music_id, part) values(unhex(?), unhex(?), ?)", [memberId, sheetMusicId, part], function(error, results, fields) {
  141.                                     if (error) {
  142.                                         res.status(503).send(errorMessage);
  143.                                     } else {
  144.                                         client.query("SELECT performance_data FROM tma.sheet_music WHERE sheet_music_id = unhex(?)", [sheetMusicId], function(error, results, fields) {
  145.                                             if (error) {
  146.                                                 client.rollback(function() {
  147.                                                     res.status(503).send(errorMessage);
  148.                                                 });
  149.                                             } else {
  150.                                                 let performanceData = JSON.parse(results[0]['performance_data']);
  151.                                                 let {progressData, trackIndex} = ParserPData.createEmptyProgressData(performanceData, part);
  152.                                                 let progress = {
  153.                                                     index: 0,
  154.                                                     data: [progressData]
  155.                                                 };
  156.                                                 client.query("INSERT INTO tma.performance_progress (performance_progress_id, member_id, sheet_music_id, staff_number, progress_data) values(unhex(replace(uuid(),\"-\",\"\")), unhex(?), unhex(?), ?, ?)", [memberId, sheetMusicId, trackIndex+1, JSON.stringify(progress)], function(error, results, fields) {
  157.                                                     if (error) {
  158.                                                         client.rollback(function() {
  159.                                                             res.status(503).send(errorMessage);
  160.                                                         });
  161.                                                     } else {
  162.                                                         client.commit(function(err) {
  163.                                                             if (err) {
  164.                                                                 client.rollback(function() {
  165.                                                                     res.status(503).send(errorMessage);
  166.                                                                 });
  167.                                                             } else {
  168.                                                                 res.status(200).send();
  169.                                                             }
  170.                                                         });
  171.                                                     }
  172.                                                 });
  173.                                             }
  174.                                         });
  175.                                     }
  176.                                 });
  177.                             });
  178.                         });
  179.                     } else {
  180.                         res.status(400).send(errorMessage);
  181.                     }
  182.                 }
  183.             }).catch((error) => {
  184.                 res.status(403).send('Unauthorized');
  185.             });
  186.         }
  187.     }).catch((error) => {
  188.         res.status(403).send('Unauthorized');
  189.     });
  190. });
  192. module.exports = router;