Skip to content
Prev 24339 / 398502 Next

Database newbee problem...

Danardono wrote:
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
Message-ID: <20021017094048.C10454@jessie.research.bell-labs.com>
In-Reply-To: <3DAE35D4.1000105@student.umu.se>; from daodao99@student.umu.se on Thu, Oct 17, 2002 at 01:00:20PM +0900