I found a way to automate the addition of @xml:id attributes where these are required because of linking from the TOC, so that's been done in Le Bon Mariage, Le Blanc and Ville-Thierry.
Did the last session with the three remaining volunteers, one of whom unfortunately dropped out.
Started working on rendering of TOC code, as described here. These are the changes I've made:
- I made substantial edits to Le Bon Mariage, Ville-Thierry and Le Blanc to fix minor inconsistencies and missing attributes.
- I added a special handler for
<ref type="pageNum">which processes a TOC page number into a link to the<fw>containing that page number. Note, though, that none of the<fw>tags in question actually has an@xml:idattribute yet, with the exception of one that I added to Le Bon Mariage for testing. I'll probably try to automate the addition of those attributes. - I added an appropriate CSS ruleset for the page numbers.
Basically everything seems to be working, although the page width of the Ville-Thierry is still wrong; I need to work on that a little. But someone else will take over the markup of that document at some point, so it could be left to them.
§ 3.5.3 - "event/character/citation" tab empty, check this **Added events from "event/place" tab to here citing proper characters**
- ID677, The ship Dionysus hired…and heads for Asia instead (change to "…and heads for Asia to sell him instead"?) "event/place" **Nevermind**
§ - Add event "People begin to honor the god Dionysus" (place "Nowhere") **Only added this to "event/character/citation" tab citing character: Dionysus**
§ 3.5.4 - "event/character/citation" tab empty, check this **Added events from "event/place" tab to here citing proper characters**
- ID685, Zeus sends Cadmus and Harmonia to the Elysian Fields (change to "Zeus turns Cadmus and Harmonia into serpents and sends them away to the Elysian Fields"?) "event/place" **Nevermind**
§ 3.5.5 - ID2688, Dirce is spouse of Lycus (4) (add vice versa) "character/character/citation"
§ - ID2691, ibid "character/character/citation"
§ - ID2737, Labdacus is mortal mother of Nycteis (delete record, this is inaccurate) "character/character/citation"
§ - ID1924-1926, Amphion and Zethus…throw her into a river (change to "…into a spring") "event/character/citation"
§ - ID709, ibid "event/place"
§ - ID1927, Dirce gives her name to the river in which she died (change to "Dirce gives her name to the spring…") "event/character/citation"
§ - ID710, ibid "event/place"
§ - Add event "Lycus and Nycteus fled Euboea for killing Phlegyas" (characters: Lycus, Nycteus, Phlegyas) "event/character/citation"
§ - ibid (place: Euboea) "event/place"
§ - Add event "Lycus and Nycteus move to Hyria" (characters: Lycus, Nycteus) "event/character/citation"
§ - ibid (place: Hyria) "event/place"
§ 3.5.6 - ID2696, Thebe is spouse of Zethus (add vice versa) "character/character/citation"
§ - ID660/1424, Ethodaia is the daughter of Amphion and Niobe (2) (text says "or, as some say, Neaera", add new record with this character's name as daughter of Amphion and another for Niobe (2)?) "character/character/citation" **Added Neaera (2) as daughter of Amphion and Niobe (2)**
§ - ID1963, Niobe leaves Thebes and goes to her father in Sipylus (character cited is "Sipylus", but text says "[Niobe] went to her father Tantalus at Sipylus", so should we change this to Tantalus (2) since he is not cited?) "event/character/citation" **Corrected, also changed character Tantalus to Tantalus (1) since there are two**
- ID1945-1946, Niobe says she is more blessed with children than Leto (text says "Latona" rather than Leto, change event and cited character to "Latona"?) "event/character/citation" **Please look into this, I am not sure since there is an entry for Leto and Latona. Ought we to keep both or should we use the Latinized version "Latona" for all entries instead?**
- ID723, ibid "event/place"
- ID1947-1949, Leto calls upon Apollo… (ibid) "event/character/citation"
- ID724, ibid "event/place"
- ID726, Apollo shoots down the men while they are hunting on Mt. Cithaeron (place cited is "Thebes" but should we change to "Mt. Cithaeron" instead?) "event/place" **Mount Cithaeron is not in the database**
- ID730, Niobe leaves Thebes and goes to her father in Sipylus (place cited is "Unknown" should we change to "Sipylus" instead?) "event/place" **Ibid**
- ID731, Niobe prays to Zeus and is turned into a stone that weeps (ibid) "event/place"
* 3.5.7 - ID669, Menoeceus is the mortal father of Jocasta (text says "some [say] that she was Epicasta", add a new record for Epicasta as the daughter of Menoeceus?) "character/character/citation"
- Add new record for Epicasta as the mortal mother of Oedipus? "character/character/citation" **Epicasta is not in the database**
- ID2675/2720, Jocasta is spouse of Laius & vice versa (add two new records with Epicasta as spouse of Laius & vice versa?) "character/character/citation"
- ID2009-2010, Laius marries Jocasta (also cite "Epicasta"?) "event/character/citation"
- ID2012-2013, Laius gets drunk and sleeps with Jocasta (ibid) "event/character/citation"
3.5.8 - ID1592-1595/2676/2734, also cite Epicasta? "character/character/citation"
- ID2039-2040, Oedipus unwittingly marries his mother (ibid) "event/character/citation"
- ID2042-2046, Oedipus begets Polynices, Eteocles… (ibid) "event/character/citation"
§ - ID2033, Hera sends the Sphinx to Thebes (also cite character: Sphinx) "event/character/citation"
§ - ID2037, Oedipus solves the riddle of the Sphinx (ibid) "event/character/citation"
* - ID749, Hera sends the Sphinx to Thebes (place: Thebes, should this say Mount Phicium instead? Text says "she sat on Mount Phicium") "event/place"
§ - Add event "Damasistratus rules Plataea" (character: Damasistratus, place: Plataea)
3.5.9 - Personal note: Colonus is in Attica
3.6
§ 3.6.1 - ID2681, Argia is spouse of Polynices (In ID2562 as well as in 1.9.17 she is Argia (1), however "Argia" has not been cited anywhere but here. We ought to make this change then delete the record for "Argia" so that way we have Argia (1) for this citation and Argia (2) who is unrelated.) "character/character/citation"
§ - Add record entry for: Adrastus (1) is mortal father of Deipyle & Argia (1) "character/character/citation"
- Add event "Polynices marries Argia" (characters: Polynices, Argia (1)) "event/character/citation" **Nevermind**
§ - ID2076, Polynices and Tydeus wear the boar and the lion… (character cited is Argia, change to Argia (1)) "event/character/citation"
§ - Add event "Tydeus fled from Calydon" (character: Tydeus) "event/character/citation"
§ 3.6.2 - "event/character/citation" tab is empty, check this **Added events from "event/place" tab citing proper characters**
§ - ID783, Polyncies begs Eriphyle to convince Amphiarous to go to war (correct spelling to "Polynices begs Eriphyle to convince Amphiaraus to go to war") "event/place" **Corrected spelling**
3.6.3 - Frazer's footnote #3 mentions Mecisteus as the brother of Adrastus as mentioned in 1.9.13, ought we to add Talaus as the mortal father of Mecisteus (1)? "character/character/citation"
* - Add Tydeus and Parthenopaeus (2) to group "Seven against Thebes" (there ought to be nine since text says "Some…do not reckon Tydeus and Polynices among them") "group/character/citation"
§ - ID2457, Parthenopaeus goes to war against Thebes (should this be "Adrastus musters an army and the Seven against Thebes" instead? If so, add characters: Adrastus (1), Capaneus, Eteoclus, Hippomedon, Mecisteus (1), Parthenopaeus (2), Polynices, and Amphiaraus) "event/character/citation" **Deleted event and replaced with "Adrastus musters an army…" and cited aforementioned characters**
* 3.6.4 - Add record for Hypsipyle as foster mother of Opheltes (check to see if this is accurate, text says "Hypsipyle showed them the way to a spring, leaving behind an infant boy Opheltes, whom she nursed, a child of Eurydice and Lycurgus") "character/character/citation"
§ - Add record for Lycurgus (2) as mortal father of Opheltes "character/character/citation"
§ - "event/character/citation" tab is missing many events, check this
§ - ID799-805, match verb tenses present/past "event/place"
§ - ID789, Hypsiple leads the Seven against Thebes to a spring (correct spelling to "Hypsipyle…") "event/place"
§ - ID793, Hypsiple becomes servant of Lycurgus (ibid) "event/place"
Leaving early. Hours are mounting.
Planning and administration for Calico is getting into high gear. I could actually have spent all day answering emails as they came in without a break today...
In breaks between workshop sessions, I tried to address the problem of the length of time queries are taking by using temporary tables constructed directly in the query instead of joining to views. The approach I took (joining to a temporary table created in the join clause) had no effect -- the query took exactly the same time. But there may be a way to create a temporary table once earlier in the query, and then join to it later. Still working on this.
Did two training sessions today, including walk-throughs of actual rooms, and tours to Cadboro Commons. Also tested some ports and investigated storage options in Cad Commons (there are basically none).
§ 3.1.2 - ID2551, Minos is spouse of Pasiphae (add vice versa) "character/character/citation"
§ - ID2706/2708, Crete is spouse of Minos (record is repeated twice, one of them should be changed to the opposite of the other) "character/character/citation"
§ - Add relationships for Pasiphae and Crete being the possible mothers of Minos' children: Catreus, Deucalion (2), Glaucus (2), Androgeus, Acalle, Xenodice, Ariadne, and Phaedra "character/character/citation"
§ - ID1664, Minos marries Crete or Pasiphae, has children (character cited is Glaucus (1), but in the relationships table it was Glaucus (2) that was cited as son of Minos, which Glaucus is correct?) "event/character/citation" **Changed to Glaucus (2)**
§ 3.1.3 - ID1672-1679, these records do not belong in 3.1.3, move to 3.1.4 "event/character/citation"
§ - ID622-625, ibid. "event/place"
- ID1670, Poseidon sends a bull to Minos…Minos neglects to sacrifice it. (change to "…Minos sacrifices a different bull, keeping the fine one in his herd"? to emphasize that he tried to trick Poseidon by making him think that he did sacrifice the fine bull when in fact he did not.) "event/character/citation"
- ID1670, ibid. (cite Poseidon in this event as well) "event/character/citation"
§ 3.1.4 - move aforementioned records to here
3.2
3.2.1 - ok
§ 3.2.2 - Aerope is spouse of Plisthenes, and vice versa (add) "character/character/citation"
§ - Clymene (1) is mortal mother of Palamedes and Oeax (add) "character/character/citation"
§ - ID2727/2730, these do not belong in 3.2.2 "character/character/citation" **Deleted citations for 3.2.2**
§ - ID636, does not belong in 3.2.2, move to 3.3.2 "event/place"
3.3
3.3.1 - ok
* 3.3.2 - ID1698-1700, Minos causes Polyidus to teach divination to Glaucus… (these events have no place listed, should we add "Crete" as the place?) "event/character/citation"
3.4
* 3.4.1 - ID637, Cadmus buries Telephassa, who died (place is listed as "Thrace", but text says: "When Telephassa died, Cadmus buried her, and after being hospitably received by the Thracians he came to Delphi…" should we therefore cite place as -UNSPECIFIED-? If so we ought to make a new event such as "Cadmus is received hospitably by the Thracians" with place being "Thrace") "event/place"
§ 3.4.2 - ID638, Cadmus is mortal father of Polydorus (1) (add Harmonia as god mother of Polydorus (1) also) "character/character/citation"
§ - ID2682, Aristaeus is spouse of Autonoe (4) (add vice versa) "character/character/citation"
§ - ID2690, Echion (3) is spouse of Agave (3) (add vice versa) "character/character/citation"
§ - ID1718-1719, Gods attends the wedding of Cadmus and Harmonia (change spelling to "Gods attend…", also Zeus and Europa are cited but not explicitly mentioned, just "all the gods", should we use Abas (1) instead?) "event/character/citation" **Deleted citations for Zeus and Europa and corrected spelling**
§ - ID644, Gods attends the wedding of Cadmus and Harmonia (change spelling to "Gods attend…") "event/place"
§ 3.4.3 - ID1761, Zeus turns Dionysus into a kid (Zeus is cited, add Dionysus to event as well) "event/character/citation"
- ID651, Giants born (not sure if this belongs in 3.4.3) "event/place"
§ 3.4.4 - ID654, Chiron trains Actaeon to be a hunter (this ought to be in the event/character/citation tab as well, with characters Chiron and Actaeon involved in the event) "event/place"
§ - ID655, Actaeon eaten by his dogs (ibid, with Actaeon involved in the event) "event/place"
§ - ID656, Actaeon sees Artemis bathing… (ibid, with Actaeon and Artemis involved in the event) "event/place"
3.5
§ 3.5.1 - ID662, Lycurgus is king of the Edonians (place is "-UNSPECIFIED-" but text says they dwell beside the river Strymon, should we change to reflect this?) "event/place"
§ - Add event "Proteus rules Egypt", character "Proteus", place "Egypt" **Unsure which Proteus to cite, so I cited Proteus (1). Double-check please**
§ - Add event "Dionysus hastens through Thrace against the Indians", character "Dionysus", place "Thrace"
§ - All the events in "event/place" tab should also appear in the "event/character/citation" tab. They are as follows:
§ - ID657, Dionysus discovers the vine (character: Dionysus)
§ - ID658, Hera drives Dionysus insane (characters: Hera, Dionysus)
§ - ID659, Dionysus roams around… (character: Dionysus, Proteus) **Also cited Hera**
§ - ID660, ibid (character: Dionysus)
§ - ID661, Dionysus purified of his insanity by Rhea… (characters: Dionysus, Rhea, also Cybela is in Phrygia for my personal reference)
§ - ID662, Lycurgus is king of the Edonians (character: Lycurgus (4))
§ - ID663, Lycurgus insults and expels Dionysus (characters: Lycurgus (4), Dionysus)
§ - ID664, Dionysus takes refuge in the Sea with Thetis (characters: Dionysus, Thetis)
§ - ID665 - ok
§ - ID666, Dionysus drives Lycurgus crazy (characters: Lycurgus (4), Dionysus)
§ - ID667, Lycurgus kills his son Dryas with an axe (characters: Lycurgus (4), Dryas (3), also add "in a fit of madness"?)
§ - ID668, Lycurgus chained up by the Edonians… (character: Lycurgus (4), Dionysus, also add "by the will of Dionysus"?)
§ 3.5.2 - "event/character/citation" tab is again empty, please look into this **Added events from "event/place" tab to "event/character/citation" tab, citing the proper characters**
- ID670, Dionysus wanders through (place "India", text says that Dionysus set up pillars there, should we change to "…and sets up pillars in India" to reflect this?) "event/place" **Nevermind**