From e2723a411ef3a56eff208e50022766a22042cc6b Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Fri, 6 Jan 2017 12:48:01 -0800 Subject: [PATCH] add missing select papers by pmid rule --- bibtex_to_paper | 3 +++ 1 file changed, 3 insertions(+) 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 ?; -- 2.39.2