man => 0,
only_print => 0,
search_by_pmid => 0,
+ search_by_file => 0,
use_git => 1,
'bibtex_cache' => File::Spec->catfile(User->Home,'.bibtex_to_paper_cache'),
);
'use_git|use-git!',
'only_print|only-print!',
'search_by_pmid|search-by-pmid!',
+ 'search_by_file|search-by-file!',
'clear_cache|clear-cache!',
'papers_directory|papers-directory=s@',
'debug|d+','help|h|?','man|m');
my $entry;
if ($options->{search_by_pmid}) {
$entry = select_entry_from_pmid($dbh,$sth,$bibtex_key);
+ } elsif ($options->{search_by_file}) {
+ $entry = select_entry_from_file($dbh,$sth,$bibtex_key);
} else {
$entry = select_entry_from_bibtex_key($dbh,$sth,$bibtex_key);
}
return select_one($dbh,$sth->{select_bibtex_by_pmid},$pmid);
}
+sub select_entry_from_file{
+ my ($dbh,$sth,$filename) = @_;
+
+ return select_one($dbh,$sth->{select_bibtex_by_file_name_like},'%'.$filename.'%');
+}
+
sub select_entry_from_bibtex_key{
my ($dbh,$sth,$bibtex_key) = @_;
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 ?;
EOF
select_papers_by_path => <<'EOF',
EOF
select_bibtex_by_file_name => <<'EOF',
SELECT * FROM bibtex WHERE file_name = ?;
+EOF
+ select_bibtex_by_file_name_like => <<'EOF',
+SELECT * FROM bibtex WHERE file_name LIKE ?;
EOF
select_bibtex_by_pmid => <<'EOF',
SELECT * FROM bibtex WHERE pmid = ?;