reindex-text

name

reindex-text

description

Re-index the sung text of a Piece that already exists in the emmsap database. Use when a musicxml/mxl file was updated or re-imported and its Text row is stale, or the user says "reindex the text(s) from piece <id>", "re-run text indexing for <piece>". The normal index_texts.main() only touches pieces with NO text, so an existing Piece must have its Text row deleted and rebuilt. Runs against the live DB via Django shell.

reindex-text — rebuild the Text row for an existing Piece

emmsap2.index_texts.main() skips any piece that already has a Text (Piece.objects.exclude(text__isnull=False)). So updateDB will not refresh a piece whose file changed. To reindex, delete the stale Text row and re-run the per-piece logic.

Model facts (as of this writing — verify if models.py changed)

• Text has a OneToOneField to Piece (on_delete=CASCADE), fields: language, text, text_reg, text_no_space.
• Reusable functions live in emmsap2/index_texts.py:
  • get_text_from_score(sc) — assembles lyrics across parts, adding a later part's text only when it's <0.8 Levenshtein-similar to what's already there.
  • regularize_text(text_in, language) → (text_reg, text_no_space).
  • module globals ld (LanguageDetector) and mistakes (filename→language overrides).
• Piece 3758 = Krakow_2464_10_Celebris_dies_colitur.mxl is a good smoke-test id.

Procedure

Run with uv run python manage.py shell -c "..." from the repo root. Replace with the piece id (or look it up by filename with ).