Add Alchemist Descriptions
Inserts 13 folio-specific scholarly descriptions for the two alchemist annotators from Russell Ch. 6-7.
1"""Add scholarly descriptions to alchemist-annotated folios. 2 3Sources: Russell 2014, Ch. 6 (BL Hand B / d'Espagnet) and Ch. 7 (Buffalo Hand E / pseudo-Geber). 4These descriptions are derived from close reading of Russell's thesis and are tagged 5with source_method='LLM_ASSISTED' since the extraction and synthesis was done by Claude 6reading Russell's prose, not by Russell himself writing these summaries. 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# Schema addition 16SCHEMA = """ 17CREATE TABLE IF NOT EXISTS folio_descriptions ( 18 id INTEGER PRIMARY KEY, 19 signature_ref TEXT NOT NULL, 20 manuscript_shelfmark TEXT, 21 hand_label TEXT, 22 title TEXT NOT NULL, 23 description TEXT NOT NULL, 24 alchemical_element TEXT, 25 alchemical_process TEXT, 26 alchemical_framework TEXT, 27 russell_page_ref TEXT, 28 source_method TEXT DEFAULT 'LLM_ASSISTED', 29 needs_review BOOLEAN DEFAULT 1, 30 UNIQUE(signature_ref, manuscript_shelfmark, hand_label) 31); 32""" 33 34# BL C.60.o.12 - Hand B (d'Espagnet school) 35BL_DESCRIPTIONS = [ 36 { 37 "sig": "flyleaf", 38 "hand": "B", 39 "ms": "C.60.o.12", 40 "title": "The Alchemist's Manifesto: 'Master Mercury'", 41 "description": ( 42 "On the flyleaf verso, the anonymous alchemist lays out his entire interpretive " 43 "framework in a programmatic summary: 'verus sensus intentionis huius libri est " 44 "3um: Geni et Totius Naturae energiae & operationum Magisteri Mercurii Descriptio " 45 "elegans, ampla' -- the HP's true sense is threefold: the full and elegant " 46 "description of the generation of all nature, its energies, and the operations of " 47 "'Master Mercury.' This Rosetta Stone for all subsequent annotations identifies " 48 "quicksilver as the supreme operative principle, reflecting Jean d'Espagnet's " 49 "Enchiridion Physicae Restitutae, where mercury is the vehicle of the world spirit " 50 "continuously emanating from the Sun." 51 ), 52 "element": "Mercury (Master Mercury / Magisteri Mercurii)", 53 "process": "Universal generation and spirit-matter mediation", 54 "framework": "d'Espagnet: mercury as vehicle of spiritus mundi", 55 "page": "pp. 159-160", 56 }, 57 { 58 "sig": "a1r", 59 "hand": "B", 60 "ms": "C.60.o.12", 61 "title": "Dawn as Albedo: The Sun's First Emanation", 62 "description": ( 63 "At the opening of Poliphilo's narrative, Hand B annotates the dawn scene " 64 "with careful precision: 'Tempus ergo matutinum erat, sine diluculo, uel " 65 "crepusculum' (It was the early morning, before dawn, or later in the evening). " 66 "This is not mere translation. The annotator identifies the exact solar position -- " 67 "the moment before the sun crests the horizon -- because in d'Espagnet's framework, " 68 "the sun is the origin of the world spirit whose emanations are most potent at dawn. " 69 "The passage heading is labeled 'AURORAE DESCRIPTIO' (Description of the Dawn). " 70 "Hand B also notes the etymology of Leucothea: 'Leucos albus, candidus' -- white, " 71 "bright -- connecting the dawn goddess to the alchemical stage of Albedo (whitening)." 72 ), 73 "element": "Sol (Sun) and Albedo (whitening stage)", 74 "process": "Solar emanation at dawn; beginning of the Work", 75 "framework": "d'Espagnet: sun as source of world spirit", 76 "page": "pp. 165-166", 77 }, 78 { 79 "sig": "a3r", 80 "hand": "B", 81 "ms": "C.60.o.12", 82 "title": "The HP as Alchemical Treatise", 83 "description": ( 84 "Hand B recognized that the HP's own dedicatory letter mirrors the conventions " 85 "of alchemical texts. The letter claims the book is written so that 'none but the " 86 "most learned should be able to penetrate the inner sanctum of his teaching' -- " 87 "language directly paralleling the alchemical tradition of deliberate obscurantism, " 88 "where knowledge is veiled 'so that it might not come to the attention of the " 89 "greedy and the insane.' For a reader steeped in the prisca sapientia (ancient " 90 "wisdom), the HP's extreme linguistic difficulty was not a flaw but a guarantee " 91 "of hidden knowledge. The more incomprehensible the text, the more ancient wisdom " 92 "it was understood to contain." 93 ), 94 "element": "Prisca sapientia (ancient wisdom)", 95 "process": "Horizon of expectation; alchemical hermeneutics", 96 "framework": "d'Espagnet: obscurantism as marker of authenticity", 97 "page": "pp. 155-156", 98 }, 99 { 100 "sig": "a4r", 101 "hand": "B", 102 "ms": "C.60.o.12", 103 "title": "Jupiter's Titles: Planetary Hierarchy", 104 "description": ( 105 "Hand B extracts Poliphilo's invocation to Jupiter, transcribing the god's " 106 "divine titles into a hierarchical list on the flyleaf: 'O Diespiter, Maximo, " 107 "Optimo, & Omnipotente & Opitulo...' Jupiter rules the higher, middle, and " 108 "lower realms. In alchemical metals, Jupiter corresponds to tin. The annotator's " 109 "interest in Jupiter's cosmic hierarchy maps onto the Hermetic principle 'as above, " 110 "so below' -- the resonance between celestial order and material transformation " 111 "that underpins all alchemical practice." 112 ), 113 "element": "Jupiter / Tin", 114 "process": "Planetary-metal correspondence; cosmic hierarchy", 115 "framework": "d'Espagnet: Hermetic resonance between realms", 116 "page": "p. 167", 117 }, 118 { 119 "sig": "b6v", 120 "hand": "B", 121 "ms": "C.60.o.12", 122 "title": "Elephant and Obelisk: Ideograms in Syntax", 123 "description": ( 124 "The famous woodcut of the elephant bearing an obelisk -- later realized by " 125 "Bernini in the Piazza della Minerva for Pope Alexander VII -- is densely annotated " 126 "by Hand B with alchemical ideograms embedded directly in the syntax of Latin " 127 "sentences. The sun symbol with the suffix '-ra' reads 'scintillata aurata' " 128 "(shimmering gold). These are not marginal glosses but a complete symbolic language: " 129 "compact symbols for gold, silver, mercury, Venus, and Jupiter carry Latin case " 130 "endings, allowing them to function as nouns and adjectives within grammatical " 131 "sentences. Russell notes the consistency with Newton's Keynes MSS vocabulary, " 132 "suggesting a possible connection to the Royal Society or Cambridge alchemical circle." 133 ), 134 "element": "Multiple metals: Gold, Silver, Mercury, Venus, Jupiter", 135 "process": "Ideographic decipherment of the printed text", 136 "framework": "d'Espagnet: standardized ideographic vocabulary", 137 "page": "pp. 156-158", 138 }, 139 { 140 "sig": "d8v", 141 "hand": "B", 142 "ms": "C.60.o.12", 143 "title": "Panta Tokadi: Mercury as Universal Vessel", 144 "description": ( 145 "Facing the Panta Tokadi woodcut, Hand B translates the phrase as 'rerum omnium " 146 "vas' -- vessel of all things -- rather than 'mother of all,' as Godwin translates " 147 "it. This deliberate shift from biological generation to instrumental containment " 148 "equates the Panta Tokadi figure directly with Mercury: not a passive mother but " 149 "an active vessel through which the world spirit is channeled into matter. " 150 "The annotation reflects d'Espagnet's concept of the 'magnetick principle' -- " 151 "the force by which mercury draws the animating spirit of the sun into the " 152 "vessels of physical matter." 153 ), 154 "element": "Mercury as universal vessel (vas)", 155 "process": "Spirit-matter mediation via mercury", 156 "framework": "d'Espagnet: magnetick principle; mercury as conduit", 157 "page": "pp. 164-165", 158 }, 159 { 160 "sig": "e1r", 161 "hand": "B", 162 "ms": "C.60.o.12", 163 "title": "Panta Tokadi: Cinnabar, Digestion, and the World Spirit", 164 "description": ( 165 "The Panto Tokadi woodcut -- a satyr revealing a mother figure flanked by two fauns " 166 "bearing vessels -- receives Hand B's most elaborate alchemical annotation. The mercury " 167 "symbol appears on the top frieze and above the right faun's vessel. The left faun " 168 "bears the cinnabar symbol (mercury sulphide). Below the caption, B writes: 'duae " 169 "columbae in uno vase bibentes sunt minium & digestione' -- the two doves drinking " 170 "in one vase represent cinnabar and digestion. The streams of milk from the mother's " 171 "nipples signify the generation of all things through mercury's magnetick principle. " 172 "This is the key annotation revealing Hand B's d'Espagnet-based schema at full power." 173 ), 174 "element": "Mercury, Cinnabar (mercury sulphide), Digestion", 175 "process": "Emanation of world spirit; generation through mercury", 176 "framework": "d'Espagnet: sun's outpouring of animating energy via mercury", 177 "page": "pp. 163-165", 178 }, 179 { 180 "sig": "E8v", 181 "hand": "B", 182 "ms": "C.60.o.12", 183 "title": "Venus Persists: The Alchemist's Stamina", 184 "description": ( 185 "Deep into Book II -- where most annotators' energy has long since flagged -- " 186 "Hand B is still at work, replacing the goddess Venus's name with her alchemical " 187 "symbol: the text reads 'Veneris' but the annotation substitutes the Venus/copper " 188 "ideogram with the Latin case ending '-eris' appended. Russell observes that this " 189 "demonstrates the alchemist's remarkable persistence: 'notes decline in frequency " 190 "and alchemical significance in Book II' but the symbolic vocabulary is maintained " 191 "to the end. Venus (copper) is the feminine planetary metal in the d'Espagnet system." 192 ), 193 "element": "Venus / Copper (feminine planetary metal)", 194 "process": "Persistent symbolic substitution through Book II", 195 "framework": "d'Espagnet: planetary-metal associations maintained throughout", 196 "page": "p. 157", 197 }, 198 { 199 "sig": "y7r", 200 "hand": "B", 201 "ms": "C.60.o.12", 202 "title": "Fons Heptagonis: The Seven Metals", 203 "description": ( 204 "The illustration of the heptagonal fountain -- seven-sided, with seven angles -- " 205 "is labeled by Hand B with the alchemical sign of a different element at each angle. " 206 "The seven metals correspond to the seven classical planets: gold/Sun, silver/Moon, " 207 "mercury/Mercury, copper/Venus, iron/Mars, tin/Jupiter, lead/Saturn. This systematic " 208 "labeling transforms the decorative fountain into a diagram of the complete " 209 "alchemical cosmos, with each planetary metal occupying its proper position. " 210 "The annotator labels the fountain 'frogg green' (in English, confirming his " 211 "nationality), apparently describing the color of the ink or the patina." 212 ), 213 "element": "All seven planetary metals", 214 "process": "Complete cosmological mapping of the alchemical system", 215 "framework": "d'Espagnet: planetary-metal correspondence system", 216 "page": "p. 136", 217 }, 218] 219 220# Buffalo - Hand E (pseudo-Geber school) 221BUFFALO_DESCRIPTIONS = [ 222 { 223 "sig": "b7r", 224 "hand": "E", 225 "ms": "Buffalo RBR", 226 "title": "Geber's Ingenium: Opening the Alchemical Reading", 227 "description": ( 228 "At the episode of the elephant and obelisk, with its statues of a crowned king " 229 "and queen, Hand E establishes the interpretive framework for everything that " 230 "follows. Under the motto 'Gonos et Euphyia' (Labor and Industry), the annotator " 231 "praises Geber's 'ingenium subtile' (subtle ingenuity) -- declaring that the HP " 232 "will be read within a Geberian framework. Labor and industry are the essential " 233 "virtues of the alchemist, whose work might involve distilling the same substance " 234 "hundreds of times. The king and queen statues 'easily commend themselves to " 235 "reading along the lines of Geber,' where the masculine principle (Sol/Gold) and " 236 "the feminine principle (Luna/Silver) are interconnected inverses." 237 ), 238 "element": "Sol/Luna (Gold/Silver) as gendered principles", 239 "process": "Initiation of Geberian reading; framework declaration", 240 "framework": "pseudo-Geber: Summa Perfectionis methodology", 241 "page": "pp. 187-188", 242 }, 243 { 244 "sig": "c6v", 245 "hand": "E", 246 "ms": "Buffalo RBR", 247 "title": "Bacchus and Demeter: The Chemical Wedding Encoded", 248 "description": ( 249 "Poliphilo views a Greek epigram: 'to the blessed Mother, the Goddess Venus, " 250 "and to her Son, Amor, Bacchus and Demeter have given of their own substances.' " 251 "Hand E cuts directly to the alchemical meaning: 'Bacchus et Ceres [Demeter] " 252 "id est sol et luna' -- Bacchus and Demeter ARE Sol and Luna. Hand D elaborates " 253 "that 'Bacchus was believed by the ancients to be that hidden virtue which helps " 254 "plants to produce mature fruits.' But for the alchemist, the mythological pairing " 255 "encodes the chemical wedding -- the union of masculine (Sol/gold) and feminine " 256 "(Luna/silver) principles that produces the philosopher's stone." 257 ), 258 "element": "Sol/Luna identified as Bacchus/Demeter", 259 "process": "Chemical wedding; union of masculine and feminine metals", 260 "framework": "pseudo-Geber: mythological coding of the Great Work", 261 "page": "pp. 187-188", 262 }, 263 { 264 "sig": "h1r", 265 "hand": "E", 266 "ms": "Buffalo RBR", 267 "title": "The Chess Match: Three Rounds of Distillation", 268 "description": ( 269 "The HP's elaborate chess match between 32 maidens (16 silver, 16 gold) becomes, " 270 "in Hand E's reading, an allegory of iterative alchemical refinement. In Round 1, " 271 "silver wins: the annotator writes 'Argentum' with a crescent moon sketch and " 272 "'Rex ex argento factus victor remanet' (The king made of silver remains victor). " 273 "Round 2: silver wins again. Round 3: gold finally triumphs -- but E's annotation " 274 "undergoes a telling correction. He first writes 'Rex ex auro' (king of gold), " 275 "then revises to 'Regina' (queen) and 'aura' and 'victrix' (feminine victor), " 276 "with the sun symbol. The final word is 'Auru(m)' -- Gold, the perfected metal. " 277 "The correction reveals E recognizing the hermaphroditic outcome: the triumphant " 278 "figure combines king and queen, masculine and feminine, Sol and Luna." 279 ), 280 "element": "Silver (Luna) yielding to Gold (Sol); Hermaphrodite", 281 "process": "Iterative distillation (three rounds); coincidentia oppositorum", 282 "framework": "pseudo-Geber: transmutation through repeated refinement", 283 "page": "pp. 189-190", 284 }, 285 { 286 "sig": "b5r", 287 "hand": "E", 288 "ms": "Buffalo RBR", 289 "title": "The Ambiguous Gods: Alchemical Hermaphrodites", 290 "description": ( 291 "An epigram reading 'D.AMBIG.DD' -- 'dedicated to the ambiguous gods' -- " 292 "triggers Hand E's most explicit statement of Geberian theory. The annotation " 293 "reads: 'diis ambiguis id est metallis hermafroditis guarda enim metalla sunt " 294 "mas et foemina... aura-argentu enim in sua altitudine mas est in sua profunda " 295 "foeminina argentum vero in sua altitudine est foemininum in suo profundo mas.' " 296 "The 'ambiguous gods' are metals that possess both genders: gold is masculine " 297 "'in its height' but feminine 'in its depth'; silver is feminine in its height " 298 "but masculine in its depth. This paradoxical gender-inversion is the fundamental " 299 "principle of pseudo-Geber's system -- the engine that makes transmutation possible." 300 ), 301 "element": "Hermaphroditic metals (Gold-Silver gender inversion)", 302 "process": "Coincidentia oppositorum; gender-inversion as transmutation principle", 303 "framework": "pseudo-Geber: metals as masculine-feminine inverses", 304 "page": "p. 190", 305 }, 306] 307 308 309def main(): 310 conn = sqlite3.connect(DB_PATH) 311 cur = conn.cursor() 312 313 print("Creating folio_descriptions table...") 314 cur.executescript(SCHEMA) 315 conn.commit() 316 317 print("Inserting BL alchemist descriptions (Hand B, d'Espagnet)...") 318 bl_count = 0 319 for d in BL_DESCRIPTIONS: 320 cur.execute(""" 321 INSERT OR REPLACE INTO folio_descriptions 322 (signature_ref, manuscript_shelfmark, hand_label, title, 323 description, alchemical_element, alchemical_process, 324 alchemical_framework, russell_page_ref, source_method, needs_review) 325 VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 'LLM_ASSISTED', 1) 326 """, (d["sig"], d["ms"], d["hand"], d["title"], d["description"], 327 d["element"], d["process"], d["framework"], d["page"])) 328 bl_count += 1 329 conn.commit() 330 print(f" {bl_count} BL descriptions inserted") 331 332 print("Inserting Buffalo alchemist descriptions (Hand E, pseudo-Geber)...") 333 buf_count = 0 334 for d in BUFFALO_DESCRIPTIONS: 335 cur.execute(""" 336 INSERT OR REPLACE INTO folio_descriptions 337 (signature_ref, manuscript_shelfmark, hand_label, title, 338 description, alchemical_element, alchemical_process, 339 alchemical_framework, russell_page_ref, source_method, needs_review) 340 VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 'LLM_ASSISTED', 1) 341 """, (d["sig"], d["ms"], d["hand"], d["title"], d["description"], 342 d["element"], d["process"], d["framework"], d["page"])) 343 buf_count += 1 344 conn.commit() 345 print(f" {buf_count} Buffalo descriptions inserted") 346 347 print(f"\nTotal: {bl_count + buf_count} alchemist folio descriptions") 348 conn.close() 349 350 351if __name__ == "__main__": 352 main()