JuliaHealth / JuliaHealth/BioMedQuery.jl
ERROR: LoadError: (2): File not found
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, usedf[!, 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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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