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.7)dbmisc_0.3.zip(r-4.6)dbmisc_0.3.zip(r-4.5)
dbmisc_0.3.tgz(r-4.6-any)dbmisc_0.3.tgz(r-4.5-any)
dbmisc_0.3.tar.gz(r-4.7-any)dbmisc_0.3.tar.gz(r-4.6-any)
dbmisc_0.3.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
dbmisc/json (API)

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

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

On CRAN:

Conda:

databaseschemasqlsqlite

4.32 score 27 stars 3 packages 17 scripts 29 exports 12 dependencies

Last updated from:aef8712958 (on master). Checks:7 WARNING, 2 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64WARNING102
source / vignettesOK159
linux-release-x86_64WARNING114
macos-release-arm64WARNING94
macos-oldrel-arm64WARNING71
windows-develWARNING119
windows-releaseWARNING71
windows-oldrelWARNING86
wasm-releaseOK103

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