RFC: quantmod::getSymbols.MySQL
On 10/29/2014 08:25 AM, Joshua Ulrich wrote:
As many of you know, the Defaults package was removed from CRAN on
2014-10-03 at Jeff's request. This broke a fair bit of functionality
in quantmod, most of which I have addressed in recent commits on
R-Forge.
One issue I have not resolved is how to adapt getSymbols.MySQL to the
new no-Defaults paradigm. I will be taking over as maintainer of
quantmod, so I am soliciting input from getSymbols.MySQL users.
My proposed solution to getSymbols.MySQL is to look for specific
option()s if certain arguments are missing. I think this is the
cleanest and most obvious solution, but am open to alternatives. I
would use the option structure below, with only the three arguments
listed.
options(quantmod.defaults = list(
getSymbols.MySQL = list(
user="josh",
password="secret",
dbname="stocks")
)
)
What I do is something like this, but default to user/password/host equal "" or NULL, in which case I assume the .my.cnf file will be used and make the connection without specifying user/password/host. Paul
Should I consider another option structure? Should additional arguments be supported? Anything else I'm missing? Thanks,