MetaBrainz Foundation

Create a report for non-CD-type mediums on MusicBrainz with pre-gap tracks

Pre-gap tracks only make sense for certain types of media (CDs, in particular). Having, e.g., vinyls with a pre-gap track is therefore a bug, and there could be a report to find and fix these.

The objective is to create a daily report of non-CD-type MusicBrainz media which have a pre-gap track. 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

  • sql
  • template toolkit
  • musibrainz
  • perl

Students who completed this task

Eshan Singh

Task type

  • code Code
  • done_all Quality Assurance
close

2017