MetaBrainz Foundation

Create a report for CD-type releases on MusicBrainz that do not have an attached Disc ID

Sometimes, Disc ID is very helpful to identify a release from a CD (and similar type medium). A fair number of MusicBrainz releases are missing Disc IDs. A daily report of these would be quite useful especially when restricted to editor subscriptions.

The objective is to create a daily report of pseudo-releases which have no Disc IDs for at least one of their CD-type media. Two steps are necessary to reach it:

  1. Understanding the database schema and creating a specific SQL query
  2. Adding a new report based on this query

Requirements:

  • A working development environment, including a MusicBrainz server in standalone mode. (See the documentation for information on how to do this.) Installation should be fairly straightforward to complete, but it could be quite long depending on your computer performance. Note that running the server code is only supported on Linux systems and that you need at least ~20 GB of space to install it.

Steps include:

  1. Create a personal account in the issue tracker and assign yourself the linked ticket
  2. Create a branch to modify the code (SQL, Perl, Template Toolkit) with style
  3. Test your changes on your local MusicBrainz server and show us a screenshot
  4. Create a pull request to submit your changes
  5. Wait for review and make additional changes if required until approval

If you have questions, at any step, feel free to ping us on #metabrainz (IRC channel).

Task tags

  • musicbrainz
  • sql
  • template toolkit
  • perl

Students who completed this task

Eshan Singh

Task type

  • code Code
  • done_all Quality Assurance
close

2017