r - Unable to use setDefaults on quantmod -


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