Seed Dictionary V3
Seeds 14 additional terms: narrative form, built form, aesthetics, alchemy, material culture.
1"""Seed additional HP entity terms — third expansion wave. 2 3Adds terms for: narrative structures, specific woodcuts, editions/translations, 4scholarly methodology, and concepts that fill gaps in existing categories. 5 6Idempotent: uses INSERT OR IGNORE. 7""" 8 9import sqlite3 10from pathlib import Path 11 12BASE_DIR = Path(__file__).resolve().parent.parent 13DB_PATH = BASE_DIR / "db" / "hp.db" 14 15# Categories 16CHARS = "Characters & Figures" 17PLACES = "Places & Settings" 18BUILT = "Architecture & Built Form" 19GARDEN = "Gardens & Landscape" 20PROC = "Processions & Ritual" 21VISUAL = "Visual & Typographic" 22AESTH = "Aesthetic Concepts" 23MATERIAL = "Material Culture" 24BOOK = "Book History & Bibliography" 25TEXT = "Textual & Visual Motifs" 26ANNOT = "Annotation Studies" 27ALCHEM = "Alchemical Interpretation" 28DEBATE = "Scholarly Debates" 29NARR = "Narrative & Literary Form" 30 31TERMS = [ 32 # === Narrative & Literary Form (new category) === 33 { 34 "slug": "dream-vision", 35 "label": "Dream Vision", 36 "category": NARR, 37 "definition_short": "A literary genre in which the narrator falls asleep and experiences a visionary journey, to which the HP belongs.", 38 "definition_long": "The dream vision is a medieval and early modern literary genre in which the narrator falls asleep and undergoes a guided journey through an allegorical landscape. The HP belongs to this tradition alongside the Roman de la Rose, Dante's Commedia, and Chaucer's Book of the Duchess. The genre provides a license for mixing registers (erotic, philosophical, architectural) and for encounters with allegorical figures that would be implausible in a realistic narrative frame. Priki (2016) places the HP's double dream within this comparative tradition.", 39 "source_basis": "Priki 2016; Gollnick 1999; Agamben 1984", 40 }, 41 { 42 "slug": "petrarchism", 43 "label": "Petrarchism", 44 "category": NARR, 45 "definition_short": "The literary tradition of imitating Petrarch's love poetry, whose conventions the HP adapts into a prose-image hybrid.", 46 "definition_long": "Petrarchism — the tradition of imitating Petrarch's Canzoniere — provides the HP with its central love vocabulary: the distant beloved, the suffering lover, the transformative power of beauty, and the interplay of desire and frustration. Trippe (2002) argues that the HP adapts these Petrarchan conventions from lyric poetry into a visual register, translating the beloved's beauty from metaphor into woodcut illustration. The HP's treatment of Polia draws heavily on Petrarchan tropes while exceeding them through narrative and architectural elaboration.", 47 "source_basis": "Trippe 2002; Godwin 1999", 48 }, 49 { 50 "slug": "roman-de-la-rose", 51 "label": "Roman de la Rose", 52 "category": NARR, 53 "definition_short": "The thirteenth-century French allegorical poem that is the HP's most important literary predecessor in the dream-vision genre.", 54 "definition_long": "The Roman de la Rose (c. 1230-1275), by Guillaume de Lorris and Jean de Meun, is the foundational European dream-vision allegory. Like the HP, it combines a love quest with encyclopedic digressions and allegorical encounters in a garden setting. Priki (2016) places the HP within a lineage running from the Roman de la Rose through the HP to later dream narratives, arguing that both texts use the dream frame to enable pedagogical encounters that prepare the dreamer for union with the beloved.", 55 "source_basis": "Priki 2016; Godwin 1999", 56 }, 57 { 58 "slug": "neoplatonism", 59 "label": "Neoplatonism", 60 "category": NARR, 61 "definition_short": "The philosophical tradition of Plotinus and Ficino that informs the HP's treatment of beauty, love, and ascent from sensory experience to intellectual vision.", 62 "definition_long": "Neoplatonic philosophy pervades the HP's structure and imagery. Poliphilo's journey from the dark forest through sensory initiation to union with Polia on Cythera enacts a Neoplatonic ascent from material confusion to intellectual clarity. The five nymphs represent the senses as stages in this ascent. The circular garden of Cythera embodies the Neoplatonic emanation from the One. The HP's combination of erotic desire and philosophical aspiration reflects Ficino's reading of Platonic eros as the soul's drive toward beauty and truth.", 63 "source_basis": "Lefaivre 1997; Godwin 1999; Gollnick 1999", 64 }, 65 66 # === More Characters === 67 { 68 "slug": "logistica-thelemia", 69 "label": "Logistica and Thelemia", 70 "category": CHARS, 71 "definition_short": "Two allegorical figures representing reason (Logistica) and desire/will (Thelemia) who guide Poliphilo at a critical juncture.", 72 "definition_long": "At a key narrative moment, Poliphilo encounters two female figures: Logistica (reason, calculation) and Thelemia (will, desire). They represent the competing claims of rational judgment and passionate aspiration. Poliphilo must navigate between them, and his choice reflects the HP's humanist conviction that neither pure reason nor pure desire suffices — both must be integrated. The pairing echoes the three gates of Thelemia (vita contemplativa, vita activa, vita voluptuosa) and the broader Renaissance discourse on free will.", 73 "source_basis": "HP; Godwin 1999; Lefaivre 1997", 74 }, 75 76 # === More Architecture === 77 { 78 "slug": "colossus", 79 "label": "Colossus", 80 "category": BUILT, 81 "definition_short": "A gigantic figure or statue encountered by Poliphilo, described with measurements evoking the Colossus of Rhodes.", 82 "definition_long": "Poliphilo encounters colossal statues and figures that evoke the ancient Wonders of the World, particularly the Colossus of Rhodes. These passages demonstrate the HP's interest in extreme scale as a vehicle for meraviglia (wonder). The colossal figures are described with precise measurements, combining the awe of gigantism with the rationality of architectural proportion. They represent the HP's characteristic fusion of the marvelous and the measurable.", 83 "source_basis": "HP; Godwin 1999", 84 }, 85 { 86 "slug": "mosaic", 87 "label": "Mosaic", 88 "category": BUILT, 89 "definition_short": "Intricate floor and wall mosaics described in the HP, depicting mythological scenes in tessellated stone and glass.", 90 "definition_long": "The HP describes elaborate mosaic work on floors, walls, and ceilings of the buildings Poliphilo explores. These mosaics depict mythological scenes, geometric patterns, and symbolic imagery. Poliphilo reads them as visual texts, interpreting their iconography alongside their material composition. The mosaic passages contribute to the HP's broader interest in surfaces that carry meaning — inscribed, painted, carved, or tessellated.", 91 "source_basis": "HP; Godwin 1999; Stewering 2000", 92 }, 93 94 # === More Visual/Typographic === 95 { 96 "slug": "colophon", 97 "label": "Colophon", 98 "category": BOOK, 99 "definition_short": "The printed statement at the end of the 1499 HP identifying the printer (Aldus), place (Venice), and date (December 1499).", 100 "definition_long": "The 1499 HP ends with a colophon identifying the book as printed in Venice by Aldus Manutius in December 1499. The colophon is one of the few paratextual elements that provides external evidence about the book's production. It confirms the date and printer but does not name the author, leaving the authorship question dependent on internal evidence like the acrostic and stylistic analysis.", 101 "source_basis": "HP colophon; Painter 1963; Farrington 2015", 102 }, 103 { 104 "slug": "world-census", 105 "label": "World Census of Annotated Copies", 106 "category": ANNOT, 107 "definition_short": "Russell's systematic survey identifying all known annotated copies of the HP, conducted through ISTC records and institutional catalogs.", 108 "definition_long": "Russell's world census of annotated HP copies involved searching the Incunabula Short Title Catalogue (ISTC) and contacting holding institutions worldwide to identify copies bearing manuscript annotations. From this census he selected six copies for detailed study, encompassing eleven distinct annotator hands. The census methodology — systematic, institutionally grounded, and reproducible — established the evidentiary foundation for his annotation studies.", 109 "source_basis": "Russell 2014, Ch. 1-2", 110 }, 111 112 # === Aesthetic/Intellectual === 113 { 114 "slug": "ut-pictura-poesis", 115 "label": "Ut Pictura Poesis", 116 "category": AESTH, 117 "definition_short": "The classical principle 'as painting, so poetry' — the interchangeability of verbal and visual art — which the HP embodies.", 118 "definition_long": "The Horatian principle ut pictura poesis ('as painting, so poetry') asserts a fundamental analogy between visual and verbal art. The HP takes this principle further than perhaps any other Renaissance text: its 172 woodcuts are not subordinate illustrations but integral components of the work, and its verbal descriptions aspire to the vividness of painting. Trippe (2002) and Priki analyze how the HP negotiates the text-image boundary, making ut pictura poesis a structural rather than merely theoretical commitment.", 119 "source_basis": "Trippe 2002; Priki; Horace, Ars Poetica", 120 }, 121 { 122 "slug": "horror-vacui", 123 "label": "Horror Vacui", 124 "category": AESTH, 125 "definition_short": "The aesthetic tendency to fill every available surface with ornament, characteristic of the HP's descriptive and visual density.", 126 "definition_long": "The HP exhibits a pronounced horror vacui — an aversion to empty space — in both its verbal descriptions and its woodcut illustrations. Every surface Poliphilo encounters is carved, inscribed, painted, or planted. Every page of text is dense with description, digression, and learned vocabulary. This aesthetic density is not accidental but structural: the HP's meaning emerges from accumulation, overlay, and the refusal to leave any surface unworked.", 127 "source_basis": "HP passim; Jarzombek 1990", 128 }, 129 130 # === More Alchemical === 131 { 132 "slug": "great-work", 133 "label": "Great Work (Magnum Opus)", 134 "category": ALCHEM, 135 "definition_short": "The alchemical process of transmuting base matter into gold or the philosopher's stone, which both HP alchemist annotators read into the narrative.", 136 "definition_long": "The Great Work (magnum opus) is the central goal of alchemy: the transformation of base matter into gold, the philosopher's stone, or the elixir of life. Both the BL and Buffalo alchemist annotators read the HP as encoding stages of the Great Work beneath its love narrative. The BL alchemist followed d'Espagnet's mercury-centered framework; the Buffalo alchemist followed pseudo-Geber's sulphur and Sol/Luna emphasis. In both readings, Poliphilo's journey maps onto the stages of refinement, and his union with Polia represents the successful completion of the Work.", 137 "source_basis": "Russell 2014, Ch. 6-7; Perifano 2004", 138 }, 139 140 # === Material Culture additions === 141 { 142 "slug": "gold-leaf", 143 "label": "Gold Leaf", 144 "category": MATERIAL, 145 "definition_short": "Thin sheets of hammered gold used for gilding surfaces, frequently described adorning the HP's architectural interiors.", 146 "definition_long": "Gold leaf and gilding appear throughout the HP as markers of supreme luxury and divine association. Poliphilo describes ceilings, columns, and sculptural details covered in gold, specifying the quality of the application and the visual effect of light on gilded surfaces. The alchemical annotators took particular interest in gold references, reading them as encoding the final stage of transmutation.", 147 "source_basis": "HP passim; Russell 2014", 148 }, 149 { 150 "slug": "silk", 151 "label": "Silk", 152 "category": MATERIAL, 153 "definition_short": "Fine textile featured prominently in the HP's descriptions of clothing, drapery, and ceremonial hangings.", 154 "definition_long": "Silk and other fine textiles receive detailed attention in the HP. Poliphilo describes the garments of nymphs, queens, and processional figures with attention to weave, color, drape, and embroidery. These textile descriptions contribute to the HP's tactile and sensory richness, reinforcing the book's investment in material culture as a vehicle for meaning.", 155 "source_basis": "HP passim; Godwin 1999", 156 }, 157] 158 159LINKS = [ 160 # Narrative form 161 ("dream-vision", "dream-narrative", "RELATED"), 162 ("dream-vision", "dream-within-dream", "RELATED"), 163 ("dream-vision", "roman-de-la-rose", "RELATED"), 164 ("petrarchism", "vernacular-poetics", "RELATED"), 165 ("petrarchism", "polia", "RELATED"), 166 ("petrarchism", "ekphrasis", "RELATED"), 167 ("roman-de-la-rose", "dream-narrative", "RELATED"), 168 ("roman-de-la-rose", "allegory", "RELATED"), 169 ("neoplatonism", "venus-aphrodite", "RELATED"), 170 ("neoplatonism", "circular-garden", "RELATED"), 171 ("neoplatonism", "prisca-sapientia", "RELATED"), 172 173 # Characters 174 ("logistica-thelemia", "thelemia", "RELATED"), 175 ("logistica-thelemia", "eleuterylida", "RELATED"), 176 177 # Architecture 178 ("colossus", "meraviglia", "RELATED"), 179 ("colossus", "pyramid", "RELATED"), 180 ("mosaic", "grotesque", "RELATED"), 181 ("mosaic", "ekphrasis", "RELATED"), 182 183 # Book 184 ("colophon", "aldus-manutius", "RELATED"), 185 ("colophon", "1499-edition", "RELATED"), 186 ("world-census", "annotator-hand", "RELATED"), 187 ("world-census", "incunabulum", "RELATED"), 188 189 # Aesthetic 190 ("ut-pictura-poesis", "woodcut", "RELATED"), 191 ("ut-pictura-poesis", "ekphrasis", "RELATED"), 192 ("horror-vacui", "varieta", "RELATED"), 193 ("horror-vacui", "grotesque", "RELATED"), 194 195 # Alchemy 196 ("great-work", "alchemical-allegory", "RELATED"), 197 ("great-work", "master-mercury", "RELATED"), 198 ("great-work", "chemical-wedding", "RELATED"), 199 200 # Material 201 ("gold-leaf", "porphyry", "RELATED"), 202 ("silk", "nymphs-five-senses", "RELATED"), 203] 204 205 206def main(): 207 conn = sqlite3.connect(DB_PATH) 208 cur = conn.cursor() 209 210 print("Seeding HP entity dictionary terms (v3)...") 211 inserted = 0 212 for t in TERMS: 213 cur.execute(""" 214 INSERT OR IGNORE INTO dictionary_terms 215 (slug, label, category, definition_short, definition_long, 216 source_basis, review_status, needs_review, source_method) 217 VALUES (?, ?, ?, ?, ?, ?, 'DRAFT', 1, 'LLM_ASSISTED') 218 """, (t["slug"], t["label"], t["category"], 219 t["definition_short"], t["definition_long"], 220 t.get("source_basis", ""))) 221 inserted += cur.rowcount 222 conn.commit() 223 print(f" Inserted {inserted} new terms ({len(TERMS)} defined)") 224 225 print("Creating term links...") 226 linked = 0 227 for slug_a, slug_b, link_type in LINKS: 228 cur.execute("SELECT id FROM dictionary_terms WHERE slug=?", (slug_a,)) 229 a = cur.fetchone() 230 cur.execute("SELECT id FROM dictionary_terms WHERE slug=?", (slug_b,)) 231 b = cur.fetchone() 232 if a and b: 233 cur.execute(""" 234 INSERT OR IGNORE INTO dictionary_term_links 235 (term_id, linked_term_id, link_type) 236 VALUES (?, ?, ?) 237 """, (a[0], b[0], link_type)) 238 linked += cur.rowcount 239 if link_type == "RELATED": 240 cur.execute(""" 241 INSERT OR IGNORE INTO dictionary_term_links 242 (term_id, linked_term_id, link_type) 243 VALUES (?, ?, ?) 244 """, (b[0], a[0], link_type)) 245 linked += cur.rowcount 246 conn.commit() 247 print(f" Created {linked} links") 248 249 cur.execute("SELECT COUNT(*) FROM dictionary_terms") 250 print(f"\nTotal terms: {cur.fetchone()[0]}") 251 cur.execute("SELECT category, COUNT(*) FROM dictionary_terms GROUP BY category ORDER BY COUNT(*) DESC") 252 for row in cur.fetchall(): 253 print(f" {row[0]}: {row[1]}") 254 255 conn.close() 256 print("\nDone.") 257 258 259if __name__ == "__main__": 260 main()