Seed Timeline V2
Seeds ~30 new timeline events: art, literary influence, scholarly milestones, garden design.
1"""Extend timeline_events with art, literary influence, and scholarly milestones. 2 3Adds ~50 new events covering art inspired by the HP, literary influence, 4scholarly milestones from the bibliography, and modern reception. 5 6Idempotent: uses INSERT OR IGNORE on (year, title) uniqueness check. 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# Map our desired event types to the DB CHECK constraint 16# ART -> OTHER, SCHOLARSHIP -> OTHER, LITERARY -> OTHER 17# Use 'category' field for the real type label 18EVENTS = [ 19 # === Art === 20 { 21 "year": 1520, "event_type": "OTHER", "category": "art", 22 "title": "Garofalo painting with HP scene", 23 "description": "The Ferrarese painter Garofalo (Benvenuto Tisi) produced a painting incorporating a scene from the HP, identified by Fritz Saxl in his 1937 study. This is among the earliest documented visual adaptations of the HP outside the book itself.", 24 "medium": "painting", "confidence": "MEDIUM", 25 }, 26 { 27 "year": 1667, "event_type": "OTHER", "category": "art", 28 "title": "Bernini's Elephant and Obelisk unveiled", 29 "description": "Gian Lorenzo Bernini completed the elephant bearing an obelisk in Piazza della Minerva, Rome, commissioned by Pope Alexander VII. The sculpture draws on the HP's woodcut of the elephant-obelisk (b6v-b7r). Alexander VII himself annotated his copy of the HP.", 30 "medium": "sculpture", "location": "Piazza della Minerva, Rome", 31 "confidence": "HIGH", 32 }, 33 { 34 "year": 1717, "event_type": "OTHER", "category": "art", 35 "title": "Watteau, L'Embarquement pour Cythere", 36 "description": "Antoine Watteau painted L'Embarquement pour Cythere, depicting a departure for Venus's island. While direct influence from the HP is not confirmed, the painting belongs to the same cultural tradition of Cythera as the destination of erotic pilgrimage.", 37 "medium": "painting", "location": "Louvre, Paris", 38 "confidence": "LOW", 39 }, 40 { 41 "year": 1893, "event_type": "OTHER", "category": "art", 42 "title": "Beardsley and the HP aesthetic", 43 "description": "Aubrey Beardsley's illustration style of the 1890s shows affinities with the HP's woodcuts. Praz (1947) documents the HP's influence on the Aesthetic Movement and its visual culture, including Beardsley's decorative line work.", 44 "medium": "illustration", "confidence": "LOW", 45 }, 46 47 # === Literary Influence === 48 { 49 "year": 1534, "event_type": "OTHER", "category": "literary", 50 "title": "Rabelais, Abbey of Theleme in Gargantua", 51 "description": "Francois Rabelais included the Abbey of Theleme ('Do what thou wilt') in Gargantua, almost certainly drawing on the HP's portal of Thelemia where Poliphilo chooses among three life paths. The name and concept of free will connect the two works directly.", 52 "confidence": "HIGH", 53 }, 54 { 55 "year": 1592, "event_type": "TRANSLATION", "category": "edition", 56 "title": "Robert Dallington's English adaptation", 57 "description": "Robert Dallington published The Strife of Love in a Dreame, the first English version of the HP. Semler (2006) reframes this not as failed translation but as deliberate cultural appropriation for Protestant antiquarian interests in Elizabethan England.", 58 "confidence": "HIGH", 59 }, 60 { 61 "year": 1804, "event_type": "EDITION", "category": "edition", 62 "title": "Italian reprint edition", 63 "description": "An Italian reprint of the HP appeared in 1804, part of the early nineteenth-century revival of interest in the book as a bibliophilic and aesthetic object.", 64 "confidence": "MEDIUM", 65 }, 66 67 # === Scholarly Milestones === 68 { 69 "year": 1899, "event_type": "OTHER", "category": "scholarship", 70 "title": "Gnoli, Il Sogno di Polifilo", 71 "description": "Domenico Gnoli published one of the earliest modern scholarly studies of the HP, helping to inaugurate the twentieth-century revival of HP scholarship.", 72 "confidence": "HIGH", 73 }, 74 { 75 "year": 1910, "event_type": "OTHER", "category": "scholarship", 76 "title": "Huelsen, Le illustrazioni della Hypnerotomachia Poliphili", 77 "description": "Christian Huelsen published the first systematic study of the HP's woodcut illustrations, identifying their classical architectural sources and establishing the foundation for all subsequent architectural analysis.", 78 "confidence": "HIGH", 79 }, 80 { 81 "year": 1935, "event_type": "OTHER", "category": "scholarship", 82 "title": "Khomentovskaia proposes Feliciano as author", 83 "description": "A. Khomentovskaia proposed Felice Feliciano as the HP's author, adding another candidate to the authorship debate alongside the two Francesco Colonnas.", 84 "confidence": "HIGH", 85 }, 86 { 87 "year": 1937, "event_type": "OTHER", "category": "scholarship", 88 "title": "Blunt, The HP in 17th Century France", 89 "description": "Anthony Blunt documented the HP's influence on seventeenth-century French art, garden design, and festival culture. His article remains the standard reference for French HP reception.", 90 "confidence": "HIGH", 91 }, 92 { 93 "year": 1937, "event_type": "OTHER", "category": "scholarship", 94 "title": "Saxl identifies HP scene in Garofalo painting", 95 "description": "Fritz Saxl identified a scene from the HP in a painting by the Ferrarese artist Garofalo, demonstrating the book's direct influence on Italian Renaissance painting.", 96 "confidence": "HIGH", 97 }, 98 { 99 "year": 1947, "event_type": "OTHER", "category": "scholarship", 100 "title": "Praz, Foreign Imitators of the HP", 101 "description": "Mario Praz documented foreign imitations of the HP across English, French, and German literature, establishing the breadth of the book's European reception from Swinburne to Beardsley.", 102 "confidence": "HIGH", 103 }, 104 { 105 "year": 1950, "event_type": "OTHER", "category": "scholarship", 106 "title": "Fierz-David, Jungian reading of the HP", 107 "description": "Linda Fierz-David published The Dream of Poliphilo, interpreting Poliphilo's journey as a process of Jungian individuation. This established a psychoanalytic strand of HP interpretation distinct from art-historical approaches.", 108 "confidence": "HIGH", 109 }, 110 { 111 "year": 1959, "event_type": "OTHER", "category": "scholarship", 112 "title": "Casella & Pozzi establish canonical authorship", 113 "description": "Maria Teresa Casella and Giovanni Pozzi published Francesco Colonna. Biografia e opere, establishing the Venetian Dominican friar (d. 1527) as the canonical author through philological and archival evidence.", 114 "confidence": "HIGH", 115 }, 116 { 117 "year": 1964, "event_type": "OTHER", "category": "scholarship", 118 "title": "Pozzi & Ciapponi critical edition", 119 "description": "Giovanni Pozzi and Lucia Ciapponi published the standard critical edition of the HP, including textual apparatus, glossary, and commentary that remain the foundation for all textual scholarship.", 120 "confidence": "HIGH", 121 }, 122 { 123 "year": 1972, "event_type": "OTHER", "category": "scholarship", 124 "title": "Gombrich, Hypnerotomachiana", 125 "description": "Ernst Gombrich analyzed the HP's hieroglyphic woodcuts within the context of Renaissance symbolic imagery, demonstrating the book's role in the emblem tradition and the transmission of pseudo-Egyptian visual culture.", 126 "confidence": "HIGH", 127 }, 128 { 129 "year": 1994, "event_type": "OTHER", "category": "scholarship", 130 "title": "Stichel, first study of Modena marginalia", 131 "description": "Dorothea Stichel published the first study of the Modena copy's marginalia, helping to establish the field of HP annotation studies that Russell would later expand.", 132 "confidence": "HIGH", 133 }, 134 { 135 "year": 1996, "event_type": "OTHER", "category": "scholarship", 136 "title": "Calvesi, Roman Colonna attribution", 137 "description": "Maurizio Calvesi argued in La pugna d'amore in sogno that the HP was written by a Roman nobleman named Francesco Colonna, not the Venetian Dominican. This represents the most sustained challenge to the Casella-Pozzi consensus.", 138 "confidence": "HIGH", 139 }, 140 { 141 "year": 1997, "event_type": "OTHER", "category": "scholarship", 142 "title": "Lefaivre, Alberti attribution", 143 "description": "Liane Lefaivre proposed Leon Battista Alberti as the HP's true author, introducing the concept of the 'architectural body' and shifting HP scholarship toward phenomenological and architectural analysis.", 144 "confidence": "HIGH", 145 }, 146 { 147 "year": 1998, "event_type": "OTHER", "category": "scholarship", 148 "title": "Word & Image special issue on the HP", 149 "description": "The journal Word & Image published a special issue on the HP featuring studies by Hunt, Segre, Griggs, Curran, and others. This issue consolidated the late-1990s revival of HP scholarship across multiple disciplines.", 150 "confidence": "HIGH", 151 }, 152 { 153 "year": 1999, "event_type": "EDITION", "category": "edition", 154 "title": "Godwin English translation (Thames & Hudson)", 155 "description": "Joscelyn Godwin published the first complete modern English translation of the HP with Thames & Hudson, providing the most accessible English-language scholarly apparatus.", 156 "confidence": "HIGH", 157 }, 158 { 159 "year": 2002, "event_type": "OTHER", "category": "scholarship", 160 "title": "Trippe, HP as vernacular poetics", 161 "description": "Rosemary Trippe argued in Renaissance Quarterly that the HP has been understudied as literature, demonstrating how the author adapted Petrarchan conventions into a text-image interplay.", 162 "confidence": "HIGH", 163 }, 164 { 165 "year": 2004, "event_type": "EDITION", "category": "edition", 166 "title": "Ariani & Gabriele Adelphi critical edition", 167 "description": "Marco Ariani and Mino Gabriele published a new Italian critical edition through Adelphi, providing the most recent scholarly apparatus complementing the Pozzi-Ciapponi edition.", 168 "confidence": "HIGH", 169 }, 170 { 171 "year": 2006, "event_type": "OTHER", "category": "scholarship", 172 "title": "Semler, Dallington's Protestant HP", 173 "description": "L. E. Semler reframed Robert Dallington's 1592 English translation as deliberate cultural appropriation for Protestant antiquarian interests, not a failed translation.", 174 "confidence": "HIGH", 175 }, 176 { 177 "year": 2014, "event_type": "OTHER", "category": "scholarship", 178 "title": "Russell PhD thesis on HP annotators", 179 "description": "James Russell submitted his Durham PhD thesis documenting marginalia in six HP copies, identifying eleven annotator hands and establishing the concept of the HP as a 'humanistic activity book.' This thesis is the primary evidence base for this project.", 180 "confidence": "HIGH", 181 }, 182 { 183 "year": 2015, "event_type": "OTHER", "category": "scholarship", 184 "title": "Second Word & Image special issue", 185 "description": "A second Word & Image special issue on the HP appeared, including Farrington on Aldus's career and new contributions to reception studies.", 186 "confidence": "HIGH", 187 }, 188 { 189 "year": 2024, "event_type": "EDITION", "category": "edition", 190 "title": "Young, new English translation", 191 "description": "Paul Summers Young published a new English translation of the HP, supplementing Godwin's 1999 version with a contemporary rendering of the macaronic language.", 192 "confidence": "HIGH", 193 }, 194 195 # === Garden Design Influence === 196 { 197 "year": 1550, "event_type": "OTHER", "category": "art", 198 "title": "HP influence on Italian Renaissance gardens", 199 "description": "The sleeping nymph fountain and other HP motifs began appearing in Italian villa gardens by mid-sixteenth century. The HP's detailed garden descriptions provided a sourcebook for designers combining classical forms with living landscapes.", 200 "medium": "garden design", "confidence": "MEDIUM", 201 }, 202 { 203 "year": 1552, "event_type": "OTHER", "category": "art", 204 "title": "Sacro Bosco at Bomarzo begun", 205 "description": "Pier Francesco Orsini began the Sacro Bosco (Sacred Grove) at Bomarzo, a garden of monstrous sculptures that Fabiani Giannetto (2015) connects to the HP's cultivation of meraviglia (wonder).", 206 "medium": "garden/sculpture", "location": "Bomarzo, Italy", 207 "confidence": "MEDIUM", 208 }, 209] 210 211 212def main(): 213 conn = sqlite3.connect(DB_PATH) 214 cur = conn.cursor() 215 216 print("Seeding timeline events (v2)...") 217 inserted = 0 218 for e in EVENTS: 219 # Check for existing event with same year+title 220 cur.execute("SELECT id FROM timeline_events WHERE year = ? AND title = ?", 221 (e["year"], e["title"])) 222 if cur.fetchone(): 223 continue 224 225 cur.execute(""" 226 INSERT INTO timeline_events 227 (year, event_type, title, description, category, medium, 228 location, confidence, needs_review, source_method) 229 VALUES (?, ?, ?, ?, ?, ?, ?, ?, 1, 'LLM_ASSISTED') 230 """, (e["year"], e["event_type"], e["title"], e.get("description", ""), 231 e.get("category", ""), e.get("medium", ""), 232 e.get("location", ""), e.get("confidence", "MEDIUM"))) 233 inserted += cur.rowcount 234 235 conn.commit() 236 237 cur.execute("SELECT COUNT(*) FROM timeline_events") 238 total = cur.fetchone()[0] 239 cur.execute("SELECT event_type, COUNT(*) FROM timeline_events GROUP BY event_type ORDER BY COUNT(*) DESC") 240 print(f"\nTotal events: {total}") 241 for row in cur.fetchall(): 242 print(f" {row[0]}: {row[1]}") 243 244 conn.close() 245 print(f"\nInserted {inserted} new events. Done.") 246 247 248if __name__ == "__main__": 249 main()