Closed dovinmu closed 2 months ago
to transfer the embeddings table to the new table:
sqlite3 aphis_reports_embeddings.db ".dump _embeddings_citations" > dump.sql
sqlite3 aphis_reports.db < dump.sql
sqlite-utils rename-table aphis_reports.db _embeddings_citations _embeddings_citation_inspection
sqlite-utils transform aphis_reports.db citation_inspection --pk rowid
csvsqlcitations
citations
is same as forinspections_citations
csvsql into database, referring to prejoined table