{
  "_id": "6a17f7f1acfb0bcc41da932e",
  "Package": "rocker",
  "Title": "Database Interface Class",
  "Version": "0.3.2",
  "Authors@R": "person(given = \"Nikolaus\", family = \"Pawlowski\", role = c(\"aut\", \"cre\", \"cph\"), email = \"niko@fr33.net\")",
  "Description": "'R6' class interface for handling relational database\nconnections using 'DBI' package as backend. The class allows\nhandling of connections to e.g. PostgreSQL, MariaDB and SQLite.\nThe purpose is having an intuitive object allowing\nstraightforward handling of SQL databases.",
  "License": "MIT + file LICENSE",
  "URL": "https://github.com/nikolaus77/rocker",
  "BugReports": "https://github.com/nikolaus77/rocker/issues",
  "Encoding": "UTF-8",
  "RoxygenNote": "7.3.2",
  "VignetteBuilder": "knitr",
  "Config/testthat/edition": "3",
  "Config/pak/sysreqs": "libsodium-dev",
  "Repository": "https://nikolaus77.r-universe.dev",
  "Date/Publication": "2025-08-30 22:26:10 UTC",
  "RemoteUrl": "https://github.com/nikolaus77/rocker",
  "RemoteRef": "HEAD",
  "RemoteSha": "b72f1c6dbcd127ff10253564aa38d787a2161406",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-28 08:04:52 UTC",
    "User": "root"
  },
  "Author": "Nikolaus Pawlowski [aut, cre, cph]",
  "Maintainer": "Nikolaus Pawlowski <niko@fr33.net>",
  "MD5sum": "9fc7bb01c14d4824d5b409af669fc930",
  "_user": "nikolaus77",
  "_type": "src",
  "_file": "rocker_0.3.2.tar.gz",
  "_fileid": "17cbdbdc856475403affbfae916a7b5a88472185231f3d8135059a26707e0f08",
  "_filesize": 365029,
  "_sha256": "17cbdbdc856475403affbfae916a7b5a88472185231f3d8135059a26707e0f08",
  "_created": "2026-05-28T08:04:52.000Z",
  "_published": "2026-05-28T08:08:17.565Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78249304853,
      "time": 162,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7260805204"
    },
    {
      "job": 78249304777,
      "time": 129,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7260795541"
    },
    {
      "job": 78249304776,
      "time": 164,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7260797990"
    },
    {
      "job": 78249304868,
      "time": 120,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7260786878"
    },
    {
      "job": 78248886870,
      "time": 164,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7260755079"
    },
    {
      "job": 78249304796,
      "time": 105,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7260787603"
    },
    {
      "job": 78249304795,
      "time": 98,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7260785731"
    },
    {
      "job": 78249304837,
      "time": 83,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7260781098"
    },
    {
      "job": 78249304804,
      "time": 81,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7260780420"
    }
  ],
  "_buildurl": "https://github.com/r-universe/nikolaus77/actions/runs/26562527199",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/nikolaus77/rocker",
  "_commit": {
    "id": "b72f1c6dbcd127ff10253564aa38d787a2161406",
    "author": "Nikolaus Pawlowski <niko@fr33.net>",
    "committer": "Nikolaus Pawlowski <niko@fr33.net>",
    "message": "Adjustments in preparation for CRAN submission\n",
    "time": 1756592770
  },
  "_maintainer": {
    "name": "Nikolaus Pawlowski",
    "email": "niko@fr33.net",
    "login": "nikolaus77",
    "description": "",
    "uuid": 83133578
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "R6",
      "role": "Imports"
    },
    {
      "package": "sodium",
      "role": "Imports"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "crayon",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "RMariaDB",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "RPostgres",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    }
  ],
  "_owner": "nikolaus77",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-35",
      "n": 5
    }
  ],
  "_tags": [
    {
      "name": "v0.3.2",
      "date": "2025-08-30"
    }
  ],
  "_topics": [
    "database",
    "dbi",
    "mariadb",
    "mysql",
    "postgres",
    "postgresql",
    "r6",
    "sql",
    "sqlite"
  ],
  "_stars": 5,
  "_contributors": [
    {
      "user": "nikolaus77",
      "count": 74,
      "uuid": 83133578
    }
  ],
  "_userbio": {
    "uuid": 83133578,
    "type": "user",
    "name": "Nikolaus Pawlowski"
  },
  "_downloads": {
    "count": 176,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/rocker"
  },
  "_devurl": "https://github.com/nikolaus77/rocker",
  "_searchresults": 6,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/rocker.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/nikolaus77/rocker",
  "_realowner": "nikolaus77",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.2",
      "date": "2021-11-17"
    },
    {
      "version": "0.2.1",
      "date": "2021-12-12"
    },
    {
      "version": "0.3.0",
      "date": "2022-01-05"
    },
    {
      "version": "0.3.1",
      "date": "2022-08-20"
    },
    {
      "version": "0.3.2",
      "date": "2025-08-30"
    }
  ],
  "_exports": [
    "appendTable",
    "begin",
    "canConnect",
    "clearResult",
    "columnInfo",
    "commit",
    "connect",
    "createTable",
    "disconnect",
    "execute",
    "existsTable",
    "fetch",
    "getInfoCon",
    "getInfoDrv",
    "getInfoRes",
    "getQuery",
    "getRowCount",
    "getRowsAffected",
    "getStatement",
    "hasCompleted",
    "isValidCon",
    "isValidDrv",
    "isValidRes",
    "listFields",
    "listObjects",
    "listTables",
    "newDB",
    "readTable",
    "removeTable",
    "rocker",
    "rollback",
    "sendQuery",
    "sendStatement",
    "setupDriver",
    "setupMariaDB",
    "setupPostgreSQL",
    "setupSQLite",
    "unloadDriver",
    "validateCon",
    "writeTable"
  ],
  "_help": [
    {
      "page": "appendTable",
      "title": "Append data to table.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "appendTable"
      ]
    },
    {
      "page": "begin",
      "title": "Begin transaction.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "begin"
      ]
    },
    {
      "page": "canConnect",
      "title": "Test connection parameters.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "canConnect"
      ]
    },
    {
      "page": "clearResult",
      "title": "Clear query or statement result.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "clearResult"
      ]
    },
    {
      "page": "columnInfo",
      "title": "Information on query result columns.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "columnInfo"
      ]
    },
    {
      "page": "commit",
      "title": "Commit transaction.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "commit"
      ]
    },
    {
      "page": "connect",
      "title": "Establish database connection using stored parameters.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "connect"
      ]
    },
    {
      "page": "createTable",
      "title": "Create empty formatted table.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "createTable"
      ]
    },
    {
      "page": "disconnect",
      "title": "Disconnect database.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "disconnect"
      ]
    },
    {
      "page": "execute",
      "title": "Execute SQL statement in database. Combination of functions execute and clearResult. If required, database is automatically connected and disconnected.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "execute"
      ]
    },
    {
      "page": "existsTable",
      "title": "Check if table exists.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "existsTable"
      ]
    },
    {
      "page": "fetch",
      "title": "Fetch SQL query result from database.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "fetch"
      ]
    },
    {
      "page": "getInfoCon",
      "title": "Information on connection object.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "getInfoCon"
      ]
    },
    {
      "page": "getInfoDrv",
      "title": "Information on driver object.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "getInfoDrv"
      ]
    },
    {
      "page": "getInfoRes",
      "title": "Information on result object.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "getInfoRes"
      ]
    },
    {
      "page": "getQuery",
      "title": "Retrieve SQL query from database. Combination of functions sendQuery(), fetch() and clearResult(). If required, database is automatically connected and disconnected.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "getQuery"
      ]
    },
    {
      "page": "getRowCount",
      "title": "Information on number of retrieved rows.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "getRowCount"
      ]
    },
    {
      "page": "getRowsAffected",
      "title": "Information on number of affected rows.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "getRowsAffected"
      ]
    },
    {
      "page": "getStatement",
      "title": "Information on sent statement.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "getStatement"
      ]
    },
    {
      "page": "hasCompleted",
      "title": "Information whether all records were retrieved.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "hasCompleted"
      ]
    },
    {
      "page": "isValidCon",
      "title": "Check connection object.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "isValidCon"
      ]
    },
    {
      "page": "isValidDrv",
      "title": "Check driver object.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "isValidDrv"
      ]
    },
    {
      "page": "isValidRes",
      "title": "Check result object.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "isValidRes"
      ]
    },
    {
      "page": "listFields",
      "title": "List table column names.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "listFields"
      ]
    },
    {
      "page": "listObjects",
      "title": "List database objects.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "listObjects"
      ]
    },
    {
      "page": "listTables",
      "title": "List database tables.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "listTables"
      ]
    },
    {
      "page": "newDB",
      "title": "newDB",
      "concept": [
        "rocker"
      ],
      "topics": [
        "newDB"
      ]
    },
    {
      "page": "readTable",
      "title": "Read table.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "readTable"
      ]
    },
    {
      "page": "removeTable",
      "title": "Remove table.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "removeTable"
      ]
    },
    {
      "page": "rocker-R6-class",
      "title": "'rocker' Database Interface R6 Class",
      "concept": [
        "rocker"
      ],
      "topics": [
        "rocker",
        "rocker-R6-class"
      ]
    },
    {
      "page": "rocker-README",
      "title": "README",
      "concept": [
        "rocker",
        "rocker-S3-functions"
      ],
      "topics": [
        "rocker-README"
      ]
    },
    {
      "page": "rocker-S3-functions",
      "title": "'rocker' Database Interface R6 Class - S3 functions",
      "concept": [
        "rocker",
        "rocker-S3-functions"
      ],
      "topics": [
        "rocker-S3-functions"
      ]
    },
    {
      "page": "rollback",
      "title": "Rollback transaction.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "rollback"
      ]
    },
    {
      "page": "sendQuery",
      "title": "Send SQL query to database.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "sendQuery"
      ]
    },
    {
      "page": "sendStatement",
      "title": "Send SQL statement to database.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "sendStatement"
      ]
    },
    {
      "page": "setupDriver",
      "title": "Setup database driver and define connection parameters.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "setupDriver"
      ]
    },
    {
      "page": "setupMariaDB",
      "title": "Setup database driver and define connection parameters for MariaDB using RMariaDB package. Wrapper for setupDriver() function.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "setupMariaDB"
      ]
    },
    {
      "page": "setupPostgreSQL",
      "title": "Setup database driver and define connection parameters for PostgreSQL using RPostgres package. Wrapper for setupDriver() function.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "setupPostgreSQL"
      ]
    },
    {
      "page": "setupSQLite",
      "title": "Setup database driver and define connection parameters for SQLite using RSQLite package. Wrapper for setupDriver() function.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "setupSQLite"
      ]
    },
    {
      "page": "unloadDriver",
      "title": "Reset database driver and connection parameters.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "unloadDriver"
      ]
    },
    {
      "page": "validateCon",
      "title": "Check if an earlier opened connection is still open.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "validateCon"
      ]
    },
    {
      "page": "writeTable",
      "title": "Write data to table.",
      "concept": [
        "rocker-S3-functions"
      ],
      "topics": [
        "writeTable"
      ]
    }
  ],
  "_readme": "https://github.com/nikolaus77/rocker/raw/HEAD/README.md",
  "_rundeps": [
    "DBI",
    "R6",
    "sodium"
  ],
  "_vignettes": [
    {
      "source": "Transactions.Rmd",
      "filename": "Transactions.html",
      "title": "Database transactions with R6 rocker class",
      "author": "Nikolaus Pawlowski",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2021-12-02 20:10:48",
      "modified": "2021-12-11 10:02:08",
      "commits": 2
    },
    {
      "source": "DBI_objects_and_functions.Rmd",
      "filename": "DBI_objects_and_functions.html",
      "title": "DBI package objects and functions in R6 rocker class",
      "author": "Nikolaus Pawlowski",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2021-12-02 20:10:48",
      "modified": "2021-12-11 10:02:08",
      "commits": 2
    },
    {
      "source": "Database_connections.Rmd",
      "filename": "Database_connections.html",
      "title": "Initiation of SQL database connections in R6 rocker class",
      "author": "Nikolaus Pawlowski",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2021-12-02 20:10:48",
      "modified": "2021-12-29 17:47:31",
      "commits": 3
    },
    {
      "source": "Installation_and_Object.Rmd",
      "filename": "Installation_and_Object.html",
      "title": "Installation and set up of R6 rocker object",
      "author": "Nikolaus Pawlowski",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2021-12-29 17:47:31",
      "modified": "2021-12-29 17:47:31",
      "commits": 1
    },
    {
      "source": "Password_storage.Rmd",
      "filename": "Password_storage.html",
      "title": "Protected password (credentials) storage inside of R6 rocker class",
      "author": "Nikolaus Pawlowski",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2021-12-02 20:10:48",
      "modified": "2021-12-11 10:02:08",
      "commits": 2
    },
    {
      "source": "Packages_and_databases.Rmd",
      "filename": "Packages_and_databases.html",
      "title": "Usage of relational databases (SQLite, PostgreSQL and MariaDB) with R6 rocker class",
      "author": "Nikolaus Pawlowski",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2021-12-02 20:10:48",
      "modified": "2021-12-11 10:02:08",
      "commits": 2
    },
    {
      "source": "S3_and_R6_functions.Rmd",
      "filename": "S3_and_R6_functions.html",
      "title": "Usage of S3 class functions on R6 rocker class",
      "author": "Nikolaus Pawlowski",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2021-12-02 23:54:55",
      "modified": "2021-12-11 10:02:08",
      "commits": 2
    }
  ],
  "_score": 5.243038048686294,
  "_indexed": true,
  "_nocasepkg": "rocker",
  "_universes": [
    "nikolaus77"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.2",
      "date": "2026-05-28T08:07:36.000Z",
      "distro": "noble",
      "commit": "b72f1c6dbcd127ff10253564aa38d787a2161406",
      "fileid": "7d7192928c1654573b58f99eb46aaa289cf3bde6ac58222b16d06d8250eee813",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nikolaus77/actions/runs/26562527199"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.3.2",
      "date": "2026-05-28T08:07:08.000Z",
      "distro": "noble",
      "commit": "b72f1c6dbcd127ff10253564aa38d787a2161406",
      "fileid": "550bb72d36f986b9ae44d4d0ab08dbdcb3ce40ba3b2a3068a5c855db8fc6dc62",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nikolaus77/actions/runs/26562527199"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.2",
      "date": "2026-05-28T08:07:21.000Z",
      "commit": "b72f1c6dbcd127ff10253564aa38d787a2161406",
      "fileid": "a1028bb5342b8375d1732204f18e42bfe8e36f360335fa8e25ae5822215a5285",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nikolaus77/actions/runs/26562527199"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.3.2",
      "date": "2026-05-28T08:06:47.000Z",
      "commit": "b72f1c6dbcd127ff10253564aa38d787a2161406",
      "fileid": "21c630289a83e438ca0981ed6b616028b921be516f51cc06e160af11a982234e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nikolaus77/actions/runs/26562527199"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.2",
      "date": "2026-05-28T08:07:03.000Z",
      "commit": "b72f1c6dbcd127ff10253564aa38d787a2161406",
      "fileid": "c51cae64572d729893fbc4352e88b411ca6c50168c65acd66efbe161cc6951e6",
      "status": "success",
      "buildurl": "https://github.com/r-universe/nikolaus77/actions/runs/26562527199"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.2",
      "date": "2026-05-28T08:06:27.000Z",
      "commit": "b72f1c6dbcd127ff10253564aa38d787a2161406",
      "fileid": "6f7bc9e40ef6b50efb36e4d95dd54c683095c3f964fc966b676e0eb8dd8471e2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nikolaus77/actions/runs/26562527199"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.2",
      "date": "2026-05-28T08:06:12.000Z",
      "commit": "b72f1c6dbcd127ff10253564aa38d787a2161406",
      "fileid": "015f2add852ea07346804da18691a57defe14f400c67cae20b6325b7966a75e4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nikolaus77/actions/runs/26562527199"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.3.2",
      "date": "2026-05-28T08:06:11.000Z",
      "commit": "b72f1c6dbcd127ff10253564aa38d787a2161406",
      "fileid": "3c1acbfaea0d0dce76319f88f8988512f760adff9dd6c5d2699825522aa699db",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nikolaus77/actions/runs/26562527199"
    }
  ]
}