{"Package":"stacomirtools","Version":"0.6.0.1","Date":"2022-04-28","Title":"Connection Class for Package stacomiR","Authors@R":"c(\nperson(\"Cedric\", \"Briand\", role = c(\"aut\", \"cre\"), email = \"cedric.briand00@gmail.com\"),\nperson(\"Marion\", \"Legrand\", role = \"aut\", email = \"tableau-salt-loire@logrami.fr\"),\nperson(\"Beaulaton\", \"Laurent\", role = \"ctb\", email = \"laurent.beaulaton@ofb.gouv.fr\"))","Author":"Cedric Briand [aut, cre],\nMarion Legrand [aut],\nBeaulaton Laurent [ctb]","Maintainer":"Cedric Briand ","Description":"S4 class wrappers for the 'ODBC' and Pool DBI connection, also provides some\nutilities to paste small datasets to clipboard, rename columns. It is used by the package 'stacomiR' for\nconnections to the database. Development versions of 'stacomiR' are available in R-forge.","License":"GPL (>= 2)","Collate":"'ConnectionODBC.R' 'RequeteODBC.R' 'RequeteODBCwhere.R'\n'RequeteODBCwheredate.R' 'utilities.R' 'stacomirtools.R'\n'stacomirtools-package.R''ConnectionDB.R' 'RequeteDB.R'\n'RequeteDBwhere.R' 'RequeteDBwheredate.R' 'zzz.R'","LazyLoad":"yes","Depends":"RODBC, DBI, pool","Imports":"methods, xtable, utils, RPostgres","Suggests":"testthat, withr","NeedsCompilation":"no","RoxygenNote":"7.1.2","Packaged":"2022-04-29 10:00:13 UTC; cedric.briand","Repository":"CRAN","Date/Publication":"2022-04-29 11:40:02 UTC","repoType":"cran","tarballUrl":"ftp://cran.r-project.org/pub/R/src/contrib/stacomirtools_0.6.0.1.tar.gz","jsonAuthors":[{"name":"Cedric Briand","email":"cedric.briand00@gmail.com","maintainer":true},{"name":"Marion Legrand","email":"tableau-salt-loire@logrami.fr","maintainer":false},{"name":"Beaulaton Laurent","email":"laurent.beaulaton@ofb.gouv.fr","maintainer":false}],"readme":"\n\n\n# stacomirtools\n\n\n\n[![CRAN\nstatus](https://www.r-pkg.org/badges/version/stacomirtools)](https://CRAN.R-project.org/package=stacomirtools)\n[![Lifecycle:\nstable](https://img.shields.io/badge/lifecycle-stable-brightgreen.svg)](https://lifecycle.r-lib.org/articles/stages.html#stable)\n[![Downloads](https://cranlogs.r-pkg.org/badges/stacomirtools)](https://cran.r-project.org/package=stacomirtools)\n\n\nStacomirtools provides S4 class wrappers for DBI pool and ODBC,\nessentially managing database connections for stacomiR plus one or two\nhandy functions.\n\n## Installation\n\nYou can install the development version of stacomirtools like so:\n\n``` r\n#install.packages(\"remotes\")\n#remotes::install_github(repo= \"Remotes: gitlab::git@forgemia.inra.fr:stacomi/stacomirtools.git\")\ninstall.packages(\"stacomirtools\", repos=\"http://R-Forge.R-project.org\")\n```\n\n## Example\n\nThe connection is established via options, for ODBC connections you need\nto setup the ODBC connection corresponding to your version of R (either\n32 or 64 bits). You need to specify user and password.\n\n``` r\nlibrary(stacomirtools)\n# all options :\noptions(list(\n stacomiR.dbname = \"bd_contmig_nat\",\n stacomiR.host =\"localhost\",\n stacomiR.port = \"5432\",\n stacomiR.user = \"mysuser\",\n stacomiR.password = \"mypassword\",\n stacomiR.ODBClink = NULL,\n stacomiR.printqueries =FALSE\n ))\nreq <- new(\"RequeteDB\")\nreq <- query(req)\n```\n\n## Pool Connection\n\nFor Pool, if you are running on your machine (localhost) and use\npostgres standard 5432 port, you need only to set options for dbname,\nuser and password, otherwise you can connect to different hosts.\n\n``` r\noptions(list( \n stacomiR.user = \"mysuser\",\n stacomiR.password = \"mypassword\" \n ))\n# if you don't provide those you will be prompted for user and password if interactive\nreq <- new(\"RequeteDB\")\nreq <- query(req)\n# The query result is stored in req@query you can use either\nreq@query\n# or\ngetquery(req)\n# to get it\n```\n\n## ODBC Connection\n\nIn windows establish ODBC link by typing ODBC in the search bar, then\nchoose either 32 bit or 64 bit, user source add POSTGRESQL ODBC Driver\n(these must be prior installed with postgres via application stack\nmanager). Then edit the datasource for the following fields. \\* Data\nSource : the name of the stacomiR.ODBClink below \\* Database \\* Serveur\n: on you computer `localhost` \\* User Name \\* Password \\* Port\n\n``` r\noptions(list( \n stacomiR.ODBClink = \"bd_contmig_nat\",\n stacomiR.user = \"mysuser\",\n stacomiR.password = \"mypassword\" \n ))\nreq <- new(\"RequeteODBC\")\nreq <- connect(req)\nreq@query\n```","jobInfo":{"package":"stacomirtools","version":"0.6.0.1","parsingStatus":"success","parserVersion":1,"parsedAt":"2022-04-29T14:30:09+0000"}}

Description

Usage

Arguments