From: Don Armstrong <don@donarmstrong.com>
Date: Fri, 6 Jan 2017 20:48:01 +0000 (-0800)
Subject: add missing select papers by pmid rule
X-Git-Url: https://git.donarmstrong.com/?p=bin.git;a=commitdiff_plain;h=e2723a411ef3a56eff208e50022766a22042cc6b

add missing select papers by pmid rule
---

diff --git a/bibtex_to_paper b/bibtex_to_paper
index 77cbffa..a6350eb 100755
--- 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 ?;