Package: dbmisc 0.3

dbmisc: Tools for working with SQLite in R

Tools for working with SQLite in R, in particular support for simple YAML schemas.

Authors:Sebastian Kranz

dbmisc_0.3.tar.gz
dbmisc_0.3.zip(r-4.5)dbmisc_0.3.zip(r-4.4)dbmisc_0.3.zip(r-4.3)
dbmisc_0.3.tgz(r-4.4-any)dbmisc_0.3.tgz(r-4.3-any)
dbmisc_0.3.tar.gz(r-4.5-noble)dbmisc_0.3.tar.gz(r-4.4-noble)
dbmisc_0.3.tgz(r-4.4-emscripten)dbmisc_0.3.tgz(r-4.3-emscripten)
dbmisc.pdf |dbmisc.html✨
dbmisc/json (API)

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

Peer review:

Bug tracker:https://github.com/skranz/dbmisc/issues

On CRAN:

databaseschemasqlsqlite

4.40 score 26 stars 4 packages 16 scripts 29 exports 12 dependencies

Last updated 2 years agofrom:aef8712958 (on master). Checks:OK: 1 WARNING: 6. Indexed: yes.

TargetResultDate
Doc / VignettesOKDec 03 2024
R-4.5-winWARNINGDec 03 2024
R-4.5-linuxWARNINGDec 03 2024
R-4.4-winWARNINGDec 03 2024
R-4.4-macWARNINGDec 03 2024
R-4.3-winWARNINGDec 03 2024
R-4.3-macWARNINGDec 03 2024

Exports:convert.db.to.rconvert.r.to.dbdbConnectSQLiteWithSchemadbCreateSchemaTabledbCreateSchemaTablesdbCreateSQLiteFromSchemadbDeletedbGetdbGetMemoisedbInsertdbTableColsdbUpdateempty.df.from.schemaempty.row.from.schemaexample.empty.row.schemaget.db.schemaget.db.schemasget.table.memoiseinit.schemaload.and.init.schemaslogDBcommandschema.r.classesschema.templateset.db.schemaset.db.schemasset.table.memoisesql.where.codeto.db.dateto.db.datetime

Dependencies:cliDBIgluelifecyclemagrittrrestorepointrlangstringistringrstringtoolsvctrsyaml

Readme and manuals

Help Manual

Help pageTopics
Convert data from a database table to R formatconvert.db.to.r
Convert data from a database table to R formatconvert.r.to.db
Creates a connection to an SQLite database and sets the specified schemadbConnectSQLiteWithSchema
Create database table and possible indices from a simple yaml schemadbCreateSchemaTable
Create or update database tables and possible indices from a simple yaml schemadbCreateSchemaTables
Create or update a SQLite database from a schema filedbCreateSQLiteFromSchema
Delete row(s) from tabledbDelete
Get rows from a tabledbGet
Get results from a database like dbGet put buffer the results in memorydbGetMemoise
Insert row(s) into tabledbInsert
Get a data frame with column information for a database tabledbTableCols
Update a row in a database tabledbUpdate
Creates an example data frame from a database schema table using provided column values and default values specified in schemaempty.df.from.schema
Creates an example row from a database schema table using provided column values and default values specified in schemaempty.row.from.schema
Extract schemas from a data base connectionget.db.schema
Init a schema by parsing table definition and store info in easy accessibale R formatinit.schema
Load and init database table schemas from yaml fileload.and.init.schemas
log a command that changes a databaselogDBcommand
Get a vector of R classes of the database columns described in a schemaschema.r.classes
Create an example schema from a list of R objectsschema.template
Set schemas as hidden attribute to a data base connection dbset.db.schema
Create a parametrized or escaped SQL WHERE clause from the provided parameters.sql.where.code
Convert an R object to a date object that can be used in a WHERE clause.to.db.date
Convert an R object to a datetime object that can be used in a WHERE clause.to.db.datetime