add missing select papers by pmid rule

diff --git a/bibtex_to_paper b/bibtex_to_paper
index 77cbffaba17091b288982783821d4567f6935bed..a6350eb98caedfecffcac5d9b248c5ac41760660 100755 (executable)
--- a/bibtex_to_paper
+++ b/bibtex_to_paper
@@ -477,6 +477,9 @@ INSERT OR REPLACE INTO bibtex (bibtex_key,file_name,pmid,doi,html) VALUES (?,?,?
 EOF
          select_papers_by_name => <<'EOF',
 SELECT * FROM papers WHERE file_name = ?;
+EOF
+         select_papers_by_pmid => <<'EOF',
+SELECT * FROM papers JOIN bibtex ON papers.file_name = bibtex.file_name WHERE bibtex.pmid = ?;
 EOF
          select_papers_by_name_like => <<'EOF',
 SELECT * FROM papers WHERE file_name LIKE ?;