Package: gmDatabase 0.5.0

K. Gerald van den Boogaart

gmDatabase: Accessing a Geometallurgical Database with R

A template for a geometallurgical database and a fast and easy interface for accessing it is provided in this package.

Authors:K. Gerald van den Boogaart [aut, cre], Stephan Matos Camacho [aut]

gmDatabase_0.5.0.tar.gz
gmDatabase_0.5.0.tar.gz(r-4.5-noble)gmDatabase_0.5.0.tar.gz(r-4.4-noble)
gmDatabase_0.5.0.tgz(r-4.4-emscripten)gmDatabase_0.5.0.tgz(r-4.3-emscripten)
gmDatabase.pdf |gmDatabase.html✨
gmDatabase/json (API)

# Install 'gmDatabase' in R:
install.packages('gmDatabase', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.

1.28 score 19 scripts 148 downloads 45 exports 35 dependencies

Last updated 9 years agofrom:caacdca5a0. Checks:1 OK, 1 NOTE. Indexed: yes.

TargetResultLatest binary
Doc / VignettesOKJan 22 2025
R-4.5-linuxNOTEJan 22 2025

Exports:dbNowextractDollarExpressionsfindVarsInExpressionforKeyValgmAddgmAddMembersgmAddUserToGroupgmAndifygmChangePasswordgmClassgmClassMembersgmConnectServergmCreateClassgmCreateDBgmCreateRightsGroupgmCreateUsergmCreateUserGroupgmDBSummarygmDefaultRightsGroupgmDisconnectServergmEscapeStringsgmExprgmGetgmGetVargmGetVariableTypegmJoinAVariablegmListVariablesgmListVariableTypesgmReadgmReadInternalgmRemovegmRequestgmSetgmSetRightsgmSetRightsGroupgmSQLgmSQL2SQLgmSQLTablegmSQLValuesrepairGmGrandChildsreplaceVarsInExpressionrootSQL2SQLenvSQLenvtick

Dependencies:base64encbslibcachemclicodetoolscommonmarkcrayonDBIdigestfastmapfontawesomeforeachfsgluehtmltoolshttpuviteratorsjquerylibjsonlitelaterlifecyclemagrittrmemoisemimepromisesR6rappdirsRcpprlangRMySQLsassshinysourcetoolswithrxtable

Readme and manuals

Help Manual

Help pageTopics
Get the actual system timedbNow
Extracting a dollar expressionextractDollarExpressions
'findVarsInExpression'findVarsInExpression
forKeyVal - Looping named listsforKeyVal
Adding and updating objects in a geometallurgical database.gmAdd gmSet
Creating a conjunctiongmAndify
Function for changing the password of a user in the geometallurgical database.gmChangePassword
Returning information from geometallurgicala databasegmClass gmClassMembers
Geometallurgy Database connectiongmConnectServer gmCreateDB gmDBSummary gmDisconnectServer gmEscapeStrings gmListVariables gmListVariableTypes gmRequest gmRequest,character,list,ANY-method gmRequest,character,list,MySQLConnection-method
Providing new classes and adding new users, rights groups, usergroups, etc.gmAddMembers gmAddUserToGroup gmCreateClass gmCreateRightsGroup gmCreateUser gmCreateUserGroup gmDefaultRightsGroup gmSetRights gmSetRightsGroup
Creating gmExpressionsgmExpr root
Get information about an object.gmGet gmGetVar
Getting information on variables in a geometallurgy (gm)DatabasegmGetVariableType
Creating the join R representation of a SQL JOINgmJoinADollarExpr gmJoinAVariable
Add the ID to the selectiongmJoinTheID
Return the result of an SQl query given as R-like representationgmRead gmReadInternal
Delete objects in an geometallurgical databasegmRemove
Provide an R representation of SQLgmSQL gmSQL2SQL gmSQLTable SQL2SQLenv SQLenv
Format vector in parenthesis and SQL quote itgmSQLValues
Parse an R expression of SQl statementsmakeGmSQLfromR
Updating second order inheritance.repairGmGrandChilds
Replace Variables in ExpressionsreplaceVarsInExpression
Create a unique nametick