| fetch {rocker} | R Documentation |
Fetch SQL query result from database.
Description
Fetch SQL query result from database.
Usage
fetch(db, n = -1, ...)
Arguments
db |
rocker object |
n |
Number of record to be fetched |
... |
Optional, additional suitable parameters passed to |
Value
Records
See Also
Other rocker-S3-functions:
appendTable(),
begin(),
canConnect(),
clearResult(),
columnInfo(),
commit(),
connect(),
createTable(),
disconnect(),
execute(),
existsTable(),
getInfoCon(),
getInfoDrv(),
getInfoRes(),
getQuery(),
getRowCount(),
getRowsAffected(),
getStatement(),
hasCompleted(),
isValidCon(),
isValidDrv(),
isValidRes(),
listFields(),
listObjects(),
listTables(),
readTable(),
removeTable(),
rocker-README,
rocker-S3-functions,
rocker-package,
rollback(),
sendQuery(),
sendStatement(),
setupDriver(),
setupMariaDB(),
setupPostgreSQL(),
setupSQLite(),
unloadDriver(),
validateCon(),
writeTable()
Examples
db <- rocker::newDB()
rocker::setupSQLite(db)
rocker::connect(db)
rocker::writeTable(db, "mtcars", mtcars)
rocker::sendQuery(db, "SELECT * FROM mtcars;")
output <- rocker::fetch(db)
rocker::clearResult(db)
rocker::disconnect(db)
rocker::unloadDriver(db)