How sathishcb/sk-harvard-artifacts-collection works
The product is a Streamlit workflow for collecting Harvard Art Museums records, previewing and inserting normalized artifact data, then exploring it with 25 SQL analyses. The graph separates collection, persistence, and analytics. The sampled app and helper modules show the principal calls; the README documents the broader workflow and schema. The schema file itself was not excerpted, so its relationship is based on the documented table design and the sampled schema-loading code.
Main entry points: app.py Streamlit app · api.py Async API collector · database.py Schema loader · schema.sql Artifact tables
Components 15
Streamlit Experience
- Streamlit app
app.py - Data preview
app.py - Query interface
app.py - Query results
app.py
Artifact Collection
- Credentials config
config.py - Async API collector
api.py
SQL Persistence
- Database setup
database.py - Schema loader
database.py - Artifact schema
schema.sql - Duplicate-safe insert
database.py - Artifact tables
schema.sql
SQL Analytics
- SQL query catalog
queries.py - Query execution
app.py
Other components
- User
- Harvard API
Connections 17
- User → Streamlit app: uses
README.md - Streamlit app → Credentials config: reads credentials
app.py - Streamlit app → Database setup: initializes database
app.py - Streamlit app → Schema loader: loads schema
app.py - Schema loader → Artifact schema: reads
database.py - Schema loader → Artifact tables: creates tables
database.py - Streamlit app → Async API collector: requests collection
app.py - Async API collector → Harvard API: fetches records
api.py - Async API collector → Data preview: returns normalized data
app.py - Streamlit app → Data preview: shows sample data
app.py - Streamlit app → Duplicate-safe insert: invokes migration
app.py - Duplicate-safe insert → Artifact tables: inserts records
database.py - Streamlit app → SQL query catalog: selects SQL
app.py - Streamlit app → Query execution: runs query
app.py - Query execution → Artifact tables: reads tables
- Query execution → Query results: displays rows
app.py - User → Query interface: chooses query
README.md