func/work.js

  1. "use strict";
  3. Object.defineProperty(exports, "__esModule", {
  4.   value: true
  5. });
  6. exports.loadAuthorNames = loadAuthorNames;
  7. /*
  8.  * Copyright (C) 2022  Shivam Awasthi
  9.  * Some parts adapted from bookbrainz-site
  10.  *
  11.  * This program is free software; you can redistribute it and/or modify
  12.  * it under the terms of the GNU General Public License as published by
  13.  * the Free Software Foundation; either version 2 of the License, or
  14.  * (at your option) any later version.
  15.  *
  16.  * This program is distributed in the hope that it will be useful,
  17.  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  18.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  19.  * GNU General Public License for more details.
  20.  *
  21.  * You should have received a copy of the GNU General Public License along
  22.  * with this program; if not, write to the Free Software Foundation, Inc.,
  23.  * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  24. */
  26. /**
  27.  * @param  {ORM} orm - the BookBrainz ORM, initialized during app setup
  28.  * @param  {array} workBBIDs - the array containing the BBIDs of the works contained in the edition
  29.  * @returns {Object} - Returns an array of objects containing the authorAlias, authorBBID of each work in an edition
  30. */
  31. async function loadAuthorNames(orm, workBBIDs) {
  32.   if (!workBBIDs.length) {
  33.     return [];
  34.   }
  35.   const sqlQuery = `select
  36. 		author.bbid as authorBBID,
  37. 		alias."name" as authorAlias,
  38. 		work.bbid as workBBID
  39. 		from
  40. 			bookbrainz.work as work
  41. 		-- Get Authors related to Work (relationship type 8, Author wrote Work)
  42. 		left join bookbrainz.relationship_set as workRelSet on
  43. 			workRelSet.id = work.relationship_set_id
  44. 		left join bookbrainz.relationship_set__relationship as workRelSetRel on
  45. 			workRelSetRel.set_id = workRelSet.id
  46. 		inner join bookbrainz.relationship as workRel on
  47. 			workRel.type_id = 8
  48. 			and workRel.id = workRelSetRel.relationship_id
  49. 		left join bookbrainz.author as author on
  50. 			author.bbid = workRel.source_bbid
  51. 			and author.master is true
  52. 		-- Get defaultAlias of the Authors
  53. 		left join bookbrainz.alias on
  54. 			alias.id = author.default_alias_id 
  55. 		where
  56. 			work.master is true
  57. 			and work.data_id is not null
  58. 			and work.bbid in ${`(${workBBIDs.map(bbid => `'${bbid}'`).join(', ')})`}`;
  59.   const queryResults = await orm.bookshelf.knex.raw(sqlQuery);
  60.   return queryResults.rows;
  61. }