We're using cookies to make this site more secure, featureful and efficient.

Issue 594: Diagram

Object
Caerlaverock Castle (Dance)
Submitter
Meinhard Reiser
Assigned to
Anselm Lingnau
Priority
Nice to have
Disposition
Being handled
Description

Keith, can you please add a modified (title & source) copy of the diagram for “Bruce’s Men” https://my.strathspey.org/dd/dance/11188/ to this dance?

Previous Actions

  • Date  Dec. 10, 2014, 5:51 p.m.
  • User  Unknown

New issue submitted

  • Date  Dec. 14, 2014, 8:52 p.m.
  • User  Keith Rose (keithrose)

Disposition changed to »Fixed« (previously »New«)

Bruce’s Men diagram copied to this dance and renamed

  • Date  Dec. 14, 2014, 9:37 p.m.
  • User  Anselm Lingnau (anselm)

Assigned changed to »anselm« (previously »None«)
Priority changed to »Nice to have« (previously »Normal«)
Disposition changed to »Being handled« (previously »Fixed«)

If the two dances are really identical then there should be only one entry in the database and the different titles should be added via aliases, especially if the identity is not a case of parallel invention (which can be ruled out here as both dances are by Roy Goldring).

There are basically two issues that make this difficult. Firstly, there is currently no way to include a reference to a dance alias when linking a dance to a publication (such that there could be a reference in the entry for “Bruce’s Men” saying “Published in: Graded & Social Dances 3 (as ‘Caerlaverock Castle’)”, similar to tunes in recordings). Secondly, diagrams contain a hard-coded dance title and a dance can have only one diagram per crib source, therefore it is difficult to have two diagrams for the same dance (as in, sequence of figures) with different titles.

The first issue is reasonably easy to fix by adding a foreign key to the DanceAlias table to the DancesPublicationsMap table. The second issue can in principle be addressed in the same way (by adding a DanceAlias reference to DanceDiagram objects), but we will need to figure out a convention for naming diagrams that belong to dances whose titles are really dance aliases.

All of this makes sense if we’re interested in database purity. We could also agree that if this only applies to a very small number of dances then we might as well not bother and just add cross-references as required. The dance alias addition to dance-publication maps, however, is probably a good idea in any case (to take care of spelling variances, for example) and once we have this feature we might as well use it to do the Right Thing here, too.

I’m reopening this issue as “Being handled”, priority “Nice to have”, and assigning it to me just so I don’t forget about this.