i seem doing wrong when trying use setdefaults. if enter each argument every time use getsymbols.mysql, seems work fine error when doing following:
> setdefaults(getsymbols.mysql, user = 'root', password = '********', dbname = 'psedata', db.fields = c("date", "open", "high", "low", "close", "volume", "adj"), field.names = c("date", "open", "high", "low", "close", "volume", "adj"), env = .globalenv) > getsymbols('ali', src = 'mysql') error in .local(conn, statement, ...) : not run statement: function psedata.c not exist however, following works:
> getsymbols.mysql('ali', user = 'root', password = '********', dbname = 'psedata', db.fields = c("date", "open", "high", "low", "close", "volume", "adj"), field.names = c("date", "open", "high", "low", "close", "volume", "adj"), env = .globalenv) [1] "ali" i feel i'm missing obvious can't find it.
this looks bug (either in setdefaults or importdefaults), , following code seems produce query work. note untested, because don't have mysql database available.
setdefaults(getsymbols.mysql, user = 'root', password = '********', dbname = 'psedata', db.fields = quote(c("date", "open", "high", "low", "close", "volume", "adj")), field.names = quote(c("date", "open", "high", "low", "close", "volume", "adj")), env = .globalenv)
Comments
Post a Comment