[R] Database newbee problem...

David James dj at research.bell-labs.com
Thu Oct 17 15:40:48 CEST 2002


Danardono wrote:
> Just curious, does the function dbDriver exist in RMySQL?
> I usually use dbManager.
> 
> >>m <- dbDriver("MySQL")
> >>con <- dbConnect(m,group="testdb")
> >>    
> >>
> /Danar.
> 
> 
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

There has been a change in function names in the new RMySQL 0.5-0
version (also in the new ROracle and RSQLite).  The reason is that
the R-SIG-DB has agreed on a common interface to all databases,
and as part of this new common interface, most functions have been
renamed.  The following simple name mapping may help you upgrade
existing code to the new DBI:

pre-DBI                  DBI 0.1-4 
----------------------   ----------------------------------
dbManager                dbDriver
dbConnect                dbConnect
dbExecStatement          dbSendQuery
dbExec                   dbSendQuery
quickSQL                 dbGetQuery
fetch                    fetch
getTables                dbListTables
getConnections           dbListConnections
getResultSets            dbListResults
getConnection            dbGetConnection
getFields                dbColumnInfo         # for a result set 
getFields                dbListFields         # for a table name in a conn
getStatement             dbGetStatement
getRowsAffected          dbGetRowsAffected
getRowCount              dbGetRowCount
hasCompleted             dbHasCompleted
getInfo                  dbGetInfo
describe                 summary
getTableFields           dbListFields
getTable                 dbReadTable
assignTable              dbWriteTable
existsTable              dbExistsTable
SQLDataType              dbDataType
make.SQL.name            make.db.name
isSQLKeyword             isSQLKeyword
removeTable              dbRemoveTable
getException             dbGetException
load                     dbDriver
unload                   dbUnloadDriver
commit                   dbCommit
rollback                 dbRollback
callProc                 dbCallProc
close                    dbDisconnect
close                    dbClearResult

getVersion               NA
getCurrentDatabase       NA
getNumRows               NA
getNullOk                NA
getNumCols               NA
getDatabases             NA
getTableIndices          NA

NA                       dbGetDBIVersion

-- 
David A. James
Statistics Research, Room 2C-253            Phone:  (908) 582-3082       
Bell Labs, Lucent Technologies              Fax:    (908) 582-3340
Murray Hill, NJ 09794-0636
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list