JuliaHealth / JuliaHealth/BioMedQuery.jl

ERROR: LoadError: (2): File not found

Open
#72 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Julia
Stars
19
Forks
9
PR merge metrics
No merged PRs in 30d

Description

Hey I am trying to run the following the save.efetch function in Julia v1.4.0. On Windows 10.

When I attempt to run this code:
BioMedQuery.PubMed.save_efetch!(conn, efetch_doc, true, true)

I get the following error:

Saving 15 articles to database
┌ Warning: getindex(df::DataFrame, col_ind::ColumnIndex) is deprecated, use df[!, col_ind] instead.
│ caller = select_columns(::MySQL.Connection, ::String) at mysql_db_utils.jl:62
└ @ BioMedQuery.DBUtils C:\Users\antho.julia\packages\BioMedQuery\K4kwC\src\DBUtils\mysql_db_utils.jl:62
ERROR: LoadError: (2): File 'C:UsersanthoDocumentsMachine_LearningWork2020-04-17_PubMed_basic.csv' not found (Errcode: 2)
Stacktrace:
[1] execute!(::MySQL.Connection, ::String) at C:\Users\antho.julia\packages\MySQL\R2gKS\src\MySQL.jl:84
[2] db_insert!(::MySQL.Connection, ::Dict{String,DataFrame}, ::String, ::String; verbose::Bool, drop_csv::Bool) at C:\Users\antho.julia\packages\BioMedQuery\K4kwC\src\PubMed\pubmed_sql_utils.jl:482
[3] save_efetch!(::MySQL.Connection, ::XMLElement, ::Bool, ::Bool) at C:\Users\antho.julia\packages\BioMedQuery\K4kwC\src\PubMed\eutils_sql_save.jl:25
[4] create_mysql_pubmed_db(::String, ::String, ::XMLElement) at C:\Users\antho\Documents\Machine_Learning\Work\collect_data.jl:132
[5] main() at C:\Users\antho\Documents\Machine_Learning\Work\collect_data.jl:604
[6] top-level scope at C:\Users\antho\Documents\Machine_Learning\Work\collect_data.jl:627
[7] include(::Module, ::String) at .\Base.jl:377
[8] exec_options(::Base.JLOptions) at .\client.jl:288
[9] _start() at .\client.jl:484
in expression starting at C:\Users\antho\Documents\Machine_Learning\Work\collect_data.jl:627

This code seems to work on MacOS however I have not been able to get this running on Windows.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with src/PubMed/pubmed_sql_utils.jl:482, called by src/PubMed/eutils_sql_save.jl:25, and inspect how the CSV path is passed to MySQL on Windows. Reproduce the save_efetch! call with the shown Windows setup and compare the generated path with the existing macOS behavior. Done means the 15 articles can be saved on Windows without the file-not-found error.

Written by the indexing model from the issue text.

Assessment

Tech stack
julia, mysql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.