{ "_id": "6a1568a0acfb0bcc41d62353", "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], Marion Legrand [aut], Beaulaton\nLaurent [ctb]", "Maintainer": "Cedric Briand ", "Description": "S4 class wrappers for the 'ODBC' and Pool DBI connection,\nalso provides some utilities to paste small datasets to\nclipboard, rename columns. It is used by the package 'stacomiR'\nfor connections to the database. Development versions of\n'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", "NeedsCompilation": "no", "RoxygenNote": "7.1.2", "Packaged": { "Date": "2026-05-26 09:28:56 UTC", "User": "root" }, "Config/pak/sysreqs": "unixodbc-dev libpq-dev", "Repository": "https://cedricbriandgithub.r-universe.dev", "Date/Publication": "2022-04-29 10:40:02 UTC", "RemoteUrl": "https://github.com/cran/stacomirtools", "RemoteRef": "HEAD", "RemoteSha": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "MD5sum": "a02953e3658a315482a943d0e977e12e", "_user": "cedricbriandgithub", "_type": "src", "_file": "stacomirtools_0.6.0.1.tar.gz", "_fileid": "60c24c01efa5cfa3d748be45a5551ef29fe6ca2aede9c94fbcc82c0e6a304ff8", "_filesize": 145008, "_sha256": "60c24c01efa5cfa3d748be45a5551ef29fe6ca2aede9c94fbcc82c0e6a304ff8", "_created": "2026-05-26T09:28:56.000Z", "_published": "2026-05-26T09:32:16.702Z", "_distro": "noble", "_jobs": [ { "job": 77845908053, "time": 125, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7213568095" }, { "job": 77845908151, "time": 133, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7213570174" }, { "job": 77845908141, "time": 168, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7213571479" }, { "job": 77845908106, "time": 150, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7213567288" }, { "job": 77845454559, "time": 160, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7213522594" }, { "job": 77845908075, "time": 98, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7213558637" }, { "job": 77845908129, "time": 97, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7213557861" }, { "job": 77845908089, "time": 103, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7213560082" }, { "job": 77845908102, "time": 144, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7213574857" } ], "_buildurl": "https://github.com/r-universe/cedricbriandgithub/actions/runs/26443979094", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/stacomirtools", "_commit": { "id": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "author": "Cedric Briand ", "committer": "cran-robot ", "message": "version 0.6.0.1\n", "time": 1651228802 }, "_maintainer": { "name": "Cedric Briand", "email": "cedric.briand00@gmail.com", "login": "cedricbriandgithub", "description": "", "uuid": 26055877 }, "_registered": true, "_dependencies": [ { "package": "RODBC", "role": "Depends" }, { "package": "DBI", "role": "Depends" }, { "package": "pool", "role": "Depends" }, { "package": "methods", "role": "Imports" }, { "package": "xtable", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "RPostgres", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "cran", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "cedricbriandgithub", "count": 6, "uuid": 26055877 } ], "_userbio": { "uuid": 26055877, "type": "user", "name": "Cédric Briand" }, "_downloads": { "count": 184, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/stacomirtools" }, "_searchresults": 15, "_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/stacomirtools.html", "manual.pdf" ], "_realowner": "cedricbriandgithub", "_cranurl": false, "_releases": [ { "version": "0.3", "date": "2013-01-07" }, { "version": "0.5.0", "date": "2016-08-20" }, { "version": "0.5.2", "date": "2017-06-24" }, { "version": "0.5.3", "date": "2018-10-06" }, { "version": "0.6.0", "date": "2021-11-11" }, { "version": "0.6.0.1", "date": "2022-04-29" } ], "_exports": [ "chnames", "connect", "ex", "funhtml", "getquery", "induk", "is.even", "is.odd", "killfactor", "query", "tab2df" ], "_help": [ { "page": "chnames", "title": "This function replaces the variable names in a data.frame", "topics": [ "chnames" ] }, { "page": "connect", "title": "generic connect function for baseODBC", "topics": [ "connect", "connect.generic" ] }, { "page": "connect-ConnectionDB-method", "title": "connect method for ConnectionDB class", "topics": [ "connect,ConnectionDB-method", "connect.ConnectionDB" ] }, { "page": "connect-ConnectionODBC-method", "title": "connect method for ConnectionODBC class", "topics": [ "connect,ConnectionODBC-method", "connect.ConnectionODBC" ] }, { "page": "connect-RequeteODBC-method", "title": "connect method loads a request to the database and returns either an error or a data.frame", "topics": [ "connect,RequeteODBC-method", "connect.RequeteODBC" ] }, { "page": "connect-RequeteODBCwhere-method", "title": "connect method loads a request to the database and returns either an error or a data.frame", "topics": [ "connect,RequeteODBCwhere-method", "connect.RequeteODBCwhere" ] }, { "page": "connect-RequeteODBCwheredate-method", "title": "connect method loads a request to the database and returns either an error or a data.frame", "topics": [ "connect,RequeteODBCwheredate-method", "connect.RequeteODBCwheredate" ] }, { "page": "ConnectionDB-class", "title": "ConnectionDB class", "topics": [ "ConnectionDB-class" ] }, { "page": "ConnectionODBC-class", "title": "ConnectionODBC class", "topics": [ "ConnectionODBC-class" ] }, { "page": "ex", "title": "ex fonction to write to the clipboard", "topics": [ "ex" ] }, { "page": "funhtml", "title": "function used to print the html tables of output (see xtable documentation)", "topics": [ "funhtml" ] }, { "page": "getquery", "title": "generic query function for", "topics": [ "getquery" ] }, { "page": "getquery-RequeteDB-method", "title": "getquery retreives the result of the query from the object", "topics": [ "getquery,RequeteDB-method" ] }, { "page": "induk", "title": "unique values of a vector", "topics": [ "induk" ] }, { "page": "is.even", "title": "is.even function modified from package sma", "topics": [ "is.even" ] }, { "page": "is.odd", "title": "id.odd function modified from package sma", "topics": [ "is.odd" ] }, { "page": "killfactor", "title": "very usefull function used to \"kill\" the factors, noticeably after loading with 'ODBC'", "topics": [ "killfactor" ] }, { "page": "query", "title": "generic query function for", "topics": [ "query", "query.RequeteDB" ] }, { "page": "query-RequeteDB-method", "title": "query method loads a quert to the data and returns either an error or a data.frame", "topics": [ "query,RequeteDB-method" ] }, { "page": "query-RequeteDBwhere-method", "title": "query method loads a request to the database and returns either an error or a data.frame", "topics": [ "query,RequeteDBwhere-method", "query.RequeteODBCwhere" ] }, { "page": "query-RequeteDBwheredate-method", "title": "query method loads a request to the database and returns either an error or a data.frame", "topics": [ "query,RequeteDBwheredate-method", "query.RequeteDBwheredate" ] }, { "page": "RequeteDB-class", "title": "RequeteDB class", "topics": [ "RequeteDB-class" ] }, { "page": "RequeteDBwhere-class", "title": "RequeteDBwhere class", "topics": [ "RequeteDBwhere-class" ] }, { "page": "RequeteDBwheredate-class", "title": "RequeteDBwhere class", "topics": [ "RequeteDBwheredate-class" ] }, { "page": "RequeteODBC-class", "title": "RequeteODBC class", "topics": [ "RequeteODBC-class" ] }, { "page": "RequeteODBCwhere-class", "title": "RequeteODBCwhere class", "topics": [ "RequeteODBCwhere-class" ] }, { "page": "RequeteODBCwheredate-class", "title": "RequeteODBCwhere class", "topics": [ "RequeteODBCwheredate-class" ] }, { "page": "tab2df", "title": "Function to transform a ftable into dataframe but just keeping the counts, works with ftable of dim 2", "topics": [ "tab2df" ] }, { "page": "validity_DB", "title": "validity function for ConnectionDB class", "topics": [ "validity_DB" ] }, { "page": "validity_ODBC", "title": "Validity method for ODBC class", "topics": [ "validity_ODBC" ] } ], "_readme": "https://github.com/cran/stacomirtools/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cli", "cpp11", "DBI", "generics", "glue", "hms", "later", "lifecycle", "lubridate", "pkgconfig", "pool", "R6", "Rcpp", "rlang", "RODBC", "RPostgres", "timechange", "vctrs", "withr", "xtable" ], "_score": 1.8750612633917, "_indexed": true, "_nocasepkg": "stacomirtools", "_universes": [ "cedricbriandgithub" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.6.0.1", "date": "2026-05-26T09:30:56.000Z", "distro": "noble", "commit": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "fileid": "630014783df11a70b62be09b3cbfd0fae46eff4d21db41e082993130bc949230", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cedricbriandgithub/actions/runs/26443979094" }, { "r": "4.6.0", "os": "linux", "version": "0.6.0.1", "date": "2026-05-26T09:31:02.000Z", "distro": "noble", "commit": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "fileid": "c35a5ee5dbf25939712c701b51b3bb2c4722745db0f7761c0f2a6b125d31061e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cedricbriandgithub/actions/runs/26443979094" }, { "r": "4.5.3", "os": "mac", "version": "0.6.0.1", "date": "2026-05-26T09:31:13.000Z", "commit": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "fileid": "f3e51f6afd0f81fe5032de7365e292d15813a8ec471b48c67a92bdf16b3f1092", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cedricbriandgithub/actions/runs/26443979094" }, { "r": "4.6.0", "os": "mac", "version": "0.6.0.1", "date": "2026-05-26T09:31:02.000Z", "commit": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "fileid": "e06b8468dcaf11f13deb58080e6816dd6c7c15f886cf699a7bd6cc28bcea0a4b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cedricbriandgithub/actions/runs/26443979094" }, { "r": "4.6.0", "os": "wasm", "version": "0.6.0.1", "date": "2026-05-26T09:30:52.000Z", "commit": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "fileid": "1599088f0f169bbaef2047b2421bbcba7c7c38a433f9d477c0e7450f6459fbca", "status": "success", "buildurl": "https://github.com/r-universe/cedricbriandgithub/actions/runs/26443979094" }, { "r": "4.7.0", "os": "win", "version": "0.6.0.1", "date": "2026-05-26T09:30:15.000Z", "commit": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "fileid": "1ca71021058a15700ba368fe56dd9619b59119f0207784f858eeb554e5963e94", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cedricbriandgithub/actions/runs/26443979094" }, { "r": "4.5.3", "os": "win", "version": "0.6.0.1", "date": "2026-05-26T09:30:29.000Z", "commit": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "fileid": "12c27af7fac65b2b96f43bc6015cb8f26f87f925950fbd68e8d7a478687d920d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cedricbriandgithub/actions/runs/26443979094" }, { "r": "4.6.0", "os": "win", "version": "0.6.0.1", "date": "2026-05-26T09:31:11.000Z", "commit": "7cb86c4e30988a2fbb78d04a45d1c1bf7d54afa9", "fileid": "cd08182588d99b7ab40def0d1d6f066169fbffe29b085fa058f48239753c0497", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cedricbriandgithub/actions/runs/26443979094" } ] }