{ "_id": "6a181022acfb0bcc41dae4ca", "Package": "gmDatabase", "Version": "0.5.1", "Date": "2025-04-25", "Title": "Accessing a Geometallurgical Database with R", "Authors@R": "c(person(\"K. Gerald\", \"van den Boogaart\", role = c(\"aut\", \"cre\"),\nemail = \"support@boogaart.de\"),\nperson(\"Stephan\", \"Matos Camacho\", role = c(\"aut\"),\nemail = \"s.matos@hzdr.de\")\n)", "Author": "K. Gerald van den Boogaart [aut, cre], Stephan Matos Camacho\n[aut]", "Maintainer": "K. Gerald van den Boogaart ", "Description": "A template for a geometallurgical database and a fast and\neasy interface for accessing it.", "License": "GPL (>= 2) | LGPL (>= 2)", "LazyLoad": "TRUE", "URL": "https://cran.r-project.org/package=gmDatabase,\nhttp://www.stat.boogaart.de", "Copyright": "(C) 2016 by Helmholtz Institute Freiberg for Resource\nTechnology", "NeedsCompilation": "no", "RoxygenNote": "7.1.2", "Packaged": { "Date": "2026-05-28 09:48:52 UTC", "User": "root" }, "Repository": "https://cran.r-universe.dev", "Date/Publication": "2025-04-26 12:40:02 UTC", "RemoteUrl": "https://github.com/cran/gmDatabase", "RemoteRef": "HEAD", "RemoteSha": "1ce44aa214d13a1a8af6656eac7721e97f5ca7da", "MD5sum": "bd02817a7e8630201f9415f678735526", "_user": "cran", "_type": "src", "_file": "gmDatabase_0.5.1.tar.gz", "_fileid": "3d7cfc4ff00e56f0437714c7f7cf30cbb6e72b358ff82e7ffa66f38cc78d75e1", "_filesize": 206617, "_sha256": "3d7cfc4ff00e56f0437714c7f7cf30cbb6e72b358ff82e7ffa66f38cc78d75e1", "_created": "2026-05-28T09:48:52.000Z", "_published": "2026-05-28T09:51:30.899Z", "_distro": "noble", "_jobs": [ { "job": 78265749410, "time": 125, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7262840369" }, { "job": 78265749398, "time": 122, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7262839775" }, { "job": 78265259429, "time": 179, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7262797316" }, { "job": 78265749321, "time": 119, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7262838214" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/26567311579", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/gmDatabase", "_commit": { "id": "1ce44aa214d13a1a8af6656eac7721e97f5ca7da", "author": "K. Gerald van den Boogaart ", "committer": "cran-robot ", "message": "version 0.5.1\n", "time": 1745671202 }, "_maintainer": { "name": "K. Gerald van den Boogaart", "email": "support@boogaart.de" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 2.1.0", "role": "Depends" }, { "package": "DBI", "role": "Depends" }, { "package": "RMySQL", "role": "Depends" }, { "package": "foreach", "role": "Depends" }, { "package": "methods", "role": "Depends" }, { "package": "digest", "role": "Depends" }, { "package": "shiny", "role": "Depends" }, { "package": "MASS", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 157, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/gmDatabase" }, "_searchresults": 19, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/gmDatabase.html", "manual.pdf" ], "_realowner": "cran", "_cranurl": false, "_releases": [ { "version": "0.5.0", "date": "2016-06-16" }, { "version": "0.5.1", "date": "2025-04-26" } ], "_exports": [ "dbNow", "extractDollarExpressions", "findVarsInExpression", "forKeyVal", "gmAdd", "gmAddMembers", "gmAddUserToGroup", "gmAndify", "gmChangePassword", "gmClass", "gmClassMembers", "gmConnectServer", "gmCreateClass", "gmCreateDB", "gmCreateRightsGroup", "gmCreateUser", "gmCreateUserGroup", "gmDBSummary", "gmDefaultRightsGroup", "gmDisconnectServer", "gmEscapeStrings", "gmExpr", "gmGet", "gmGetVar", "gmGetVariableType", "gmJoinAVariable", "gmListVariables", "gmListVariableTypes", "gmRead", "gmReadInternal", "gmRemove", "gmRequest", "gmSet", "gmSetRights", "gmSetRightsGroup", "gmSQL", "gmSQL2SQL", "gmSQLTable", "gmSQLValues", "repairGmGrandChilds", "replaceVarsInExpression", "root", "SQL2SQLenv", "SQLenv", "tick" ], "_help": [ { "page": "dbNow", "title": "Get the actual system time", "topics": [ "dbNow" ] }, { "page": "extractDollarExpressions", "title": "Extracting a dollar expression", "topics": [ "extractDollarExpressions" ] }, { "page": "findVarsInExpression", "title": "'findVarsInExpression'", "topics": [ "findVarsInExpression" ] }, { "page": "forKeyVal", "title": "forKeyVal - Looping named lists", "topics": [ "forKeyVal" ] }, { "page": "gmAdd", "title": "Adding and updating objects in a geometallurgical database.", "topics": [ "gmAdd", "gmSet" ] }, { "page": "gmAndify", "title": "Creating a conjunction", "topics": [ "gmAndify" ] }, { "page": "gmChangePassword", "title": "Function for changing the password of a user in the geometallurgical database.", "topics": [ "gmChangePassword" ] }, { "page": "gmClass", "title": "Returning information from geometallurgicala database", "topics": [ "gmClass", "gmClassMembers" ] }, { "page": "gmConnectServer", "title": "Geometallurgy Database connection", "topics": [ "gmConnectServer", "gmCreateDB", "gmDBSummary", "gmDisconnectServer", "gmEscapeStrings", "gmListVariables", "gmListVariableTypes", "gmRequest", "gmRequest,character,list,ANY-method", "gmRequest,character,list,MySQLConnection-method" ] }, { "page": "gmCreateClass", "title": "Providing new classes and adding new users, rights groups, usergroups, etc.", "topics": [ "gmAddMembers", "gmAddUserToGroup", "gmCreateClass", "gmCreateRightsGroup", "gmCreateUser", "gmCreateUserGroup", "gmDefaultRightsGroup", "gmSetRights", "gmSetRightsGroup" ] }, { "page": "gmExpr", "title": "Creating gmExpressions", "topics": [ "gmExpr", "root" ] }, { "page": "gmGet", "title": "Get information about an object.", "topics": [ "gmGet", "gmGetVar" ] }, { "page": "gmGetVariableType", "title": "Getting information on variables in a geometallurgy (gm)Database", "topics": [ "gmGetVariableType" ] }, { "page": "gmJoinAVariable", "title": "Creating the join R representation of a SQL JOIN", "topics": [ "gmJoinADollarExpr", "gmJoinAVariable" ] }, { "page": "gmJoinTheID", "title": "Add the ID to the selection", "topics": [ "gmJoinTheID" ] }, { "page": "gmRead", "title": "Return the result of an SQl query given as R-like representation", "topics": [ "gmRead", "gmReadInternal" ] }, { "page": "gmRemove", "title": "Delete objects in an geometallurgical database", "topics": [ "gmRemove" ] }, { "page": "gmSQL", "title": "Provide an R representation of SQL", "topics": [ "gmSQL", "gmSQL2SQL", "gmSQLTable", "SQL2SQLenv", "SQLenv" ] }, { "page": "gmSQLValues", "title": "Format vector in parenthesis and SQL quote it", "topics": [ "gmSQLValues" ] }, { "page": "makeGmSQLfromR", "title": "Parse an R expression of SQl statements", "topics": [ "makeGmSQLfromR" ] }, { "page": "repairGrandChilds", "title": "Updating second order inheritance.", "topics": [ "repairGmGrandChilds" ] }, { "page": "replaceVarsInExpression", "title": "Replace Variables in Expressions", "topics": [ "replaceVarsInExpression" ] }, { "page": "tick", "title": "Create a unique name", "topics": [ "tick" ] } ], "_rundeps": [ "base64enc", "bslib", "cachem", "cli", "codetools", "commonmark", "DBI", "digest", "fastmap", "fontawesome", "foreach", "fs", "glue", "htmltools", "httpuv", "iterators", "jquerylib", "jsonlite", "later", "lifecycle", "magrittr", "memoise", "mime", "otel", "promises", "R6", "rappdirs", "Rcpp", "rlang", "RMySQL", "sass", "shiny", "sourcetools", "withr", "xtable" ], "_score": 1.2787536009528289, "_indexed": true, "_nocasepkg": "gmdatabase", "_universes": [ "cran" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.5.1", "date": "2026-05-28T09:50:56.000Z", "distro": "noble", "commit": "1ce44aa214d13a1a8af6656eac7721e97f5ca7da", "fileid": "2f3e3b92ace0f3d9aeb249c39cb50a87dac5ab0b9e99ccdb58cec66cb4cb27c0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26567311579" }, { "r": "4.6.0", "os": "linux", "version": "0.5.1", "date": "2026-05-28T09:50:52.000Z", "distro": "noble", "commit": "1ce44aa214d13a1a8af6656eac7721e97f5ca7da", "fileid": "492a0c5ee3a6433173aa6b55f8548d9d9c058c04729ed074576f1b5a29881551", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26567311579" }, { "r": "4.6.0", "os": "wasm", "version": "0.5.1", "date": "2026-05-28T09:51:10.000Z", "commit": "1ce44aa214d13a1a8af6656eac7721e97f5ca7da", "fileid": "336825877acc9c347a59f24e7dc64988d94da374b4efe143eee08bf30a53eab9", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/26567311579" } ] }