Package: stacomirtools 0.6.0.1

stacomirtools: Connection Class for Package stacomiR

S4 class wrappers for the 'ODBC' and Pool DBI connection, also provides some utilities to paste small datasets to clipboard, rename columns. It is used by the package 'stacomiR' for connections to the database. Development versions of 'stacomiR' are available in R-forge.

Authors:Cedric Briand [aut, cre], Marion Legrand [aut], Beaulaton Laurent [ctb]

stacomirtools_0.6.0.1.tar.gz
stacomirtools_0.6.0.1.zip(r-4.5)stacomirtools_0.6.0.1.zip(r-4.4)stacomirtools_0.6.0.1.zip(r-4.3)
stacomirtools_0.6.0.1.tgz(r-4.4-any)stacomirtools_0.6.0.1.tgz(r-4.3-any)
stacomirtools_0.6.0.1.tar.gz(r-4.5-noble)stacomirtools_0.6.0.1.tar.gz(r-4.4-noble)
stacomirtools_0.6.0.1.tgz(r-4.4-emscripten)stacomirtools_0.6.0.1.tgz(r-4.3-emscripten)
stacomirtools.pdf |stacomirtools.html✨
stacomirtools/json (API)
NEWS

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

Peer review:

On CRAN:

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

11 exports 0.36 score 24 dependencies 1 dependents 15 scripts 261 downloads

Last updated 2 years agofrom:7cb86c4e30. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKAug 29 2024
R-4.5-winOKAug 29 2024
R-4.5-linuxOKAug 29 2024
R-4.4-winOKAug 29 2024
R-4.4-macOKAug 29 2024
R-4.3-winOKAug 29 2024
R-4.3-macOKAug 29 2024

Exports:chnamesconnectexfunhtmlgetqueryindukis.evenis.oddkillfactorquerytab2df

Dependencies:bitbit64blobclicpp11DBIgenericsgluehmslaterlifecyclelubridatepkgconfigplogrpoolR6RcpprlangRODBCRPostgrestimechangevctrswithrxtable

Readme and manuals

Help Manual

Help pageTopics
This function replaces the variable names in a data.framechnames
generic connect function for baseODBCconnect connect.generic
connect method for ConnectionDB classconnect,ConnectionDB-method connect.ConnectionDB
connect method for ConnectionODBC classconnect,ConnectionODBC-method connect.ConnectionODBC
connect method loads a request to the database and returns either an error or a data.frameconnect,RequeteODBC-method connect.RequeteODBC
connect method loads a request to the database and returns either an error or a data.frameconnect,RequeteODBCwhere-method connect.RequeteODBCwhere
connect method loads a request to the database and returns either an error or a data.frameconnect,RequeteODBCwheredate-method connect.RequeteODBCwheredate
ConnectionDB classConnectionDB-class
ConnectionODBC classConnectionODBC-class
ex fonction to write to the clipboardex
function used to print the html tables of output (see xtable documentation)funhtml
generic query function forgetquery
getquery retreives the result of the query from the objectgetquery,RequeteDB-method
unique values of a vectorinduk
is.even function modified from package smais.even
id.odd function modified from package smais.odd
very usefull function used to "kill" the factors, noticeably after loading with 'ODBC'killfactor
generic query function forquery query.RequeteDB
query method loads a quert to the data and returns either an error or a data.framequery,RequeteDB-method
query method loads a request to the database and returns either an error or a data.framequery,RequeteDBwhere-method query.RequeteODBCwhere
query method loads a request to the database and returns either an error or a data.framequery,RequeteDBwheredate-method query.RequeteDBwheredate
RequeteDB classRequeteDB-class
RequeteDBwhere classRequeteDBwhere-class
RequeteDBwhere classRequeteDBwheredate-class
RequeteODBC classRequeteODBC-class
RequeteODBCwhere classRequeteODBCwhere-class
RequeteODBCwhere classRequeteODBCwheredate-class
Function to transform a ftable into dataframe but just keeping the counts, works with ftable of dim 2tab2df
validity function for ConnectionDB classvalidity_DB
Validity method for ODBC classvalidity_ODBC