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.
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:
This code seems to work on MacOS however I have not been able to get this running on Windows.